1
SET @start_value= @@global.log_slow_admin_statements;
2
SET @@global.log_slow_admin_statements= DEFAULT;
3
SELECT @@global.log_slow_admin_statements;
4
@@global.log_slow_admin_statements
6
SET @@global.log_slow_admin_statements= TRUE;
7
SELECT @@global.log_slow_admin_statements;
8
@@global.log_slow_admin_statements
10
SET @@global.log_slow_admin_statements= true;
11
SELECT @@global.log_slow_admin_statements;
12
@@global.log_slow_admin_statements
14
SET @@global.log_slow_admin_statements= 0;
15
SELECT @@global.log_slow_admin_statements;
16
@@global.log_slow_admin_statements
18
SET @@global.log_slow_admin_statements= 1;
19
SELECT @@global.log_slow_admin_statements;
20
@@global.log_slow_admin_statements
23
SET @@global.log_slow_admin_statements= @goodvar;
24
SELECT @@global.log_slow_admin_statements;
25
@@global.log_slow_admin_statements
27
SET GLOBAL log_slow_admin_statements= DEFAULT;
28
SELECT @@global.log_slow_admin_statements;
29
@@global.log_slow_admin_statements
31
SET GLOBAL log_slow_admin_statements= ON;
32
SELECT @@global.log_slow_admin_statements;
33
@@global.log_slow_admin_statements
35
SET GLOBAL log_slow_admin_statements= OFF;
36
SELECT @@global.log_slow_admin_statements;
37
@@global.log_slow_admin_statements
39
SET GLOBAL log_slow_admin_statements= -0;
40
SELECT @@global.log_slow_admin_statements;
41
@@global.log_slow_admin_statements
43
SET GLOBAL log_slow_admin_statements= 0.00;
44
ERROR 42000: Incorrect argument type to variable 'log_slow_admin_statements'
45
SET GLOBAL log_slow_admin_statements= +0;
46
SELECT @@global.log_slow_admin_statements;
47
@@global.log_slow_admin_statements
49
SET @@global.log_slow_admin_statements= 'DEFAULT';
50
ERROR 42000: Variable 'log_slow_admin_statements' can't be set to the value of 'DEFAULT'
51
SET @@global.log_slow_admin_statements= 'true';
52
ERROR 42000: Variable 'log_slow_admin_statements' can't be set to the value of 'true'
53
SET @@global.log_slow_admin_statements= BLABLA;
54
ERROR 42000: Variable 'log_slow_admin_statements' can't be set to the value of 'BLABLA'
55
SET @@global.log_slow_admin_statements= 25;
56
ERROR 42000: Variable 'log_slow_admin_statements' can't be set to the value of '25'
57
SET GLOBAL log_slow_admin_statements= -1;
58
ERROR 42000: Variable 'log_slow_admin_statements' can't be set to the value of '-1'
60
SET @@global.log_slow_admin_statements= @badvar;
61
ERROR 42000: Variable 'log_slow_admin_statements' can't be set to the value of 'true'
62
SET GLOBAL log_slow_admin_statements= 'DEFAULT';
63
ERROR 42000: Variable 'log_slow_admin_statements' can't be set to the value of 'DEFAULT'
64
SET log_slow_admin_statements= TRUE;
65
ERROR HY000: Variable 'log_slow_admin_statements' is a GLOBAL variable and should be set with SET GLOBAL
66
SET SESSION log_slow_admin_statements= TRUE;
67
ERROR HY000: Variable 'log_slow_admin_statements' is a GLOBAL variable and should be set with SET GLOBAL
68
SET @@session.log_slow_admin_statements= TRUE;
69
ERROR HY000: Variable 'log_slow_admin_statements' is a GLOBAL variable and should be set with SET GLOBAL
70
SET LOCAL log_slow_admin_statements= TRUE;
71
ERROR HY000: Variable 'log_slow_admin_statements' is a GLOBAL variable and should be set with SET GLOBAL
72
SET @@global log_slow_admin_statements= TRUE;
73
ERROR 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 'log_slow_admin_statements= TRUE' at line 1
74
SET @@SESSION log_slow_admin_statements= TRUE;
75
ERROR 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 'log_slow_admin_statements= TRUE' at line 1
76
SET @@global.log_slow_admin_statements= @start_value;