pat333
asked on
testing stored procedure
I've written a mysql procedure that I am trying to run/test in a query analyzer and obtain the return value. The client is aqua data studio on windows.
In my mind, the code would be something like (i'm new to mysql):
call proc_myproc(@return,1);
select @test;
The intention is that the contents of @test would be shown in the results pane. However, running this returns the error:
W (1): 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 ';
select @test' at line 1
How can I run more than 1 command in a single request like this? Can I do it outside of a procedure or function? Both lines evaluate/run fine in isolation.
In my mind, the code would be something like (i'm new to mysql):
call proc_myproc(@return,1);
select @test;
The intention is that the contents of @test would be shown in the results pane. However, running this returns the error:
W (1): 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 ';
select @test' at line 1
How can I run more than 1 command in a single request like this? Can I do it outside of a procedure or function? Both lines evaluate/run fine in isolation.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.