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;