With the introduction of Stored Procedures in MySQL ver.5 the option of the MySQL command line tool to choose another delimiter for SQL statements than “;” should be implemented in sqlyog ASAP.
The reason for that is that you create a Stored Procedure like this (simple example without parameters):
CREATE PROCEDURE myproc ()
BEGIN
statement;
statement;
and so on …..
END
Since “;” is used within the CREATE PROCEDURE SQL-statement you will need ANOTHER delimiter to delimit SQL-statements. It could be “|” or anything meningful (in different articles published by MySQL recently they use double slashes “//”)
With MySQL command line tool it is implemented with the DELIMITER command, ie:
“DELIMITER |;” wil change the SQL-delimiter from ; to |
and
“DELIMITER ;|” will change it back
….. but I almost don't care HOW it's done with Sqlyog!
I don't expect Sqlyog to implement full-featured support for stored procedures with the GUI overnight. But I would like to be able to use the SQL-pane in sqlyog to work with stored procedures to a start – and ASAP!
