[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]
