[development] MySQL Insert on Duplicate Key Update

[Chris Johnson]

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