批量插入数据存储过程备忘

最新推荐文章于 2024-09-06 07:00:00 发布

weixin_30873847

最新推荐文章于 2024-09-06 07:00:00 发布

阅读量32

点赞数

原文链接：http://www.cnblogs.com/libaoting/p/4107614.html

版权

 1 DELIMITER /
 2 CREATE PROCEDURE insertuser()
 3 BEGIN
 4 SET @i = 1000;
 5 SET @temp = 'xxx';
 6 WHILE @i < 3000 DO
 7 SET @username = CONCAT(@temp,@i);
 8 INSERT INTO xxx(id,username,password,nikename,head,email,ischeckemail) values
 9 (@username,@username,'password',@username,'head.png','xxxxxxx@qq.com','true');
10 SET @i=@i+1;
11 END WHILE;
12 END
13 /
14 DELIMITER ;
15 CALL insertuser();