Clear an autoincrement

[sergioq]

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?

thanks

[Anigel]

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)

http://dev.mysql.com/doc/mysql/en/TRUNCATE.html

Alternatively you can use

ALTER TABLE tbl_name AUTO_INCREMENT = 1

To reset the auto_increment value