如何在单个SQL查询中更新和插入数据。

Question

可能重复：
Oracle: how to UPSERT (update or insert into a table?)
How to Perform an UPSERT so that I can use both new and old values in update part如何在单个SQL查询中更新和插入数据。

我想知道如何单查询可以更新，并从数据库中删除数据。

请帮我这个:)

Answer 1

INSERT INTO table_name (column1, column2, column3,...) 
VALUES (value1, value2, value3,...); DELETE FROM table_name 
WHERE some_column=some_value 

我觉得

Answer 2

delete from table where id = 1 
update table set name = 'john' where id = 1 

Answer 3

有一个MERGE命令。
它可以让你做upserts。自10g以来，它还包含一个DELETE子句