Answer the question
In order to leave comments, you need to log in
Trigger issue?
I can't figure out what the problem is, please help
CREATE TRIGGER `Emp_upd` AFTER UPDATE ON `Employee`
FOR EACH ROW BEGIN
INSERT INTO `History` (`Table`, `Operation`, `Emp_ID`, `Person_ID`) VALUES ('Employee', 'Update', OLD.Emp_ID, OLD.Persom_ID);
END
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question