MySQL  8.0.27
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