SELECT ... FOR UPDATE和MAX() [英] SELECT ... FOR UPDATE and MAX()

问题描述

此查询中的SELECT ... FOR UPDATE是否锁定该表中的行?

Do SELECT ... FOR UPDATE in this query lock rows in this table?

表位于InnoDB中，查询位于事务内部

Table is in InnoDB and query is inside transaction

select max(id) from table1 FOR UPDATE

我有这段代码，看来SELECT ... FOR UPDATE不能锁定行.

I have this code and it seems SELECT ... FOR UPDATE doesn't lock rows.

推荐答案

也许可行吗? :

select id from table where id IN (select max(id) from table1) FOR UPDATE

这篇关于SELECT ... FOR UPDATE和MAX()的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！