mysql 索引

#查看表的所有索引

show index from tblname;

 

#删除表的索引

drop index index_name on tblname;

 

#表添加索引(btree)

alter table tblname add index using btree(column_name);