select FROM_UNIXTIME(reg_time,'%Y-%m-%d')as date,COUNT(*)
FROM wd_member
where phone != '' and reg_time != ''
GROUP BY FROM_UNIXTIME(reg_time,'%Y-%m-%d');
mysql 通过时间戳查询每天的数据量
最新推荐文章于 2024-05-22 10:13:27 发布
select FROM_UNIXTIME(reg_time,'%Y-%m-%d')as date,COUNT(*)
FROM wd_member
where phone != '' and reg_time != ''
GROUP BY FROM_UNIXTIME(reg_time,'%Y-%m-%d');