mysql index add , drop, show
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;
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;
Congratulations @taegyunkim! You received a personal award!
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!