Re: creating a mysql stored procedure

On 6/29/07, Dan Climan <dcliman@xxxxxxxxxx> wrote:
>
>
>
>
> Is there a way to creat a stored procedure in MySQL using Squirrel-SQL?
>
>
>
> I have a valid stored procedure that I can create in the db using a mysql
> <filename.sql
>
>
>
> Every attempt to run this query through squirrel results in syntax errors.
>
> I've tried a DELIMTER // command and changing the session delimiter, but
> that didn't work.


Support needs to be added in the MySQL plugin for parsing stored
procedures and other constructs.  We'll see if we can get that in soon
- we have an outstanding request for it here:

http://sourceforge.net/tracker/index.php?func=detail&aid=1466324&group_id=28383&atid=393417

 It would be helpful if you would provide some sample script for
creating stored procedures that would be similar to ones that you
would expect SQuirreL to handle.  If you decide to provide any sample
script(s) you can attach them to the feature request above.

Rob

-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/