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.