example of event to fetch the data from a table on every 5
Posted: Fri Jan 07, 2011 12:08 am
I created the event for the select query, it successfully running on mysql.I have the problem that how to run this on the window for every 1 hour.
this is my code:
event CREATE EVENT `kaif`
ON SCHEDULE EVERY 5 SECOND
do
SELECT * FROM test.temp2;
this code is running successfully on mysql but how to retrive (fetch) the result and display on the browser
please give me the solution
Thanks in advance from Kaif
this is my code:
event CREATE EVENT `kaif`
ON SCHEDULE EVERY 5 SECOND
do
SELECT * FROM test.temp2;
this code is running successfully on mysql but how to retrive (fetch) the result and display on the browser
please give me the solution
Thanks in advance from Kaif