mysql触发器实现同一个数据库表的数据同步-insert-updata-Delect

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

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

1 ·

CC 4.0 BY-SA版权

mysql 专栏收录该内容

2 篇文章

订阅专栏

本文深入探讨了数据库触发器的创建与使用，详细介绍了在不同操作（如更新、插入和删除）下触发器如何同步更新从属数据库表，确保数据一致性。通过具体示例，展示了触发器在实际应用中的强大功能。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

DELIMITER &&
CREATE TRIGGER tri_order_1_update AFTER UPDATE ON t_order_0 FOR EACH ROW
BEGIN
   UPDATE ds_0_slave_1.t_order_0
       SET ds_0_slave_1.t_order_0.user_id = NEW.user_id
       AND ds_0_slave_1.t_order_0. STATUS = NEW. STATUS
   WHERE
       ds_0_slave_1.t_order_0.order_id = old.order_id ;
END&&
DELIMITER ;

DELIMITER &&

CREATE TRIGGER tri_order_1_insert AFTER INSERT ON t_order_0 FOR EACH ROW
BEGIN
   INSERT INTO ds_0_slave_1.t_order_0 (order_id, user_id, STATUS)
VALUES
   (
       NEW.order_id,
       NEW.user_id,
       NEW. STATUS
   ) ;
END&&
DELIMITER ;

DELIMITER &&

CREATE TRIGGER tri_order_1_delete AFTER DELETE ON t_order_0 FOR EACH ROW
BEGIN
   DELETE
FROM
   ds_0_slave_1.t_order_0
WHERE
   ds_0_slave_1.t_order_0.order_id = old.order_id ;
END&&
DELIMITER ;