From: Paul DuBois Date: June 9 2001 11:57pm Subject: Re: Auto Increment Problems Again List-Archive: http://lists.mysql.com/win32/6403 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" ; format="flowed" 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