怎么让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  

登录后复制

登录后复制

谢谢