mysql 插入固定数量数据_mysql存储过程插入固定数量测试数据

insert into dw_user(type_id,username,password,islock,invite_userid,integral,status,avatar_status,phone_status,video_status,scene_status,phone,logintime, addtime,addip,uptime,upip,lasttime,lastip,chongzu_id,cz_money,cz_cash,chongzu_new_id,iscompany,locktime,user_role,sms_blacklist,referee,promote_id) values(2,'tt70','e10adc3949ba59abbe56e057f20f883e',0,0,0,0,0,1,0,0,0,0,'1378108136','192.168.1.201','1378108136','192.168.1.201','1378108136', '192.168.1.201',0,0,0,0,0,0,0,0,0,0); 存储过程插入固定用户 delimiter  create procedure dowhile()   begin    declare i int default 0;   start transaction;         while i<1000 do     insert into dw_user(type_id,username,password,islock,invite_userid,integral,status,avatar_status,phone_status,video_status,scene_status,phone,logintime, addtime,addip,uptime,upip,lasttime,lastip,chongzu_id,cz_money,cz_cash,chongzu_new_id,iscompany,locktime,user_role,sms_blacklist,referee,promote_id) values(2,concat('s00',i),'e10adc3949ba59abbe56e057f20f883e',0,0,0,0,0,1,0,0,0,0,'1378108136','192.168.1.201','1378108136','192.168.1.201','1378108136', '192.168.1.201',0,0,0,0,0,0,0,0,0,0);   set i=i+1;     end while;    commit;      end;  delimiter; 调用存储过程 call dowhile(); 删除存储过程 drop dowhile;