MySQL Forums
Forum List  »  Performance

Advanced Search
New Topic

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

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
ON DUPLICATE ... bug or feature?
2782
Peter Witschi
December 04, 2004 06:32AM
Re: ON DUPLICATE ... bug or feature?
1814
Sergey Petrunya
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.