CREATE OR REPLACE
TRIGGER TRIG_BF_U_YYCQ
AFTER UPDATE
ON tYYCQ
FOR EACH ROW
BEGIN
INSERT INTO tBFLOG(PZH,LSH,BM,CZFS,LSHMC)
values(11,:NEW.LSH,'tYYCQ','U','LSH');
--------------应用新值时按变量处理加‘:’END TRIG_BF_U_YYCQ;
/
TRIGGER TRIG_BF_U_YYCQ
AFTER UPDATE
ON tYYCQ
FOR EACH ROW
BEGIN
INSERT INTO tBFLOG(PZH,LSH,BM,CZFS,LSHMC)
values(11,:NEW.LSH,'tYYCQ','U','LSH');
--------------应用新值时按变量处理加‘:’END TRIG_BF_U_YYCQ;
/
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货