BEFORE Triggers —
execute before an INSERT, UPDATE, or DELETE operation.
DELIMITER //
CREATE TRIGGER trgBeforeUpdate
BEFORE UPDATE ON Employees
FOR EACH ROW
BEGIN
IF NEW.Salary > OLD.Salary * 1.10 THEN
SET NEW.Salary = OLD.Salary * 1.10;
END IF;
END;
//
DELIMITER ;
This trigger ensures that salary increases do not exceed 10%.
Semantic portal