Emp(eid,ename,age,salary)
Works(eid,did)
Dept(did,managerid)


create trigger GiveRaise after update on Emp
for each row
begin
update Emp M
set M.salary=new.salary
where M.salary<new.salary
and M.eid in(select d.managerid from Emp e,Works w,Dept d
where e.eid=new.eid
and E.eid=w.eid
and w.did=d.did);
end

Ads

• 
• 
• 
• 
• 
• 
• 
• 
• 
•