CREATE PROCEDURE test_insert ()
BEGIN
DECLARE i INT DEFAULT 22;
WHILE i<72
DO
INSERT INTO gta_vsl_xnjd1220.coursecycle
(CoursePlan_Id,
CycleCount,
RecordStatus,
CreatedTime,
CreaterID
)
VALUES(i, '17', '1', '0001-01-01 00:00:00',
'0' );
INSERT INTO gta_vsl_xnjd1220.coursecycle
(CoursePlan_Id,
CycleCount,
RecordStatus,
CreatedTime,
CreaterID
)
VALUES(i, '18', '1', '0001-01-01 00:00:00',
'0' );
SET i=i+1;
END WHILE ;
END;