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

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

欢迎大家阅读《mysql 批量插入测试数据，两分钟安插10W条_mysql》,跪求各位点评，by 搞代码

微信 赏一包辣条吧~

支付宝 赏一听可乐吧~