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]

Ankith Reddy

Published on 22-Feb-2018 12:22:04