Chapter 34. Events
34.1 What Is an Event?
The MySQL database server never executes actions on the database by itself or executes a SELECT or UPDATE statement suddenly. Applications ask MySQL to execute an SQL statement or to start a stored procedure. Triggers are also started indirectly by an application; MySQL does not start the trigger on its own.
When using events, MySQL appears to directly access the database without the request of an application. Events are procedural database objects that MySQL invokes at the appropriate time. An event can be invoked only once—for example, on January 6, 2010, at 2 p.m. An event can also be started periodically—for example, every Sunday at 4 a.m. When events are scheduled, MySQL keeps a schedule that tells ...
Get SQL for MySQL Developers: A Comprehensive Tutorial and Reference now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
