sql语句:
![](https://img-blog.csdnimg.cn/img_convert/ad742958b507d5e00233b16ced603ab6.png)
SELECT
days.days,
count( employee.create_time ) AS count
FROM
(
SELECT
DATE_FORMAT( @date := DATE_ADD( @date, INTERVAL - 1 DAY ), '%Y-%m-%d' ) days
FROM
( SELECT @date := DATE_ADD( NOW( ), INTERVAL 1 DAY ) FROM employee LIMIT 30 ) create_time
) AS days
LEFT JOIN employee ON TO_DAYS( employee.create_time ) = TO_DAYS( days.days )
GROUP BY
days.days
根据时间进行分组,查询30天内的数据