Mysql按照固定时间间隔统计数据
SELECT
CODE,TM,SUM(DRP)
FROM
xxTable
WHERE
CODE= '409K0044' and `TM` >= '2023-01-01 08:00:00'
AND MOD ( unix_timestamp( `TM` ) - unix_timestamp( '2023-01-01 08:00:00' ), 24 * 60 * 60 ) BETWEEN 0 AND 1
GROUP BY CODE,TM
DRP是需要统计累计的数据字段，TM是日期字段