List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:September 26 2001 10:40pm
Subject:Re: Reset Auto Increment
View as plain text  
At 6:03 PM -0500 9/25/01, mickalo@stripped wrote:
>Hi All,
>
>I seen a post a few days ago on how to set the auto increment value 
>back to one
>after deleting all the data from a table. I suppose I could just re-create the
>table, but thought it be simpler to just alter the table to reset the auto
>increment value back to 1. what exactly is the "alter" syntax to reset it??

If you saw a post, then the link at the bottom of each message indicates
how to get to the list archive.  You'll find the answer there.  Often
a useful strategy.  In any case, the answer is:

ALTER TABLE tbl_name AUTO_INCREMENT = 1

>
>thx's
>
>mysql database
>
>Mike(mickalo)Blezien
>=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
>Thunder Rain Internet Publishing
>Providing Internet Solutions that work!
>http://www.thunder-rain.com
>Tel: 1(225)686-2002
>=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
>
>
>---------------------------------------------------------------------
>Before posting, please check:
>    http://www.mysql.com/manual.php   (the manual)
>    http://lists.mysql.com/           (the list archive)
>
>To request this thread, e-mail <mysql-thread86380@stripped>
>To unsubscribe, e-mail <mysql-unsubscribe-paul=snake.net@stripped>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-- 
Paul DuBois, paul@stripped
Thread
Reset Auto Incrementmickalo26 Sep
  • RE: Reset Auto Incrementjohnlucas-Arluna26 Sep
  • Re: Reset Auto IncrementPaul DuBois27 Sep