Help for this page

Select Code to Download


  1. or download this
    # Connect to the database, (the directory containing our csv file(s))
    my $dbh = DBI->connect("DBI:CSV:f_dir=.;csv_eol=\n;");
    ...
    my @rows = $dbh->selectrow_arrayref("SELECT IP, SUM(PartitionSize), SU
    +M(PartitionFree) FROM results GROUP BY IP");
    
    print ("@rows\n"); # Just here to view output
    
  2. or download this
    SQL ERROR: Can't find table names in FROM clause!
    
    
    Execution ERROR: No command found!.
    
  3. or download this
    my @rows = $dbh->selectrow_arrayref("SELECT IP FROM results");