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;
For any types of queries, you can contact us on info[at]namasteui.com.
Hormonal balance plays a pivotal role in overall well-being, influencing various aspects of health, from…
Dog walking is an excellent way to maintain your furry friend's camaraderie and provides many…
Introduction Businesses understand the diverse requirements of mobile applications, which provide a competitive advantage. There…
The Internet of Things (IoT) has recently changed the world. It links gadgets together and…
NFTs, or Non-Fungible Tokens, are revolutionizing the digital economy. These unique digital assets, authenticated through…
It is safe to say that if you are in need of a good laptop…