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!