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