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
5207
September 13, 2006 10:47PM
3485
September 14, 2006 10:45AM
3210
September 14, 2006 07:10PM
3025
September 14, 2006 10:31PM
2966
September 15, 2006 01:06AM
2846
September 19, 2006 12:55AM
3251
September 19, 2006 02:05AM
10278
February 12, 2007 07:56AM
3361
February 24, 2007 01:05PM
3328
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.