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