Re: INSERT on duplicate UPDATE?

[Sergei Golubchik]

Hi!

On Sep 14, 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?

In the manual:
http://dev.mysql.com/doc/mysql/en/INSERT.html

> Is this ANSI-SQL standard ?

No.

> Or is it even documented?

Of course.
http://dev.mysql.com/doc/mysql/en/INSERT.html

Regards,
Sergei

-- 
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /   Sergei Golubchik <serg@stripped>
 / /|_/ / // /\ \/ /_/ / /__  MySQL AB, Senior Software Developer
/_/  /_/\_, /___/\___\_\___/  Osnabrueck, Germany
       <___/  www.mysql.com