存储过程

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);