MySQL触发器数据表同步

最新推荐文章于 2024-08-05 09:57:15 发布

丈八涯

最新推荐文章于 2024-08-05 09:57:15 发布

阅读量956

点赞数 1

分类专栏：练习学习

本文链接：https://blog.csdn.net/supplychain/article/details/17609083

版权

练习学习专栏收录该内容

16 篇文章 0 订阅

订阅专栏

create table T(id integer, strName varchar(50));
create table tempT(id integer, strName varchar(50));

DELIMITER && 
CREATE TRIGGER tri_memory_update AFTER UPDATE ON T FOR EACH ROW 
BEGIN
    UPDATE T SET strName=NEW.strName WHERE strName=OLD.strName; 
END && 
DELIMITER ;

DELIMITER && 
CREATE TRIGGER tri_memory_insert AFTER Insert ON T FOR EACH ROW 
BEGIN
    insert into tempT(id,strName) VALUES(NEW.id,NEW.strName);
END && 
DELIMITER ;

DELIMITER && 
CREATE TRIGGER tri_memory_delete AFTER DELETE ON T FOR EACH ROW 
BEGIN
    DELETE From tempT where tempT.id = OLD.id;
END && 
DELIMITER ;