mysql根据查询条件更新

// 根据author_account的uid更新手机号码到user_base表

update user_base u,(select uid,number from author_account) a set u.number= a.number where a.uid= u.uid;


//更新根据id排序后的序列号

update article_edit_chapter a,(select (@i:=@i+1) i,id from article_edit_chapter where artId=1 order by id) i,(select @i :=0) ir set a.index= i.i where a.id= i.id and artId=1


//group 更新

update article a,(select artId artId,SUM(words) words,SUM(`count`) `count`,SUM(praiseNum) praiseNum,SUM(commentNum) commentNum,SUM(shareNum) shareNum
from article_chapter group by artId) c set a.words= c.words,a.`count`=c.count,a.`praiseNum`=c.praiseNum,a.`commentNum`=c.commentNum,a.`shareNum`=c.shareNum 
where a.id= c.artId;

阅读更多
版权声明:本文为博主原创文章,未经博主允许不得转载。 https://blog.csdn.net/oZhiMing12/article/details/76021051
想对作者说点什么? 我来说一句

没有更多推荐了,返回首页

关闭
关闭
关闭