MySQL按每天分组查询

SELECT
	DATE_FORMAT( date, '%m-%d' ) time 
FROM
	t_time_dimension 
WHERE
	y = YEAR (curdate()) 
	AND date BETWEEN DATE_FORMAT( CURDATE( ), '%Y-%m-01 00:00:00' ) 
	AND DATE_FORMAT( DATE_SUB( CURDATE(), INTERVAL 1 DAY ), '%Y-%m-%d 23:59:59' ) 
GROUP BY
	DATE_FORMAT(date,'%m-%d')

其中用到的表t_time_dimension 数据与结构在下方资源链接中（也可从文章最上方直接点击下载）：
https://download.csdn.net/download/qq_42567801/12068874