huanxuan163
huanxuan163
2017-04-07 01:53

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

  • 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
  • 点赞
  • 回答
  • 收藏
  • 复制链接分享

1条回答