怎样改变mysql的variables的变量里的值.通过什么命令.

Question

mysql> SHOW VARIABLES LIKE 'character_set_connection';
+--------------------------+--------+
| Variable_name            | Value  |
+--------------------------+--------+
| character_set_connection | latin1 |
+--------------------------+--------+
1 row in set (0.00 sec)mysql> set character_set_connection=gb2312;
Query OK, 0 rows affected (0.03 sec)mysql> SHOW VARIABLES LIKE 'character_set_connection';
+--------------------------+--------+
| Variable_name            | Value  |
+--------------------------+--------+
| character_set_connection | gb2312 |
+--------------------------+--------+
1 row in set (0.00 sec)mysql>

Answer 1

也就是说改变变量的值用
set 变量名=变量值 对否?