gpt4 book ai didi

mysql - 递归/嵌套事务

转载 作者:行者123 更新时间:2023-11-29 02:35:15 24 4
gpt4 key购买 nike

<分区>

我有 2 个存储过程 A、B,它们都在一个事务 block 中。问题是 A 调用 B,因此存在递归/嵌套事务。我不确定是否有问题?当我调用 A 时会发生什么?

引自《MySQL存储过程编程》:

START TRANSACTION signifies the commencement of a new transaction. If an existing transaction is already in progress, then START TRANSACTION will issue an implicit COMMIT. When you issue START TRANSACTION, the autocommit property (described in the next section) is effectively and implicitly set to 0 until the transaction ends. We recommend that you explicitly commit or roll back existing transactions before any START TRANSACTION statements, since the implicit COMMIT might not be obvious to someone reading or maintaining your code.

24 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com