Reset AUTO_INCREMENT

[Nico v. Rossum]

Hi *

How can reset a auto_incremet collumn so it starts from 1

TIA

[John Smith]

I came across this same problem in Paul DuBois's excellent book MySQL, pp.
142 - 143. The process is to drop the auto_increment column and then add it
back again:

ALTER TABLE table
DROP column,
ADD column INT UNSIGNED AUTO_INCREMENT NOT NULL,
AUTO_INCREMENT = 1;
"Nico v. Rossum" <n.*********@chello.nl> wrote in message
news:Gx**********************@amsnews03.chello.com ...

Hi *

How can reset a auto_incremet collumn so it starts from 1

TIA

[John Smith]

I came across this same problem in Paul DuBois's excellent book MySQL, pp.
142 - 143. The process is to drop the auto_increment column and then add it
back again:

ALTER TABLE table
DROP column,
ADD column INT UNSIGNED AUTO_INCREMENT NOT NULL,
AUTO_INCREMENT = 1;
"Nico v. Rossum" <n.*********@chello.nl> wrote in message
news:Gx**********************@amsnews03.chello.com ...

Hi *

How can reset a auto_incremet collumn so it starts from 1

TIA