--删除唯一除索引
ALTER TABLE `hero` DROP INDEX onlyName;
ALTER TABLE hero DROP INDEX onlyType;
--添加唯一索引
ALTER TABLE hero ADD UNIQUE onlyType(TYPE);
ALTER TABLE hero ADD UNIQUE onlyName(NAME);
--查看所有索引
SHOW INDEX FROM hero;
--删除唯一除索引
ALTER TABLE `hero` DROP INDEX onlyName;
ALTER TABLE hero DROP INDEX onlyType;
--添加唯一索引
ALTER TABLE hero ADD UNIQUE onlyType(TYPE);
ALTER TABLE hero ADD UNIQUE onlyName(NAME);
--查看所有索引
SHOW INDEX FROM hero;