- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
- 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 create a MySQL one-time event that executes after some specified time interval?
As we know a one-time event means the events that will be executed only once on a particular schedule. To illustrate the creation of such kind of events we are using the following example in which we are creating an event which will execute after some specified time interval −
Example
mysql> CREATE EVENT testing_event5 ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 1 MINUTE ON COMPLETION PRESERVE DO INSERT INTO event_message(message,generated_at) Values('Hi',NOW());
Query OK, 0 rows affected (0.06 sec)
mysql> Select * from event_message;
+----+---------+---------------------+
| ID | MESSAGE | Generated_at |
+----+---------+---------------------+
| 1 | Hello | 2017-11-22 17:05:22 |
| 2 | Hi | 2017-11-22 17:08:37 |
+----+---------+---------------------+
2 rows in set (0.00 sec)In the above result set the message ‘Hi’ is stored after I minute interval from the current time.
Updated on 22-Jun-2020 12:28:53
- Related Questions & Answers
- How can we create a MySQL one-time event that executes immediately?
- How can we create a MySQL recurring event that executes after a specified time period and ends after a specified time period?
- How can we create multiple MySQL triggers for the same trigger event and action time?
- How can we add a time interval to date stored in a column of MySQL table?
- In MySQL, how can we display time in other format specified by the user?
- How to hide a widget after some time in Python Tkinter?
- How MySQL behaves when we use INTERVAL of time unit with CURDATE() function?
- How can we offload the time/date handling in MySQL?
- Find the minimum time after which one can exchange notes in Python
- What are some of the best Indian movies of all time that we can see anytime, anywhere?
- How to make a setInterval() stop after some time or after a number of actions in JavaScript?
- What are the best English movies of all time that we can see at any time?
- How can we start MySQL event scheduler?
- How can we set time in a table in JDBC?
- How can we retrieve time from a table in JDBC?
Advertisements