Selon "Kapoor, Nishikant" <[EMAIL PROTECTED]>: > > > -----Original Message----- > > > 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 > > Hi, > You don"t need to use @row in perl, > just use : > > $n=0; > while (fetch..) { > $n++; > print "$n"."$ename ...\n"; > > } > > Mathias > > I could, but I am assigning the entire resultset in one shot to another > construct as follows: > > my $str = "SELECT [EMAIL PROTECTED]:[EMAIL PROTECTED] as row, <fields> FROM > <tables> WHERE ..."; > my $sth = $conn->prepare($st); > $sth->execute(); > return $sth->fetchall_arrayref( {} ); > > Thanks, > -Nishi > >
Then alter your table to add an auto_increment column, update it and play your query without @row. Mathias -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
