查找复合索引的字段按顺序输出
查找复合索引的字段：
select GROUP_CONCAT(column_name) as composit_index
from information_schema.statistics
where table_name='fruits'
group by index_name
having count(index_name)>1

对于每组的复合索引字段，我想按照seq_in_index进行排序输出
如何操作？



[解决办法]

SQL code

select GROUP_CONCAT( column_name ORDER BY  SEQ_IN_INDEX desc) as composit_indexfrom information_schema.statisticswhere table_name='test1'group by index_namehaving count(index_name)>1