List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:August 13 1999 2:12pm
Subject:RE: MySQL and Perl
View as plain text  
At 6:41 AM -0400 8/13/99, Ee Loon wrote:
>consider the following statement:
>   select * from table;
>
> In perl, i used to have a while loop to fetch each
> rows that matches the selection. Is there a way to retreive all rows with a
>single command instead of issuing multiple
>fetchrow() in PERL?


What are you using?  DBI?

You can use fetchall_arrayref with a statement handle or selectall_arrayref
with a database handle.  I'm being deliberatly vague here, because you
really should look up how to use them in the DBI documentation.

-- 
Paul DuBois, paul@stripped
Thread
mysql-queryranjeet walunj9 Aug
  • MySQL and Perlksausw9 Aug
    • Re: MySQL and PerlRichard K. Moore9 Aug
      • RE: MySQL and PerlEe Loon13 Aug
  • Re: mysql-queryMartin Ramsch10 Aug
Re: MySQL and Perlluuk9 Aug
RE: MySQL and PerlPaul DuBois13 Aug
  • RE: MySQL and PerlStuart D Jackson13 Aug