创建索引

create index index_test on test(id,name); --创建索引
CREATE UNIQUE INDEX index_test ON test (id,name); --创建唯一索引

 

删除索引

drop index index_test on test; --删除索引
alter table test drop index index_test; --删除索引