Re: auto_increment command
| From: | bedul | Date: | Mon, 12 Mar 2007 01:55:50 +0000 |
| Subject: | Re: auto_increment command | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-43246@lists.php.net to get a copy of this message | ||
u can't
----- Original Message -----
From: "Ron Piggott" <ron.php@actsministries.org>
To: "PHP DB" <php-db@lists.php.net>
Sent: Monday, March 12, 2007 7:52 AM
Subject: [PHP-DB] auto_increment command
> I am not sure if that last e-mail went through or not. I am wondering
> how to re-set the auto_increment field back to 1 in one of my tables.
> Ron
there no such thing reset auto_increment
if you need the reset.. there were way to do that.
rename the table.. then take query to build it
create new table and tralalla.. u have reset it.
fyi. if inside the table already have a data were id was 100.. the next id
must be 101..
btw.. if you want to make your table more clean (i said about.. how random
the num).. there is a way.
what reason u wanna do that??