Re: INSERT on duplicate UPDATE?

[Mayuran Yogarajah]

Yves Goergen wrote:

> Hi,
> I can vaguely remember there was something like "INSERT... on 
> duplicate key UPDATE..." in MySQL, but the documentation search is 
> almost as useful as I'm used to - it cannot tell me anything about 
> this. Can you please? How does this work, what's the syntax? Is this 
> ANSI-SQL standard (or compatible to other DBMS)? Or is it even 
> documented?
>

Its described in the INSERT syntax, and is available as of v4.1.1.
http://dev.mysql.com/doc/mysql/en/INSERT.html

M