MySQL是否同时支持原子选择和更新 [英] Does MySQL Support Atomic Select and Update Together

问题描述

我正在MySQL中寻找以下内容:

I'm looking for something like the following in MySQL:

SELECT Field1 
FROM MyTable 
AFTER UPDATE 
SET Field2 = 'myvalueX' 
WHERE Field3 = 'myvalueY';

上面的假设语句为受语句的更新部分影响的每一行返回Field1的值.

The above hypothetical statement returns the values for Field1 for each row that was affected by the update part of the statement.

这样的语句在MySQL中存在吗?

Does such a statement exist in MySQL?

推荐答案

执行以下操作:

START TRANSACTION;
UPDATE ....
SELECT ....
COMMIT;

这篇关于MySQL是否同时支持原子选择和更新的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！