本文演示了如何在MySQL中创建触发器，实现在`time`表插入新记录时自动将数据同步到`time_2`表，以及在`time`表删除记录时，`time_2`表对应的记录也随之删除。通过`CREATE TRIGGER`语句定义了`AFTER INSERT`和`AFTER DELETE`触发器，确保两个表的数据一致性。
mysql> usetest;Databasechanged
mysql> desctime;+-------+---------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+---------------------+------+-----+---------+-------+
| id | bigint(60) unsigned | NO | | 0 | |
+-------+---------------------+------+-----+---------+-------+
1 row in set (0.01sec)
mysql> desctime_2;+-------+---------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+---------------------+------+-----+---------+-------+
| id | bigint(60) unsigned | NO | | 0 | |
+-------+---------------------+------+-----+---------+-------+
1 row in set (0.01sec)
#创
最低0.47元/天 解锁文章
124
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
