Default Value

Global variables can have literal, NULL, or system constant default values.

Default Value:
 
                        (1)
|--+-| Literal Number |-----------------------------+-----------|
   |                   (2)                          |
   +-| Quoted String |------------------------------+
   |                      (3)                       |
   +-| Literal Interval |---------------------------+
   |                      (4)                       |
   +-| Literal Datetime |---------------------------+
   +-CURRENT--+-----------------------------------+-+
   |          |                              (5)  | |
   |          '-| DATETIME Field Qualifier |------' |
   '-+-DBSERVERNAME-+-------------------------------'
     +-SITENAME-----+
     +-TODAY--------+
     +-USER---------+
     '-NULL---------'
 

1. See Literal Number
2. See Quoted String
3. See Literal INTERVAL
4. See Literal DATETIME
5. See DATETIME Field Qualifier

If you specify a default value, the global variable is initialized with the specified value.