List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:January 10 2000 1:31am
Subject:Re: user variables -> calculating limit
View as plain text  
At 9:53 AM +1100 2000-01-10, Albert Ng wrote:
>Thanks Paul.
>Well I was hoping that I can use variables to
>find the size of a table so that I can display only
>the last few rows of the table by using limit since
>I can't do a limit -10 to signify I want it to go from
>the bottom of the records. And without sub-query,
>looks like my only choice is to do 2 sql's  and
>use a local variable in my program. sigh....oh,
>I can't upgrade to 3.23 for various reasons.

Are you using a script consisting only of SQL, or are you
accessing MySQL from within some other programming

>Paul DuBois wrote:
>>  >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
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