mysql按周/月/年统计数据

mysql 按周/月/年统计数据分别如下

select DATE_FORMAT(UPDATE_TIME,'%Y%u') weeks,count(UPDATE_TIME) count from table_name group by weeks; select DATE_FORMAT(UPDATE