MySQL events were added in MySQL 5.1.6 and 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 .

Read this article:
PHPMaster: Working with MySQL Events

Tags: Mobile Tutorials & Articles
Martin E. Psinas is a self-taught web developer, published author, and is currently studying Japanese. For more information, visit his website.

No Reader comments

Special Offer
Free course!

Git into it! Bonus course Introduction to Git is yours when you take up a free 14 day SitePoint Premium trial.