使用Unix时间戳在一个月内进行SQL计数记录

格式化时间戳，然后将其分组。

按月分组：

SELECt DATE_FORMAT(t.timestamp, "%Y-%m") AS "_Month", COUNT(*)FROM yourtable as tGROUP BY _Month;

按年份分组：

SELECt DATE_FORMAT(t.timestamp, "%Y") AS "_Year", COUNT(*)FROM yourtable as tGROUP BY _Year;

如果timestamp-field以unixtime-
value的形式存储，请

FROM_UNIXTIME()

SELECt DATE_FORMAT(FROM_UNIXTIME(t.timestamp), "%Y") AS "_Year", COUNT(*)FROM yourtable as tGROUP BY _Year;