The MySQL Event Scheduler manages the scheduling and execution of events, that is, tasks that run according to a schedule.

MySQL_events_cheatsheet.sql

/*
Original Idea: @josuebasurto
Reference: https://dev.mysql.com/doc/refman/5.7/en/event-scheduler.html
*/

-- Use certain database
use mydatabase;

-- Show all events from a database
show events from mydatabase;
-- Short version
show events;
-- Detailed version
SELECT * FROM INFORMATION_SCHEMA.events;
-- Friendly Version
SELECT EVENT_NAME, EVENT_DEFINITION, EXECUTE_AT, status, LAST_EXECUTED FROM INFORMATION_SCHEMA.events;

--Check Original Data
select * from latabla;

--Create an event that will run 
CREATE EVENT FIRSTEVENT ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 1 MINUTE DO
update latabla set descripcion = '1';
-- Add comments to identify
CREATE EVENT SECONDEVENT ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 1 MINUTE COMMENT 'THIS IS A COMMENT' DO
update latabla set descripcion = '2';

-- Drop events
drop event FIRSTEVENT;
drop event SECONDEVENT;

-- Check current Timestamp of the server
select current_timestamp;

-- Turn on scheduler! Important
SET GLOBAL event_scheduler = ON;

-- Turn it off
SET GLOBAL event_scheduler = OFF;