MySQL Forums
Forum List  »  Events (Job Scheduler)

what happend with start event schedule
Posted by: Jerry Pasaribu
Date: July 01, 2007 07:39PM

what happened with mysql event?
i write a new event schedule
i wrote this code on 01 july 2007 14:46
this is a code
$jadwal="CREATE EVENT ".$_SESSION[uid]." ON SCHEDULE EVERY 2 MINUTE ".
"COMMENT 'Add Bunga' ".
"DO ".
"call hitbunga();";
$kerjakansql=mysql_query($jadwal);

this is a result (show events)
mysql> show events\G;
*************************** 1. row ***************************
Db: hyip
Name: budi
Definer: root@localhost
Type: RECURRING
Execute at: NULL
Interval value: 2
Interval field: MINUTE
Starts: 2007-06-20 14:03:26
Ends: NULL
Status: ENABLED
1 row in set (0.01 sec)

ERROR:
No query specified
the question is why starts is 2007-06-20 14:03:26 ?

i use mysql falcon 5.1
and os is win xp

best regards

jerry

Options: ReplyQuote


Subject
Views
Written By
Posted
what happend with start event schedule
6034
July 01, 2007 07:39PM


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.