Activation Time : Introduction « Trigger « MySQL Tutorial






Use BEFORE to perform an action prior to the change being made in the table.

Use AFTER to perform an action after the changes are made in the table.

When you choose AFTER, you cannot change the values of the incoming query.

13.1.Introduction
13.1.1.The CREATE TRIGGER Statement
13.1.2.Activation Time
13.1.3.OLD and NEW Keywords