Difference between revisions of "Indexes"
From MyWiki
(Created page with "SHOW INDEX FROM yourtable;") |
|||
| (2 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
SHOW INDEX FROM yourtable; | SHOW INDEX FROM yourtable; | ||
| + | |||
| + | |||
| + | CREATE INDEX part_of_name ON customer (name(10)); | ||
| + | |||
| + | |||
| + | <source lang="text"> | ||
| + | |||
| + | |||
| + | SQL CREATE INDEX Syntax | ||
| + | |||
| + | Creates an index on a table. Duplicate values are allowed: | ||
| + | CREATE INDEX index_name | ||
| + | ON table_name (column_name) | ||
| + | SQL CREATE UNIQUE INDEX Syntax | ||
| + | |||
| + | Creates a unique index on a table. Duplicate values are not allowed: | ||
| + | CREATE UNIQUE INDEX index_name | ||
| + | ON table_name (column_name) | ||
| + | |||
| + | |||
| + | 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> | ||
Latest revision as of 13:38, 18 September 2014
SHOW INDEX FROM yourtable;
CREATE INDEX part_of_name ON customer (name(10));
SQL CREATE INDEX Syntax Creates an index on a table. Duplicate values are allowed: CREATE INDEX index_name ON table_name (column_name) SQL CREATE UNIQUE INDEX Syntax Creates a unique index on a table. Duplicate values are not allowed: CREATE UNIQUE INDEX index_name ON table_name (column_name) 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;
