create procedure testInsert()
begin
declare i int;
set i=1;
while i<10000000 do
insert into test(name) values(i);
set i=i+1;
end while;
end;
MySql循环插入的存储过程
最新推荐文章于 2022-06-20 08:35:01 发布
create procedure testInsert()
begin
declare i int;
set i=1;
while i<10000000 do
insert into test(name) values(i);
set i=i+1;
end while;
end;