There is a common issue which is usually faced by almost every newbie web developer or database administrator. When you insert records in your table of database after deleting all or some records from that table, if AUTO_INCREMENT property was set on your ID column or any other column, when you insert new records in that table it starts generating ID after the last ID generated by AUTO_INCREMENT in table, the following SQL query can reset the AUTO_INCREMENT from beginning or any number you want. 🙂

SQL Query

ALTER TABLE tablename AUTO_INCREMENT = 1

You can also reset it from the MySQL => Operations => Table Options. Just change AUTO_INCREMENT to 1.

Facebook Official Page: All PHP Tricks

Twitter Official Page: All PHP Tricks