SEO

#1 (**permalink**) 02-28-2008, 08:49 AM

I have this statement in a SQL file.

CREATE PROCEDURE HAPPINESS (IN player BIGINT, IN turn INT)
BEGIN
UPDATE something SET something=player;
UPDATE something2 set something2=turn;
END;

When I run this command:

bash$ mysql -p table < storedprocedure.sql

I get this error.
ERROR 1064 (42000) at line 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 'UPDATE something SET something=player;' at
line 3

If i take out the BEGIN and END it works fine, but only includes the
first UPDATE statement. The second one get ommited. Which is expected.
It seems to have something to do with the BEGIN statement and I can't
seem to figure it out. Any Suggestions?

#2 (**permalink**) 02-28-2008, 08:49 AM

"Ryan Knopp" wrote ...
>I have this statement in a SQL file.
>
> CREATE PROCEDURE HAPPINESS (IN player BIGINT, IN turn INT)
> BEGIN
> UPDATE something SET something=player;
> UPDATE something2 set something2=turn;
> END;
>
> When I run this command:
>
> bash$ mysql -p table < storedprocedure.sql
>
> I get this error.
> ERROR 1064 (42000) at line 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 'UPDATE something SET something=player;' at
> line 3
>
> If i take out the BEGIN and END it works fine, but only includes the
> first UPDATE statement. The second one get ommited. Which is expected.
> It seems to have something to do with the BEGIN statement and I can't
> seem to figure it out. Any Suggestions?

delimiter /
CREATE PROCEDURE HAPPINESS (IN player BIGINT, IN turn INT)
BEGIN
UPDATE something SET something=player;
UPDATE something2 set something2=turn;
END;
/

Regards
Dimitre

#3 (**permalink**) 02-28-2008, 08:49 AM

On Dec 21, 1:08 pm, "Radoulov, Dimitre" <cichomit...@gmail.com> wrote:
> "Ryan Knopp" wrote ...
>
>
>
>
>
> >I have this statement in a SQL file.
>
> > CREATE PROCEDURE HAPPINESS (IN player BIGINT, IN turn INT)
> > BEGIN
> > UPDATE something SET something=player;
> > UPDATE something2 set something2=turn;
> > END;
>
> > When I run this command:
>
> > bash$ mysql -p table < storedprocedure.sql
>
> > I get this error.
> > ERROR 1064 (42000) at line 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 'UPDATE something SET something=player;' at
> > line 3
>
> > If i take out the BEGIN and END it works fine, but only includes the
> > first UPDATE statement. The second one get ommited. Which is expected.
> > It seems to have something to do with the BEGIN statement and I can't
> > seem to figure it out. Any Suggestions?delimiter /
> CREATE PROCEDURE HAPPINESS (IN player BIGINT, IN turn INT)
> BEGIN
> UPDATE something SET something=player;
> UPDATE something2 set something2=turn;
> END;
> /
>
> Regards
> Dimitre- Hide quoted text -- Show quoted text -

Ah, something so simple. For some reason I thought the delimiter was
only for the command line.
Thanks!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Stored Procedure Syntax error.