UPDATE ey_archives
SET add_time = UNIX_TIMESTAMP('2024-10-11 10:00:01') + (aid - 4189) * 86400
WHERE aid BETWEEN 4189 AND 4195;

任务：
 
2024-10-07 10:00:01       07
2024-10-07 10:00:58       07

2024-10-07 10:01:01       07
2024-10-07 10:01:58       07

2024-10-08 10:00:01       14
2024-10-08 10:00:58       14

UPDATE ey_archives
SET add_time = UNIX_TIMESTAMP('2024-11-12 10:00:01') + (aid - 4391) * 60
WHERE aid BETWEEN 4391 AND 4395;

任务：

2024-10-11 10:00:01到10:04:01 共5篇