Reset Auto Increment ID field

[tonynoriega]

i have an auto increment "ID" field in mysql dbase...

i was doing some testing, and it obviously kept counting...

how can i reset it back to "1" so i can start fresh?

[LifeinAsia]

One way is to delete the field and re-add it.

[coopster]

If you don't need the data that is in the table you can TRUNCATE [dev.mysql.com] table.

[tonynoriega]

i need to retain several records that are already in there....

am i just out of luck?

[phranque]

assuming mysql:

SET insert_id = 1;