Clear an autoincrement
have an AUTOINCREMENT field, which works for every record added....1, 2, 3,
my question is this, when i am done testing i want to start at ONE again, but even if i delete all records, it still keeps SOMWHERE the last UserID,
how do i reset it to 1?
If you use the truncate table command to delete your test data then it will reset the auto incrememnt value (unless you are using innodb tables)
Alternatively you can use
To reset the auto_increment value
ALTER TABLE tbl_name AUTO_INCREMENT = 1