Difference between revisions of "Indexes"
From MyWiki
| Line 2: | Line 2: | ||
| − | + | CREATE INDEX part_of_name ON customer (name(10)); | |
Revision as of 13:37, 18 September 2014
SHOW INDEX FROM yourtable;
CREATE INDEX part_of_name ON customer (name(10));
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;
