u can't
----- Original Message -----
From: "Ron Piggott" <[EMAIL PROTECTED]>
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??

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to