mysql触发器

DELIMITER $$
CREATE TRIGGER trg_synccomsuminfo AFTER UPDATE ON t_orderpay  
 FOR EACH ROW BEGIN       
  IF  OLD.step != NEW.step THEN
    call proc_paysync(NEW.order_no);
  END IF;   
end $$
DELIMITER ; 

posted on 2016-05-17 17:23  xihong  阅读(110)  评论(0编辑  收藏  举报

导航