MySQL CREATE EVENT wrong syntax

Question

Edit: I've figured out my MySQL version doesn't support it. I run 5.0.91, it requires 5.1 or so. I'm assuming the syntax is correct. Thanks for the help.

I've just created this mysql event that's supposed to be run every hour. However, I keep getting this error:

#1064 - 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 event_upcomingbattle ON SCHEDULE EVERY 1 HOUR STARTS CURRENT_TIMESTAMP' at line 1

This is my code:

DELIMITER //
CREATE EVENT event_upcomingbattle
    ON SCHEDULE EVERY 1 HOUR
    STARTS CURRENT_TIMESTAMP
    DO
        CALL update_upcomingbattle();
    END//
DELIMITER ;

Am I missing something stupid? The update_upcomingbattle() procedure exists.

What happens when you change the event name, or put it between `? — Konerak
– Konerak, Commented Jan 26, 2012 at 9:40
I've figured out my MySQL version doesn't support it. I run 5.0.91, it requires 5.1 or so. I'm assuming the syntax is correct. Thanks for the help. — Patrickdev
– Patrickdev, Commented Jan 26, 2012 at 9:41

Patrickdev · Accepted Answer · 2016-09-10 22:02:46Z

2

The MySQL version I was using did not support events. Event support was added in MySQL 5.1.6. Instead, I was running 5.0.91. As soon as I updated MySQL, it started working.

edited Sep 10, 2016 at 22:02

answered Jan 7, 2013 at 8:36

Patrickdev

2,3911 gold badge21 silver badges29 bronze badges

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

Collectives™ on Stack Overflow

MySQL CREATE EVENT wrong syntax

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related