开发者

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.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜