set auto increment to value code example
Example: how insert auto increment
ALTER TABLE yourTableName
MODIFY yourColumnName INT NOT NULL AUTO_INCREMENT;
ALTER TABLE yourTableName
MODIFY yourColumnName INT NOT NULL AUTO_INCREMENT;