We can create scheduled events by SQL on MySQL using the CREATE EVENT statement. The syntax for the CREATE EVENT statement is as follows:

CREATE EVENT event_name
ON SCHEDULE schedule
DO event_body;

The event_name parameter is the name of the event. The schedule parameter specifies when the event will be executed. The event_body parameter is the SQL statement that the event will execute.

The schedule parameter can be a specific date and time, or it can be a recurring schedule. For example, the following statement creates a one-time event that will be executed at 10:00 AM on January 1st, 2023:

SQL

CREATE EVENT my_event
ON SCHEDULE AT '2023-01-01 10:00:00'
DO UPDATE my_table SET my_column = 1;

The following statement creates a recurring event that will be executed every day at 10:00 AM:

SQL

CREATE EVENT my_event
ON SCHEDULE EVERY DAY AT 10:00:00
DO UPDATE my_table SET my_column = 1;

The event_body parameter can be any valid SQL statement. For example, the following statement creates an event that will update the my_column column in the my_table table to 1:

SQL

CREATE EVENT my_event
ON SCHEDULE AT '2023-01-01 10:00:00'
DO UPDATE my_table SET my_column = 1;

Unraveling the Mysteries of MySQL’s Scheduled Events