MySQL Forums
Forum List  »  Events (Job Scheduler)

event problem
Posted by: tayfur boler
Date: March 14, 2009 03:25AM

Hi all,

I have a event but it's not working.

I have mysql 5.1.24-rc version.


CREATE EVENT e_second
ON SCHEDULE
EVERY 5 second
COMMENT '5 sn de bir insert'
DO
insert into testevent (test) values (now());



SELECT * FROM mysql.event-->

db name body definer execute_at interval_value interval_field created modified last_executed starts ends status on_completion sql_mode comment originator time_zone character_set_client collation_connection db_collation body_utf8
muyaptest e_second insert into testevent (test) values (now()) root@localhost \N 5 SECOND 2009-03-14 10:13:27 2009-03-14 10:13:27 \N 2009-03-14 08:13:27 \N ENABLED DROP 5 sn de bir insert 1 SYSTEM utf8 utf8_general_ci utf8_turkish_ci insert into testevent (test) values (now())

Thanks.
Tayfur BĂ–LER

Options: ReplyQuote


Subject
Views
Written By
Posted
event problem
4794
March 14, 2009 03:25AM


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.