Mysql仅使用一个表为每个奖杯合计条目

我现在没有办法尝试,但我相信你只需要 group by 奖杯和 count 寄存器,类似于:

SELECT trophy, registration, count(*) FROM your_table
GROUP BY registration, trophy

• count(*)
• 分组依据 表示“并按此列将其分组”

这里有一些参考资料:

https://dev.mysql.com/doc/refman/5.7/en/counting-rows.html

https://dev.mysql.com/doc/refman/5.7/en/group-by-functions.html

SELECT registration, trophy, count(*) as votes FROM your_table
GROUP BY registration, trophy

所以count(*)列将被称为更漂亮的投票

由于您希望对每个注册和奖杯配对进行单独计数,请在中同时使用这两列 GROUP BY

SELECT registration, trophy, COUNT(*) AS votes
FROM yourTable
GROUP BY registration, trophy
ORDER BY trophy, registration

SELECT registration, COUNT(trophy) FROM table_name GROUP BY registration, trophy;

你需要根据奖杯和注册进行分组。

SELECT count(*) as TotalVotes, trophy, registration FROM your_table 
GROUP BY trophy, registration

    TotalVotes | trophy | registration
         2     |    1   | hk57 hxz
         1     |    1   | sj2 ghd
         1     |    2   | sj2 ghd
         1     |    2   | hk57 hxz