mysql index add , drop, show

in #index6 years ago (edited)

SHOW INDEX FROM tablename;

ALTER TABLE tablename ADD INDEX indexname (column1, column2);

ALTER TABLE tablename ADD UNIQUE INDEX indexname (column1, column2);

ALTER TABLE tablename DROP INDEX indexname;

Sort:  

Congratulations @taegyunkim! You received a personal award!

Happy Birthday! - You are on the Steem blockchain for 1 year!

You can view your badges on your Steem Board and compare to others on the Steem Ranking

Vote for @Steemitboard as a witness to get one more award and increased upvotes!