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，怎么看进度？