循环插入语句
DROP PROCEDURE IF EXISTS proc_initData; DELIMITER $ CREATE PROCEDURE proc_initData() BEGIN DECLARE i INT DEFAULT 1; WHILE i<=5 DO INSERT INTO warning (TYPE,CODE,NAME,LEVEL,come_from) VALUES('事件','event','服务控制或应用程序','蓝','日志分析'); SET i = i+1; END WHILE; END $ CALL proc_initData();
参考 https://blog.csdn.net/CSDN2497242041/article/details/79256063