CODE EXAMPLE FOR SQL

add auto increment in id

ALTER TABLE jobs
MODIFY job_id INT NOT NULL AUTO_INCREMENT;