【知识库】--mysql COMMIT and ROLLBACK --AUTOCOMMIT（196）

自驱

于 2017-05-07 14:28:13 发布

阅读量622

点赞数

分类专栏： mysql 文章标签： mysql

mysql 专栏收录该内容

40 篇文章

订阅专栏

本文介绍了MySQL中如何使用COMMIT和ROLLBACK来控制事务。COMMIT用于提交成功完成的事务，使所有更改生效；ROLLBACK则用于撤消事务，在发生错误时将表恢复到事务开始前的状态。通过设置AUTOCOMMIT变量可以进一步控制事务行为。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

COMMIT and ROLLBACK:
These two keywords Commit and Rollback are mainly used for MySQL Transactions.

When a successful transaction is completed, the COMMIT command should be issued so that the changes to all involved tables will take effect.

If a failure occurs, a ROLLBACK command should be issued to return every table referenced in the transaction to its previous state.

You can control the behavior of a transaction by setting session variable called AUTOCOMMIT. If AUTOCOMMIT is set to 1 (the default), then each SQL statement (within a transaction or not) is considered a complete transaction and committed by default when it finishes. When AUTOCOMMIT is set to 0, by issuing the SET AUTOCOMMIT=0 command, the subsequent series of statements acts like a transaction and no activities are committed until an explicit COMMIT statement is issued.