You can‘t specify target table for update in FROM clause

ORACLE和MYSQL存在不同的语法，导致了这个问题
原SQL

UPDATE t_user_asset SET f_cashAmount =   

    (  

     SELECT (ua.f_cashAmount+50000) cashAmount FROM t_user_asset ua WHERE ua.f_userId = 290  

  )  

WHERE f_userId = 290  

修改后的SQL，适合mysql的

UPDATE t_user_asset SET f_cashAmount =   

(  

  SELECT ub.cashAmount FROM  

        (  

             SELECT (ua.f_cashAmount+50000) cashAmount FROM t_user_asset ua WHERE ua.f_userId = 290  

        ) ub  

)  

WHERE f_userId = 290