mysql中使用update select

weixin_34292287

于 2015-07-30 09:37:00 发布

阅读量61

点赞数

CC 4.0 BY-SA版权

文章标签：数据库

原文链接：http://www.cnblogs.com/adtuu/p/4688236.html

本文介绍了通过数据库更新语句批量更新用户行为统计数据，包括分享总数、点赞总数和摇动次数，涉及INNER JOIN操作和子查询，提高了数据更新效率。

UPDATE

t_user

INNER JOIN

t_shake ON t_shake.user_id = t_user.user_id

SET

t_user.shake_total_num = t_shake.shake_total_num;


UPDATE t_user INNER JOIN

(

select user_id,count(id) as share_total_num

from `t_share_history`

group by user_id

) tmp

ON tmp.user_id = t_user.user_id

SET t_user.share_total_num = tmp.share_total_num;


UPDATE t_user INNER JOIN

(

select user_id,sum(like_num) as like_total_num

from `t_user_like`

group by user_id

) tmp

ON tmp.user_id = t_user.user_id

SET t_user.like_total_num = tmp.like_total_num;

转载于:https://www.cnblogs.com/adtuu/p/4688236.html