A trigger is an automatic SQL procedure that executes in response to certain events on a table, such as INSERT, UPDATE, or DELETE.
Example SQL Trigger:
sqlCopyEditCREATE TRIGGER update_salary BEFORE UPDATE ON Employees
FOR EACH ROW SET NEW.salary = GREATEST(NEW.salary, 30000);
This ensures salaries never drop below 30,000.
Leave a Reply