Help for this page

Select Code to Download


  1. or download this
    my @column_names = ("MO_resp","MT_resp","AO_resp");
    my $sql = "select ".join ",", map { "sum($_)" } @column_names;
    ...
    my $hour_sth = $hour_db->prepare( $sql );
    
    $hour_sth->execute($table_name, $db_date, "$hour:%") or die $DBI::errs
    +tr;