Syntax error How can we put schedule for different kinds of MySQL events?

How can we put schedule for different kinds of MySQL events?

Basically, there are two kinds of events for which we need to specify the schedule −

One-time event

One-time event means it will be executed only once on a particular schedule. If we want to create a one-time event then we need to put the following syntax after ON SCHEDULE clause −

AT Timestamp[+INTERVAL]

Recurring events

Recurring event means that it will be executed after regular time of interval. If we want to create a recurring event then we need to put the following syntax after ON SCHEDULE clause −

EVERY interval STARTS timestamp [+INTERVAL] ENDS timestamp [+INTERVAL]
Updated on: 2020-06-22T12:32:13+05:30

134 Views

Kickstart Your Career

Get certified by completing the course

Get Started
Advertisements