MySql分分钟添加上千条数据

delimiter $$
drop procedure if exists wk;
create procedure wk()
begin
declare i int;
set i = 100;
while i < 1000 do
INSERT INTO test.open_invite_code (id, code, uid, utime, ctime, description, status) VALUES (i, '49b42087', '89', '2015-06-26 14:57:31', '2015-06-26 14:57:31', 'soul', 'soul');
set i = i +1;
end while;
end $$
delimiter ;
call wk();

posted @ 2016-11-23 10:39  DeadGhost  阅读(743)  评论(0编辑  收藏  举报