1.创建测试表
CREATE TABLE tb1(id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
num INT
)ENGINE=INNODB CHARSET=utf8
2.演示repeat的插入数据
DELIMITER //
DROP PROCEDURE IF EXISTS p4//
CREATE PROCEDURE p4(IN n INT)
BEGIN
DECLARE i INT DEFAULT 0;
REPEAT
INSERT INTO tb1(num)VALUES(i+1);
SET i = i +1;
UNTIL i=n END REPEAT;
END//
CALL p4(1000000); 测试插入一百万数据
SELECT COUNT(*)AS num FROM tb1