写了一个trigger
=====================================================
CREATE TRIGGER sysjj.t_afterupdate_tassess_supplyer
AFTER UPDATE ON sysjj.tassess_supplyer
FOR EACH ROW
BEGIN
UPDATE sysjj.torder_master SET status=7 WHERE id = NEW.forderid AND status = 6;
update sysjj.tcheckdelivery_master set fstatus=4 where forderid = NEW.forderid and fstatus =2;
END;
==================================================
执行这个语句总说end前有错.如果不要begin...end ,执行第一个update后就报错.可能是什么原因呀?
=====================================================
CREATE TRIGGER sysjj.t_afterupdate_tassess_supplyer
AFTER UPDATE ON sysjj.tassess_supplyer
FOR EACH ROW
BEGIN
UPDATE sysjj.torder_master SET status=7 WHERE id = NEW.forderid AND status = 6;
update sysjj.tcheckdelivery_master set fstatus=4 where forderid = NEW.forderid and fstatus =2;
END;
==================================================
执行这个语句总说end前有错.如果不要begin...end ,执行第一个update后就报错.可能是什么原因呀?
CREATE TRIGGER sysjj.t_afterupdate_tassess_supplyer
AFTER UPDATE ON sysjj.tassess_supplyer
FOR EACH ROW
BEGIN
UPDATE sysjj.torder_master SET status=7 WHERE id = NEW.forderid AND status = 6;
update sysjj.tcheckdelivery_master set fstatus=4 where forderid = NEW.forderid and fstatus =2;
END$$
delimiter;
中间有空格delimiter $$这样写