mysql批量更新数据

有时候我们需要批量去更新数据库中的数据，一个很简单的例子

update db_user.user_dongtai as a

set 
a.user_learning_project = (select count(*) from db_project.user_project where stats = 1 and userid = a.userid),
a.user_learning_news = (select count(*) from db_news.user_news where stats = 1 and userid = a.userid)