Resetting Counter

[lilman]

I have an auto increment id set up for my table users.  I want to reset it so it starts counting at 0. See, I register accounts and then dropped them but the auto increment doesn't start over. I hope I was clear enough, if not let me know.

Is there a way to restart the counter?

[Conjurer]

Wow - that is exactly the same exact question I have.

Call me annal retentive, but when I originally built the table I had a way to do it that set it to 1001 as the starting point. Because it is our member list I would like to have the new data load starting with 1001.

It is an AR thing I know because from the functioning of the database it makes absolutely no difference. But it is something I want to do, so what would be the SQL statement to do it?

I tried
[quote]ALTER TABLE directory MODIFY user_id AUTO_INCREMENT = '1001'[/quote]


But that bombs - I am trying to modify it in PHPAdmin.

[printf]

You guys are missing point of what a auto increment column is used for, when you do silly stuff on a column that is setup with this option.


printf

[Conjurer]

Actually I acknowledged the point when I said I was being annal retentive and that where it starts makes no difference to the database, so that said, how do you do it?

I know there is a way...

[Conjurer]

Bingo!

ALTER TABLE table_name  AUTO_INCREMENT =1001  << or whatever value you want it to start with.

:D

[lilman]

[quote author=Conjurer link=topic=115580.msg470677#msg470677 date=1163975411]
Bingo!

ALTER TABLE table_name  AUTO_INCREMENT =1001  << or whatever value you want it to start with.

:D
[/quote]

Thank you!

[fenway]

If you're cleaning out the table, use TRUNCATE -- otherwise, leave these alone.