navicat update trigger syntax

12 ár síðan • 0

I am trying to create an UPDATE Trigger to log status changes - as below

INSERT INTO statushistory (TableType,IndexValue, OldValue, NewValue, ChangeDate) VALUES('X',1,'AAAA','BBBB', NOW())

This works, but how do I change it to get it to use real field values instead of the 1, AAAA and BBBB in the example above

Thanks, Steve

Vote