Re: Re: phpMyAdmin--resetting auto increments to 0

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



tedd wrote:

At 1:42 PM -0600 4/16/06, Chuck Anderson 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
On a related note (he did say PhpMyAdmin) ...

ALTER TABLE 'tablename' auto_increment=n works, but I can't get PhpMyAdmin to reset the auto_increment through the Operations menu page.

If I go to the Operations tab for a table and set the auto_increment value to something less that it currently is, PhpMyAdmin will not honor my request and re-specifies the current auto_increment value in the ALTER TABLE command (even though my requested value is valid).

Is this because of a config setting? I could have sworn earlier versions would obey my request.

Chuck:

This always works for me in PhpMyAdmin (I mistyped it before).

1. Delete the first record.
2. Reset the auto_increment in Operations to whatever you want.
3. Insert a record.
4. Delete that record.

After that, the next record will start at the new auto_increment value. Don't ask why, that's just the way it works.

tedd
That would work, except that I want to change the auto_increment without deleting the first record.

During testing I may add many entries to the end of an existing database table. When I am done testing I want to delete those "extraneous" entries (leaving the earlier entries intact). Call me obsessive/compulsive or whatever, but I like to knock the auto_increment value back down to the next valid value (what was the first "test" value).

PhpMyAdmin refuses to use the valid auto_increment value I specify in Operations and I have to edit the query to set it right.


--
*****************************
Chuck Anderson • Boulder, CO
http://www.CycleTourist.com
Integrity is obvious.
The lack of it is common.
*****************************

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux