DELIMITER //
CREATE EVENT `zctb`
ON SCHEDULE
EVERY 1 DAY
STARTS '2023-07-10 21:14:00'
ON COMPLETION PRESERVE
DO
BEGIN
INSERT INTO uf_zctbb (mark, name, cpuxh, wkmacdz, gtypdx, jxypdx, nczdx, xkpz, czxtxx, modedatacreater, modedatacreatedate, modedatacreatetime, formmodeid)
SELECT a.mark, a.name, a.cpuxh, a.wkmacdz, a.gtypdx, a.jxypdx, a.nczdx, a.xkpz, a.czxtxx, 1, CURDATE(), CURTIME(), 579
FROM cptcapital a
LEFT JOIN uf_zctbb b ON a.mark = b.mark
WHERE b.mark IS NULL;
END //
DELIMITER ;资产表同步事件
CREATE TRIGGER zcgx
AFTER UPDATE ON uf_zctbb
FOR EACH ROW
BEGIN
UPDATE cptcapital
SET
cpuxh = NEW.cpuxh,
wkmacdz = NEW.wkmacdz,
gtypdx = NEW.gtypdx,
jxypdx = NEW.jxypdx,
nczdx = NEW.nczdx,
xkpz = NEW.xkpz,
czxtxx = NEW.czxtxx
WHERE mark = NEW.mark;
END;
资产修改表同步到资产信息表触发器