# 查看日志相关的配置参数
show global variables like '%innodb%log%';
事务控制语句
#查看是否开启自动提交功能
show global variables like 'autocommint%';
show session variables like 'autocommint%';
#关闭当前会话的autocommint功能
set @@session.autocommint = 0
1. start transaction/begin 开始
2. commint/commint work 提交
3. rollback/rollbackwork 回滚
4. savepoint 标识符
5. rollback to savepoint 回滚到指定保存点
6. release savepoint 删除保存点
事务隔离级别
#查看当前设置的隔离级别
show variables like 'tx_isolation';
REPEATABLE-READ 可重读
SERIALIZABLE 串行化
READ-COMMINTTED 读已提交
READ-UNCOMMINTTED 读未提交
转载于:https://www.cnblogs.com/kcxg/p/10382475.html