It used to do what you are saying. That was very bad. For example, we stored click data for articles. Whe the articles were archived for speed reasons, MySQL started filling in the holes. When we got back around to archiving those rows, we could not do so as the archive table already had rows matching that id.
so, you have to pick your poison. an unsigned it is 4,294,967,295. You can safely go to 9,223,372,036,854,775,807 with a big int. I know I won't hit a wall anytime soon. Brian. ----- Original Message ----- From: "Scott Munday" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, August 20, 2002 1:18 PM Subject: Suggestion on New MySQL Function | Through your MySQL documentation, I wasn't able to find a function that I | think could be useful. If you DELETE a row with an INT AUTO_INCREMENT field, | it will still be able to add the next highest value to this column on an | INSERT (ex. If after INSERTing rows, you DELETE a row with a value of five | in its INT AUTO_INCREMENT column and the highest value for this particular | INT column is currently six, your next INSERTed row will have a value of | seven). This is very troubling for me, since at some point this INT will | reach it's limit with 'holes' within the table. I think a function to find | the lowest hole in a specified table would be a useful addition to further | upgrades. Thank you for your time and patience. | Sincerely, | Trash Phantom | | | --------------------------------------------------------------------- | Before posting, please check: | http://www.mysql.com/manual.php (the manual) | http://lists.mysql.com/ (the list archive) | | To request this thread, e-mail <[EMAIL PROTECTED]> | To unsubscribe, e-mail <[EMAIL PROTECTED]> | Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php | | --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
