mysql - 如何在 5 天后自动更新状态？

Question

我的数据库表中有发送日期和状态列。帖子的当前状态是 = 已发送/已接收。我只想更改状态 = 5 天后自动中止。

我尝试过的:

CREATE EVENT reset ON SCHEDULE EVERY 1 day DO
    update barter_proposals 
       set proposal_status="Aborted"
     WHERE `sent_date`>=DATE_ADD( CURDATE(), INTERVAL 1 day )
       AND proposal_status = "Sent/Received"---------Not worked



CREATE EVENT rot ON SCHEDULE EVERY 1 day DO 
    update barter_proposals 
       set proposal_status="Aborted"
     WHERE DATE_ADD(sent_date, INTERVAL 1 day )>=NOW()
       AND proposal_status = "Sent/Received"---------Not worked



CREATE EVENT rot ON SCHEDULE EVERY 1 day DO 
    update barter_proposals 
       set proposal_status="Aborted"
     WHERE sent_date=CURDATE()
       AND proposal_status = "Sent/Received"-----------Not Worked

如何在 5 天后自动更新状态？ sent_date 可以是任何内容。

如果 sent_date 是 26/03/2018，那么在 01/04/2018，状态应该自动更新为 Aborted。我怎样才能写出逻辑？

Answer 1

试试 CURDATE()-5

CREATE EVENT rot ON SCHEDULE EVERY 1 day DO 
    update barter_proposals 
       set proposal_status="Aborted"
     WHERE sent_date=DATE(CURDATE()-5)
       AND proposal_status = "Sent/Received"