Mysql的触发器这样写有什么问题

Question

 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

Answer 1

if语句不要==，if new.hire_status=1这样就行