selectdb in DBI

[Ramprasad A Padmanabhan]

quick question

  In my script  I need to connect to two  different databases How Can I 
do this

 $dbh = DBI->connect( "DBI:mysql:database=$DBNAME1;host=$DBHOST","", "" 
)  or die "Can't connect to Mysql database: $DBI::errstr\n";

.......
.......
.......
# Now change the database
$dbh->selectdb($DBNAME2)   # This function doesnot  exist
Do I need to connect to mysql again inorder to select a different database

Thanks
Ram




--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]