create table aaa(id int,userid int,username varchar(20000));
-- 存储过程造数
delimiter //
drop procedure if exists testinsert;
create procedure testinsert()
begin
declare i int default 600000;
while i < 900000
do
start transaction;
insert into aaa set id=i , userid=i,username=concat('tt',i);
select sleep(1);
commit;
set i=i+1;
end while;
end//
delimiter ;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29291882/viewspace-2128795/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29291882/viewspace-2128795/