本文共 553 字,大约阅读时间需要 1 分钟。
CREATE PROCEDURE insert_chenzhuo1_info ()BEGINDECLARE total int;DECLARE num int;set @num=0;set @total=11000000;WHILE @num < @total DOINSERT 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
可用于对数据库插入多条数据
转载地址:http://qzshn.baihongyu.com/