phpMyAdmin--resetting auto increments to 0
| From: | alex | Date: | Sun, 16 Apr 2006 06:46:25 +0000 |
| Subject: | phpMyAdmin--resetting auto increments to 0 | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-234059@lists.php.net to get a copy of this message | ||
hi everyone
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
regards alex