MySQL - Show Index, Drop Index , Create Index

摘要:MySQL - Show Index, Drop Index , Create Index

show index from table_name;
 
drop index `INDEX_NAME` on table_name;
create index `INDEX_NAME` on table_name(column_name);