MySQL Forums
Forum List  »  Performance

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

Options: ReplyQuote


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