From: Date: September 14 2004 10:20pm
Subject: INSERT on duplicate UPDATE?
List-Archive: http://lists.mysql.com/mysql/172601
Message-Id: <4147528E.5050708@unclassified.de>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit

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?

-- 
Yves Goergen <nospam.list@stripped>

BlackBoard Internet Newsboard System --> blackboard.unclassified.de
Free (GPL), easy to use and install, secure, innovative! (PHP+MySQL)