查询库中表的索引
select TABLE_NAME, INDEX_NAME, GROUP_CONCAT(COLUMN_NAME) as INDEX_COLUMN
from
information_schema.statistics
where
table_schema='库名'
GROUP BY TABLE_NAME, INDEX_NAME;
查询库中表的索引
select TABLE_NAME, INDEX_NAME, GROUP_CONCAT(COLUMN_NAME) as INDEX_COLUMN
from
information_schema.statistics
where
table_schema='库名'
GROUP BY TABLE_NAME, INDEX_NAME;