Triggers

Automate actions in MariaDB Server with triggers. Learn how to create and manage triggers that execute automatically before or after data modifications, ensuring data integrity and business logic enfo

Trigger Overview

Complete MariaDB triggers overview: BEFORE/AFTER INSERT/UPDATE/DELETE timing, CREATE TRIGGER syntax, FOLLOWS|PRECEDES ordering, and DROP/SHOW TRIGGERS.

CREATE TRIGGER

Complete CREATE TRIGGER reference: OR REPLACE, DEFINER, IF NOT EXISTS, FOLLOWS/PRECEDES options for BEFORE/AFTER INSERT, UPDATE, or DELETE triggers rules.

Trigger Limitations

Understand the constraints of triggers, such as the prohibition of statements that return result sets or explicitly start/commit transactions.

Triggers and Implicit Locks

Explains how triggers can cause implicit locks on referenced tables during the execution of a statement, potentially affecting concurrency.