At 3:01 PM -0600 4/16/06, Chuck Anderson wrote:
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:
Okay, then delete whatever record you want and reset the
auto_increment value to that -- for example: Let's say you have
records 0 - 100 that you want to keep. Then you added some test
records that went from 101 to 150 and now you want to delete those
records and start again at 101, right?
Simple, just:
1. Delete records 101-150.
2. Reset the auto_increment in Operations to 101
3. Insert a false record.
4. Delete that false record.
Now, your dB will be set to start at 101.
What's even more amazing (at least I've found), is that if you had
0-100 records you wanted to keep and 101-150 you wanted to delete,
but also had 151 to 200 you also wanted to keep, you could do what I
said above and the auto_increment would fill up 101-150 and then jump
to 201. It's neat the way it works. At least that's my memory. Try it.
tedd
--
--------------------------------------------------------------------------------
http://sperling.com
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
