常用的produce mysql
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()
如有错误,请邮件zs253499660@sina.com,如有更好的方法,可以推荐