mysql 生成批量存储过程

CREATE  PROCEDURE `BatchInsert`(IN init INT, IN loop_time INT)
BEGIN
 DECLARE Var INT;
 DECLARE ID INT;
 SET Var = 0;
 SET ID = init;
 WHILE Var < loop_time DO
 INSERT INTO tb_test(Id) VALUES(ID);
 SET ID = ID + 1;
 SET Var = Var + 1;
 END WHILE;
 END;