1SET @start_global_value = @@global.log_disabled_statements; 2select @@global.log_disabled_statements; 3@@global.log_disabled_statements 4sp 5select @@session.log_disabled_statements; 6@@session.log_disabled_statements 7sp 8show global variables like 'log_disabled_statements'; 9Variable_name Value 10log_disabled_statements sp 11show session variables like 'log_disabled_statements'; 12Variable_name Value 13log_disabled_statements sp 14select * from information_schema.global_variables where variable_name='log_disabled_statements'; 15VARIABLE_NAME VARIABLE_VALUE 16LOG_DISABLED_STATEMENTS sp 17select * from information_schema.session_variables where variable_name='log_disabled_statements'; 18VARIABLE_NAME VARIABLE_VALUE 19LOG_DISABLED_STATEMENTS sp 20set global log_disabled_statements=1; 21select @@global.log_disabled_statements; 22@@global.log_disabled_statements 23slave 24set session log_disabled_statements=1; 25select @@session.log_disabled_statements; 26@@session.log_disabled_statements 27slave 28set session log_disabled_statements=1; 29select @@session.log_disabled_statements; 30@@session.log_disabled_statements 31slave 32set session log_disabled_statements=2; 33select @@session.log_disabled_statements; 34@@session.log_disabled_statements 35sp 36set session log_disabled_statements='slave'; 37select @@session.log_disabled_statements; 38@@session.log_disabled_statements 39slave 40set session log_disabled_statements='sp'; 41select @@session.log_disabled_statements; 42@@session.log_disabled_statements 43sp 44set session log_disabled_statements='slave,sp'; 45select @@session.log_disabled_statements; 46@@session.log_disabled_statements 47slave,sp 48set session log_disabled_statements=''; 49select @@session.log_disabled_statements; 50@@session.log_disabled_statements 51 52set session log_disabled_statements=1.1; 53ERROR 42000: Incorrect argument type to variable 'log_disabled_statements' 54set session log_disabled_statements=1e1; 55ERROR 42000: Incorrect argument type to variable 'log_disabled_statements' 56set session log_disabled_statements="foo"; 57ERROR 42000: Variable 'log_disabled_statements' can't be set to the value of 'foo' 58set session log_disabled_statements=1024; 59ERROR 42000: Variable 'log_disabled_statements' can't be set to the value of '1024' 60SET @@global.log_disabled_statements = @start_global_value; 61