CREATE TABLE test2(id INT PRIMARY KEY AUTO_INCREMENT);

INSERT INTO test2() VALUES(),(),(),();

INSERT INTO test2(id) SELECT id+(SELECT COUNT(*) FROM test2) FROM test2;

INSERT INTO test2(id) SELECT id+(SELECT COUNT(*) FROM test2) FROM test2;

INSERT INTO test2(id) SELECT id+(SELECT COUNT(*) FROM test2) FROM test2;

INSERT INTO test2(id) SELECT id+(SELECT COUNT(*) FROM test2) FROM test2;

连续执行同样的 SQL 数次,就可以快速构造千万级别的数据

INSERT INTO test2(id) SELECT id+(SELECT COUNT(*) FROM test2) FROM test2;

……

--本篇文章转自:

第11问:不小心对一个大表进行了 update,怎么看进度?

 

Logo

腾讯云面向开发者汇聚海量精品云计算使用和开发经验,营造开放的云计算技术生态圈。

更多推荐