Jump to content

resetting auto increment


jimfog
 Share

Recommended Posts

I have made a table with a primary key that is set to auto increment every time. As I am doing various test in the particular table, many times, I delete rows. I notice though, that the auto increment value never starts from 1(after I have deleted all the rows of the table),it just continuesfrom where it was left last time.If the row I deleted had the value of 10, then the newly created row will have the value of 11, even if this is going to be the first row created, after deletion of previous rows. I use PHPMyAdminWhat can I do to fix this? I fixed it, the only thing that needed was to use the "empty table" command.

Edited by jimfog
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...