//批量更新用户mous余额
“UPDATE mous_user SET mous_balance=(
SELECT sum_amount FROM
(SELECT
P.user_id,
SUM(P.profit_amount) + U.mous_balance as sum_amount
FROM
mous_profit_invest_log as P LEFT JOIN mous_user as U ON U.id=P.user_id
WHERE profit_date = ‘2019-07-08 23:59:59’
GROUP BY
user_id) sum_am WHERE id=user_id)”
批量更新用户mous余额
最新推荐文章于 2019-07-25 19:38:01 发布