Hi, I know that the H2 'MERGE' syntax is non-standard. Actually I knew that when I implemented it. The reason is that the standard MERGE syntax is complicated. Hard to implement and hard to use (in my view). Very verbose; also you have to specify values twice. I wanted to provide a simple solution. The standard MERGE syntax can still be implemented if required (there is already a feature request for it).
The H2 MERGE works like MySQL 'REPLACE', however in H2 you can additionally set the key columns (MySQL it always using the primary key). I didn't know about the MySQL 'REPLACE' so far, maybe that's what I will implement next (it would be just a parser change). Regards, Thomas -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
