Mysql 关闭自动commit
时间:2021-07-01 10:21:17
帮助过:34人阅读
mysql> show variables like ‘autocommit‘;
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| autocommit | OFF |
+---------------+-------+
1 row in set (0.00 sec)
2、@@autocommit为0表示off,为1表示on
- mysql> select @@autocommit;
- +--------------+
- | @@autocommit |
- +--------------+
- | 0 |
- +--------------+
- 1 row in set (0.00 sec)
Mysql 关闭自动commit
标签:alt comment 关闭 ted ber mit row 关闭自动 设置