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 阅读(112) 评论(0) 编辑 收藏 举报