UPDATE的目标表不可更新 [英] The target table of the UPDATE is not updatable

问题描述

我需要运行此查询:

UPDATE TempRH T 
    JOIN (
           SELECT offices_id,MAX(Poids)AS Poids
           FROM TempRH  
           GROUP BY 
                  offices_id
          )T1
    ON T1.offices_id=T.offices_id
    SET T1.Poids=0

但是在执行时会出现错误:

but on execution it gives an error:

#1288-The target table T1 of the UPDATE is not updatable.

有解决方案吗?

推荐答案

在我看来，进行一些小的更改即可解决此问题?

Seems to me a small change would fix this?

UPDATE TempRH T 
    JOIN (
           SELECT offices_id,MAX(Poids)AS Poids
           FROM TempRH  
           GROUP BY 
                  offices_id
          )T1
    ON T1.offices_id=T.offices_id
    SET T.Poids=0 

将T1.Poids更改为T.Poids.因此，您SET要在TABLE上的值UPDATE

Change T1.Poids to T.Poids. So you SET a value on the TABLE you want to UPDATE

这篇关于UPDATE的目标表不可更新的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！