相关文章推荐
千杯不醉的海龟  ·  浦东这些展会等你来打卡·  1 年前    · 
无邪的仙人球  ·  雷电将军3d同人游戏怎么下-抖音·  1 年前    · 
爱热闹的金针菇  ·  坦诚携手 ...·  1 年前    · 
暗恋学妹的柑橘  ·  中国教育报:“一带一路”上的中国教育行动-北 ...·  2 年前    · 
个性的山寨机  ·  染色、偏光、镜面和变色太阳镜… ...·  2 年前    · 
Code  ›  MySQL :: MySQL 5.7 Reference Manual :: 13.3.4 SAVEPOINT, ROLLBACK TO SAVEPOINT, and RELEASE SAVEPOINT Statements
https://dev.mysql.com/doc/refman/5.7/en/savepoint.html
玩足球的黄花菜
2 年前
Statements That Cause an Implicit Commit
SAVEPOINT, ROLLBACK TO SAVEPOINT, and RELEASE SAVEPOINT Statements
LOCK TABLES and UNLOCK TABLES Statements
SET TRANSACTION Statement
XA Transactions
XA Transaction SQL Statements
XA Transaction States
Restrictions on XA Transactions
CREATE FUNCTION Statement for Loadable Functions
DROP FUNCTION Statement for Loadable Functions
INSTALL PLUGIN Statement
UNINSTALL PLUGIN Statement
SAVEPOINT identifier
ROLLBACK [WORK] TO [SAVEPOINT] identifier
RELEASE SAVEPOINT identifier

InnoDB supports the SQL statements SAVEPOINT , ROLLBACK TO SAVEPOINT , RELEASE SAVEPOINT and the optional WORK keyword for ROLLBACK . The SAVEPOINT statement sets a named transaction savepoint with a name of identifier . If the current transaction has a savepoint with the same name, the old savepoint is deleted and a new one is set. The ROLLBACK TO SAVEPOINT statement rolls back a transaction to the named savepoint without terminating the transaction. Modifications that the current transaction made to rows after the savepoint was set are undone in the rollback, but InnoDB does not release the row locks that were stored in memory after the savepoint. (For a new inserted row, the lock information is carried by the transaction ID stored in the row; the lock is not separately stored in memory. In this case, the row lock is released in the undo.) Savepoints that were set at a later time than the named savepoint are deleted. If the ROLLBACK TO SAVEPOINT statement returns the following error, it means that no savepoint with the specified name exists:

ERROR 1305 (42000): SAVEPOINT identifier does not exist

The RELEASE SAVEPOINT statement removes the named savepoint from the set of savepoints of the current transaction. No commit or rollback occurs. It is an error if the savepoint does not exist. All savepoints of the current transaction are deleted if you execute a COMMIT , or a ROLLBACK that does not name a savepoint. A new savepoint level is created when a stored function is invoked or a trigger is activated. The savepoints on previous levels become unavailable and thus do not conflict with savepoints on the new level. When the function or trigger terminates, any savepoints it created are released and the previous savepoint level is restored.

 
推荐文章
千杯不醉的海龟  ·  浦东这些展会等你来打卡
1 年前
无邪的仙人球  ·  雷电将军3d同人游戏怎么下-抖音
1 年前
爱热闹的金针菇  ·  坦诚携手 合作共赢——中国航空工业副总经理陈元先-国务院国有资产监督管理委员会
1 年前
暗恋学妹的柑橘  ·  中国教育报:“一带一路”上的中国教育行动-北京交通大学新闻网
2 年前
个性的山寨机  ·  染色、偏光、镜面和变色太阳镜… 这些户外神器是怎么制造的? - 知乎
2 年前
今天看啥   ·   Py中国   ·   codingpro   ·   小百科   ·   link之家   ·   卧龙AI搜索
删除内容请联系邮箱 2879853325@qq.com
Code - 代码工具平台
© 2024 ~ 沪ICP备11025650号