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 ;
本文参考链接:https://www.cnblogs.com/xihong2014/p/5502456.html


