If you have a mysql database table with indexes and you want to get the alter table\u00a0 commands to “create” the same indexes on another db<\/p>\n
You can run this sql — replacing the tablename with your table.<\/p>\n
Just add<\/p>\n
alter table TABLENAME<\/p>\n
Then paste the add index commands generated by the SQL below<\/p>\n
SELECT\u00a0\u00a0\u00a0 concat(‘add index ‘, i.index_name , ‘ using BTREE(‘,
\ngroup_concat(i.column_name order by i.seq_in_index), ‘),’) cmd
\nFROM\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 information_schema.STATISTICS i\u00a0\u00a0\u00a0\u00a0\u00a0 — i for index
\nWHERE\u00a0\u00a0 i.table_name\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = ‘DCAS’
\nGROUP BY\u00a0\u00a0\u00a0\u00a0 i.index_name<\/p><\/blockquote>\n","protected":false},"excerpt":{"rendered":"If you have a mysql database table with indexes and you want to get the alter table\u00a0 commands to “create” the same indexes on another db You can run this sql — replacing the tablename with your table. Just add … Continue reading