- MySQL 환경변수 확인
전체 목록
mysql> SHOW VARIABLES;
+---------------------------------------------------+------------------------------------------------------------------------------------------------------------------------+
| Variable_name | Value |
+---------------------------------------------------+------------------------------------------------------------------------------------------------------------------------+
| auto_increment_increment | 1 |
| auto_increment_offset | 1 |
... (생략)
| warning_count | 0 |
+---------------------------------------------------+------------------------------------------------------------------------------------------------------------------------+
329 rows in set (0.00 sec)
mysql> SHOW GLOBAL VARIABLES;
+---------------------------------------------------+------------------------------------------------------------------------------------------------------------------------+
| Variable_name | Value |
+---------------------------------------------------+------------------------------------------------------------------------------------------------------------------------+
| auto_increment_increment | 1 |
| auto_increment_offset | 1 |
... (생략)
| wait_timeout | 28800 |
+---------------------------------------------------+------------------------------------------------------------------------------------------------------------------------+
317 rows in set (0.00 sec)
LIKE 조건
mysql> SHOW VARIABLES LIKE 'auto_%';
+--------------------------+-------+
| Variable_name | Value |
+--------------------------+-------+
| auto_increment_increment | 1 |
| auto_increment_offset | 1 |
| autocommit | ON |
| automatic_sp_privileges | ON |
+--------------------------+-------+
4 rows in set (0.00 sec)
mysql> SHOW VARIABLES LIKE 'auto\_%';
+--------------------------+-------+
| Variable_name | Value |
+--------------------------+-------+
| auto_increment_increment | 1 |
| auto_increment_offset | 1 |
+--------------------------+-------+
2 rows in set (0.00 sec)
1개 보기
mysql> SELECT @@auto_increment_increment;
+----------------------------+
| @@auto_increment_increment |
+----------------------------+
| 1 |
+----------------------------+
1 row in set (0.00 sec)
같이 보기
