Description: Creates an index called index_name on the column or columns given by column_list (names of columns are comma-separated if more than one) of the table table_name.
UNIQUE option specifies a unique index. FULLTEXT option specifies a full-text index that will help a SELECT...WHERE MATCH...AGAINST query. If neither UNIQUE or FULLTEXT are specified, the index will be non-unique.
Synonymous with ALTER TABLE...ADD INDEX.
Limitations: FULLTEXT option works only on VARCHAR and TEXT columns of MyISAM tables, and only in versions 3.23.23 and later.
Description in: Day 9
See also: ALTER TABLE, DROP INDEX
3.142.200.109