- or download this
sub fetch_count
{
...
$db->selectrow_array("SELECT COUNT(*) FROM $table");
}
- or download this
my $row1 = $dbh->selectrow_array('SELECT COUNT(*) FROM table_one');
my $row2 = $dbh->selectrow_array('SELECT COUNT(*) FROM table_two');
- or download this
my ($row1, $row2)
= map { $dbh->selectrow_array("SELECT COUNT(*) FROM $_") }
qw<table_one table_two>;