MYSQL EVENT

hello friends now i gave the tutorial  on mysql events. how to implement the event and preform the particular task on particular time with help of mysql event.

query is

option 1

“create event name of event on SCHEDULE AT  ‘ 2014-2-17 23:05:00’ + interval 1 hour do select * from tablename “;

this simple query show the all records of table on set time(2014-2-17 23:05:00)

option 2

“create event name of event on SCHEDULE AT  ‘ 2014-2-17 23:05:00’ + interval 1 minute do select * from tablename “;

this simple query show the all records of table on set time(2014-2-17 23:05:00)

option 3

“create event name of event on SCHEDULE AT  ‘ 2014-2-17 23:05:00’ + interval 1 second do select * from tablename “;

this simple query show the all records of table on set time(2014-2-17 23:05:00)

option 4

“create event name of event on SCHEDULE AT  ‘ 2014-2-17 23:05:00’ + interval ‘4:30’ HOUR_MINUTE  do select * from tablename “;

this simple query show the all records of table on set time(2014-2-17 23:05:00)

option 5

“create event name of event on SCHEDULE AT  ‘ 2014-2-17 23:05:00’ + interval ‘4:30’ MINUTE _SECOND do select * from tablename “;

this simple query show the all records of table on set time(2014-2-17 23:05:00)

option 6

“create event name of event on SCHEDULE AT  ‘ 2014-2-17 23:05:00’  do select * from tablename “;

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s