41.索引操作

普通索引

添加索引：alter table t1 add index idx_name(name);
删除索引：alter table t1 drop index idx_name;

唯一索引

添加索引：alter table t1 add unique uni_name(name);
删除索引：alter table t1 drop index uni_name;