CODE EXAMPLE FOR SQL

change auto increment mysql

ALTER TABLE tbname MODIFY COLUMN columname smallint(5) auto_increment