SELECT TABLE_SCHEMA AS `SCHEMA`,
TABLE_NAME AS `Table`,
index_name AS `Index`,
GROUP_CONCAT(column_name ORDER BY seq_in_index) AS `Columns`
FROM information_schema.statistics
WHERE index_name=‘appkey_mid_gmid‘
GROUP BY TABLE_NAME,index_name;
原文：http://www.cnblogs.com/zejin2008/p/7731884.html