CODEWITHSUNDEEP
mysql
TDo
TDo

Reputation: 744

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

Upvotes: 0

Views: 163

Answers (1)

Joseph
Joseph

Reputation: 522

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

Try TRUNCATE instead.

Upvotes: 2

Related Questions