我想知道mysql(或mariadb)是否提供了一个过期函数,可以在db中自动删除一行,而无需使用任何额外的调度程序或类似sql的程序 DELETE .这应该在创建表时发生或定义,以便 INSERT 它开始管理它。这里有很多相关的问题:mysql如何使值过期?指定时间后删除mysql行mysql给行一个生命周期然而,我找不到答案。我对使用 WHERE 也不是 DELETE .有可能吗?
DELETE
INSERT
WHERE
w8rqjzmb1#
是的,同样的,你可以用这种方法创建一个事件 CREATE EVENT lifetime ON SCHEDULE EVERY 1 DAY STARTS '14:05:44' ENDS '14:05:46' ON COMPLETION NOT PRESERVE ENABLE DO BEGIN // put your delete query here with where clause by calculate your exp date END
CREATE EVENT lifetime ON SCHEDULE EVERY 1 DAY STARTS '14:05:44' ENDS '14:05:46' ON COMPLETION NOT PRESERVE ENABLE DO BEGIN // put your delete query here with where clause by calculate your exp date END
1条答案
按热度按时间w8rqjzmb1#
是的,同样的,你可以用这种方法创建一个事件
CREATE EVENT lifetime ON SCHEDULE EVERY 1 DAY STARTS '14:05:44' ENDS '14:05:46' ON COMPLETION NOT PRESERVE ENABLE DO BEGIN // put your delete query here with where clause by calculate your exp date END