At 5:04 PM -0400 6/9/01, Matt Neimeyer wrote:
>I just finished creating a database and it's application and prior
>to putting it into production I went through and cleaned up all the
>auto increment columns so that the test ID's that I used are
>available again. But now the numbers being generated are still in
>the higher range... for example If I had 1 4 10 and I fixed it to 1
>2 3 the next id being generated is 11 instead of 4.
>
>Is there something I need to do to make it use the new lower range?
ALTER TABLE tbl_name AUTO_INCREMENT = 0
will tell MySQL to reset the sequence counter.
>
>Matt
>
>
>---------------------------------------------------------------------
>Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
>posting. To request this thread, e-mail win32-thread6401@stripped
>
>To unsubscribe, send a message to the address shown in the
>List-Unsubscribe header of this message. If you cannot see it,
>e-mail win32-unsubscribe@stripped instead.
--
Paul DuBois, paul@stripped
