CREATE INDEX
CREATE [UNIQUE | FULLTEXT] INDEX index_name ON tbl_name
(col_name[(length)], ...)
This query creates a new index on an existing table. It works identically
to ALTER TABLE ADD INDEX, described in "ALTER TABLE".
CREATE [UNIQUE | FULLTEXT] INDEX index_name ON tbl_name
(col_name[(length)], ...)