On Friday 09 June 2006 02:31 pm, Paul DuBois wrote:
> When you use the mysql client, you must redefine the statement delimiter
> during definition of a stored routine (or trigger or event) that uses
> compound statement syntax with multiple statements making up the body of
> the routine. See the e
Hello all and thanks again for any responses.
I'm hoping this is something really basic I'm not seeing. I have MySQL
5.0.22-log, and I'm having a weird time creating a basic stored procedure. I
get this far:
mysql> CREATE PROCEDURE getRootId (IN company_id INT)
-> BEGIN
-> DECLARE vari
