sql多表关联删除

最新推荐文章于 2024-04-25 20:58:33 发布

XiaoOfxiao

最新推荐文章于 2024-04-25 20:58:33 发布

阅读量1.1k

点赞数

文章标签： sql Powered by 金山文档

本文链接：https://blog.csdn.net/weixin_53304105/article/details/129591433

版权

  @Delete("DELETE blo,col,com,ima,lik,vid FROM blog blo" +
            " LEFT JOIN collect col ON col.blog_id=blo.blog_id " +
            " LEFT JOIN comment com ON com.blog_id=blo.blog_id " +
            " LEFT JOIN image ima ON ima.blog_id=blo.blog_id    " +
            " LEFT JOIN mylike lik ON lik.blog_id=blo.blog_id    " +
            " LEFT JOIN video vid ON vid.blog_id=blo.blog_id   " +
            "WHERE blo.blog_id = #{blog_id} ")
    Integer deleteBlogById(@Param("blog_id") String blog_id);