___  ___    _ _    _  _ _____   _____
 / __|/ _ \  | | |  | || |_ _\ \ / / __|
| (_ | (_) | |_  _| | __ || | \ V /| _|
 \___|\___/    |_|  |_||_|___| \_/ |___|

 --- A GOPHER-LIKE INTERFACE FOR HIVE BLOCKCHAIN ---

mysql index add , drop, show

BY: @taegyunkim | CREATED: Sept. 3, 2018, 11:12 a.m. | VOTES: 0 | PAYOUT: $0.00 | [ VOTE ]

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;

TAGS: [ #index ] [ #add ]

Replies

@steemitboard | July 31, 2019, 6:14 a.m. | Votes: 0 | [ VOTE ]

Congratulations @taegyunkim! You received a personal award!

https://steemitimages.com/70x70/http://steemitboard.com/@taegyunkim/birthday1.pngHappy 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!
[ BACK TO TRENDING ] [ BACK TO MENU ]
CMD>