mysql> Delimiter ;//
mysql> CREATE PROCEDURE BatchInsert(IN init INT, IN loop_time INT)
-> BEGIN
-> DECLARE Var INT;
-> DECLARE ID INT;
-> SET Var = 0;
-> SET ID = 165;
-> WHILE Var < loop_time DO
-> INSERT INTO t_user(ID, Password) VALUES(ID, 123456);
-> SET ID = ID + 1;
-> SET Var = Var + 1;
-> END WHILE;
-> END;//
Query OK, 0 rows affected (0.00 sec)
mysql> call BatchInsert(1, 1000);