- 论坛徽章:
- 0
|
- mysql>
- mysql> delimiter $$
- mysql>
- mysql> CREATE PROCEDURE myProc(
- -> in_from INTEGER,
- -> in_to INTEGER,
- -> in_amount DECIMAL(8,2))
- -> BEGIN
- ->
- -> DECLARE txn_error INTEGER DEFAULT 0 ;
- ->
- -> DECLARE CONTINUE HANDLER FOR SQLEXCEPTION BEGIN
- -> SET txn_error=1;
- -> END;
- ->
- -> SAVEPOINT savepoint_tfer;
- ->
- -> UPDATE employee
- -> SET salary=in_amount
- -> WHERE id=in_from;
- ->
- -> IF txn_error THEN
- -> ROLLBACK TO savepoint_tfer;
- -> SELECT 'Transfer aborted ';
- -> ELSE
- -> UPDATE employee
- -> SET salary=in_amount
- -> WHERE id=in_to;
- ->
- -> IF txn_error THEN
- -> ROLLBACK TO savepoint_tfer;
- -> SELECT 'Transfer aborted ';
- -> END IF;
- -> END IF;
- ->
- -> END$$
- Query OK, 0 rows affected (0.00 sec)
复制代码 |
|