$minutes = 60 * 2
SELECT COUNT(id) AS TOTAL,job_id
from tlb_stats
WHERE log_time >= DATE_SUB(CURRENT_DATE,INTERVAL $minutes MINUTE)
GROUP BY job_id
它只选择最近的记录并跳过旧记录.当我更改log_time< =它只选择旧的并跳过新的. 我究竟做错了什么？
最佳答案
$minutes = 60 * 2
SELECT COUNT(id) AS TOTAL,job_id
from tlb_stats
WHERE log_time >= DATE_SUB(CURRENT_DATE,INTERVAL $minutes MINUTE)
GROUP BY job_id
它只选择最近的记录并跳过旧记录.当我更改log_time< =它只选择旧的并跳过新的. 我究竟做错了什么？