SELECT
DATE_FORMAT(create_time, '%y年%m月%d日') day,
count(*) num
FROM
z_customer
WHERE
create_time
GROUP BY
day desc
LIMIT 0 , 7
mysql 查找近一周的数据量
于 2020-07-13 01:08:26 首次发布
SELECT
DATE_FORMAT(create_time, '%y年%m月%d日') day,
count(*) num
FROM
z_customer
WHERE
create_time
GROUP BY
day desc
LIMIT 0 , 7