php - mysql 不同和计数

Question

我有这样的表:

+------+-------+
| user | data  |
+------+-------+
|  1   |   a   |
+------+-------+
|  1   |   b   |
+------+-------+
|  2   |   c   |
+------+-------+

我需要得到类似的东西:

Array
(
    [1] => 2
    [2] => 1
)

获取唯一用户并计算数据行中的实例，有什么想法吗？

我试过这个查询:

SELECT DISTINCT user from table ORDER BY ID DESC

Answer 1

你应该为此使用GROUP BY。

SELECT `User`, COUNT(data) TotalCount
FROM tableName
GROUP BY `User`
ORDER BY TotalCount DESC