1select @@global.show_compatibility_56; 2@@global.show_compatibility_56 31 4select @@session.show_compatibility_56; 5ERROR HY000: Variable 'show_compatibility_56' is a GLOBAL variable 6show global variables like 'show_compatibility_56'; 7Variable_name Value 8show_compatibility_56 ON 9show session variables like 'show_compatibility_56'; 10Variable_name Value 11show_compatibility_56 ON 12select * from information_schema.global_variables 13where variable_name='show_compatibility_56'; 14VARIABLE_NAME VARIABLE_VALUE 15SHOW_COMPATIBILITY_56 ON 16select * from information_schema.session_variables 17where variable_name='show_compatibility_56'; 18VARIABLE_NAME VARIABLE_VALUE 19SHOW_COMPATIBILITY_56 ON 20set global show_compatibility_56=1; 21show variables like "show_compatibility_56"; 22Variable_name Value 23show_compatibility_56 ON 24set global show_compatibility_56=0; 25show variables like "show_compatibility_56"; 26Variable_name Value 27show_compatibility_56 OFF 28set global show_compatibility_56=ON; 29show variables like "show_compatibility_56"; 30Variable_name Value 31show_compatibility_56 ON 32set global show_compatibility_56=OFF; 33show variables like "show_compatibility_56"; 34Variable_name Value 35show_compatibility_56 OFF 36set global show_compatibility_56=TRUE; 37show variables like "show_compatibility_56"; 38Variable_name Value 39show_compatibility_56 ON 40set global show_compatibility_56=FALSE; 41show variables like "show_compatibility_56"; 42Variable_name Value 43show_compatibility_56 OFF 44set global show_compatibility_56=999; 45ERROR 42000: Variable 'show_compatibility_56' can't be set to the value of '999' 46set session show_compatibility_56=1; 47ERROR HY000: Variable 'show_compatibility_56' is a GLOBAL variable and should be set with SET GLOBAL 48