use DBI; my $dbh = DBI->connect('dbi:mysql:database=db1' , 'user', 'password'); my $db1_data = $dbh->selectall_hashref(qq/select * from table where field = 'value'/); my $db2_data = $dbh->selectall_hashref(qq/select * from db2.table where field = 'value');