系统表介绍
session_variables 当前会话变量信息
| 列名 | 含义 |
|---|---|
| VARIABLE_NAME | 变量名 |
| VARIABLE_VALUE | 变量值 |
实例
mysql> select * from session_variables limit 10 ;
+--------------------------+---------------------+
| VARIABLE_NAME | VARIABLE_VALUE |
+--------------------------+---------------------+
| auto_generate_certs | ON |
| auto_increment_increment | 1 |
| auto_increment_offset | 1 |
| autocommit | ON |
| automatic_sp_privileges | ON |
| avoid_temporal_upgrade | OFF |
| back_log | 250 |
| basedir | /usr/local/mysql57/ |
| big_tables | OFF |
| bind_address | * |
+--------------------------+---------------------+
10 rows in set (0.00 sec)