Question

create table salary (empid int primary key references emp (empid),

                     paygrade varchar(2),

                     amount decimal (10,2),

                     lupdate TIMESTAMP DEFAULT CURRENT_TIMESTAMP, foreign key (empid) references emp (empid));

Use the Salary table above to answer the following question.
Add a column to the salary table named position with each person's position as "staff", except for Walton, Shah, Harper who are "manager".
ALTER TABLE salary
ADD position varchar(32);
how do we make the exception for Walton, Shah, Harper to be managers...is it the DEFAULT syntax?

Answer 1

Yes there is a default syntax.

Add the column position in salary table using default constraint

ALTER TABLE salary
ADD position varchar(32) default 'staff';

this will create a column of position where all position are staff. Now for Walton, shah, Harper

Now add exception for the three guys

update salary s, emp e

set position = "manager"

where emp_name in ('Walton',Shah','Harper') and e.empid = s.empid;