Insert...on duplicate key update in other databases(ParAccel) except MySql
Insert...on duplicate key update in MySql is not a sql standard. Can we treat this statement as atomic? Is there any equ开发者_如何学Goivalent statements in other databases especially ParAccel? If no,considering atomic or performance,how to design the statement by using sql92 sql99 or other standards?
The close equivalent in Standard SQL is MERGE
, introduced in SQL-99 and altered slightly in SQL:2003.
MERGE
is widely supported e.g. SQL Server 2008, Oracle 9, PostgreSQL, etc.
精彩评论