mysql设置variables时global和session的区别

我在设置binlog格式时用的 set session

mysql> show variables like "binlog_format%";
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| binlog_format | ROW   |
+---------------+-------+
1 row in set, 1 warning (0.00 sec)

mysql> set session  binlog_format=statement;
Query OK, 0 rows affected (0.00 sec)

mysql> show variables like "binlog_format%";
+---------------+-----------+
| Variable_name | Value     |
+---------------+-----------+
| binlog_format | STATEMENT |
+---------------+-----------+
1 row in set, 1 warning (0.00 sec)
 

但是打开另一个cmd

mysql> show variables like 'binlog_for%';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| binlog_format | ROW   |
+---------------+-------+
1 row in set, 1 warning (0.00 sec)

 

set session只对当前的连接生效

如果用set global binlog_format=statement;就针对全局了