我试图从一个表(user_tranz)中获取值的汇总,并希望将其存储在基于(基于(用户)的另一个表(用户)中(用户)(用户)用户的ID拥有这两个MySQL表结构:
1-用户:
id coin buy added free pay_later renewed pro
=========== ==== ===== ====== ==== =========== ========== ===
1 0 0 0 0 0 0 0
2 0 0 0 0 0 0 0
3 0 0 0 0 0 0 0
2- USER_TRANZ:
id (AI) user_id coin buy added free pay_later renewed pro
========== =========== ==== ===== ====== ==== =========== ========== ===
99 1 10 5 10 10 20 50 100
98 2 5 5 10 10 20 50 10
97 3 5 5 10 10 20 50 25
96 3 0 0 10 10 20 50 10
95 3 10 5 0 0 20 50 5
94 2 10 5 10 10 20 50 10
到目前为止,我知道这可以通过此类(左JON与cocecce())来完成/p>
预期结果:
Users:
id coin buy added free pay_later renewed pro
=========== ==== ===== ====== ==== =========== ========== ===
1 10 5 10 10 20 50 100
2 15 10 20 20 40 100 20
3 15 10 20 20 60 150 40
怎么样:
UPDATE users u
SET u.coin = (
SELECT SUM(ut.coin)
FROM user_tranz ut
WHERE ut.user_id = u.id
), ...
您可以使用子查询来确定在更新查询中插入的值。