Unrecognized statement type (near schedule)

Problems with the Windows version of XAMPP, questions, comments, and anything related.

Unrecognized statement type (near schedule)

Postby xfawkes » 17. March 2017 16:36

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 :)
xfawkes
 
Posts: 1
Joined: 17. March 2017 16:29
XAMPP version: 5.6.30
Operating System: Windows 10

Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 27 guests