1、DROP PROCEDURE IF EXISTS inserts
CREATE PROCEDURE inserts(IN i INT,IN limitNum INT)
BEGIN
WHILE i<limitNum
DO
INSERT INTO test VALUES(i,CONCAT('name',i),CONCAT('上海',i),CONCAT('插入detail',i));
SET i=i+1;
END WHILE;
COMMIT;
END;
CREATE PROCEDURE inserts(IN i INT,IN limitNum INT)
BEGIN
WHILE i<limitNum
DO
INSERT INTO test VALUES(i,CONCAT('name',i),CONCAT('上海',i),CONCAT('插入detail',i));
SET i=i+1;
END WHILE;
COMMIT;
END;