- Mysql的触发器这样写有什么问题
-
create trigger positions_trigger after update on student_positions for each row begin if new.hire_status==1 then update positions p set people_approved=people_approved+1 where new.position_id=p.pid end if; end
create trigger positions_trigger
after update on student_positions for each row
begin
if new.hire_status==1 then
update positions p
set people_approved=people_approved+1
where new.position_id=p.pid
end if;
end