You can stop a trigger from firing by disabling it using the ALTER TRIGGER statement. ALTER TRIGGER before_employee_salary_update DISABLE;