Re: Duplicate Entry for an Auto-increment column
Try do a
select max(auto_inc_col) from tablename
And what is the datatype you used for the auto_inc column
If you reach the max value of the datatype, mysql may truncate to the max value and you got a duplicate key error.
Subject
Views
Written By
Posted
5207
September 13, 2006 10:47PM
3485
September 14, 2006 10:45AM
Re: Duplicate Entry for an Auto-increment column
3209
September 14, 2006 07:10PM
3025
September 14, 2006 10:31PM
2966
September 15, 2006 01:06AM
2845
September 19, 2006 12:55AM
3251
September 19, 2006 02:05AM
10276
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.