执行如下sql即可显示出指定数据库的所有索引:
mysql> use information_schema;
mysql> SELECT TABLE_NAME,INDEX_SCHEMA,INDEX_NAME,COLUMN_NAME FROM statistics where TABLE_SCHEMA ='database_name';
执行如下sql即可显示出指定数据库的所有索引:
mysql> use information_schema;
mysql> SELECT TABLE_NAME,INDEX_SCHEMA,INDEX_NAME,COLUMN_NAME FROM statistics where TABLE_SCHEMA ='database_name';