MySQL Events Scheduler

What is the Event Scheduler?

Example

SET GLOBAL event_scheduler = ON;

CREATE EVENT daily_cleanup
ON SCHEDULE EVERY 1 DAY
DO
  DELETE FROM logs WHERE created < NOW() - INTERVAL 30 DAY;

Summary

• Events run SQL on a schedule (EVERY 1 DAY, etc.).
• Turn on the scheduler first; good for cleanup and periodic tasks.

Event Scheduler क्या है?

Example

SET GLOBAL event_scheduler = ON;

CREATE EVENT daily_cleanup
ON SCHEDULE EVERY 1 DAY
DO
  DELETE FROM logs WHERE created < NOW() - INTERVAL 30 DAY;

सारांश

• Events SQL को schedule पर चलाते हैं (EVERY 1 DAY, आदि)।
• पहले scheduler ON करें; cleanup और periodic tasks के लिए अच्छा।