同步修改:
在mysql中,修改某一张表的某个字段时,同步另一张表的某个字段。
修改efarm_sso_account表的密码字段时,同步修改munitsctusers表的密码字段:
DROP TRIGGER IF EXISTS trig_same_sso_ctuser_password;
DELIMITER $$
CREATE TRIGGER efarm.trig_same_sso_ctuser_password
AFTER UPDATE ON efarm_sso_account
FOR EACH ROW
BEGIN
IF new.col_password != old.col_password THEN
UPDATE munitsctusers SET loginpwd = new.col_password WHERE loginname = new.col_loginname;
END IF;
END $$
DELIMITER ;