We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
BEGIN/START TRANSACTION
COMMIT
COMMIT WORK
ROLLBACK
ROLLBACK WORK
SAVEPOINT identifier
SAVEPOINT
RELEASE SAVEPOINT identifier
ROOLBACK TO identifier
SET TRANSACTION
BEGIN
SET
SET AUTOCOMMIT=0
SET AUTOCOMMIT=1
The text was updated successfully, but these errors were encountered:
No branches or pull requests
事务控制语句
BEGIN/START TRANSACTION
显示的开启一个事物COMMIT
或COMMIT WORK
提交事务,并且使已对数据库进行的修改编程永久性的ROLLBACK
或ROLLBACK WORK
回滚事务,并且撤销正在进行的所有未提交的修改SAVEPOINT identifier
,SAVEPOINT
允许在事务中创建一个保存点,一个事务可以有多个保存点RELEASE SAVEPOINT identifier
删除一个事务的保存点,当没有保存点是,会抛出异常ROOLBACK TO identifier
把事务回滚到保存点SET TRANSACTION
用老设置事务的隔离级别MySQL 事务处理的方法
BEGIN
、ROLLBACK
、COMMIT
实现BEGIN
开始一个事务ROLLBACK
事务回滚COMMIT
事务确认/提交SET
改变 MySQL 的自动提交模式SET AUTOCOMMIT=0
禁止自动提交SET AUTOCOMMIT=1
开启自动提交The text was updated successfully, but these errors were encountered: