mysql 存储过程SAVEPOINT ROLLBACK to
来源:互联网 发布:淘宝代销规格如何匹配 编辑:程序博客网 时间:2024/05/16 17:23
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 SET X2 = 4;
START TRANSACTION;
SAVEPOINT savepoint_1;
BEGIN
INSERT INTO eugene VALUES (1);
INSERT INTO eugene VALUES (2);
SELECT X2;
end;
ROLLBACK TO SAVEPOINT savepoint_1;
iNSERT INTO eugene VALUES (3);
END$$
DELIMITER ;
#测试表
CREATE TABLE `eugene` (
`t1` int(4) default NULL
)
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 SET X2 = 4;
START TRANSACTION;
SAVEPOINT savepoint_1;
BEGIN
INSERT INTO eugene VALUES (1);
INSERT INTO eugene VALUES (2);
SELECT X2;
end;
ROLLBACK TO SAVEPOINT savepoint_1;
iNSERT INTO eugene VALUES (3);
END$$
DELIMITER ;
#测试表
CREATE TABLE `eugene` (
`t1` int(4) default NULL
)
- mysql 存储过程SAVEPOINT ROLLBACK to
- oracle中的SAVEPOINT和ROLLBACK TO SAVEPOINT语法解析
- savepoint与rollback(savepoint)
- Rails出现ROLLBACK TO SAVEPOINT active_record_1信息的解决
- 第二章 SQL命令参考-ROLLBACK TO SAVEPOINT
- COMMIT, ROLLBACK AND SAVEPOINT
- oracle sql rollback savepoint
- SQL存储过程rollback tran的使用
- [存储过程]中的事务(rollback)回滚
- commit,rollback,savepoint事务__mysql学习笔记
- mysql savepoint 示例
- mysql savepoint 示例
- PostgreSQL 存储过程中回滚(ROLLBACK)和数组的使用
- Oracle存储过程的commit和rollback,sqlerrm
- PL/SQL中savepoint和rollback的用法
- 【mysql】mysql存储过程
- savepoint
- SAVEPOINT
- 使用System.DirectoryServices.Protocols实现对AD的简单操作
- Subversion之路--实现精细的目录访问权限控制(v1.0 更新于2006.12.05) (二)
- vb.net做一个MSN灌水机
- Symbian资源文件浅析
- 调整心态
- mysql 存储过程SAVEPOINT ROLLBACK to
- C#托管Socket的实现方法(1)
- 海量数据库的查询优化及分页算法方案
- C#托管Socket的实现方法(2)
- 一个注册会员页面中:表单验证的js
- 最近在研究Mythtv
- oracle 常用命令
- JAVA华为面试题
- 软件开发规范