mysql 批量插入测试数据，两分钟插入10W条

CREATE PROCEDURE pro_cust_batch()
BEGIN
declare v_login_name BIGINT DEFAULT 13800000000;
declare v_max BIGINT DEFAULT 100000;
declare batch int default 50;
declare i int default 0;
declare v_pwd varchar(35);
declare v_img varchar(150);
declare v_groupId int;
declare v_regfrom varchar(10);
declare v_curdate datetime;
declare v_sqltext VARCHAR(9000);
declare v_firstSql VARCHAR(400);

set v_pwd='e10adc3949ba59abbe56e057f20f883e';
set v_img='Users/img/1.png';
set v_groupId=27;
set v_curdate=NOW();
set v_sqltext='';

WHILE i < v_max DO
set i = i + 1;
set v_login_name=v_login_name+1;
set v_regfrom=concat('PC',i);

set v_firstSql=concat('(''',v_login_name,''',''',v_pwd,''',''',v_img,''',''',v_login_name,''',''',v_curdate,''',',v_groupId,',''',v_regfrom,''',',0,',',1,',',1,',''',v_curdate,''')');
if mod(i,batch)=1 then
set v_sqltext=concat(v_firstSql);
else
set v_sqltext=concat(v_sqltext,',',v_firstSql);
end if;

if mod(i,batch)=0 then
set @sqltext=concat('INSERT INTO cus_customer(LoginName,Pwd,Uimage,Mobile,RegTime,GroupId,RegFrom,MaxOnline,State,CreateId,CreateTime) VALUES ',v_sqltext);
prepare stmt from @sqltext;
execute stmt;
DEALLOCATE PREPARE stmt;
set v_sqltext='';
end if;

END WHILE;

end