In this tutorial, we will show you how to reset the Auto increment field in MySQL.
Mysql Auto-increment allows a unique number to be generated when a new record is inserted into a table. The function allows you to automatically add 1 to the previous record if you enter a new value.
You can always reset Mysql auto increment so that when you delete a record your data does show an uneven picture.
read more