Re: [Squirrel-sql-users] MySql Stored Procedures and Squirrel

[Robert M. <rob...@gm...>]

On 4/6/06, Chris Roberts <fi...@ya...> wrote:
> Hi All,
>
> Now I just have the default installation... it's got some kind of MySQL p=
lugin... but perhaps it's grossly out of date. Has anyone had any experienc=
e working with MySQL stored procedures without having to leave Squirrel?

The MySQL plugin was developed several years before MySQL allowed stored
procedures, so no, I'm pretty sure that it doesn't support showing the
text of an
stored procedure.  The plugin just needs to be updated to supported showing
 the text in a "source" tab when the procedure is clicked on in the
object tree -
much like what is already done in the Oracle plugin.  You can submit a feat=
ure
request for this here:

http://sourceforge.net/tracker/?group_id=3D28383&atid=3D393417

As far as running stored procedures, make sure that you use a "safe"
statement separator in "Session Properties" in the "SQL"
tab.  By default it's semi-colon (;) which is often seen one or more times =
in
the body of most stored procedures I've seen (Oracle PL/SQL.  I've haven't
worked with MySQL's stored procedures yet).  You could - for example - use
"FOO" as the separator and just highlight your procedure create statement
and run it.

Rob Manning