1SET @start_value = @@global.flush; 2SELECT @start_value; 3@start_value 40 5'#--------------------FN_DYNVARS_030_01------------------------#' 6SET @@global.flush = ON; 7SET @@global.flush = DEFAULT; 8SELECT @@global.flush; 9@@global.flush 100 11'#---------------------FN_DYNVARS_030_02-------------------------#' 12SET @@global.flush = @start_value; 13SELECT @@global.flush; 14@@global.flush 150 16'#--------------------FN_DYNVARS_030_03------------------------#' 17SET @@global.flush = ON; 18SELECT @@global.flush; 19@@global.flush 201 21SET @@global.flush = OFF; 22SELECT @@global.flush; 23@@global.flush 240 25SET @@global.flush = 0; 26SELECT @@global.flush; 27@@global.flush 280 29SET @@global.flush = 1; 30SELECT @@global.flush; 31@@global.flush 321 33'#--------------------FN_DYNVARS_030_04-------------------------#' 34SET @@global.flush = 2; 35ERROR 42000: Variable 'flush' can't be set to the value of '2' 36SET @@global.flush = -1; 37ERROR 42000: Variable 'flush' can't be set to the value of '-1' 38SET @@global.flush = TRUEF; 39ERROR 42000: Variable 'flush' can't be set to the value of 'TRUEF' 40SET @@global.flush = TRUE_F; 41ERROR 42000: Variable 'flush' can't be set to the value of 'TRUE_F' 42SET @@global.flush = FALSE0; 43ERROR 42000: Variable 'flush' can't be set to the value of 'FALSE0' 44SET @@global.flush = OON; 45ERROR 42000: Variable 'flush' can't be set to the value of 'OON' 46SET @@global.flush = ONN; 47ERROR 42000: Variable 'flush' can't be set to the value of 'ONN' 48SET @@global.flush = OOFF; 49ERROR 42000: Variable 'flush' can't be set to the value of 'OOFF' 50SET @@global.flush = 0FF; 51ERROR 42000: Variable 'flush' can't be set to the value of '0FF' 52SET @@global.flush = ' '; 53ERROR 42000: Variable 'flush' can't be set to the value of ' ' 54SET @@global.flush = " "; 55ERROR 42000: Variable 'flush' can't be set to the value of ' ' 56SET @@global.flush = ''; 57ERROR 42000: Variable 'flush' can't be set to the value of '' 58'#-------------------FN_DYNVARS_030_05----------------------------#' 59SET @@session.flush = 1; 60ERROR HY000: Variable 'flush' is a GLOBAL variable and should be set with SET GLOBAL 61SELECT @@session.flush; 62ERROR HY000: Variable 'flush' is a GLOBAL variable 63'#----------------------FN_DYNVARS_030_06------------------------#' 64SELECT IF(@@global.flush, "ON", "OFF") = VARIABLE_VALUE 65FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 66WHERE VARIABLE_NAME='flush'; 67IF(@@global.flush, "ON", "OFF") = VARIABLE_VALUE 681 69'#---------------------FN_DYNVARS_030_07----------------------#' 70SET @@global.flush = TRUE; 71SELECT @@global.flush; 72@@global.flush 731 74SET @@global.flush = FALSE; 75SELECT @@global.flush; 76@@global.flush 770 78'#---------------------FN_DYNVARS_030_08----------------------#' 79SET @@global.flush = 1; 80SELECT @@flush = @@global.flush; 81@@flush = @@global.flush 821 83'#---------------------FN_DYNVARS_030_09----------------------#' 84SET flush = 1; 85ERROR HY000: Variable 'flush' is a GLOBAL variable and should be set with SET GLOBAL 86SET global.flush = 1; 87ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'flush = 1' at line 1 88SELECT global.flush; 89ERROR 42S02: Unknown table 'global' in field list 90SELECT flush = @@session.flush; 91ERROR 42S22: Unknown column 'flush' in 'field list' 92SET @@global.flush = @start_value; 93SELECT @@global.flush; 94@@global.flush 950 96