delimiter //
create procedure m()
begin
declare num int;
set num=1;
while num < 100000
insert into test(stuNo,StuName)   values('随便','123') set num=num+1;
end while;
 end//

CALL m()