mysql - 尝试....在 mysql 中捕获事务？

Question

当SQL语句出现错误系统会自动回滚更改时，如何启动事务？

Transaction MySQL

PHP + MySQL transactions examples

在 PHP 中

try {
    // First of all, let's begin a transaction
    $db->beginTransaction();

    // A set of queries; if one fails, an exception should be thrown
    $db->query('first query');
    $db->query('second query');
    $db->query('third query');

    // If we arrive here, it means that no exception was thrown
    // i.e. no query has failed, and we can commit the transaction
    $db->commit();
} catch (Exception $e) {
    // An exception has been thrown
    // We must rollback the transaction
    $db->rollback();
}

如何在没有PHP，只有MYSQL的情况下重复逻辑

Answer 1

我们可以将多个查询写入MySQL 过程/函数，并可以维护事务。请引用下面给出的示例。基本上，您应该声明一个将调用回滚的错误处理程序。

PROCEDURE `myprocedure`()
BEGIN

.. Declare statements ..

DECLARE EXIT HANDLER FOR SQLEXCEPTION 
BEGIN
      .. set any flags etc  eg. SET @flag = 0; ..
      ROLLBACK;
END;

START TRANSACTION;

    .. Query 1 ..
    .. Query 2 ..
    .. Query 3 ..

COMMIT;
.. eg. SET @flag = 1; ..

END

详情请见下方链接

MySQL : transaction within a stored procedure

How can I use transactions in my MySQL stored procedure?