select year(application_date) as years, count(1) from patent group by year(application_date) order by years-- year(application_date) 获取年份-- month(application_date) 获取月份-- day(application_date) 获取日
使用 date_format(application_date, '%y')，可自定义日期格式
select date_format(application_date, "%y") as year, count(1) from patent group by date_format(application_date, "%y")
推荐：《mysql教程》
以上就是mysql怎么根据date做年，月，日分组统计查询的详细内容。