resetting auto-increment field

[gray01]

I\'ve got a few tables with auto-increment IDs. I want to delete all data and start again with empty tables. However, the auto-increment value is remembered, so the empty table isnt populated starting with ID = 1, but with the value before the data was deleted - is there a way to reset it?

[pallevillesen]

ALTER TABLE tbl_name AUTO_INCREMENT = 1;

 

P.

[gray01]

thanks biopv - i hope you get paid for technical support