MySQL Forums
Forum List  »  InnoDB

Duplicate Entry for an Auto-increment column
Posted by: East Heretic
Date: September 13, 2006 10:47PM

I'm running an application which stores large volumes of property data using MySQL 5.0, MySQL.Net and stored procedures. Sometimes, I get the following error (whenever 2 or more people are entering data):

#23000 Duplicate entry '<some number>' for key 1

The thing is the primary key is set to auto-increment. I can understand if it's not, but it is and I don't know why this is happening. Has anyone experienced this before?


Options: ReplyQuote

Written By
Duplicate Entry for an Auto-increment column
September 13, 2006 10:47PM

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.