这篇博客介绍了如何在MySQL中使用触发器来实现实时的数据同步和备份。通过在`OPM_Alarm`表上创建BEFORE INSERT和AFTER DELETE触发器，将新插入的记录复制到`OPM_Alarm_copy`表，并在删除记录时保存原数据到`OPM_AlarmAction_log`。此外，还提到了Django连接MySQL同步数据表和改变数据表字符集的方法。
添加记录到新记录表
DELIMITER $$
USE `DB_Test`$$
CREATE
/*!50017 DEFINER = 'root'@'%' */
TRIGGER `InsertOPM_Alarm_trigger` BEFORE INSERT ON `OPM_Alarm`
FOR EACH ROW BEGIN
INSERT INTO OPM_Alarm_copy (AlarmId,AlarmCode,AlarmTypeId,AlarmLevelId,AlarmObjectCode,AlarmStatus,AlarmHandleUser,
AlarmHandleTime,ADDTIME,ParkUserId,BerthCode,BargainOrderCode,BerthStartTime)
VALUES(new.AlarmId,new.AlarmCode,new.AlarmTypeId,new.AlarmLevelId,new.AlarmObjectCode,new.AlarmStatus,new.AlarmHandleUser,
new.AlarmHandleTime,new.ADDTIME,new.ParkUserId,new.BerthCode,new.BargainOrderCode,new.BerthStartTime);
END;
$$
DELIMITER ;
CREATE TRIGGER InsertOPM_Alarm_trigger
BEFORE INSERT ON OPM_Alarm
FOR EACH ROW
BEGIN
INSERT INTO OPM_Alarm_copy (AlarmId,AlarmCode,AlarmTypeId,AlarmLevelI
最低0.47元/天 解锁文章
扫一扫
773
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
