[code=MySql] begin SELECT * from table1 where status = 0; update table1 set status = 1 where status =0; end[/code]我是通过 Navicat 8 for MySql 工具来建的存储过程, 我想在这个存储过程里加个事务,如何有一条失败马上回滚,希望大家看清楚我的是MySql
CREATE PROCEDURE p100() BEGIN declare exit handler for sqlexception rollback; START TRANSACTION; SELECT * FROM a; update A set B= 1 where B =100; COMMIT ; END ;
http://topic.csdn.net/u/20090506/10/7f68c158-425b-4a38-9c8b-533cd4a27f05.html
CREATE PROCEDURE p100()
BEGIN
declare exit handler for sqlexception rollback;
START TRANSACTION;
SELECT * FROM a;
update A set B= 1 where B =100;
COMMIT ;
END ;