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]