MySql循环插入的存储过程

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;