无详细内容 事务 rollback mysql mysqlmysql delimiter $$mysqlmysql 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 sqlex
事务 rollback mysql 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)