Stored Procedures (MySQL 5.0.3)

[Giles]

I was so pleased to finally find a decent tool for writing queries for MySQL, I have been evaluating several in order to recommend to my comapny which to purchase.

Unfortunately the one thing we do most often is write Stored procedures (we are currently Migrating from MS SQL Server) and SQLyog does not seem to work for that.

If I use the basic format (EG):-

CREATE PROCEDURE simpleproc (OUT param1 INT)

BEGIN

SELECT COUNT(*) INTO param1 FROM VPS_PARAMETER;

END

It gives an error in the SELECT line (I suspect because this is the first line with a statement delimiter ';').

This is the same error I would expect from the command line, on the command line the 'workaround' is to change the delimiter, IE:-

DELIMITER //

CREATE PROCEDURE simpleproc (OUT param1 INT)

BEGIN

SELECT COUNT(*) INTO param1 FROM VPS_PARAMETER;

select PARAM1;

END //

DELIMITER ;

But as 'DELIMITER' is a command line command (not an SQL statement) this does not work in SQLyog.

Oddly the first bit of code works fine in an inferior (in my opinion) product 'ISQL for MySQL'.

Is there some way round this, or an update to support MySQL 5 in the works?

Thanks,

GILES

[Ritesh]

We are working on this issue and plan to fix it in v4.07.

[peterlaursen]

Lease take your tame to read through these ,,,

http://www.webyog.com/forums/index.php?act…t=ST&f=6&t=1352

http://www.webyog.com/forums/index.php?act…t=ST&f=3&t=1365

But Ritesh has told me that some issues – among others with character sets and an ablity to chose between languages i the Sqlyog GUI and Scheduled ODBC-import – will have first priority . (Will probably take about 2 maybe 3 mths to accomplish) before they can really go into the new features of MySQL 5.

DELIMITER option does not work in SQLYOG (and not i MySQL's own MySQL Query Browser either) It's only implemented in COnmmand-lene tool. Probably the libraries that from MySQL that must be must compiled into an GUI tool like Sqlyog are not yet out. It's seems that MySQL themselves quite “forgot” alle other clients than command-line.

Even a simpel Stored Procedyre that has only ones statement in it and this won't need delimiters like

Quote:

procedure p set @myvar = “We want GUI support for Stored Procedures”

won't work from Sqlyog og MySQL Query Browser because the libray doesn't know about SP's but thinks that you a trying a session-defined procedure (or user-function)and returns the error messige “Procedure statement must include INTO” or something like that …

But I too would like to use SQLYOG for working with SP's and Triggers too.

[Giles]

Excellent 🙂 – No idea when I suppose? 😉

[peterlaursen]

OK . Ritesh was there allready …

[Giles]

Thanks guys, I will pop back here every now and then to see whats happening as this is definately the best tool I have found for MySQL.

I will probably recommend it to the company despite this point as it has so many other things I like and will use.

Ta,

GILES

[Author]

Posts