Hello friends, I was facing issue in database. I wanted the auto increment should start from 1.
There were 20 rows in table. When I deleted all the rows from the table and inserted new row then auto increment started from id = 21 instead of 1. I wanted to start counting from 1 again. This issue was resolved by following lines :
ALTER TABLE tablename AUTO_INCREMENT = 1
For InnoDB you cannot set the auto_increment value lower or equal to the highest current index.
This is the sample example: Here you can see that I am deleting records from table user_invites having 5 rows in it.
5 rows have been deleted as shown below:
Now I inserted one row into the table user_invites:
Now you will see that instead of starting from id 1, it is starting from id 27
Now lets reset auto increment
Now lets insert 1 row again
Now you will see that auto increment has been reset to 1