By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
id | val1 | val2 | val3 |
---|---|---|---|
1 | 11 | 111 | 1111 |
2 | 22 | 222 | 2222 |
id | val1 | val2 | val3 |
---|---|---|---|
1 | null | 11111 | null |
2 | 22222 | null | null |
COLUMN_NAME |
---|
val1 |
val2 |
val3 |
@sql |
---|
UPDATE t1 JOIN t2 USING (id) SET t2.val1 = COALESCE(t2.val1, t1.val1),t2.val2 = COALESCE(t2.val2, t1.val2),t2.val3 = COALESCE(t2.val3, t1.val3); |
id | val1 | val2 | val3 |
---|---|---|---|
1 | 11 | 11111 | 1111 |
2 | 22222 | 222 | 2222 |