MySql Triggers - Can a trigger stop ALL dml?

Question

Hi All,

Is it possible to create a trigger on a table that is initiated when ANY dml is performed on the table?

For example -- I need to ensure that no insert/update/delete statements can be run on the weekend. So, instead of writing:

CREATE TRIGGER DENY_DML_1 BEFORE INSERT...

CREATE TRIGGER DENY_DML_2 BEFORE UPDATE...

CREATE TRIGGER DENY_DML_3 BEFORE DELETE...

...is it possible to write one trigger to rule them all?

Many thanks in advance! ~Daniel

Answer 1

No. From the documentation:

*trigger_event* indicates the kind of statement that activates the trigger. The *trigger_event* can be one of the following: INSERT... UPDATE... DELETE...