I am using MySQL, so I can try trigger.
However, this is my first time write one, do you have a sample trigger I
can use as reference?
DELIMITER //
DROP TRIGGER tbl_Insert//
DROP TRIGGER tbl_Update//
DROP TRIGGER tbl_Delete//
commit //
CREATE TRIGGER tbl_Insert AFTER INSERT ON tbl
FOR EACH ROW
BEGIN
INSERT INTO _history (Action, ActDate, User)
values (‘Add’, Now(), SUBSTRING_INDEX(USER(),_utf8’@’,1));
END//
CREATE TRIGGER tbl_Update BEFORE UPDATE ON tbl
FOR EACH ROW
BEGIN
Declare Act varchar(400);
Set Act = ‘Edit:’;
if (select old.field1<>new.field1) then Select CONCAT(Act,’ Field1’)
into Act; end if;
if (select old.field2<>new.field2) then Select CONCAT(Act,’ Field2’)
into Act; end if;
INSERT INTO firm_history (Action, ActDate, User)
values (Act, Now(), SUBSTRING_INDEX(USER(),_utf8’@’,1));
END//
CREATE TRIGGER tbl_Delete BEFORE DELETE ON tbl
FOR EACH ROW
BEGIN
Declare Act varchar(400);
Set Act = ‘Del’;
INSERT INTO firm_history (Action, ActDate, User)
values (Act, Now(), SUBSTRING_INDEX(USER(),_utf8’@’,1));
END//