MYSQL数据库一次性插入大量数据

DROP TABLE IF EXISTS student;

CREATE TABLE student (
stu_id int NOT NULL AUTO_INCREMENT,
stu_name varchar(15) NOT NULL,
PRIMARY KEY (stu_id)
) ENGINE=InnoDB AUTO_INCREMENT=10001 DEFAULT CHARSET=utf8;

DROP PROCEDURE IF EXISTS proc_initData;

DELIMITER $ – 将结束符改成$
CREATE PROCEDURE proc_initData()
BEGIN
DECLARE i INT DEFAULT 1;
WHILE i<=10000000 DO
INSERT INTO student (stu_id,stu_name) VALUES(i,CONCAT(“张三”,i));
SET i = i+1;
END WHILE;
END $

CALL proc_initData();