You can, but it has nothing to do with PHP, and you shouldn't anyway. If you *CARE* about the ID numbers, then you're doing something wrong in the first place. On Sun, April 16, 2006 1:46 am, 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 > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- Like Music? http://l-i-e.com/artists.htm -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
