1 of 1

Trigger Limitations

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

The following restrictions apply to triggers:

All of the restrictions listed in Stored Routine Limitations.
All of the restrictions listed in Stored Function Limitations.
Triggers are always executed for each row. MariaDB does not support the standard FOR EACH STATEMENT option.
Triggers cannot operate on any tables in the mysql, information_schema or performance_schema database.
Cannot return a result set.
The statement is not permitted, since triggers don't return any values. Use to immediately exit a trigger.
Triggers are not activated by actions.
If a trigger is loaded into cache, it is not automatically reloaded when the table metadata changes. In this case a trigger can operate using the outdated metadata.
By default, with row-based replication, triggers run on the master, and the effects of their executions are replicated to the slaves. It is possible to run triggers on slaves. See .

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

The following restrictions apply to triggers:

All of the restrictions listed in Stored Routine Limitations.
All of the restrictions listed in Stored Function Limitations.
Triggers are always executed for each row. MariaDB does not support the standard FOR EACH STATEMENT option.
Triggers cannot operate on any tables in the mysql, information_schema or performance_schema database.
Cannot return a result set.
The statement is not permitted, since triggers don't return any values. Use to immediately exit a trigger.
Triggers are not activated by actions.
If a trigger is loaded into cache, it is not automatically reloaded when the table metadata changes. In this case a trigger can operate using the outdated metadata.
By default, with row-based replication, triggers run on the master, and the effects of their executions are replicated to the slaves. It is possible to run triggers on slaves. See .

See Also