mysql - SQL语句报错

Question

UPDATE (SELECT  money,tb.userInfoId,yh.regTime,hy.vipStatus,hy.expirationTime,hy.grade
                    FROM (SELECT SUM(money) money,userInfoId  
                                FROM orderlist 
                                WHERE status = 2
                                GROUP BY userInfoId) tb
                    LEFT JOIN (SELECT userInfoId,grade,vipStatus,expirationTime
                                         FROM member) hy ON tb.userInfoId = hy.userInfoId
                    LEFT JOIN (SELECT regTime,userInfoId FROM userinfo) yh ON tb.userInfoId = yh.userInfoId
    WHERE money>=1000 AND hy.grade = 0) a1 SET a1.vipStatus = 1 

[Err] 1288 - The target table a1 of the UPDATE is not updatable

写得有点烂....

Answer 1

I think it’s because: what follows your update is a result set, not a real table, so the update operation cannot be performed.