Posts Tagged "reset"

How to reset Auto-increament in MySQL?

It is possible to reset the auto increment value of a MySQL auto incremental primary key to a new value, either higher or lower than what it would otherwise next be. This post looks at how to do this using a MySQL query and also with phpMyAdmin. The following example changes the auto increment value for the table named “mytable” to 1. This means that the next time you insert a record into this table the value of the auto…

Read More