单个更新查询需要交易吗? [英] Transaction necessary for single update query?

问题描述

我在这样的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.

这篇关于单个更新查询需要交易吗?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！