refer from : Using MySQL Triggers to Audit Field Changes from a Database Table
我要更新一下我的使用情况为如果变更的content栏位前后有变动才要触发update的动作：
DELIMITER |
CREATE TRIGGER audit_content BEFORE UPDATE ON conten
FOR EACH ROW BEGIN
IF OLD.content <> NEW.content THEN
INSERT INTO content_audit SET content_id = OLD.id,before_value = OLD.cont
ent,after_value = NEW.content;
END IF;
END;
|
太帅了，有了这个功能，我的工作可以继续了。