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
Peter

Options: ReplyQuote


Subject
Views
Written By
Posted
ON DUPLICATE ... bug or feature?
2682
December 04, 2004 06:32AM
1770
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.