Re: [development] MySQL Insert on Duplicate Key Update

Ken Rickard wrote:

What is the opinion regarding the use of MySQL's syntax for:

INSERT .... ON DUPLICATE KEY UPDATE

http://dev.mysql.com/doc/refman/4.1/en/insert-on-duplicate.html <http://dev.mysql.com/doc/refman/4.1/en/insert-on-duplicate.html>

I haven't seen any code that uses it. Is that habit or policy?

I always vote for using standard SQL unless there are very strong arguments for using a MySQL-only extension (or any database extension, really), unless it can be easily abstracted out. ..chrisxj