Wednesday, November 30, 2011

MySQL DELIMITER statement not working in Squirrel

I have the following statements that work fine in MySQLWorkbench:
DROP PROCEDURE IF EXISTS test_delimiter;
DELIMITER //
CREATE PROCEDURE test_delimiter()
BEGIN
END//
DELIMITER ;
When I try to run them in Squirrel, 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 'DELIMITER //
CREATE PROCEDURE test_delimiter()
BEGIN
END//
DELIMITER' at line 1
SQLState: 42000
ErrorCode: 1064
Error occured in:
DELIMITER //
CREATE PROCEDURE test_delimiter()
BEGIN
END//
DELIMITER
Any ideas why?
Also, it would be great to have Cloud SQL support MySQLWorkbench. Is
there a way to connect the two?

No comments:

Post a Comment