Selon "Kapoor, Nishikant" <[EMAIL PROTECTED]>:
> [Sorry for cross-posting.]
>
> This is in continuation with the above mentioned subject - I am trying to
> find the 'display data order' for the returned resultset. The following
> thread very well answers my question:
>
> http://lists.mysql.com/mysql/185626
>
> a) SET @row=0;
> b) SELECT (@row:[EMAIL PROTECTED]) AS row, ename, empno FROM emp ORDER BY
> empno;
>
> +-----+--------+-------+
> | row | ename | empno |
> +-----+--------+-------+
> | 1 | SMITH | 7369 |
> | 2 | ALLEN | 7499 |
> | 3 | WARD | 7521 |
> | 4 | JONES | 7566 |
> | 5 | MARTIN | 7654 |
> +-----+--------+-------+
>
> However, I am trying to use it in a perl script instead of from command line,
> and I am not sure how exactly to do it. I need to execute both statements a &
> b together or else I get
>
> +-----+--------+-------+
> | row | ename | empno |
> +-----+--------+-------+
> |NULL | SMITH | 7369 |
> |NULL | ALLEN | 7499 |
> |NULL | WARD | 7521 |
> |NULL | JONES | 7566 |
> |NULL | MARTIN | 7654 |
> +-----+--------+-------+
>
> How can I execute both (a) and (b) in my perl script?
>
> Thanks for any help.
> Nishi
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
>
>
Hi,
You don"t need to use @row in perl,
just use :
$n=0;
while (fetch..) {
$n++;
print "$n"."$ename ...\n";
}
Mathias
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
