trigger_def.h File Reference

This file defines all base public constants related to triggers in MySQL. More...

Go to the source code of this file.

Enumerations
enum	enum_trigger_event_type { TRG_EVENT_INSERT = 0 , TRG_EVENT_UPDATE = 1 , TRG_EVENT_DELETE = 2 , TRG_EVENT_MAX }
	Constants to enumerate possible event types on which triggers can be fired. More...
enum	enum_trigger_action_time_type { TRG_ACTION_BEFORE = 0 , TRG_ACTION_AFTER = 1 , TRG_ACTION_MAX }
	Constants to enumerate possible timings when triggers can be fired. More...
enum	enum_trigger_order_type { TRG_ORDER_NONE = 0 , TRG_ORDER_FOLLOWS = 1 , TRG_ORDER_PRECEDES = 2 }
	Possible trigger ordering clause values: More...
enum	enum_trigger_variable_type { TRG_OLD_ROW , TRG_NEW_ROW }
	Enum constants to designate NEW and OLD trigger pseudo-variables. More...

Detailed Description

This file defines all base public constants related to triggers in MySQL.

Enumeration Type Documentation

enum_trigger_action_time_type

enum enum_trigger_action_time_type

Constants to enumerate possible timings when triggers can be fired.

Enumerator
TRG_ACTION_BEFORE
TRG_ACTION_AFTER
TRG_ACTION_MAX

enum_trigger_event_type

enum enum_trigger_event_type

Constants to enumerate possible event types on which triggers can be fired.

Enumerator
TRG_EVENT_INSERT
TRG_EVENT_UPDATE
TRG_EVENT_DELETE
TRG_EVENT_MAX

enum_trigger_order_type

enum enum_trigger_order_type

Possible trigger ordering clause values:

• TRG_ORDER_NONE – trigger ordering clause is not specified
• TRG_ORDER_FOLLOWS – FOLLOWS clause
• TRG_ORDER_PRECEDES – PRECEDES clause

Enumerator
TRG_ORDER_NONE
TRG_ORDER_FOLLOWS
TRG_ORDER_PRECEDES

enum_trigger_variable_type

enum enum_trigger_variable_type

Enum constants to designate NEW and OLD trigger pseudo-variables.

Enumerator
TRG_OLD_ROW
TRG_NEW_ROW