1. autocommit 확인

SELECT @@AUTOCOMMIT; 

+--------------+
| @@autocommit |
+--------------+
|            0 |
+--------------+

2. autocommit 설정

SET AUTOCOMMIT = FALSE;