Computer scienceFundamentalsSQL and DatabasesDBMSMySQLDB objects

Triggers

Сorrect dialect

Report a typo

What is the correct way to create a trigger?

Select one option from the list

INSERT INTO table TRIGGER new_employee AFTER FOR EACH ROW ... (trigger statements) ;

SET TRIGGER new_employee FOR table AFTER INSERT FOR EACH ROW ... (trigger statements) ;

CREATE NEW TRIGGER new_employee AFTER UPDATE table FOR EACH ROW ... (trigger statements);

CREATE TRIGGER new_employee AFTER INSERT ON table FOR EACH ROW ... (trigger statements);

INSERT INTO table TRIGGER new_employee AFTER UPDATE FOR EACH ROW ... (trigger statements) ;

___

Create a free account to access the full topic