MySql 按日、按周、按月统计

按天

SELECT DATE_FORMAT(date,'%Y-%m-%d') as date_time,SUM(real_profit) as real_profit FROM t_w  GROUP BY date_time;

按周：自然周
SELECT DATE_FORMAT(date,'%Y-%u') as date_time,SUM(real_profit) as real_profit FROM t_w  GROUP BY date_time;

按月
SELECT DATE_FORMAT(date,'%Y-%m') as date_time,SUM(real_profit) as real_profit FROM t_w  GROUP BY date_time;