mysql - 使用一些行值作为列 SQL

Question

我想要这样的列:

KILL, DEATH, WIN, playerName

这是应该应用的结果集

这是我用来获取结果集的查询:

SELECT SUM(amount) as amount, type.name as type, gamemode_statistics.Name as playerName 
FROM gamemode_statistics INNER JOIN type ON gamemode_statistics.type_id = type.id 
GROUP BY gamemode_statistics.type_id, playerName

我真的不知道该怎么做，我尝试了各种方法，但没有一个能解决我的问题。也许我只是错误地配置了我的表格？

Answer 1

如果这些是您想要显示为列的仅有的三个值，您可以这样做，这将为您提供类型计数

SELECT SUM(amount) as amount, 
SUM(`type`='KILL') AS `KILL`,
SUM(`type`='DEATH') AS `DEATH`,
SUM(`type`='WIN') AS `WIN`,
 gamemode_statistics.Name as playerName 
FROM gamemode_statistics 
INNER JOIN type ON gamemode_statistics.type_id = type.id 
GROUP BY gamemode_statistics.type_id, playerName