is there a way to change the # in an auto_increment cloumn?

[seanpaulcail]

is there a way to change the # in an auto_increment column?

I removed two members out of fifteen so I only have thirteen members.

But the last member has an id of 15 instead of 13.

Is there a way to make the auto_increment collumn say 13 instead of 15?

I use a query on the id field which is auto_increment.

thanks

[LordShryku]

You can update those numbers at will, but auto-incrementing isn't smart enough to do that itself.

[seanpaulcail]

I dumped the database table, made the change, then reloaded the table.

thanks anyway

[mrhappiness]

ALTER TABLE <tablename>
AUTO_INCREMENT = #

works for me (3.23.56)