摘要:
CREATE PROCEDURE `BatchInsert`(IN init INT, IN loop_time INT)BEGINDECLARE Var INT;DECLARE ID INT;SET Var = 0;SET ID = init;WHILE Var < loop_time DOINSERT INTO tb_test(Id) VALUES(ID);SET ID = ID + 1;SET Var = Var + 1;END WHILE;END; 阅读全文