mysql新建的表删除后索引会自动删除吗_删除MySQL表会自动删除该表的索引吗？...

是.它丢弃索引.这可以验证：

CREATE TABLE table1 (foo INT);

CREATE INDEX ix_table1_foo ON table1 (foo);

CREATE INDEX ix_table1_foo ON table1 (foo); -- fails: index already exists.

DROP TABLE table1;

CREATE TABLE table1 (foo INT);

CREATE INDEX ix_table1_foo ON table1 (foo); -- succeeds: index does not exist.

CREATE TABLE table1 (foo INT);

CREATE INDEX ix_table1_foo ON table1 (foo);

SELECT COUNT(*)

FROM information_schema.STATISTICS

WHERE INDEX_NAME = 'ix_table1_foo'; -- returns 1

DROP TABLE table1;

SELECT COUNT(*)

FROM information_schema.STATISTICS

WHERE INDEX_NAME = 'ix_table1_foo'; -- returns 0