In first MySQL statement, you will remove the auto-increment from the column and in second statement, you will again declare the field as autoincrement. This way the auto increment counter will reset ...

Hello reader's! if you already using the mysql then you have seen the id with autoincrement always add up. forevery new entery the id will increase even if you drop the table.so if you want to reset ...

If you do want to delete stuff MySQL shouldn't reuse the auto_inc. DO NOT reset the database unless you've been doing testing and such and are now going live (and even then it's questionable).

Contribute to mtembei/How-to-reset-AUTO_INCREMENT-in-MySQL development by creating an account on GitHub.