== Syntax: ==
{{{
CREATE [ONLINE|OFFLINE] [UNIQUE|FULLTEXT|SPATIAL] INDEX index_name
[index_type]
ON tbl_name (index_col_name,...)
[index_option] ...
index_col_name:
col_name [(length)] [ASC | DESC]
index_type:
USING {BTREE | HASH | RTREE}
index_option:
KEY_BLOCK_SIZE [=] value
| index_type
| WITH PARSER parser_name
}}}
== Description: ==
CREATE INDEX is mapped to an ALTER TABLE statement to create indexes.
See [[alter-table|ALTER TABLE]]. CREATE INDEX cannot be used to create a
PRIMARY KEY; use ALTER TABLE instead.
