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