MySQL auto increment does not start at 1

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

Contents hide

Answers:

Method 1

Answers:

Thank you for visiting the Q&A section on Magenaut. Please note that all the answers may not help you solve the issue immediately. So please treat them as advisements. If you found the post helpful (or not), leave a comment & I’ll get back to you as soon as possible.

Method 1

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

Try TRUNCATE instead.

All methods was sourced from stackoverflow.com or stackexchange.com, is licensed under cc by-sa 2.5, cc by-sa 3.0 and cc by-sa 4.0

0 0 votes

Article Rating