In MySQL you can add an event to a database that runs in a interval to automate database tasks. You can wait for intervals and check the table to see the changes.
By default, the event scheduler thread is not enabled in the database. You need to enable this:
SET GLOBAL event_scheduler = ON;
Or you can off this by:
SET GLOBAL event_scheduler = OFF;
You can see by below command whether event scheduler thread is running or not:
SHOW PROCESSLIST;
CREATE EVENT evt_newsletter
ON SCHEDULE EVERY 2 MINUTE
DO
INSERT INTO newsletter(message,post_date)
VALUES('Newsletter added',NOW()); Changing schedule:
ALTER EVENT evt_newsletter ON SCHEDULE EVERY 5 MINUTE;
You can change the body also
ALTER EVENT evt_newsletter
DO
INSERT INTO newsletter(message,post_date)
VALUES('Newsletter changed',NOW()); Disable event:
ALTER EVENT evt_newsletter DISABLE;
Enable event:
ALTER EVENT evt_newsletter ENABLE;
Rename event:
ALTER EVENT evt_newsletter RENAME TO evt_newsletter_new;
Drop MySQL event:
DROP EVENT [IF EXIST] evt_newsletter;
In life, finances are inevitable. And more often than not, they can be overwhelming. Having…
The management of a property isn't solely the process of collecting rental. It also involves…
Development and progression are not only essential but often one of the main goals of…
People usually stumble onto the 461 visa when they realise there’s no simple way to…
When you run a brick-and-mortar retail store, you encounter an array of customer personalities. From…
In today’s digital era, people look for convenience, transparency, and genuine rewards from their financial…