怎么让mysql每天自动删除和增加一定的记录
程序员文章站
2022-05-22 19:26:06
...
怎么让mysql在某个表里每天自动删除和增加一定的记录
回复讨论(解决方案)
每天凌晨三点执行
create event event_call_defer on schedule every 1 day starts date_add(date(curdate() + 1),interval 3 hour) on completion preserve enable do begin delete from tbl_name limit 10 end
每天凌晨三点执行
create event event_call_defer on schedule every 1 day starts date_add(date(curdate() + 1),interval 3 hour) on completion preserve enable do begin delete from tbl_name limit 10 end谢谢
上一篇: 这种PHP代码是哪种加密方式?