Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
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: 22-Jun-2020
63 Views
Advertisements