[RESOLVED] How do you change next autoindex

[conjurer]

I have a primary key in a table that is set to autoincrement. I deleted the data in preparation to import new up to date data.

The primary key field shows in PHPAdmin that the next value will be 1232:

Next Autoindex 1,232

How can you change that value so it starts at 1001?

[Piranha]

There is no reason to lower it, just let it auto increment to avoid all possible troubles. I know that you can raise it by adding the PK manually, then it continues from that value. I have no idea if it works the same way to lower it, but as I said before there is no reason at all to do it.

[conjurer]

Well 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 no difference. But it is something I want to do, so what would be the SQL statement to do it?

I tried

ALTER TABLE directory MODIFY user_id AUTO_INCREMENT = '1001'

But that bombs.

[rincewind456]

ALTER TABLE table_name  AUTO_INCREMENT =1001

[conjurer]

Thank you muchly!