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;
