
- Learn MySQL
- MySQL - Home
- MySQL - Introduction
- MySQL - Installation
- MySQL - Administration
- MySQL - PHP Syntax
- MySQL - Connection
- MySQL - Create Database
- MySQL - Drop Database
- MySQL - Select Database
- MySQL - Data Types
- MySQL - Create Tables
- MySQL - Drop Tables
- MySQL - Insert Query
- MySQL - Select Query
- MySQL - Where Clause
- MySQL - Update Query
- MySQL - Delete Query
- MySQL - Like Clause
- MySQL - Sorting Results
- MySQL - Using Join
- MySQL - NULL Values
- MySQL - Regexps
- MySQL - Transactions
- MySQL - Alter Command
- MySQL - Indexes
- MySQL - Temporary Tables
- MySQL - Clone Tables
- MySQL - Database Info
- MySQL - Using Sequences
- MySQL - Handling Duplicates
- MySQL - SQL Injection
- MySQL - Database Export
- MySQL - Database Import
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]
- Related Articles
- How can we get the metadata of MySQL events?
- Why do we need to put similar kinds of food together?
- How we can prioritize jQuery events?
- How can we put comments in a column of existing MySQL table?
- What are different kinds of sound?
- Explain Different kinds of Generators in JavaScript
- What are the different kinds of advertising frauds?
- How can we catch a double click and enter key events for a JList in Java?\n
- What is the maximum length of data we can put in a BLOB column in MySQL?
- What is the maximum length of data we can put in a TEXT column in MySQL?
- How can we detect the double click events of a JTable row in Java?
- How can we check for NULL in a MySQL query?
- How we can put two divisions side by side in HTML?
- How we can put three divisions side by side in HTML?
- How can we get randomly different set of rows or values each time from MySQL table?

Advertisements