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