update h5perf_task set run_state = 0 where id in
(SELECT t.id from (SELECT * FROM h5perf_task WHERE run_state = 2
and UNIX_TIMESTAMP( now() )-UNIX_TIMESTAMP(begin_run_time) > 420) t);
MySQL 计算两个日期之间相差的秒数 SQL
最新推荐文章于 2025-06-20 15:16:10 发布