If you have a mysql database table with indexes and you want to get the alter table\u00a0 commands to \u201ccreate\u201d the same indexes on another db<\/p>\n
You can run this sql \u2014 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(\u2018add index \u2018, i.index_name , \u2018 using BTREE(\u2018,
\ngroup_concat(i.column_name order by i.seq_in_index), \u2018),\u2019) cmd
\nFROM\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 information_schema.STATISTICS i\u00a0\u00a0\u00a0\u00a0\u00a0 \u2014 i for index
\nWHERE\u00a0\u00a0 i.table_name\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = \u2018DCAS\u2019
\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 \u201ccreate\u201d the same indexes on another db You can run this sql \u2014 replacing the tablename with your table. Just add … Continue reading