1SET @start_global_value = @@global.lc_messages;
2SELECT @start_global_value;
3@start_global_value
4en_US
5select @@global.lc_messages;
6@@global.lc_messages
7en_US
8select @@session.lc_messages;
9@@session.lc_messages
10en_US
11show global variables like 'lc_messages';
12Variable_name	Value
13lc_messages	en_US
14show session variables like 'lc_messages';
15Variable_name	Value
16lc_messages	en_US
17select * from information_schema.global_variables where variable_name='lc_messages';
18VARIABLE_NAME	VARIABLE_VALUE
19LC_MESSAGES	en_US
20select * from information_schema.session_variables where variable_name='lc_messages';
21VARIABLE_NAME	VARIABLE_VALUE
22LC_MESSAGES	en_US
23set global lc_messages=1;
24select @@global.lc_messages;
25@@global.lc_messages
26en_GB
27set session lc_messages=2;
28select @@session.lc_messages;
29@@session.lc_messages
30ja_JP
31set global lc_messages="en_US";
32set session lc_messages="en_GB";
33select @@global.lc_messages;
34@@global.lc_messages
35en_US
36select @@session.lc_messages;
37@@session.lc_messages
38en_GB
39select * from information_schema.global_variables where variable_name='lc_messages';
40VARIABLE_NAME	VARIABLE_VALUE
41LC_MESSAGES	en_US
42select * from information_schema.session_variables where variable_name='lc_messages';
43VARIABLE_NAME	VARIABLE_VALUE
44LC_MESSAGES	en_GB
45set global lc_messages=1.1;
46ERROR 42000: Incorrect argument type to variable 'lc_messages'
47set global lc_messages=1e1;
48ERROR 42000: Incorrect argument type to variable 'lc_messages'
49SET @@global.lc_messages = @start_global_value;
50SELECT @@global.lc_messages;
51@@global.lc_messages
52en_US
53