如题.
mysql> select PlanStartTime, count(*) from testoutfitempolder order by PlanStart
Time;
这样写的话是按日来统计的,统计各月的数据数量要怎么做呢?
mysql> select PlanStartTime, count(*) from testoutfitempolder order by PlanStart
Time;
这样写的话是按日来统计的,统计各月的数据数量要怎么做呢?
group by DATE_FORMAT(PlanStartTime,'%Y-%m')
order by PlanStart
from testoutfitempolder
group by date_format(PlanStartTime,'%Y-%m')
order by 1