I have a copy of 3.23.56 running on one of my machines and it does NOT wrap auto_increment columns when the upper limit is reached. I haven't tested it with any newer versions, though I doubt they'd be any different. If this is a concern for you then I would suggest using a bigger column type for auto_incrementing and making that column unsigned. The extra space required for your DB is really trivial compared to the saved headaches of devising your own wrap/reshuffle scheme.
-Rob -----Original Message----- From: TheMechE [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 15, 2003 9:40 AM To: [EMAIL PROTECTED] Subject: What about auto number primary key - wrapping? Has anyone had a table that has lived long enough to wrap the auto incrementing number...? i.e. the complete byte span and back to 0x32. I'm just wondering if mySql will fill in the deleted ID's that don't exist, or if it just halts... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
