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;
