Build Your Own DatabaseDriven Website Using PHP amp;amp; MySQL [Electronic resources]

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".