Working With MySQL Events – Complete Beginners Guide

| Last Updated: | In: Mysql


Hello friends, hope you are doing good. In today’s tutorial, I will explain the very simple and easy steps to working with MySql events with the example. After this tutorial, you will be able to:

1) Create Event
2) View Event
3) Update Event
4) Delete Event

Working With MySQL Events - Complete Beginners Guide

How to create mysql events

There is two type of events to create events in Mysql first is ONE TIME and RECURRING.These examples are tried & tested and it is working fine.

ONE TIME Events

Syntex to create one time events in mysql:

Example:

After executing the above example you will get the success message like “MySQL returned an empty result set (i.e. zero rows). (Query took 0.0002 seconds.)”. Now if you want to see the recently created events in your mysql database, then execute the below commands:

SHOW EVENTS

RECURRING Events

If you want to create the recurring event, then you need to execute the below example:

After executing the above example you will get the success message like “MySQL returned an empty result set (i.e. zero rows). (Query took 0.0002 seconds.)””

Now if you want to see the recently created events in your MySQL database, then execute the below commands:

SHOW EVENTS

How to update the existing events

If you want to edit your existing events, then follow the below example:

How to drop mysql events

Want to drop your existing events from your MySql database, then follow the below example:

Above query will drop the “my_first_event_01″ event from your database. After executing of above example you will see the success message ” MySQL returned an empty result set (i.e. zero rows). (Query took 0.0001 seconds.)”

Tags: , , , , , , ,


About: Prem Tiwari

Prem Tiwari is the founder of freewebmentor.com and is a professional developer who has vast experience in PHP and open source technologies. Apart from this, he is a blogger by hobby.


You may also like:

Get Free Access of 450+ Scripts

Don't worry you'll not be spammed!

Featured eBook

WordPress Security Guide

Free Guide: Learn how to implement security guideline in your WordPress site...

DOWNLOAD

Free WordPress Setup Service

Free WordPress Setup

Want to Setup WordPress Blog Setup? I will help you in the setup of your WordPress blog.

Click Here

Pincode Finder

pincode-finder tool

Online Pincode Finder

Best tool to locate post Office address and pincodes of all india...

SEARCH NOW