1SET @session_start_value = @@session.foreign_key_checks; 2SELECT @session_start_value; 3@session_start_value 41 5'#--------------------FN_DYNVARS_032_01------------------------#' 6SET @@session.foreign_key_checks = 1; 7SET @@session.foreign_key_checks = DEFAULT; 8SELECT @@session.foreign_key_checks; 9@@session.foreign_key_checks 101 11'#---------------------FN_DYNVARS_032_02-------------------------#' 12SET foreign_key_checks = 1; 13SELECT @@foreign_key_checks; 14@@foreign_key_checks 151 16SELECT session.foreign_key_checks; 17ERROR 42S02: Unknown table 'session' in field list 18SELECT local.foreign_key_checks; 19ERROR 42S02: Unknown table 'local' in field list 20SET session foreign_key_checks = 0; 21SELECT @@session.foreign_key_checks; 22@@session.foreign_key_checks 230 24'#--------------------FN_DYNVARS_032_03------------------------#' 25SET @@session.foreign_key_checks = 0; 26SELECT @@session.foreign_key_checks; 27@@session.foreign_key_checks 280 29SET @@session.foreign_key_checks = 1; 30SELECT @@session.foreign_key_checks; 31@@session.foreign_key_checks 321 33'#--------------------FN_DYNVARS_032_04-------------------------#' 34SET @@session.foreign_key_checks = -1; 35ERROR 42000: Variable 'foreign_key_checks' can't be set to the value of '-1' 36SET @@session.foreign_key_checks = 2; 37ERROR 42000: Variable 'foreign_key_checks' can't be set to the value of '2' 38SET @@session.foreign_key_checks = "T"; 39ERROR 42000: Variable 'foreign_key_checks' can't be set to the value of 'T' 40SET @@session.foreign_key_checks = "Y"; 41ERROR 42000: Variable 'foreign_key_checks' can't be set to the value of 'Y' 42SET @@session.foreign_key_checks = TR�E; 43ERROR 42000: Variable 'foreign_key_checks' can't be set to the value of 'TR�E' 44SET @@session.foreign_key_checks = �N; 45ERROR 42000: Variable 'foreign_key_checks' can't be set to the value of '�N' 46SET @@session.foreign_key_checks = OF; 47ERROR 42000: Variable 'foreign_key_checks' can't be set to the value of 'OF' 48SET @@session.foreign_key_checks = �FF; 49ERROR 42000: Variable 'foreign_key_checks' can't be set to the value of '�FF' 50SET @@session.foreign_key_checks = '�'; 51ERROR 42000: Variable 'foreign_key_checks' can't be set to the value of '�' 52SET @@session.foreign_key_checks = NO; 53ERROR 42000: Variable 'foreign_key_checks' can't be set to the value of 'NO' 54'#-------------------FN_DYNVARS_032_05----------------------------#' 55SET @@global.foreign_key_checks = 0; 56SELECT @@global.foreign_key_checks; 57@@global.foreign_key_checks 580 59SET @@global.foreign_key_checks = 1; 60'#----------------------FN_DYNVARS_032_06------------------------#' 61SELECT count(VARIABLE_VALUE) FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='foreign_key_checks'; 62count(VARIABLE_VALUE) 631 64'#----------------------FN_DYNVARS_032_07------------------------#' 65SELECT IF(@@session.foreign_key_checks, "ON", "OFF") = VARIABLE_VALUE 66FROM INFORMATION_SCHEMA.SESSION_VARIABLES 67WHERE VARIABLE_NAME='foreign_key_checks'; 68IF(@@session.foreign_key_checks, "ON", "OFF") = VARIABLE_VALUE 691 70SELECT @@session.foreign_key_checks; 71@@session.foreign_key_checks 721 73SELECT VARIABLE_VALUE 74FROM INFORMATION_SCHEMA.SESSION_VARIABLES 75WHERE VARIABLE_NAME='foreign_key_checks'; 76VARIABLE_VALUE 77ON 78'#---------------------FN_DYNVARS_032_08-------------------------#' 79SET @@session.foreign_key_checks = OFF; 80SELECT @@session.foreign_key_checks; 81@@session.foreign_key_checks 820 83SET @@session.foreign_key_checks = ON; 84SELECT @@session.foreign_key_checks; 85@@session.foreign_key_checks 861 87'#---------------------FN_DYNVARS_032_09----------------------#' 88SET @@session.foreign_key_checks = TRUE; 89SELECT @@session.foreign_key_checks; 90@@session.foreign_key_checks 911 92SET @@session.foreign_key_checks = FALSE; 93SELECT @@session.foreign_key_checks; 94@@session.foreign_key_checks 950 96SET @@session.foreign_key_checks = @session_start_value; 97SELECT @@session.foreign_key_checks; 98@@session.foreign_key_checks 991 100