首页 > 数据库技术 > 详细

mysql删除重复数据

时间:2018-10-08 14:46:50      阅读:152      评论:0      收藏:0      [点我收藏+]
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
    );

 

mysql删除重复数据

原文:https://www.cnblogs.com/jason123/p/9753951.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!