From: Date: September 14 2004 10:21pm
Subject: Re: INSERT on duplicate UPDATE?
List-Archive: http://lists.mysql.com/mysql/172602
Message-Id: <414752DE.1030801@Frixx-iT.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit

I think what you mean is REPLACE. Try 
http://dev.mysql.com/doc/mysql/en/REPLACE.html

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?
>

-- 

Schippers Dirk
Zaakvoerder Frixx-iT
http://www.frixx-it.com
------------------------------------------------------------------------
Bezoek ook http://www.verhalensite.com voor uw literaire tekortkomingen.