– 通过触发器记录emp表的数据变更日志,包含增加,修改,删除;
create trigger trigger_account
AFTER INSERT on account for EACH ROW – 行级触发器
BEGIN
INSERT into sync_log(id,operation,operation_time,operate_id,operate_params)
VALUES(null,‘insert’,NOW(),new.id,concat(‘插入后的(id’,new.id,‘,name:’,new.name,‘,money:’,new.money ));
END;
– 创建修改的触发器
create trigger trigger_account_update
AFTER update on account for EACH ROW – 行级触发器
BEGIN
INSERT into sync_log(id,operation,operation_time,operate_id,operate_params)
VALUES(null,‘update’,NOW(),new.id,
concat(‘修改前的(id’,new.id,‘,name:’,new.name,‘,money:’,new.money,‘)修改后的(id’,old.id,‘,name:’,old.name,‘,money:’,old.money,‘)’));
END;