:16 PM
Subject: Re: how to make a reference to previous row into a sql statement
> set @precprest='';
> select cmd.no_client,cmd.no_cmd,
> @i:=@i+1,@precprest:=cmd.no_prest as b, if(@i>1,0,1)
> from
>
> I can make a variable depending on the row because
> @i:=@i+1 di
to memorize the previous value of a column ?
- Original Message -
From: "David Yahoo" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, December 15, 2001 9:42 PM
Subject: how to make a reference to previous row into a sql statement
> Hi,
>
> I know
Hi,
I know that mysql can reference var into sql statement, I think like
@var, i cant retrieve this info.
.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
