Shulou(Shulou.com)05/31 Report--

What this article shares to you is about how to export the index creation statement in MySQL, the editor thinks it is very practical, so I share it with you to learn. I hope you can get something after reading this article.

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 = 'TEST' and TABLE_NAME='TEST'GROUP BY TABLE_NAME, INDEX_NAMEORDER BY TABLE_NAME ASC, INDEX_NAME ASC

Description: TABLE_SCHEMA is the library name and TABLE_NAME is the table name

The above is how to export the index creation statement in MySQL. The editor believes that there are some knowledge points that we may see or use in our daily work. I hope you can learn more from this article. For more details, please follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.