MySQL触发器数据表同步

最新推荐文章于 2023-11-26 09:52:45 发布

原创最新推荐文章于 2023-11-26 09:52:45 发布 · 1k 阅读

1 ·

CC 4.0 BY-SA版权

练习学习专栏收录该内容

16 篇文章

订阅专栏

本文详细介绍了如何使用SQL创建触发器来同步主表T和临时表tempT的数据更新。包括了三种不同类型的触发器：更新触发器、插入触发器及删除触发器的实现方式。

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 ;