getting error when creating EVENT in MySQL

Question

When i'm trying to create an EVENT in my MySQL getting this error

Script line: 1 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near

'EVENT `e_hourly`
ON SCHEDULE
  EVERY 1 HOUR
COMMENT 'Clears out s' at line 1

I'm attaching my create EVENT code here

CREATE EVENT `e_hourly`
  ON SCHEDULE
  EVERY 1 HOUR
  COMMENT 'Clears out sessions table each hour.'
  DO call testing();#here i'm trying to call a stored proc

jorese · Accepted Answer · 2014-03-13 16:52:59Z

1

Your Event Code seems to be fine, perhaps you don't have support for events in your mysql version?

We usually format events as:

DELIMITER $$
DROP EVENT IF EXISTS E_Hourly$$
CREATE EVENT E_Hourly ON SCHEDULE EVERY 1 HOUR COMMENT 'Clears out sessions table each hour' DO
EV:BEGIN
  CALL Testing();
END$$
DELIMITER ;

SET GLOBAL event_scheduler = ON;

answered Mar 13, 2014 at 16:52

jorese

536 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

jay Over a year ago

i've tried your code but still get error... and my MySQL server version is 5.0.41.. is the version is villain here..? and one more thing when i've tried to "SET GLOBAL event_scheduler = 1" i got error "Unknown system variable event_scheduler"(i'm sharing this information cause i think it may helps)

Collectives™ on Stack Overflow

getting error when creating EVENT in MySQL

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related