1.创建存储过程 create procedure batchInsert() begin declare i int;set i = 0; while(i<=200) do INSERT INTO `student_table_name`( `name`, `age`, `create_time`) VALUES (CONCAT('姓名',i), i, NOW()); set i = i+1; end while;end; 2.调用存储过程 call batchInsert();