MySQL删除重复记录并保留记录id最大的一条

##删除重复的数据
DELETE FROM es_express_routing WHERE (express_code,company_code) IN(
    SELECT express_code,company_code FROM (SELECT COUNT(*) c , express_code,company_code FROM es_express_routing GROUP BY express_code,company_code  HAVING c > 1) t
) AND id NOT IN (
    SELECT t.id FROM (SELECT MAX(id) id FROM es_express_routing GROUP BY express_code,company_code  HAVING COUNT(*) > 1) t);
##更新为，唯一索引    
ALTER TABLE  es_express_routing DROP INDEX idx_unique_express_routing,ADD UNIQUE idx_unique_express_routing (express_code,company_code);