mysql找到所有索引

查询MySQL索引信息

最新推荐文章于 2024-11-11 09:32:45 发布

转载最新推荐文章于 2024-11-11 09:32:45 发布 · 48 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/zejin2008/p/7731884.html

文章标签：

#数据库

SELECT a.TABLE_SCHEMA,
a.TABLE_NAME,
a.index_name,
GROUP_CONCAT(column_name ORDER BY seq_in_index) AS `Columns`
FROM information_schema.statistics a
GROUP BY a.TABLE_SCHEMA,a.TABLE_NAME,a.index_name

--查找每个列对应的索引：

select a.TABLE_SCHEMA,a.TABLE_NAME,a.column_name, a.index_name,a.seq_in_index,b.Columns from information_schema.statistics a left join
(
SELECT a.TABLE_SCHEMA,
a.TABLE_NAME,
a.index_name,
GROUP_CONCAT(column_name ORDER BY seq_in_index) AS `Columns`
FROM information_schema.statistics a
GROUP BY a.TABLE_SCHEMA,a.TABLE_NAME,a.index_name
) b on a.TABLE_SCHEMA=b.TABLE_SCHEMA and a.TABLE_NAME=b.TABLE_NAME and a.index_name=b.index_name

转载于:https://www.cnblogs.com/zejin2008/p/7731884.html