MySQL Tutorial/Trigger/Introduction

Материал из SQL эксперт
Перейти к: навигация, поиск

Activation Time

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. <A href="/Tutorial/MySQL/0260__Trigger/TheCREATETRIGGERStatement.htm">The CREATE TRIGGER Statement</a> 13. 1. 2. Activation Time 13. 1. 3. <A href="/Tutorial/MySQL/0260__Trigger/OLDandNEWKeywords.htm">OLD and NEW Keywords</a>

OLD and NEW Keywords

Two keywords are unique to SQL statements used in defining triggers: OLD and NEW.

These keywords allow you to refer to the data before and after the activating event takes place.

For example, OLD.<fieldname>, NEW.<fieldname>.

13. 1. Introduction 13. 1. 1. <A href="/Tutorial/MySQL/0260__Trigger/TheCREATETRIGGERStatement.htm">The CREATE TRIGGER Statement</a> 13. 1. 2. <A href="/Tutorial/MySQL/0260__Trigger/ActivationTime.htm">Activation Time</a> 13. 1. 3. OLD and NEW Keywords

The CREATE TRIGGER Statement

The CREATE TRIGGER statement is used to define a trigger.

The CREATE TRIGGER statement associates it with changes occurring in a table.

It has the following syntax:



   <source lang="sql">

CREATE TRIGGER <name>

ON FOR EACH ROW <body statements></source>

With the time and event, you must choose from an enumerated set of options:

CREATE TRIGGER <name> [BEFORE | AFTER] [INSERT | UPDATE | DELETE]