查找复合索引的字段:
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进行排序输出
如何操作?
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进行排序输出
如何操作?
from information_schema.statistics
where table_name='test1'
group by index_name
having count(index_name)>1