MySQL获取上个月每一天的数据统计

SQL查询上个月每一天的数量。

SELECT date_format(create_time, '%Y-%m-%d') as create_time, count(*) as count FROM table WHERE
date_format(create_time, '%Y%m') = date_format(DATE_SUB(curdate(), INTERVAL 1 MONTH),'%Y%m')
and cond = '123456'
GROUP BY create_time