What is a "MySQL event"? What is its purpose? How is it different from a "job scheduler"?
Many posts on SO, and the MySQL documentation, describe how to implement MySQL events, but I am just interested in their purpose.
MySQL events offer an alternative to scheduled tasks
and cron jobs
.
Events can be used to create backups, delete stale records, aggregate data for reports, and so on. Unlike standard triggers which execute given a certain condition, an event is an object that is triggered by the passage of time and is sometimes referred to as a temporal trigger.
Refer below link explained everything here :