Computer scienceFundamentalsSQL and DatabasesDBMSMySQLDB objects

Triggers

Theory

Body design

Report a typo

Let's create a new trigger that before UPDATE values in the table employee corrects the salary row value IF it is not positive.

Sort the code lines in the right order.

Put the items in the correct order
BEFORE UPDATE ON employee
CREATE TRIGGER check_salary
SET NEW.salary = 0
FOR EACH ROW
END IF;
IF NEW.salary < 0 THEN
___

Create a free account to access the full topic