Menu
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?
499
Assuming you have MySQL rights to create events, the basic syntax is: CREATE EVENT `event_name` ON SCHEDULE schedule [ON COMPLETION [NOT] PRESERVE] [ENABLE | DISABLE | DISABLE ON SLAVE] DO BEGIN -- event body END; The schedule can be assigned various settings, e.g.
The MySQL Event Scheduler manages the scheduling and execution of events, that is, tasks that run according to a schedule.
trigger are fired on data change. and events are fired on behalf of minutes,hour,days,date. Let me try to explain you with example, you are creating a 50% off offer on a product And you have to expire this offer after 50 Minutes or sunday at 1pm. In this case event scheduler is used.
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.
61
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
