遇到统计照片每分钟上传照片数量
SELECT DATE_FORMAT(shooting_time, ‘%Y-%m-%d %H:%i:00’) AS time, COUNT(*) AS num
FROM photos
GROUP BY time
ORDER BY time;
shooting_time是 photos表中的记录的上传时间,
统计每分钟内上传的照片数量,如果没有上传,这里就不显示这个分钟
遇到统计照片每分钟上传照片数量
SELECT DATE_FORMAT(shooting_time, ‘%Y-%m-%d %H:%i:00’) AS time, COUNT(*) AS num
FROM photos
GROUP BY time
ORDER BY time;
shooting_time是 photos表中的记录的上传时间,
统计每分钟内上传的照片数量,如果没有上传,这里就不显示这个分钟