使用php或codeigniter函数打开/关闭MySQL事件

Question

I have created a MySQL event that executes once a month to archive some tables in my database for my web app.

The problem is that I need a PHP function to manually turn that event on or off, I'm also using Codeigniter for my framework, so if it can be done using Codeigniter's functions, it would be much better.

Answer 1

Create a 1 bit attribute in database 1 => ON and 0 => OFF. Then in the condition say if flag is equal to 1 AND time to update, then update.