MySQL Event Tutorials for Beginners #4 – One Time Event – On Completion Preserve Clause

In this video we’ll see:

ONE TIME EVENT – ON COMPLETION PRESERVE CLAUSE

CREATE
EVENT
[IF NOT EXISTS]
event_name
ON SCHEDULE schedule
[ON COMPLETION [NOT] PRESERVE]
DO event_body;

schedule:
AT timestamp [+ INTERVAL interval] …
| EVERY interval
[STARTS timestamp [+ INTERVAL interval] …]
[ENDS timestamp [+ INTERVAL interval] …]

interval:
quantity {YEAR | QUARTER | MONTH | DAY | HOUR | MINUTE |
WEEK | SECOND | YEAR_MONTH | DAY_HOUR | DAY_MINUTE |
DAY_SECOND | HOUR_MINUTE | HOUR_SECOND | MINUTE_SECOND}

SOCIAL :
===============
Subscribe : https://www.youtube.com/owthub
FACEBOOK : https://www.facebook.com/owthub
TWITTER: https://twitter.com/owthub
BLOG: https://onlinewebtutorhub.blogspot.in/
UDEMY: https://www.udemy.com/user/online-web-tutor

Other Tutorials
===============
Wordpress Customizations:
———————————
Wordpress Theme (Hindi): https://goo.gl/MZ8maF
Wordpress Widget (Hindi): https://goo.gl/Dc2htn
Wordpress Plugin (English): https://goo.gl/BA7dYG
Wordpress Theme Options (English): https://goo.gl/Vjv3Ub
Wordpress JSON Rest API (English): https://goo.gl/SVQRQR
Wordpress JSON Rest API (Hindi): https://goo.gl/NNWfKa
and many more…

Javascript framework:
———————————-
Learn backbone.js here! (English) : https://goo.gl/Qd2Pcs
Learn Vue JS here ! (Hindi): https://goo.gl/MVtsmh

PHP Frameworks:
———————————-
Laravel tutorial (Hindi): https://goo.gl/Nh9qJk
CakePHP tutorial (Hindi): https://goo.gl/uRsS3G

Tags
———————————-
mysql events tutorials,
mysql events for beginners tutorial,
step by step mysql event tutorial,
beginners tutorial for mysql events,
php mysql events tutorials,
online web tutor,
online web tutor mysql events tutorial,
online web tutor sanjay,
basics of mysql events,
complete mysql events tutorial,
tutorials for mysql events for beginners,

Thanks
Online Web Tutor
Keep learning and Sharing 🙂

Post Author: hatefull