Mysql 按年、季度、月分组

按月度分组：

select DATE_FORMAT(i.created_at, '%Y-%m月')...................GROUP BY DATE_FORMAT(i.created_at, '%Y-%m')

 

按季度分组：

select CONCAT(YEAR(i.created_at),'_',QUARTER(i.created_at),'Q')....................GROUP BY CONCAT(YEAR(i.created_at),'_',QUARTER(i.created_at),'Q')

 

 

按年度分组：

select DATE_FORMAT(i.created_at, '%Y')..............................GROUP BY DATE_FORMAT(i.created_at, '%Y')