https://www.cnblogs.com/xiaoxitest/p/6242524.html
drop procedure if exists t_add; -- 如果存在t_add 存储过程则删除
create procedure t_add(num int) begin declare i int; set i=0; while i<num do insert into sudents values ('',concat('张三',i+1),'男',18,'计算机','北京市海淀区'); insert into score values('',i+1,'计算机','81'); set i=i+1; end while; end call t_add(100000); -- 调用存储过程,插入10万条数据