您必须删除外键.MySQL 中的外键自动在表上创建索引(有一个 SO Question 主题).

You have to drop the foreign key. Foreign keys in MySQL automatically create an index on the table (There was a SO Question on the topic).

ALTER TABLE mytable DROP FOREIGN KEY mytable_ibfk_1 ;