Re: phpMyAdmin--resetting auto increments to 0

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.