Re: auto_increment back to zero?
| From: | php3 at developersdesk dot com | Date: | Mon, 12 Jun 2000 23:33:26 +0000 |
| Subject: | Re: auto_increment back to zero? | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-1673@lists.php.net to get a copy of this message | ||
Addressed to: "fredo" <fredo@pandora.be>
php-general@lists.php.net
** Reply to note from "fredo" <fredo@pandora.be> Mon, 12 Jun 2000 18:42:16 +0200
>
> Small follow up,
>
> Anyone knows an easy way to set a auto_increment field back to 0?
>
DELETE FROM TableName;
The value of the auto_increment next field is 1 higher than the highest
value currently in the table. The only way to set it back to 0 is to
empty the table.
Rick Widmer
Internet Marketing Specialists
www.developersdesk.com