mysql循环insert多条数据

1.  

2. https://blog.csdn.net/ZeroBz/article/details/85119528

3.  

4.  

5.  

6.  

7.  

8. DROP PROCEDURE IF EXISTS proc_initData;-- 如果存在此存储过程则删掉

9. DELIMITER $

10. CREATE PROCEDURE proc_initData()

11. BEGIN

12. DECLARE i INT DEFAULT 1;

13. WHILE i<=15000000 DO

14. INSERT INTO t_fam_alert values(i,5,'123','dectId','dectCode','15000','14000','1300',1,'facuId','testest',0,'decType','facuCode','facuType',1);

15. SET i = i+1;

16. END WHILE;

17. END $

18. CALL proc_initData();