数据库索引个数查询
mysql数据库
SELECT TABLE_NAME,COUNT(TABLE_NAME) AS INDEX_NUM,GROUP_CONCAT(INDEX_VALUE1 SEPARATOR "#") AS INDEX_VALUE FROM (
SELECT TABLE_SCHEMA,TABLE_NAME,INDEX_NAME,COLUMN_KEY,GROUP_CONCAT(COLUMN_NAME ORDER BY SEQ_IN_INDEX ASC SEPARATOR '>') AS INDEX_VALUE1 FROM (
SELECT TABLE_SCHEMA,TABLE_NAME,INDEX_NAME,CONCAT(TABLE_NAME,INDEX_NAME) AS COLUMN_KEY,SEQ_IN_INDEX,COLUMN_NAME FROM information_schema.`STATISTICS` WHERE TABLE_SCHEMA="mysql" ORDER BY TABLE_NAME,INDEX_NAME,SEQ_IN_INDEX
) AS table1 GROUP BY TABLE_NAME,INDEX_NAME,COLUMN_KEY
) AS table2 GROUP BY TABLE_NAME