MySQL表间关联Update和Delete

最新推荐文章于 2024-03-25 13:12:38 发布

西二旗老司机

最新推荐文章于 2024-03-25 13:12:38 发布

阅读量408

点赞数

分类专栏：数据库

本文链接：https://blog.csdn.net/wud_jiyanhui/article/details/80979169

版权

数据库专栏收录该内容

7 篇文章 0 订阅

订阅专栏

本文分表介绍了如何用update ,delete做联表操作的方法：

update

update 
    a left join b on a.id=b.a_id 
set 
    a.title='aaaaa',b.body='bbbb' 
where 
    a.id=1

UPDATE 
    mem_world AS mw1 
    INNER JOIN mem_world  AS  mw2   
    ON mw1.parentid = mw2.wid  
SET 
    mw1.level = mw2.level   
WHERE 
    mw2.baseid = 107   
    AND  mw2.parentid = 0   
    AND  mw2.size > 1

delete

delete a,b from 
    a left join b on a.id=b.a_id 
where 
    a.id=1

DELETE mwb FROM  
    mem_world_building AS mwb 
    INNER JOIN 
    mem_world AS mw 
    ON mwb.wid = mw.wid 
where 
    mw.type between 11 and 15  
    and baseid = 107  
    and mw.parentid <> 0  
    and  mw.size > 1