Help for this page

Select Code to Download


  1. or download this
    my $sth = $dbh->prepare("SELECT `Test-Column-1`, `Test-Column-2` FROM 
    +`"
                .$config{'MySQL.table'}."` WHERE 1");
    ...
              'value-2 Column1' => 'value-2 Column2',
              'value-3 Column1' => 'value-3 Column2'
            };
    
  2. or download this
    #!/usr/bin/perl
    use DBI;
    ...
              'value-2 Column1' => 'value-2 Column2',
              'value-3 Column1' => 'value-3 Column2'
            };
    
  3. or download this
    my %row;
    # Column binding is the most efficient way to fetch data
    ...
                          'value-2 Column1' => 'value-2 Column2'
                        }
            };
    
  4. or download this
    [MySQL]
    user=user
    ...
    port=3306
    db=PerlMonks
    table=Data