A trigger is a set of statements that run when an event occurs on a table.
Title | Description |
---|---|
Trigger Overview | Statements run when an event occurs on a table |
Binary Logging of Stored Routines | Stored routines require extra consideration when binary logging. |
CREATE TRIGGER | Create a new trigger. |
DROP TRIGGER | Drops a trigger. |
Information Schema TRIGGERS Table | Information about triggers |
Running Triggers on the Slave for Row-based Events | Running triggers on the slave for Row-based events |
SHOW CREATE TRIGGER | Shows the CREATE TRIGGER statement used to create the trigger |
SHOW TRIGGERS | Shows currently-defined triggers |
Trigger Limitations | Restrictions applying to triggers. |
Triggers and Implicit Locks | Implicit locks due to triggers and LOCK TABLE |
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/triggers/