ALTER TABLE table_name AUTO_INCREMENT=value;
ALTER TABLE jobs MODIFY job_id INT NOT NULL AUTO_INCREMENT;
ALTER TABLE yourTableName MODIFY yourColumnName INT NOT NULL AUTO_INCREMENT;