mysql change autoincrement value code example

Example: mysql update auto

ALTER TABLE tbl AUTO_INCREMENT = 100;