mysql - 如何进行延迟的 DELETE SQL 查询？

Question

我需要在进行 DELETE 查询后 14 天从表中删除行。是否可以使用 MySQL 执行此操作？

Answer 1

您可以使用内置的 MySQL Event Scheduler安排查询或存储例程运行 at an arbitrary point in time :

This is an example of a minimal CREATE EVENT statement:

CREATE EVENT myevent
    ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 1 HOUR
    DO
      UPDATE myschema.mytable SET mycol = mycol + 1;

请注意，the Event Scheduler is disabled by default .