티스토리 뷰
728x90
UPDATE A
SET value = (
SELECT value
FROM B
WHERE B.id = A.id
);
DELETE FROM A
WHERE EXISTS (
SELECT 1
FROM B
WHERE A.id = B.id
);
[출처] https://tora-it-kingdom.tistory.com/10
728x90
'공부' 카테고리의 다른 글
[Algorithm] Swap by 3 XOR (0) | 2020.01.18 |
---|---|
[Oracle] Alter Table (0) | 2020.01.18 |
[Oracle] Update & Delete by Join Table (0) | 2020.01.18 |
[Spring] @Async & @AOP (0) | 2020.01.18 |
[HDFS] Export & Import (0) | 2020.01.18 |
[Python] Filter dict (0) | 2020.01.18 |
댓글