56,679
社区成员
发帖
与我相关
我的任务
分享
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'