navicat导出某个数据库全部的索引

步骤

• 点击数据库右键新建查询
• 填充数据名和表名即可。
• 想要导出全部去掉表名选项。

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 = '数据库名字' 
	AND TABLE_NAME='表名' 
GROUP BY
	TABLE_NAME,
	INDEX_NAME 
ORDER BY
	TABLE_NAME ASC,
	INDEX_NAME ASC;