Chris Bolt wrote:
Only with ISAM tables which reuse deleted auto_increment numbers. MyISAM
tables will give you Duplicate entry errors if you hit the maximum.
I hadn't realized this and tested it out in MySQL 3.23.43, but in my tests
ISAM tables also returned a Duplicate entry error when I
Only with ISAM tables which reuse deleted auto_increment numbers. MyISAM
tables will give you Duplicate entry errors if you hit the maximum.
I hadn't realized this and tested it out in MySQL 3.23.43, but in my tests
ISAM tables also returned a Duplicate entry error when I hit
the max. Was
Chris Bolt wrote:
Only with ISAM tables which reuse deleted auto_increment numbers. MyISAM
tables will give you Duplicate entry errors if you hit the maximum.
I hadn't realized this and tested it out in MySQL 3.23.43, but in my tests
ISAM tables also returned a Duplicate entry error when
quickie: can auto_increment wrap?
I have a system that uses mysql for temporary storage of
data. The records are kept unique in the usual lazy man's
way of having an auto_increment ID field.
A large number of records come and go from this database.
At SOME point in the future, the integer
quickie: can auto_increment wrap?
Only with ISAM tables which reuse deleted auto_increment numbers. MyISAM
tables will give you Duplicate entry errors if you hit the maximum.
-
Before posting, please check:
http
In the last episode (Oct 27), D Campbell said:
quickie: can auto_increment wrap?
I have a system that uses mysql for temporary storage of data. The
records are kept unique in the usual lazy man's way of having an
auto_increment ID field.
A large number of records come and go from