Re: INSERT INTO on AFTER UPDATE trigger

[JK Heydt]

Sorry, I want to insert a record into the row_change table for each field that changed in the trigger field:

CREATE DEFINER = CURRENT_USER TRIGGER `hto_demo`.`field_AFTER_UPDATE` AFTER UPDATE ON `field` FOR EACH ROW
BEGIN

IF OLD.FieldID<> new.FieldID
then
INSERT INTO row_change
(RowID, TableCd, FieldID, ChangeDateTime, RecordCreatedBit , DataBefore,DataAfter,UserID)
select
new.RowID
,'FLD'
,'110'
,Getdate()
,0
,old.FieldID
,new.FieldID
,system_user()
from field
end if
END

Repeat IF OLD.Field2<>NEW.Field2 each field.