批量插入百万数据,存储过程

batchInsert.sql

CREATE DEFINER=`root`@`localhost` PROCEDURE `database`.`name`()
BEGIN
DECLARE pre_name BIGINT;
DECLARE ageVal INT;
DECLARE i INT;
SET pre_name=862362681;
SET ageVal=100;
SET i=1;
WHILE i < 1000000 DO
INSERT shop(name,union_id, open_id) VALUES(CONCAT(pre_name,'@qq.com'),CONCAT(i ,'unionId'),CONCAT(i,'openId'));
SET pre_name=pre_name+100;
SET i=i+1;
END WHILE;
END