Resetting an auto increment field

If ever you wanted to reset an autoincrement field

ALTER TABLE tbl_address AUTO_INCREMENT = 100;

There are restrictions however

Learn more here