Auto-increment: reset next value

ALTER TABLE tbl SET AUTO_INCREMENT=val;