Help for this page

Select Code to Download


  1. or download this
    my $sth = $dbh->prepare(q{
        SELECT Table_PK, Name 
    ...
    }); $sth->execute;
    my %lookup = map { $_->[0], $_->[1] } 
                    @{ $sth->fetchall_arrayref };
    
  2. or download this
    $sth->bind_columns(
        map { undef ${$_}; \${$_}; } 
    ...
    while($sth->fetch) {
        print("$table_pk\t$name\n");
    }