Victoria sees the following triggers in her table:
Trigger | Event | Table | Statement | Timing | next columns... |
|---|---|---|---|---|---|
new_employee | INSERT | employee | IF NEW.profession... | BEFORE | ... |
notify_manager | INSERT | employee | BEGIN...IF... | BEFORE | ... |
set_salary | INSERT | employee | SET NEW.salary... | BEFORE | ... |
check_salary | UPDATE | employee | IF NEW.salary... | BEFORE | ... |
not_cut_salary | UPDATE | employee | IF NEW.salary... | BEFORE | ... |
check_owner | DELETE | employee | IF OLD.name... | BEFORE | ... |
check_task | UPDATE | manager | IF NEW.task... | BEFORE | ... |
Victoria wants to CREATE TRIGGER new_check with INSERT trigger event and BEFORE time action.
This new TRIGGER which must be activated before the TRIGGER set_salary
Choose the correct modifier to be specified after command body:FOR EACH ROW...