If you have not obtained Paul DuBois's "MySQL" (New Riders pub, ISBN 0-7357-0921-1), you should consider it a great investment.
For what it's worth, page 169 has a section on resequencing auto_increment columns that you might be able to apply to your database. Undoubtedly, there are pages on the online docs too, I just found his book, dog eared and easy to find things. HTH, Tony On Friday 26 October 2001 08:07 pm, Joe wrote: > Is there a query I can run to change the next autoindex to the next highest > integer in the column. > > I mean I have my userIDs, and they are autoincrementing. But if I have say > 9 users delete 5 of users, and then want to compact the table so that the > ids are all sequential. How can I make it so the next autoincrement starts > from say 5 instead of ten? > > thanks > I hope this makes sense > > > --------------------------------------------------------------------- > 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
