12、事务总结

# 查看日志相关的配置参数 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 读未提交