auto increment not starting from 1

Question

I am inserting some data to a database and I have an id column which has auto increment. I updated my xampp server yesterday and now the auto increment is starting from 4, 3, 5 in different tables. It used to work fine before. I did not delete any rows from the table it just starts from those numbers. What is wrong?

Answer 1

ALTER TABLE tablename AUTO_INCREMENT = 1

This will reset your auto increment to start from 1