mysql千万级大表在线加索引:create table tmp like paper_author; ALTER TABLE tmp ADD INDEX ( `PaperID` ) insert into tmp(ooo，...) selectooo... from paper_author Query OK, 35510600 rows affected (9 min 24.99