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;
mysql 插入固定数量数据_mysql存储过程插入固定数量测试数据
最新推荐文章于 2021-12-13 15:46:29 发布