-
-----------------索引创建------------------------------------------------
-
show index from A #查看索引
-
alter table A add primary key(id) #主键索引
-
alter table A add unique(name) #唯一索引
-
alter table A add index name(name) #普通索引
-
alter table A add fulltext(name) #全文索引
-
alter table A add index name(id,name) #多列索引
转自:https://blog.csdn.net/suifenglie/article/details/74981817