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 ;
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 ;