turing85 commented on PR #9286: URL: https://github.com/apache/camel/pull/9286#issuecomment-1425653065
> @turing85 One more question: > > If I understand correctly, this `insertSqlString` is vendor-specific, for `Mysql` there is [insert-on-duplicate](https://dev.mysql.com/doc/refman/8.0/en/insert-on-duplicate.html) statment. I just wonder if this is much better for inserting? @zhfeng Hmm... we could use [`SQL:2003`](https://en.wikipedia.org/wiki/SQL:2003)'s `MERGE` (which is effectively an `upsert`, have to play around with this a little bit to figure out how to use it with literals). But this does not seem widely adopted, e.g. MySQL does not support `SQL:2003`. And the general question is if we want to bind this implementation to such a "young" standard. This would eliminate the possibility to use it with older database systems/versions. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
