MySql 删除重复记录，只保留一条

DELETE
FROM
    error_barcode
WHERE
    barCode IN (
        SELECT
            a.barCode
        FROM
            (SELECT * FROM error_barcode) a
        GROUP BY
            barCode
        HAVING
            count(barCode) > 1
    )
AND id NOT IN (
    SELECT
        min(id)
    FROM
        (SELECT * FROM error_barcode) b
    GROUP BY
        barCode
    HAVING
        count(barCode) > 1
)