MySQL AUTOCOMMIT 확인

MySQL AUTOCOMMIT 확인

1 방법 1: SELECT[ | ]

명령어

sql

Copy

SELECT @@AUTOCOMMIT;

실행예시 (AUTOCOMMIT 활성화됨, 보통 이것이 기본값)

Console

Copy

mysql> SELECT @@AUTOCOMMIT;
+--------------+
| @@AUTOCOMMIT |
+--------------+
|            1 |
+--------------+
1 row in set (0.00 sec)

실행예시 (AUTOCOMMIT 비활성화됨)

Console

Copy

mysql> SELECT @@AUTOCOMMIT;
+--------------+
| @@AUTOCOMMIT |
+--------------+
|            0 |
+--------------+
1 row in set (0.00 sec)

2 방법 2: SHOW[ | ]

Console

Copy

mysql> SHOW VARIABLES LIKE 'autocommit';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| autocommit    | ON    |
+---------------+-------+
1 row in set (0.01 sec)

3 같이 보기[ | ]

4 참고[ | ]

http://junho85.tistory.com/11