56,865
社区成员




select count(distinct phone) from user where date(DATE) = '2017-11-22'
#建立一个非聚集索引在user表的date列上
create UNIQUE index CL_dt_user on `USER`(date)
select count(distinct phone) from user where date between '2017-11-22 00:00:00' and '2017-11-22 23:59:59'