Debian Codegraph @

mysql-test/suite/sys_vars/r/show_vs_valstr.result

raw
1 use information_schema;
2 select variable_name, s.variable_value, v.global_value
3 from global_variables s join system_variables v using (variable_name)
4 where not (s.variable_value <=> v.global_value);
5 variable_name variable_value global_value
6 select variable_name, s.variable_value, v.session_value
7 from session_variables s join system_variables v using (variable_name)
8 where v.variable_scope != 'GLOBAL' and
9 not (s.variable_value <=> v.session_value);
10 variable_name variable_value session_value