相关文章推荐
会开车的钱包  ·  中车大连公司生产的沈阳地铁2号线南延线、4号 ...·  2 月前    · 
飞翔的酸菜鱼  ·  数独秘诀·  10 月前    · 
有胆有识的勺子  ·  崩坏星穹铁道希露瓦c...·  11 月前    · 
跑龙套的蚂蚁  ·  北京文创和科技企业组团出访韩国、日本:文化“ ...·  11 月前    · 
讲道义的闹钟  ·  COS支持蛇型艺廊公园之夜2014|COS| ...·  1 年前    · 
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
玩足球的黄花菜
3 年前
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.

 
推荐文章
会开车的钱包  ·  中车大连公司生产的沈阳地铁2号线南延线、4号线列车正式载客运营
2 月前
飞翔的酸菜鱼  ·  数独秘诀
10 月前
有胆有识的勺子  ·  崩坏星穹铁道希露瓦c...
11 月前
跑龙套的蚂蚁  ·  北京文创和科技企业组团出访韩国、日本:文化“走出去”,经验“引进来”
11 月前
讲道义的闹钟  ·  COS支持蛇型艺廊公园之夜2014|COS|时尚合作_新浪时尚_新浪网
1 年前
今天看啥   ·   Py中国   ·   codingpro   ·   小百科   ·   link之家   ·   卧龙AI搜索
删除内容请联系邮箱 2879853325@qq.com
Code - 代码工具平台
© 2024 ~ 沪ICP备11025650号