创建联合唯一索引的sql

删除索引：
DROP INDEX idx_ruleId_cityId ON detail_price;
DROP INDEX 索引名称 ON 表名;

创建联合唯一索引：
ALTER TABLE detail_price ADD unique INDEX idx_ruleId_cityId(rule_id,city_id);
ALTER TABLE 表名 ADD unique INDEX 索引名称(字段1,字段2);

(如果表中已经有重复的记录，这时候添加唯一索引，执行上面的操作时，数据库会返回添加失败信息，因为已经有重复的记录了，建立索引失败。)
可以通过以下sql查询重复记录，删除多余的记录，只保留一条：
select rule_id,city_id,count(*) as count from detail_price group by rule_id,city_id having count>1;

删除表中多余的重复记录，只保留rowid最小的记录：
delete from detail_price a where (a.rule_id,a.city_id) in (select rule_id,city_id from detail_price group by rule_id,city_id having count>1)
and rowid not in (select min(rowid)from detail_price group by rule_id,city_id having count>1 )