Hello,
New user here trying to create my first report. Using the SQL Editor against a MySQL database I enter:
delimiter //
CREATE PROCEDURE test() BEGIN select 'Hello World'; END //
Executing this results in the error "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 'delimiter // CREATE PROCEDURE test() BEGIN select 'Hello World'; END // at line 1"
I can run the code directly against the database on the server and it works fine. I suspect it is the delimiter command that is the problem (I've tried $$ as well).
Any ideas?
