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
language?
>Alb
>
>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
