mysql删除重复数据

最新推荐文章于 2025-09-08 20:55:49 发布

转载最新推荐文章于 2025-09-08 20:55:49 发布 · 39 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/jason123/p/9753951.html

文章标签：

#数据库

DELETE
FROM
    table
WHERE
    id IN (
        SELECT
            src.id
        FROM
            (
                SELECT
                    t1.id
                FROM
                    table t1
                WHERE
                    (
                        t1.col1,
                        t1.col2,
                        t1.col3,
                        t1.col4,
                        t1.col5
                    ) IN (
                        SELECT
                            col1,
                            col2,
                            col3,
                            col4,
                            col5
                        FROM
                            table
                        GROUP BY
                            col1,
                            col2,
                            col3,
                            col4,
                            col5
                        HAVING
                            count(*) > 1
                    )
                AND t1.id NOT IN (
                    SELECT
                        MAX(id)
                    FROM
                        table
                    GROUP BY
                        col1,
                        col2,
                        col3,
                        col4,
                        col5
                                
                    HAVING
                        count(*) > 1
                )
            ) src
    );