List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:August 21 2001 2:06pm
Subject:Re: Resetting Auto Increment Count
View as plain text  
At 2:31 PM +0100 8/21/01, Brian Leyland wrote:
>Hello,
>
>I need to reset the auto increment value on a database.
>
>Can anyone help.
>
>
>Thanks
>
>Brian

If it's a MyISAM table and you mean that you want to reset the sequence
so that MySQL will next use the smallest currently unused value, do this:

ALTER TABLE tbl_name AUTO_INCREMENT = 0

If you mean something else, please specify.

-- 
Paul DuBois, paul@stripped
Thread
Resetting Auto Increment CountBrian Leyland21 Aug
  • Re: Resetting Auto Increment CountPaul DuBois21 Aug