MYSQL：在表中创建具有到期日期的行

您的需求看起来更像是一个事件IF，您不想添加到期日期列，而不是

CREATE EVENT delete_event ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 1 DAY
ON COMPLETION PRESERVE
DO BEGIN
      DELETE FROM Your_table  WHERE date>= logic for expiration_date   ;
END;

除此以外

DELIMITER $$
CREATE EVENT Delete ON SCHEDULE EVERY 1 DAY
DO
BEGIN
  DELETE   FROM TABLE  WHERE `date_expires` < CURRENT_TIMESTAMP();
END$$
DELIMITER 

;

注意，需要在您的服务器上启用MySQL Event Scheduler：

SET GLOBAL event_scheduler = ON;