Select Code to Download

#Assuming $sth has just been executed with a "show tables" query
while(@tmp = $sth->fetchrow_array())
...
        push @tables, $tablename;
    }
}

my $sth2 = $dbh->prepare("select count(*) from ?");
$sth2->execute($tablename);