CODE EXAMPLE FOR SQL

update auto increment value in mysql

ALTER TABLE foobar AUTO_INCREMENT=10;