Home > Article > Backend Development > 怎么让mysql每天自动删除和增加一定的记录
怎么让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谢谢