Difference between revisions of "Indexes"
From MyWiki
(Created page with "SHOW INDEX FROM yourtable;") |
|||
Line 1: | Line 1: | ||
SHOW INDEX FROM yourtable; | SHOW INDEX FROM yourtable; | ||
+ | |||
+ | |||
+ | |||
+ | |||
+ | |||
+ | <source lang="text"> | ||
+ | create index your_index_name on your_table_name(your_column_name) using HASH; | ||
+ | or | ||
+ | create index your_index_name on your_table_name(your_column_name) using BTREE; | ||
+ | </source> |
Revision as of 13:36, 18 September 2014
SHOW INDEX FROM yourtable;
create index your_index_name on your_table_name(your_column_name) using HASH; or create index your_index_name on your_table_name(your_column_name) using BTREE;