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();

原文地址:https://www.cnblogs.com/realsoul/p/6092754.html