MySQL 根据日期分组

分类: 文章 • 2023-12-11 23:17:40

SELECT DATE_FORMAT( detect_time, "%Y-%m-%d" ) AS time, COUNT(id) AS total FROM detect_video_task_result_real GROUP BY DATE_FORMAT( detect_time, "%Y-%m-%d" ) MySQL 根据日期分组