alex wrote:
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
Select the desired database on the left. The browser
will reload and show the "STRUCTURE" page.
Click on the SQL tab; the browser should now load a
page with a textarea that says "Run SQL query/queries
on database FOOBAR".
Enter the following in the textarea:
ALTER TABLE footable auto_increment=0;
and then press the "GO" button.
You can set the auto_increment number to any positive
integer, AFAIK, though there might be a limit.
:-)
Kevin Kinsey
--
Just because you're paranoid doesn't mean they AREN'T after you.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
