MySQL Forums
Forum List  »  Events (Job Scheduler)

Use Event Mysql
Posted by: Draxent Seventh
Date: September 16, 2012 10:37PM

Hi everybody !!!
I was trying to create a mysql event.
I use XAMPP and phpMyAdmin.
I created a simple event:
-----------
DELIMITER ;;
CREATE EVENT INCREASE
ON SCHEDULE EVERY 1 MINUTE
DO
BEGIN
UPDATE `translation` SET `probability` = `probability`+1;
END;;
DELIMITER ;

-----------

After I created I tried to see the table "information_schema".
The event was created correctely, but after 5 minutes nothing happens.
Infact the `EVENTS`.LAST_EXECUTED field was remained NULL.

I tried also to change the function with this difference:
"ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 1 MINUTE".
Nothing.

How can I make to work my event?
What did I wrong?


Thanks you ;)

Options: ReplyQuote


Subject
Views
Written By
Posted
Use Event Mysql
4166
September 16, 2012 10:37PM
1807
October 23, 2012 12:35AM


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.