mysqldatabasecronjob-schedulingmysql-event

What is a "MySQL event"?


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.


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/