upsert

오라클

 -  merge into

mysql

 -  on duplicate on key update

 

 

* 구문

 

INSERT INTO [TABLE] (COLUMN1, COLUMN2, ...)

VALUES (VALUE1, VALUE2, ...)

ON CONFLICT [column_name / ON CONSTRAINT constraint_name/ WHERE predicate]

[DO NOTHING] 

[DO UPDATE SET column1 = value1, ...]