RE: [PHP] phpMyAdmin--resetting auto increments to 0
| From: | Jay Blanchard | Date: | Sun, 16 Apr 2006 18:45:29 +0000 |
| Subject: | RE: [PHP] phpMyAdmin--resetting auto increments to 0 | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-234084@lists.php.net to get a copy of this message | ||
[snip]
i have delete a few entries in my database as they were entered for
testing
purposes and are no longer need (actually 102 entries)... and even
thought
that db is empty i noticed that when the next entry went in the id
number
went to 103
not 0 so i was wondering is it possible to somehow reset the value to
zero...
it is of int type and auto_increment
i have a few db's which id like to reset to zero i have tried placing a
zero
enrty after deleting the lot but it only jumps to its next increment.
does anyone know what i mean...?
any help will be grateful
[/snip]
Darned basic SQL;
TRUNCATE <table>
Will empty the table and reset the auto-increment back to the beginning.