mysql数据库根据时间戳统计最近七天的数据

SELECT
    DATE_FORMAT( FROM_UNIXTIME( 时间戳字段), '%Y-%m-%d' ) AS date,
    id,
    xxx,
    xxx,
    count( xxx) AS total 
FROM
    表名
WHERE
    DATE_SUB( CURDATE( ), INTERVAL 6 DAY ) <= FROM_UNIXTIME( 时间戳字段) 
    AND xxx= 2144 
GROUP BY
    date;

 

  参考以下：

https://blog.csdn.net/asenseof/article/details/107918573

https://blog.csdn.net/weixin_60948956/article/details/125110297

http://net.sanhaostreet.com/it/202203/3114841.html