출처1 :&nbsp;<a href="https://stackoverflow.com/questions/3384127/delete-sql-rows-where-ids-do-not-have-a-match-from-another-table" target="_blank" style="user-select: auto;">https://stackoverflow.com/questions/3384127/delete-sql-rows-where-ids-do-not-have-a-match-from-another-table</a>출처2 :&nbsp;<a href="https://stackoverflow.com/questions/2513174/avoid-duplicates-in-insert-into-select-query-in-sql-server" target="_blank" style="user-select: auto;">https://stackoverflow.com/questions/2513174/avoid-duplicates-in-insert-into-select-query-in-sql-server</a> 데이터 싱크를 맞추어야 한다면 템프테이블 같은 곳에 미리 데이터를 담아주고 아래와 같이 사용하면 빠르게 동기화 할 수 있다.&nbsp;아래 내용 중 update는 빠져있다. <h1 style="user-select: auto;">중복 제외 INSERT</h1><h4 style="user-select: auto;">Using `NOT EXISTS`</h4><pre style="background-color:#2b2b2b;color:#a9b7c6;font-family:'JetBrains Mono',monospace;font-size:9.8pt;">INSERT INTO TABLE_2 (ID, NAME) SELECT T1.ID , T1.NAME FROM TABLE_1 T1 WHERE NOT EXISTS(SELECT ID FROM TABLE_2 T2 WHERE T2.ID = T1.ID)</pre> <h4 style="user-select: auto;">Using `NOT IN`</h4><div><pre style="background-color:#2b2b2b;color:#a9b7c6;font-family:'JetBrains Mono',monospace;font-size:9.8pt;">INSERT INTO TABLE_2 (ID, NAME) SELECT T1.ID , T1.NAME FROM TABLE_1 T1 WHERE T1.ID NOT IN (SELECT ID FROM TABLE_2)</pre></div><div> </div><div><h4 style="user-select: auto;">Using `LEFT JOIN/IS NULL`</h4></div><pre style="background-color:#2b2b2b;color:#a9b7c6;font-family:'JetBrains Mono',monospace;font-size:9.8pt;">INSERT INTO TABLE_2 (ID, NAME) SELECT T1.ID , T1.NAME FROM TABLE_1 T1 LEFT JOIN TABLE_2 T2 ON T2.ID = T1.ID WHERE T2.ID IS NULL</pre> <h1 style="user-select: auto;">없는 것 DELETE</h1><h4 style="user-select: auto;">Using `NOT EXISTS`</h4><pre style="background-color:#2b2b2b;color:#a9b7c6;font-family:'JetBrains Mono',monospace;font-size:9.8pt;">DELETE FROM BLOB WHERE NOT EXISTS(SELECT NULL FROM FILES F WHERE F.ID = FILEID)</pre><h4 style="user-select: auto;"> </h4><h4 style="user-select: auto;">Using `NOT IN`</h4><pre style="background-color:#2b2b2b;color:#a9b7c6;font-family:'JetBrains Mono',monospace;font-size:9.8pt;">DELETE FROM BLOB WHERE FILEID NOT IN (SELECT F.ID FROM FILES F)</pre> <h4 style="user-select: auto;">Using `LEFT JOIN/IS NULL`</h4><pre style="background-color:#2b2b2b;color:#a9b7c6;font-family:'JetBrains Mono',monospace;font-size:9.8pt;">DELETE B FROM BLOB B LEFT JOIN FILES F ON F.ID = B.FILEID WHERE F.ID IS NULL</pre>

[MySql & MariaDB] 중복 제외 INSERT, DELETE / 효과적으로 데이터 동기화 하기 (NOT EXISTS, sync etc)