mysql - 如何从MySQL表中的两个不同列中获取总和

我在一个名为“match_scores”的表中有以下列：

player_1, player_2, player_1_points, player_2_points
tom, mike, 110, 40
tom, joe, 115, 30
mike, tom, 120, 30

我希望结果是：

tom has 255 points
mike has 160 points
joe has 30 points

最佳答案

您可以“取消激活”数据，然后重新聚合。在SQL中，这看起来像：

select player, sum(points) as points
from ((select player_1 as player, player_1_points as points from match_scores ms1) union all
      (select player_2 as player, player_2_points as points from match_scores ms2)
     ) t
group by player;

这将数据作为带有两列的结果集返回。您可以在SQL中转换为字符串，但我真的建议您在应用程序层这样做。

关于mysql - 如何从MySQL表中的两个不同列中获取总和，我们在Stack Overflow上找到一个类似的问题：https://stackoverflow.com/questions/42905107/