MySQL Forums
Forum List  »  Performance

Advanced Search
New Topic

Re: ON DUPLICATE ... bug or feature?
Posted by: Sergey Petrunya
Date: December 04, 2004 11:24PM

ON DUPLICATE KEY doesn't work for INSERT ... SELECT, see http://dev.mysql.com/doc/mysql/en/INSERT_SELECT.html for what is supported.
You could probably use INSERT IGNORE and after that process duplicates separately.

Sergey Petrunia, Software Developer
MySQL AB, www.mysql.com
My blog: http://s.petrunia.net/blog

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


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