Truncate table to reset id back to 1

[Chris_Hall]

in mysql:

ALTER TABLE <table> SET AUTO_INCREMENT = 1