Difference between revisions of "Indexes"

From MyWiki
Jump to: navigation, search
(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;