Page 1 of 1

Unrecognized statement type (near schedule)

PostPosted: 17. March 2017 16:36
by xfawkes
I'm trying to create a scheduled event through phpmyadmin by running sql such as:

CREATE EVENT test_event_01
ON SCHEDULE EVERY 1 MINUTE
DO
INSERT INTO messages(message,created_at)
VALUES('Test MySQL Event 1',NOW());

I keep getting a red line underneath the word SCHEDULE for which the error reads "unrecognized statement type (near schedule)"

If anyone can shine any light on this then it would be much appreciated :)