CODE EXAMPLE FOR SQL

set auto increment to value

ALTER TABLE table_name AUTO_INCREMENT=value;