Insert data cyclically in MySQL stored procedures

When testing machines, you often need to test the absolute values of inset and alert. Therefore, you have written a stored procedure to complete the test.
 

Drop procedure if exists proc_buildata;
Tudou @ Gyyx
Create procedure proc_buildata (IN loop_times INT)
BEGIN
DECLARE var int default 0;
 
Prepare msql from 'create table if not exists 'Employee' ('id' int (10) unsigned not null AUTO_INCREMENT, 'employeeid' int (10) unsigned not null comment '0', 'ployeename' varchar (64) not null default ''', primary key ('id') ENGINE = innodb ';
Execute msql;
 
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 (1, 2000000 );
 
 
Select count (1) FROM employee;

From the column of ylqmf