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?

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