Set auto increment start value to 1000?

[Brian Bendtsen]

Hi

Is there at way to reset a table and set the auto increment value to 1000?

/Brian Bendtsen

[Aggro]

Brian Bendtsen wrote:

Is there at way to reset a table and set the auto increment value to 1000?

truncate tablename;
insert into tablename (id) values(999);
delete from tablename where id=999;

[JJ]

To start with an AUTO_INCREMENT value other than 1, you can set that value
with CREATE TABLE or ALTER TABLE, like this:

mysql> ALTER TABLE tbl AUTO_INCREMENT = 1000;

"Brian Bendtsen" <br*@mentor-it.dk> wrote in message
news:44***********************@dread15.news.tele.d k...

Hi

Is there at way to reset a table and set the auto increment value to 1000?

/Brian Bendtsen