mysql 删除重复的数据只保留一条

支持单表中重复数据的删除处理：

    1.查询重复的数据条数

    SELECT MIN(Id) Id,user_id,team_id FROM auth_user_team
    GROUP BY user_id,team_id

    HAVING COUNT(1) >  1

    2.删除对应记录(关联查出的重复数据）

    (注：user_id,team_id为重复项)

        

DELETE C FROM auth_user_team C 

JOIN (
    SELECT MIN(Id) Id,user_id,team_id FROM auth_user_team
    GROUP BY user_id,team_id
    HAVING COUNT(1) >  1
) TMP ON C.team_id = TMP.team_id AND c.user_id = TMP.user_id AND C.Id <> TMP.Id