⏰ MySQL Event Scheduler

? Quick Overview

The MySQL Event Scheduler allows you to run SQL statements automatically at scheduled times, similar to a cron job inside the database.

? Key Concepts

• Events run automatically without user interaction
• Scheduler must be enabled globally
• Events can run once or repeatedly
• Useful for cleanup, archiving, and automation

? Syntax / Theory

An event is created using CREATE EVENT and scheduled using AT or EVERY.

// Enable the global event scheduler
SET GLOBAL event_scheduler = ON;

? Code Example(s)

// One-time scheduled event
CREATE EVENT delete_old_logs
ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 1 DAY
DO
DELETE FROM logs WHERE created_at < NOW() - INTERVAL 30 DAY;

// Daily recurring scheduled event
CREATE EVENT daily_cleanup
ON SCHEDULE EVERY 1 DAY
STARTS CURRENT_TIMESTAMP
DO
DELETE FROM sessions WHERE last_active < NOW() - INTERVAL 7 DAY;

? Live Output / Explanation

? Interactive Simulator

This JavaScript demo simulates how MySQL event scheduling behaves.