1select @@global.lower_case_table_names=20;
2@@global.lower_case_table_names=20
30
4select @@session.lower_case_table_names;
5ERROR HY000: Variable 'lower_case_table_names' is a GLOBAL variable
6SELECT @@global.lower_case_table_names in (0,1,2);
7@@global.lower_case_table_names in (0,1,2)
81
9SELECT @@global.lower_case_table_names = VARIABLE_VALUE
10FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
11WHERE VARIABLE_NAME='lower_case_table_names';
12@@global.lower_case_table_names = VARIABLE_VALUE
131
14SELECT @@global.lower_case_table_names = VARIABLE_VALUE
15FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
16WHERE VARIABLE_NAME='lower_case_table_names';
17@@global.lower_case_table_names = VARIABLE_VALUE
181
19set global lower_case_table_names=1;
20ERROR HY000: Variable 'lower_case_table_names' is a read only variable
21set session lower_case_table_names=1;
22ERROR HY000: Variable 'lower_case_table_names' is a read only variable
23