Oftentimes one needs to test web application to see if it works. But during those times one doesn’t have to retain all of the test data and after you delete the test data the auto_increment field(mostly id’s) don’t reset itself.
Here is a way to reset the auto_increment column in your mysql database:
alter table account auto_increment=4;
Guessing that I have 3 accounts I wanted to retain.
