At 9:53 AM +1100 2000-01-10, Albert Ng wrote:
>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
>> >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