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;