- # ---- mysql 循环生成 5 万行 id 连续的数据 ----
- /*
- id
- 1
- 2
- 3
- 4
- ......
- */
- CREATE TABLE tb(id INT(11) NOT NULL AUTO_INCREMENT,
- VALUE DATETIME DEFAULT NULL,
- PRIMARY KEY(id)
- )ENGINE=INNODB AUTO_INCREMENT = 1 DEFAULT CHARSET=utf8;
- SELECT * FROM tb;
- DROP TABLE tb;
- # 创建存储过程
- DELIMITER $$
- CREATE DEFINER = Hider@localhost PROCEDURE p(vRows INT)
- SQL SECURITY INVOKER
- BEGIN
- WHILE vRows> 0 DO
- INSERT tb(VALUE) VALUES(NOW());
- SET vRows = vRows - 1;
- END WHILE;
- END $$
- DELIMITER ;
- # 调用
- START TRANSACTION;
- CALL test.p(50000);
- COMMIT;
- SELECT COUNT(*) FROM tb;
- SELECT MIN(id),MAX(id) FROM tb;
简单的存储过程循环, 记得开事务, 如果逐提交数据 将会导致速度很慢.
END 2018-05-29 00:38:23
来源: http://www.bubuko.com/infodetail-2621920.html