日
SELECT DATE_FORMAT(create_date,'%Y-%m-%d') AS times , COUNT(*) AS COUNT FROM 表名 b
WHERE b.`create_date` <= "2019-02-09 00:00:00" AND b.`create_date` >= "2019-02-07 00:00:00"
GROUP BY times
月
SELECT DATE_FORMAT(create_date,'%Y-%m') AS times , COUNT(*) AS COUNT FROM 表名 b
WHERE b.`create_date` <= "2019-02-09 00:00:00" AND b.`create_date` >= "2019-02-07 00:00:00"
GROUP BY times
年
SELECT DATE_FORMAT(create_date,'%Y') AS times , COUNT(*) AS COUNT FROM 表名 b
WHERE b.`create_date` <= "2019-02-09 00:00:00" AND b.`create_date` >= "2019-02-07 00:00:00"
GROUP BY times