本文介绍如何通过SQL更新语句，将DEMO_A表中与DEMO_B匹配的ID和NAME_S对应字段的AGE、NAME_L和SALARY值，实现两个表之间的数据同步。
1、基本情况；2个表DEMO_A和DEMO_B结构完全一样
select * from DEMO_A
select * from DEMO_B
2、需求：把DEMO_A中ID与NAME_S与DEMO_B中ID与NAME_S相同的行的AGE、NAME_L、SALARY的值写入DEMO_B中对应的字段。
UPDATE DEMO_B B
SET (AGE,NAME_L,SALARY) = (SELECT AGE,NAME_L,SALARY FROM DEMO_A A WHERE B.ID = A.ID AND B.NAME_S = A.NAME_S )
WHERE EXISTS(SELECT 1 FROM DEMO_A A WHERE B.ID = A.ID AND B.NAME_S = A.NAME_S)
3、结果
扫一扫
1万+
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
