如下:
有 A 表name sex agetom man
marry womanB表name agetom 12
marry 13
如何用update语句将B表中的age更新到A表中的age中?
有 A 表name sex agetom man
marry womanB表name agetom 12
marry 13
如何用update语句将B表中的age更新到A表中的age中?
updata A
set age = (select age from B where name = A.name)
where exists(select 1 from B where name = A.name)
update A
set age = (select age from B where name = A.name)
where exists(select 1 from B where name = A.name)
UPDATE A
SET age =
(SELECT age FROM B WHERE NAME = A.name)
WHERE EXISTS (SELECT 1 FROM B WHERE NAME = A.name);
--10g以上可用
MERGE INTO A
USING B
ON (a.name = b.name)
WHEN MATCHED THEN
UPDATE SET a.age = b.age;
set age = B.age
from A
join B
on A.name = B.name