-- -- 触发器 ddgl_ddxx -- DROP TRIGGER IF EXISTS t_afterupdate_on_table_a; DELIMITER // CREATE TRIGGER t_afterupdate_on_table_a AFTER UPDATE ON table_a FOR EACH ROW begin select rzemail into @oldMail from table_b where ruserid =new.userid ; IF(new.rzemail !=@oldMail) THEN update table_b set rzemail =new.rzemail where ruserid =new.userid ; END IF; END // DELIMITER ; 试试看吧,建议还是好好看一下MYSQL 触发器相关知识,对你有帮助!学习和编程不能一味的复制黏贴代码,要学会“模仿”别人的实现思路,之后再转换成自己的,不然下次遇见类似的问题,也不知道该如何去做.......
-- -- 触发器 ddgl_ddxx -- DROP TRIGGER IF EXISTS t_afterupdate_on_table_a; DELIMITER // CREATE TRIGGER t_afterupdate_on_table_a AFTER UPDATE ON table_a FOR EACH ROW begin select rzemail into @oldMail from table_b where ruserid =new.userid ; IF(new.rzemail !=@oldMail) THEN update table_b set rzemail =new.rzemail where ruserid =new.userid ; END IF; END // DELIMITER ;
--
-- 触发器 ddgl_ddxx
--
DROP TRIGGER IF EXISTS t_afterupdate_on_table_a;
DELIMITER //
CREATE TRIGGER t_afterupdate_on_table_a AFTER UPDATE ON table_a
FOR EACH ROW begin
select rzemail into @oldMail from table_b where ruserid =new.userid ;
IF(new.rzemail !=@oldMail) THEN
update table_b set rzemail =new.rzemail where ruserid =new.userid ;
END IF;
END
//
DELIMITER ;
试试看吧,建议还是好好看一下MYSQL 触发器相关知识,对你有帮助!学习和编程不能一味的复制黏贴代码,要学会“模仿”别人的实现思路,之后再转换成自己的,不然下次遇见类似的问题,也不知道该如何去做.......
--
-- 触发器 ddgl_ddxx
--
DROP TRIGGER IF EXISTS t_afterupdate_on_table_a;
DELIMITER //
CREATE TRIGGER t_afterupdate_on_table_a AFTER UPDATE ON table_a
FOR EACH ROW begin
select rzemail into @oldMail from table_b where ruserid =new.userid ;
IF(new.rzemail !=@oldMail) THEN
update table_b set rzemail =new.rzemail where ruserid =new.userid ;
END IF;
END
//
DELIMITER ;