Mysql批量插入数据，双层循环

批量插入Mysql数据

delimiter $$
DROP PROCEDURE IF EXISTS pre1;  ## 判断当前存储过程是否存在，如果存在则删除
create procedure pre1() ## 创建存储过程
BEGIN
DECLARE i int;
set i = 1;
WHILE i < 1000 DO
	INSERT INTO class(id, name) VALUES (i, '班级');
SET i = i+1;
END WHILE;
END
$$

CALL pre1();

批量插入Mysql学生数据

delimiter $$
DROP PROCEDURE IF EXISTS pre4;
create procedure pre4()
BEGIN
DECLARE i int;
DECLARE j int;
set i = 1;
WHILE i < 1000 DO
	
	set j = 1;
	WHILE j <= 1000 DO
		INSERT INTO stu(name, age, class_id) VALUES (concat("学生",i,j), j, i);
		SET j= j+1;
		
END WHILE;
SET i = i+1;
END WHILE;
END
$$

CALL pre4();