MySQL创建索引

1.添加主键索引 PRIMARY KEY

alter table 'table_name' add primary key ('column');

2.添加唯一索引 UNIQUE

alter table 'table_name' add unique ('column');

3.添加普通索引 INDEX

alter table 'table_name' add index index_name ('column');

4.添加全文索引 FULLTEXT

alter table 'table_name' add fulltext ('column');

5.添加多列索引

alter table 'table_name' add index index_name ('column1','column2','column3');

本文转载自：https://www.cnblogs.com/a-du/p/7117837.html