MySQL查询这个月的每一天数量
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(CURDATE(),'%Y%m')
and cond = '123456'
GROUP BY create_time
MySQL查询这个月的每一天数量
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(CURDATE(),'%Y%m')
and cond = '123456'
GROUP BY create_time