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

我覺得是因為：你update後面跟的是個結果集，並不是真實的表，所以沒辦法進行更新操作。