按照日期 SELECTcount(
distinct userNum)
as newcount,
date(from_unixtime(addtime))
astimeFROM`userlist`groupbydate(from_unixtime(addtime))
按照月份
SELECT from_unixtime(addtime,"%Y-%m") as time,count(distinct uid) as newcount FROM `userlist` group by from_unixtime(addtime,"%Y-%m");
结果: