单个更新查询所需的事务?

2022-01-06 00:00:00 transactions mysql innodb

我在 InnoDB 表上有一个 mysql 查询,如下所示:

I have a mysql query on an InnoDB table like this:

UPDATE items SET qty = qty + 5 WHERE item_id = 1234 LIMIT 1;

我需要为此使用事务吗?不使用事务会发生什么不希望的事情吗?

Do I need to use a transaction for this? Could anything undesirable happen by not using a transaction?

推荐答案

不会发生严重的事情.默认情况下,MySQL 将所有单个更新/插入/删除命令包装在一个事务中.如果更新出现问题,那么事务应该正确回滚.

Nothing serious can happen. By default, MySQL wraps all single update/insert/delete commands in a transaction. If something goes wrong in the update, then the transaction should be rolled back correctly.

当您组合多个更改并希望它们全部同时"或根本不"生效时,您才真正需要事务.

You really only need transactions when you are combining multiple changes and want them all to take effect "at the same time" or "not at all".

您可以在文档中阅读更多相关信息.

You can read more about this in the documentation.

相关文章