mysql更新多个字段

转自：https://www.cnblogs.com/zihunqingxin/p/6733783.html

update user u 
JOIN (select user_id as user_id,count(*) as article_num,sum(collect_num) as collect_num,sum(like_num) as like_num from article where user_id=1) t 
on u.id=t.user_id 
set u.article_num=t.article_num,u.collect_num=t.collect_num,u.like_num=t.like_num 
where u.id=1;