mysql 如何复制触发器,MYSQL触发器更新复制整个行

I am trying to create a trigger to copy an entire row to an audit table on any UPDATE.

I have 2 tables

Frequencies and Frequencies_Audit

This is my trigger.

create trigger auditlog

before update on frequencies

for each row insert into

frequencies_audit select frequencies.*;

When I update the record I get Unknown Table frequencies.

I don't want to have to enter each field name separately if possible since we are constantly adding columns in the database.

解决方案

Rather than BEFORE UPDATE, you can write AFTER UPDATE trigger as follow ::

DELIMITER //

CREATE TRIGGER auditlog AFTER UPDATE ON frequencies

FOR EACH ROW BEGIN

INSERT INTO frequencies_audit select * from frequencies where freqId = NEW.freqId;

END;//

DELIMITER ;

freqId is just a name of Id column. Replace it with the name of Id column in your frequencies table.