MySQL 事务 ROLLBACK 示例代码
程序员文章站
2022-03-29 16:43:34
...
无详细内容 事务 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 MySQLmysql> 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)