SELECT SUM(统计列),DATE_FORMAT(时间列,'%Y-%m-%d') FROM 表 WHERE
DATE_FORMAT(时间列,'%Y-%m-%d') >= '2014-10-14' AND DATE_FORMAT(时间列,'%Y-%m-%d') <= '2014-10-21'
GROUP BY DATE_FORMAT(时间列,'%Y-%m-%d')
转载于:https://my.oschina.net/u/3369787/blog/1585815
SELECT SUM(统计列),DATE_FORMAT(时间列,'%Y-%m-%d') FROM 表 WHERE
DATE_FORMAT(时间列,'%Y-%m-%d') >= '2014-10-14' AND DATE_FORMAT(时间列,'%Y-%m-%d') <= '2014-10-21'
GROUP BY DATE_FORMAT(时间列,'%Y-%m-%d')
转载于:https://my.oschina.net/u/3369787/blog/1585815