MySQL AUTOCOMMIT 설정

MySQL AUTOCOMMIT 설정
MySQL AUTOCOMMIT 변경

1 확인 1[ | ]

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

2 변경[ | ]

mysql> SET AUTOCOMMIT=FALSE;
Query OK, 0 rows affected (0.00 sec)
→ AUTOCOMMIT을 비활성화함
→ 활성화하려면 FALSE 대신 TRUE를 쓰면 된다.

3 확인 2[ | ]

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

4 같이 보기[ | ]

문서 댓글 ({{ doc_comments.length }})
{{ comment.name }} {{ comment.created | snstime }}