List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:September 17 2001 5:21am
Subject:Re: trying to reset auto-increment
View as plain text  
At 11:05 PM -0400 9/16/01, <matt@stripped> wrote:
>I manually entered into my database several rows with high values in the
>auto-increment column.  I subsequently deleted the high value rows.  I now
>am trying to reset the auto-increment.  How do I reset it to the Max of
>the currently existing values?

ALTER TABLE tbl_name AUTO_INCREMENT = 1

>
>-matt
>matt@stripped
>====================================================
>Ecosandals.com
>Making sandals, enriching lives
>Kutengeneza akala, kuinua maisha
>====================================================


-- 
Paul DuBois, paul@stripped
Thread
trying to reset auto-incrementmatt17 Sep
Re: trying to reset auto-incrementPaul DuBois17 Sep