mysql按日、月、周、季度分组_MySQL:按日分组：select DATE_FORMAT(o.OrderDate,'%Y%m%d') weeks,count(*) count from orders o group by weeks;按月分组：select DATE_FORMAT(o.OrderDate,'%Y%m') weeks,count(*) count from orders o