更新一列：
update mytab a set name=(select b.name from goal b where b.id=a.id)
where exists (select 1 from goal b where b.id=a.id);

更新多列：
update mytab a
   set  (name,address)=(select b.name,b.address
                                     from   goal b
                                     where b.id=a.id)
   where exists (select 1
                  from goal b
                  where b.id=a.id )

特别是要注意exists后面的语句：）这会让目标行不至于为NULL

ITPub博客

Update 多个关联表SQL的写法

最新文章