select Day(date);是获取日期; select Month(date); 是获取月份; select Year(date); 是获取年份; select Day(date) day,count(question_id) question_cnt from question_practice_detail where month(date) = "08" and year(date) = "2021" group by day;