Alot of the time when you are working with MySQL you will need a table that has an auto incrementing id field. This is great and usually doesn’t pose you any problems, but i’ve noticed that if you are deleting rows manually alot (as you will during development), then it can get a little confused.

This means that there may only be 7 rows but the next new row could have an id of 59! Not great if you need some decent id’s to join with! So run this little SQL query to set the auto_increment on your table to anything you want:

ALTER TABLE your_table AUTO_INCREMENT=99

Happy coding :)