MySQL update select组合

update t_news inner join (select readCount from t_news t2 where t2.id=1) t1 set t_news.readCount = t1.readCount+1 where t_news.id=1;

posted @ 2018-07-28 12:06  西北逍遥  阅读(1231)  评论(0编辑  收藏  举报