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.


-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]



Reply via email to