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