Question

我有一个时间段栏,对插入/更新进行自动更新。

我想得到过去10分钟内更新的浏览量。

SELECT
     *
FROM
     status
WHERE
     code= myCode 
AND
      stamp_updated  
     BETWEEN
     NOW()
     AND
     DATE_ADD(NOW() , INTERVAL - 10 MINUTE)
ORDER BY 
     stamp_updated DESC
LIMIT 1

Answer 1

使用:

  SELECT *
    FROM status
   WHERE code =  myCode 
     AND `stamp_updated` BETWEEN DATE_SUB(NOW() , INTERVAL 10 MINUTE)
                           AND NOW()
ORDER BY stamp_updated DESC
   LIMIT 1

BETWEEN运营商的命令事项——如果出现倒退。

Answer 2

 ...  stamp_updated  BETWEEN NOW() - INTERVAL 10 MINUTE AND NOW()  ...

Answer 3

不清楚为什么你重新使用建筑。我的SQL可以在日期使用合乎逻辑的操作者,而且通常会大大加快。我将这样做:

select * 
  from status 
  where code= myCode  
        and stamp_updated >= DATE_SUB(NOW(), INTERVAL 10 MINUTE) 
  order by stamp_updated desc 
  limit 1;

友情链接