mysql 查询每天生成的用户数量 时间格式为YYYY-MM-DD hh:mm:ss 按天查询
数据格式如图
select from_unixtime(created_time / 1000, ‘%Y-%m-%d’) dat, count(*) coun
from user_r
group by from_unixtime(created_time / 1000, ‘%Y-%m-%d’)
select date_format(created_time, ‘%Y-%m-%d’) date, count(*) count
from user_r
group by date_format(created_time, ‘%Y-%m-%d’) ORDER BY date ASC
查询结果如图