From: Date: October 18 2004 9:52pm
Subject: Re: INSERT on duplicate UPDATE?
List-Archive: http://lists.mysql.com/mysql/174399
Message-Id: <20041018195158.GA52308@serg.mylan>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

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