SELECT DATE_FORMAT(departure_time,'%Y-%m-%d') as demand_time ,
count(0) as count FROM haikou_1
where left(`geo`,6)='w7w3y2'
AND DATE_FORMAT(departure_time,'%Y-%m-%d') BETWEEN '2017-06-01' AND '2017-08-31'
GROUP BY demand_time
ORDER BY demand_time
mysql每日汇总
最新推荐文章于 2022-05-06 11:14:17 发布