reset autoincrement field MySql4.0

[itaym02]

Greetings.

I have an autoincremented field in my table. I need to reset the counter when I delete the table (not truncate, just delete).
And I have cases when I have to set the autoincrement to count from a number I choose.

How?

[devinemke]

ALTER TABLE tablename AUTO_INCREMENT = 1

[itaym02]

thanks mate