List:MySQL on Win32« Previous MessageNext Message »
From:Paul DuBois Date:June 9 2001 11:57pm
Subject:Re: Auto Increment Problems Again
View as plain text  
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?


will tell MySQL to reset the sequence counter.

>Please check "" 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
Auto Increment Problems AgainMatt Neimeyer9 Jun
  • Re: Auto Increment Problems AgainPaul DuBois10 Jun