mysql按照天、月份、年份统计查询

按月份查询

SELECT *  FROM tbl_order GROUP BY DATE_FORMAT(CreateTime,"%Y-%m");

SELECT sum(money), DATE_FORMAT(CreateTime,"%Y-%m")  FROM tbl_order GROUP BY DATE_FORMAT(CreateTime,"%Y-%m"); 

按天查询

SELECT *  FROM tbl_bill GROUP BY DATE_FORMAT(CreateTime,"%Y-%m-%d");
SELECT sum(Income), DATE_FORMAT(CreateTime,"%Y-%m-%d")  FROM tbl_bill GROUP BY DATE_FORMAT(CreateTime,"%Y-%m-%d");