MySQL auto increment does not start at 1-CodePudding

My situation is similar to the one in this question. I am trying to insert value to DogName and set DogId to be auto_increment but it does not start at 1

Dog table

DogId DogName
3     Woofer
4     Kujo
5     Spike

I tried the solution in that question

alter table <tablename> auto_increment = <some_number>;

but did not work. I tried dropping the table and creating it again. But now the DogId starts at 6. Really appreciate any help

CodePudding user response：

I tried dropping the table and creating it again. But now the DogId starts at 6. Really appreciate any help

Try TRUNCATE instead.