Reseting an auto_increment field

[purefan]

hello
I have a column set to auto_increment and have been adding some test rows. Later on I deleted them all and expected the value auto incremented to start from 0 but it didnt, now my first row is IDed 19. How can I fix this so when I empty the table the auto_increment field is also reset?
thanks for your time

edit:I use phpMyAdmin

[SQL Maestro]

No. If you have an empty table you should just recreate it, else delete and create again this field (IMHO).

[lidzky]

I use the following:

ALTER TABLE tablename auto_increment = 0;