MySQL创建触发器批量向表插入数据

DROP PROCEDURE IF EXISTS proc_student_Insert;
CREATE  PROCEDURE proc_student_Insert(IN loop_times int)
begin
declare i INT default 20123;
set i=20123;
while i<loop_times do
  set i=i+1 ;
 insert into student(sno,sname,ssex,sbirthday,class) values(i,''+i,'女','1983-09-18','11');
end while;
end;

CALL proc_student_Insert(100000);