MENU
SET
| SET variable_assignment [, variable_assignment] ... variable_assignment: |
| user_var = expr | [GLOBAL | SESSION] system_var = expr | [@@global. | @@session. | @@]system_var = expr |
| A user-defined variable begins with the symbol @. |
| Any change to a SESSION system variable lasts until a session closes. Any change to a GLOBAL system variable lasts until the server restarts. |
| Some system variables exist as both SESSION and GLOBAL variables. |
| To view the values for the various system variables, tabulate the result retrieved by the query: SHOW [GLOBAL|SESSION] VARIABLES [LIKE ‘pattern’ | WHERE expr] |
| SET @a = 900 + 99; SELECT @a, @@system_time_zone, @@global.autocommit; |
| 999 Malay Peninsula Standard Time 1 |