添加 查看 和删除 索引

show keys from tablename; //查看索引
alter table test add unique index (`key`);   //创建unique索引

alter table test drop index `key`; //删除key键 unique索引