添加索引:
1.添加主键:
alter table tableName add primary key(columnName);
2.添加唯一索引
alter table tableName add unique indexName(columnName);
3.添加普通索引
alter table tableName add index indexName(columnName);
4.全文索引
alter table tableName add fulltext indexName(columnName)
创建索引:
create [unique|fulltext|spatial] index indexName on tableName(cilumnName);
删除索引:
drop index indexName on tableName;
alter table tableName drop index/unique/fulltext indexName;
alter table tableName drop primary key;