多个savepoint 从未在此会话中创建保存点
【赛迪网－IT技术报道】savepoint和ROLLBACK TO savepoint语法: savepoint identifier ROLLBACK [WORK] TO savepoint identifier RELEASE savepoint identifier InnoDB支持SQL语句savepoint, ROLLBACK TO savepoint, RELEASE savepoint和自选的用于ROLLBACK的WORK关键词。 savepoint语句用于设置一个事务保存点，带一个标识符名称。如果当前事务有一个同样名称的保存点，则旧的保存点被删除，新的保存点被设置。 ROLLBACK TO...
by 剑心通明 - MySQL文档中心 - 2008-04-02 16:59:01 阅读（656） 回复（0）
来源：赛迪网 作者：李明昭 【赛迪网－IT技术报道】savepoint和ROLLBACK TO savepoint语法: savepoint identifier ROLLBACK [WORK] TO savepoint identifier RELEASE savepoint identifier InnoDB支持SQL语句savepoint, ROLLBACK TO savepoint, RELEASE savepoint和自选的用于ROLLBACK的WORK关键词。 savepoint语句用于设置一个事务保存点，带一个标识符名称。如果当前事务有一个同样名称的保存点，则旧的保存点被删除，新...
请教savepoint的问题 在看savepoint的解释的时候，对ON ROLLBACK RETAIN CURSORS和ON ROLLBACK RETAIN LOCKS不是很明白，这两个之间有什么区别？ 另外，对这两个的解释也没看明白，不知道其英文到底想表达什么，每个词都能看懂，就是不理解： ON ROLLBACK RETAIN CURSORS Specifies system behavior upon rollback to this savepoint with respect to open cursor statements processed after the savepoint statement. The RETA...
来源：赛迪网 作者：Alice 示例如下： DELIMITER $$ DROP PROCEDURE IF EXISTS `test`.`handlerdemo`$$ CREATE DEFINER=`root`@`localhost` PROCEDURE `handlerdemo`() BEGIN DECLARE X2 INT; DECLARE CONTINUE HANDLER FOR SQLWARNING SET X2= 1; DECLARE CONTINUE HANDLER FOR NOT FOUND SET X2 = 2; DECLARE CONTINUE HANDLER FOR SQLSTATE '23000' SET X2= 3; DECLARE CONTINUE HANDLER FOR SQLEXCEPTION S...
