Can I set a MySQL event schedule using phpMyAdmin?

mysql events phpmyadmin mysql-event
Lars picture Lars · Jul 8, 2011 · Viewed 53.7k times · Source

I want to increment a field on the first minute of every day, and then once it hits a certain value, set the value to 1. I would like to do this directly in MySQL, but preferably through phpMyAdmin.

I am aware of the Event Scheduler, and so I'm looking for a way to use and manage it through phpMyAdmin. Is this possible?

Answer

Mchl picture Mchl · Jul 8, 2011

It is.. Just issue appropriate CREATE EVENT SQL from SQL box.

However: your MySQL server needs to have event scheduler enabled AND have EVENT privileges for the database user.

Calling SELECT @@event_scheduler; will tell you if the scheduler is available and enabled.

To enable event scheduler if it's disabled try calling SET GLOBAL event_scheduler := 1; You need the SUPER privilege for this to succeed.

Related questions

MySQL Event Scheduler on a specific time everyday

Here's my query CREATE EVENT RESET ON SCHEDULE AT TIMESTAMP DO UPDATE `ndic`.`students` SET `status` = '0'; How can I update status to "0" at 1 pm every day. What can I use instead of TIMESTAMP?

Read More
How to set global event_scheduler=ON even if MySQL is restarted?

I want to set the event_scheduler global to ON even if MySQL is restarted; how can I achieve this? SET GLOBAL event_scheduler = ON;

Read More
How to check event scheduler status mysql

In MySQL, we can enable the event scheduler by following query: SET GLOBAL event_scheduler = ON; Similarly, to turn off the scheduler: SET GLOBAL event_scheduler = OFF; But, Is there any query/way to check the status of this event_…

Read More