This topic was discussed about two weeks ago. The over-riding question was: Why does it matter that the numbers are consecutive?
Sir, I pose that question to you. -----Original Message----- From: Bryan Capitano [mailto:[EMAIL PROTECTED]] Sent: Sunday, October 14, 2001 9:21 AM To: mysql Subject: Consequtive, Sequential auto-increment? When I delete items from a table where I've got an auto-incremented primary key/index, call it table_id, I'd like to keep this column consequtive and sequential. In other words, when I delete items from the middle, then the column is no longer "sequential" because there is a number missing. Is there a function to re-index the column? -- CAPITANO WEB CONSULTING Bryan R. Capitano CELL: 541-760-6288 HOME: 541-929-5060 --------------------------------------------------------------------- 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