List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:January 7 2000 4:15pm
Subject:Re: user variables
View as plain text  
At 9:24 PM +1100 2000-01-07, Albert Ng wrote:
>Hi all,
>
>    I am trying the user variable example
>listed in
>the mysql manual as follow:
>
>select @t1:=(@t2:=1)+@t3:=4,@t1,@t2,@t3;
>
>but I get the following error message:
>
>ERROR 1064: You have an error in your
>SQL
>syntax near '@t1:=(@t2:=1)+@t3:=4,@t1,
>@t2,@t3' at line 1
>
>anyone any ideas? Is this only available
>in 3.23.8-alpha?
>I am using 3.22.16a-gamma.


The change notes in the manual indicate that
user variables were added in 3.23.6.

-- 
Paul DuBois, paul@stripped
Thread
user variablesAlbert Ng7 Jan
  • Re: user variablesPaul DuBois7 Jan
  • Re: user variables -> calculating limitAlbert Ng10 Jan
    • Re: user variables -> calculating limitBenjamin Pflugmann10 Jan
    • Re: user variables -> calculating limitPaul DuBois10 Jan
    • Where can user variables be used?Paul DuBois10 Jan
      • Where can user variables be used?Michael Widenius10 Jan
  • Re: Where can user variables be used?Albert Ng10 Jan
  • Re: Where can user variables be used?Sasha Pachev10 Jan