MySQL  8.0.18
Source Code Documentation
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

Constants to enumerate possible timings when triggers can be fired.

Enumerator
TRG_ACTION_BEFORE 
TRG_ACTION_AFTER 
TRG_ACTION_MAX 

◆ 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

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 constants to designate NEW and OLD trigger pseudo-variables.

Enumerator
TRG_OLD_ROW 
TRG_NEW_ROW