Question

mysql如何查询某个会员7天内每天产生的数据？

表结构如图，我想通过sql查到custid=2的客户在最近7天内每天有多少数据

Answer 1

SELECT * FROM TABLE_NAME WHERE CUSTID = 2 AND CREATE_TIME BETWEEN '2019-11-25' AND '2019-12-01'

追问

不好意思，可能是我描述的有些模糊，我想要的是custid为2的客户在最近7天内每天属于他的数据有多少条

追答

SELECT COUNT(*),A.CREATE_TIME FROM (SELECT * FROM TABLE_NAME WHERE CUSTID = 2 AND CREATE_TIME BETWEEN '2019-11-25' AND '2019-12-01') A GROUP BY A.CREATE_TIME