How to reset AUTO_INCREMENT in MySQL?

[Hubert-Dudek · Accepted solution]

ALTER TABLE tablename AUTO_INCREMENT = 1