The following request updates the yrsexp column in the employee table for employee Greene, who is employee number 10017:
UPDATE employee SET yrs_exp = 16 WHERE empno = 10017;
The following request updates the yrsexp column in the employee table for employee Greene, who is employee number 10017:
UPDATE employee SET yrs_exp = 16 WHERE empno = 10017;