What is a "MySQL event"?

cron, database, job-scheduling, mysql, mysql-event

Solution

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 :

http://phpmaster.com/working-with-mysql-events/

Problem

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.

Original source

Related problems