MySQL计数和总数

要获取所需内容,可以使用Group By和Count:

SELECT vote, COUNT(*) AS cnt
FROM votes
GROUP BY vote

结果:

vote  cnt
1     2  
2     6  
3     2  
4     1  
5     1  

计数为零的投票将不在此结果集中表示。如果您希望将这些包含在计数为零的情况下,那么您将需要使用一个外部联接和一个列出所有可能投票的表。

SELECT
    possible_votes.vote,
    COUNT(votes.vote) AS cnt
FROM possible_votes
LEFT JOIN votes ON possible_votes.vote = votes.vote
GROUP BY possible_votes.vote

结果:

vote  cnt
1     2  
2     6  
3     2  
4     1  
5     1  
6     0

select vote, count(votes) as vt
from t_your_table
group by vote

查看mysql手册中的group by combined with count。

SELECT vote, COUNT(*) as total
FROM votes
GROUP BY vote