mysql 按年、月、周、日分组查询1.按照年份分组查询SELECT DATE_FORMAT(t.bill_time,'%Y') month_time,sum(t.pay_price) total FROM f_bil