查询近2分钟的记录:
SELECT * FROM `aaa`.`bbb` where key= 'xx' and UNIX_TIMESTAMP(NOW())-UNIX_TIMESTAMP(collect_time)<=120;
参考:http://hi.baidu.com/%D4%C2%C1%C1%BA%FE%CB%AE/blog/item/ee3655087965fada62d9868f.html
查询近2分钟的记录:
SELECT * FROM `aaa`.`bbb` where key= 'xx' and UNIX_TIMESTAMP(NOW())-UNIX_TIMESTAMP(collect_time)<=120;
参考:http://hi.baidu.com/%D4%C2%C1%C1%BA%FE%CB%AE/blog/item/ee3655087965fada62d9868f.html