SELECT
COUNT(1) AS countNumber,
DATE_FORMAT(update_time,’%Y-%m-%d’) AS dateTime
FROM
数据库名
GROUP BY DATE_FORMAT(update_time,’%Y-%m-%d’)
mysql查 每一个月中的每一天的数据
最新推荐文章于 2024-07-21 03:14:00 发布
SELECT
COUNT(1) AS countNumber,
DATE_FORMAT(update_time,’%Y-%m-%d’) AS dateTime
FROM
数据库名
GROUP BY DATE_FORMAT(update_time,’%Y-%m-%d’)