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

Written By
Schedule Query in MySql 5
October 03, 2008 12:20PM
October 04, 2008 05:04AM
October 04, 2008 02:30PM
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.