MySQL Forums
Forum List  »  Performance

ON DUPLICATE ... bug or feature?
Posted by: Peter Witschi
Date: December 04, 2004 06:32AM

Hello there

I'm tried to use the following statement:

INSERT INTO tmpTable SELECT * FROM otherTable ON DUPLICATE KEY UPDATE tmpTable.r1=tmpTable.r1+1000

It got only an SQL Error... what is here wrong? My statement or my brain?

kind regards

Options: ReplyQuote

Written By
ON DUPLICATE ... bug or feature?
December 04, 2004 06:32AM
December 04, 2004 11:24PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.