MySQL Forums
Forum List  »  Events (Job Scheduler)

Schedule Query in MySql 5
Posted by: Ty E
Date: October 03, 2008 12:20PM

I am new to MySql and I am using navicat to develop. My question is:

I have the following statement:

Update widget
set widget_status='O'
where widget_status='T';

I want this to run automatically every 15 min. I thought I could set this up as an event in navicat, but it tells me the MySql version (5) does not support events.

Any ideas? Thanks so much for your help

Options: ReplyQuote


Subject
Views
Written By
Posted
Schedule Query in MySql 5
12238
October 03, 2008 12:20PM
7088
October 04, 2008 05:04AM
6860
October 04, 2008 02:30PM
5797
October 09, 2008 06:42PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.