Re: phpMyAdmin--resetting auto increments to 0

On 4/16/06, Jim Lucas <lists@cmsws.com> wrote: > chris smith wrote: > > On 4/16/06, Jim Lucas <lists@cmsws.com> wrote: > > > >> Jim Lucas wrote: > >> > >>> 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 > >>>> > >>>> > >>> At the top of the Structure page ( or any other when viewing a > >>> detailed table view) you should have an Empty tab at the top left. > >>> Hit that and it should reset the counter > >>> > >>> > >> also running the command: DELETE FROM table_name > >> from the SQL box, should do the same trick > >> > > > > That won't reset the counter. > > > > You'll probably need to do this after you delete all the data: > > > > update table set id=0; > > > > -- > > Postgresql & php tutorials > > http://www.designmagick.com/ > > > > > Well, I just tried it on a temp table that I have for my blog under > Mysql and it did reset the autoindex to 1. > > Seems to work the way I said. Hmm, well there you go. Thanks for letting us know :) -- Postgresql & php tutorials http://www.designmagick.com/