resetting auto increment

[jimfog]

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 November 20, 2012 by jimfog

[thescientist]

you might want to read this post http://w3schools.invisionzone.com/index.php?showtopic=45654&st=20&p=254581entry254581