[SOLVED] Reset primary key

[thefollower]

I just cleaned out my database so its pure empty but the primary key still begins one up from the record that was once there which is no longer... how do you set the primary key back to 1 so it goes up as 1 2 3 etc again ?

 

I remember doing it before like 3 years ago with php but totally forgotten the syntax to do it :S

 

Hope you can help!

[Mchl]

ALTER TABLE table AUTO_INCREMENT = 0;

 

[thefollower]

Thanks