mysql update auto

The solution for this is noted below

ALTER TABLE tbl AUTO_INCREMENT = 100;

Try other methods by searching on the site. That is if this doesn’t work