is it possible to generate create index sql in MySQL 5.7 I have a table have many index, now I want to move the index to another table. Is it possible to auto generate the index create sql using SQL command? so I do not need to generate index by myself(generate create index sql by hande).
You can use SHOW INDEXES FROM table_name; to script the list of indexes on that table.