mysql update autoincrement by value code example

Example: mysql update auto

ALTER TABLE tbl AUTO_INCREMENT = 100;