Mysql按时间间隔选择时间戳

Question

我有一张这样的 table

CREATE TABLE `TPS_INFO` (
    `TPS` INT(10) NULL DEFAULT NULL,
    `AT_TIME` TIMESTAMP NOT NULL 
              DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
)

我想选择 TPS 值和时间戳，以便在 1 分钟的差异中选择时间戳。

我如何在 mysql 中执行此操作..

Answer 1

select *,TIMESTAMPDIFF(SECOND,t1.AT_TIME,t2.AT_TIME) AS diff from tps_info t1 , tps_info  t2 having diff='60'