如何检查MySQL中的表字段是否存在索引？

SELECT * FROM information_schema.statistics WHERE table_schema='your_database_name' AND table_name='your_table_name' AND column_name='your_column_name';

SELECT * FROM information_schema.statistics WHERE table_schema='your_database_name' AND table_name='your_table_name';