Query the specified library to export all indexes

Selectconcat (' alter table  ', table_name, '   ',  ' add  ',   if (non_unique =  1, case upper (index_type)  WHEN  ' fulltext '  THEN  ' Fulltext index '   when  ' SPATIAL '  THEN  ' Spatial index '  else concat (' index  ',   index _name,   '  USING  ',  index_type  ' End,if (UPPER (index_name)  =  ' PRIMARY ',  concat (' primary key using  ', index_type ), CONCAT (' Unique index   ', index_name,  '  USING  ',  index_type)), ' (',  group_concat (distinct  CONCAT (', column_name,  ')  ORDER BY SEQ_IN_INDEX ASC SEPARATOR  ',   ') (,  ');  AS  ' show_add_indexes ' From information_schema. statisticswhere table_schema =  ' DBName ' Group by table_name, index_nameorder  by table_name asc, index_name&nbSp Asc

This article is from the "James" blog, be sure to keep this source http://lizhuan.blog.51cto.com/8099531/1825814

Query the specified library to export all indexes