Duplicate Entry for an Auto-increment column
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?
Thanks.
Subject
Views
Written By
Posted
Duplicate Entry for an Auto-increment column
5222
September 13, 2006 10:47PM
3489
September 14, 2006 10:45AM
3214
September 14, 2006 07:10PM
3029
September 14, 2006 10:31PM
2974
September 15, 2006 01:06AM
2854
September 19, 2006 12:55AM
3259
September 19, 2006 02:05AM
10287
February 12, 2007 07:56AM
3363
February 24, 2007 01:05PM
3331
October 02, 2008 11:06AM
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.