zabbix trend数据补充

INSERT INTO trend (itemid, clock, num, value_min, value_avg, value_max)
SELECT
    itemid,
    UNIX_TIMESTAMP(DATE_FORMAT(FROM_UNIXTIME(clock), '%Y-%m-%d %H:00:00')) as clock22,
    COUNT(itemid) as num,
    MIN(value) as value_min,
    AVG(value) as value_avg,
    MAX(value) as value_max
FROM
    history
WHERE 
    itemid = xxxx and /*要所有item的 就取消这一行*/
    clock BETWEEN UNIX_TIMESTAMP('2023-10-12 00:00:00') AND UNIX_TIMESTAMP('2023-10-13 00:00:00')
GROUP BY
    itemid,
    clock22;