MySQL Forums
Forum List  »  General

Advanced Search
New Topic

INSERT ... ON DUPLICATE KEY UPDATE resulting in #1062 'Duplicate entry' error
Posted by: James H
Date: October 05, 2009 04:34AM

I'm using the INSERT ... ON DUPLICATE KEY UPDATE sql, but I'm somehow getting back a #1062 'Duplicate entry' error. How can this be? It's as if the INSERT part fails (due to entry duplication) which is fine, but the ON DUPLICATE KEY UPDATE part isn't even attempted.

Anyone else experienced this or know what the solution might be?

Cheers,
James

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


Subject
Written By
Posted
INSERT ... ON DUPLICATE KEY UPDATE resulting in #1062 'Duplicate entry' error
James H
October 05, 2009 04:34AM
Re: INSERT ... ON DUPLICATE KEY UPDATE resulting in #1062 'Duplicate entry' error
Rick James
October 06, 2009 11:24PM
Re: INSERT ... ON DUPLICATE KEY UPDATE resulting in #1062 'Duplicate entry' error
James H
November 24, 2009 09:05AM
Re: INSERT ... ON DUPLICATE KEY UPDATE resulting in #1062 'Duplicate entry' error
Rick James
November 24, 2009 11:21PM


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.