Supported SQL PL statements in triggers

The triggered SQL statement of all triggers can be a dynamic compound statement.

That is, triggered SQL statements can contain one or more of the following elements:
  • CALL statement
  • DECLARE variable statement
  • SET variable statement
  • WHILE loop
  • FOR loop
  • IF statement
  • SIGNAL statement
  • ITERATE statement
  • LEAVE statement
  • GET DIGNOSTIC statement
  • fullselect
However, only AFTER and INSTEAD OF triggers can contain one or more of the following SQL statements:
  • UPDATE statement
  • DELETE statement
  • INSERT statement
  • MERGE statement