请问mysql如何生成10万数据

Question

因为我要给自己的项目测试，所以打算生成10条数据,求大佬帮助

Answer 1

delimiter
create procedure myproc()
begin
declare num int;
set num=2;
while num < 10 do
insert into new_table_test values(num,2,3); set num=num+1;
end while;
end
;

 call myproc();

select * from new_table_test;