19.4. Restrictions on Triggers

The current trigger implementation in MySQL has some limitations:

• You cannot use the CALL statement.

• You cannot begin or end transactions.

• You cannot create a trigger for a TEMPORARY table or a view.

• Trigger creation is subject to the same binary log-related restriction placed on stored routine creation that is described in the introductory part of Chapter 18, "Stored Procedures and Functions."