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]

Reply via email to