关于MySQL中删除满足子查询结果数据的操作

最新推荐文章于 2024-04-16 13:41:20 发布

weixin_30421525

最新推荐文章于 2024-04-16 13:41:20 发布

阅读量497

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/wing7319/p/10458765.html

版权

关于MySQL中删除满足子查询结果数据的操作

关键问题:MySQL不允许在子查询中使用要删除的表

错误示范:

DELETE
FROM
post_activity_user
WHERE
id IN (
SELECT
    a.id
FROM
    post_activity_user a
LEFT JOIN post_activity_info b ON a.activity_id = b.id
WHERE
    b.enterprise_id = 10000000
AND b.activity_type = 3
)

正确处理:

DELETE
FROM
    post_activity_user
WHERE
    post_activity_user.id IN (
        SELECT
            *
        FROM
            (
                SELECT
                    a.id
                FROM
                    post_activity_user a
                LEFT JOIN post_activity_info b ON a.activity_id = b.id
                WHERE
                    b.enterprise_id = 10000000
                AND b.activity_type = 3
            ) ee
    )

转载于:https://www.cnblogs.com/wing7319/p/10458765.html