mysql 删除重复记录保存一条

####删除重复记录 获得需要保存的
delete from t_config where id not in ( select * from ( select min(id) from t_config group by clientId ) as a );


####删除重复记录  获得需要删除的
delete t_config as a from t_config as  a,(
          select min(id) id , clientId from t_config group by clientId having count(clientId) > 1
      ) as b
      where a.clientId = b.clientId and a.id <> b.id;