CREATE PROCEDURE insert_chenzhuo1_info ()
BEGIN
DECLARE total int;
DECLARE num int;
set @num=0;
set @total=11000000;
WHILE @num < @total DO
INSERT INTO park_event_log (created_at,updated_at,orgId,orgName,keyPartId,keyPartName,
platFormId,platFormName,hostName,channelName,eventType,eventTypeName,direction,ownerName)
VALUES
("2021-06-09 13:49:20","2021-06-09 13:49:20","1","中国建设银行","5","公交总公司离行式自助银行","11","丽泽停车平台","丽泽车场","通行","5015","同行","出","张三");
SET @num = @num + 1;
END WHILE;
END;
CALL insert_chenzhuo1_info ();
DROP PROCEDURE insert_chenzhuo1_info
可用于对数据库插入多条数据