Mysql删除重复数据保留最小的id

DELETE

FROM

    people

WHERE

    peopleName IN (

        SELECT

            peopleName

        FROM

            people

        GROUP BY

            peopleName

        HAVING

            count(peopleName) > 1

    )

AND peopleId NOT IN (

    SELECT

        min(peopleId)

    FROM

        people

    GROUP BY

        peopleName

    HAVING

        count(peopleName) > 1

)

1 delete from tb where id in (SELECT max(id) from tb GROUP BY user HAVING count(user)>1)

1 delete from tb where id=xx