Re: MySQL DELIMITER statement not working in Squirrel

OK. But when I try the following:
DROP PROCEDURE IF EXISTS test_delimiter;
CREATE PROCEDURE test_delimiter()
BEGIN
SELECT * FROM my_table;
END;
I get:
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 '' at line 3
SQLState: 42000
ErrorCode: 1064
Error occured in:
CREATE PROCEDURE test_delimiter()
BEGIN
SELECT * FROM my_table
So how do I create a multi SQL statement procedure or function using
Squirrel? Also, it would be nice to have SQL that works in both
MySQLWorkbench and Squirrel.