在CREATE DEFINER=`root`@`%` PROCEDURE `NewProc`()
BEGIN
DECLARE i INT DEFAULT 1;
DECLARE tempId INT DEFAULT 200;
while i<=100000 DO
INSERT INTO `form_work_focus` (`ID`, `FORM_WORK_ID`, `FORM_WORK_STEP_ID`, `EMP_CODE`, `EMP_NAME`, `COMMITED`, `CREATE_EMP_NAME`, `CREATE_USER`, `CREATE_TIME`, `is_replied`,
`is_reply_viewed`, `need_reply`, `is_viewed`)
VALUES (tempId, 19, 166, 'SHXZ19060', '张三', 'Y', NULL, '04004', '2021-08-27 14:38:06', 1, 1, NULL, 1);
SET i = i+1, tempId = tempId+1;
END while;
END