SELECT
from_unixtime(ctime, ‘%Y-%m’) AS mon,
COUNT(user_id)
FROM
user
WHERE
ctime > UNIX_TIMESTAMP(‘2019-1-01 00:00:00’)
GROUP BY
mon
ORDER BY
mon
【MYSQL 按月统计】
最新推荐文章于 2024-08-02 04:12:59 发布
SELECT
from_unixtime(ctime, ‘%Y-%m’) AS mon,
COUNT(user_id)
FROM
user
WHERE
ctime > UNIX_TIMESTAMP(‘2019-1-01 00:00:00’)
GROUP BY
mon
ORDER BY
mon