56,677
社区成员
发帖
与我相关
我的任务
分享
CREATE PROCEDURE A()
BEGIN
DECLARE 'Constraint Violation'
CONDITION FOR sqlexception;
DECLARE EXIT HANDLER FOR
'Constraint Violation' ROLLBACK;
BEGIN TRANSACTION;
insert into A(vName) VALUES('a');
COMMIT;
end;
declare exit handler for sqlexception rollback;
mysql> delimiter //
mysql>
mysql> CREATE PROCEDURE A()
-> BEGIN
-> declare exit handler for sqlexception select 'ERROR'; rollback;
->
-> insert into A(vName) VALUES('a');
-> COMMIT;
-> end;
-> //
Query OK, 0 rows affected (0.00 sec)
mysql> call a()//
+-------+
| ERROR |
+-------+
| ERROR |
+-------+
1 row in set (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
mysql>