The following restrictions apply to triggers.
Until MariaDB 10.2.3, each table can have only one trigger for each timing/event combination (ie: you can't define two BEFORE INSERT triggers for the same table).
Triggers are always executed for each row. The standard FOR EACH STATEMENT option is not supported in MariaDB,
Triggers cannot operate on any tables in the mysql, information_schema or performance_schema database.
Cannot return a resultset.
The RETURN statement is not permitted, since triggers don't return any values. Use LEAVE to immediately exit a trigger.
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.
This page is licensed: CC BY-SA / Gnu FDL
RetroSearch is an open source project built by @garambo | Open a GitHub Issue
Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo
HTML:
3.2
| Encoding:
UTF-8
| Version:
0.7.4