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