DROP PROCEDURE IF EXISTS proc_buildata;
CREATE PROCEDURE proc_buildata(IN loop_times INT)
BEGIN
DECLARE var INT DEFAULT 0;
WHILE var<loop_times DO
SET var=var+1;
INSERT INTO employee (employeeid,employeename) VALUES (var,CONCAT('test',var));
END WHILE;
END
CALL proc_buildata(2000000);
SELECT COUNT(1) FROM employee;