delimiter ;;
create procedure idata3()
begin
declare i int;
set i=1;
while(i<=100000)do
insert into t values(i, i, i,i);
set i=i+1;
end while;
end;;
delimiter ;
idata3()

常用的produce mysql