[SQL] update TS_Articles set BrowseTimes= ( SELECT BrowseTimes from TS_Articles where ArticleID='8' )+1 where TS_Articles.ArticleID='8' [Err] 1093 - You can't specify target table 'TS_Articles' for update in FROM clause
mqsql 不支持 多个select 嵌套使用 可以在外面 加一层 select (select * from * where a=b)from ** as temp
不过这里我没这样写 而是下面那样 然后就没报错了
update TS_Articles set BrowseTimes= BrowseTimes +1 where TS_Articles.ArticleID='8'