[MYSQL] 인덱스 정보 조회 SQL

SELECT 	index_name 											AS 'index'
	,	GROUP_CONCAT(column_name ORDER BY seq_in_index) 	AS 'index_columns'
	,	IF( MAX(NON_UNIQUE)=0, 'Yes', '')					AS 'IsUnique'
FROM 	information_schema.statistics
WHERE 	table_schema = 'my_dbname'
AND		TABLE_NAME = 'my_tablename'
GROUP BY TABLE_NAME, index_name;

/*
SQL Results
----------------------------------------------------
index		index_columns	IsUnique
----------------------------------------------------
PRIMARY		Host,Db,User	Yes
User		User
*/