mysql delete 删除满足子查询结果数据的操作

最新推荐文章于 2025-01-05 17:07:07 发布

胖带鱼

最新推荐文章于 2025-01-05 17:07:07 发布

阅读量6.1k

点赞数 6

分类专栏： MYSQL

本文链接：https://blog.youkuaiyun.com/cr27225/article/details/103519819

版权

MYSQL 专栏收录该内容

10 篇文章

订阅专栏

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
    )