如何导出MySQL索引的创建语句

转载自
SELECT CONCAT( '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.STATISTICS WHERE TABLE_SCHEMA = 'test' AND TABLE_NAME = 'test' GROUP BY TABLE_NAME , INDEX_NAME ORDER BY TABLE_NAME ASC, INDEX_NAME ASC

说明:TABLE_SCHEMA为库名，TABLE_NAME为表名