Set the autoincrement column to the max value or the given data type (via alter table), insert a record and see what happens...
Cheers /rudy -----Original Message----- From: TheMechE [mailto:[EMAIL PROTECTED] Sent: dinsdag 15 juli 2003 15:40 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]