DBI equivelent of "use database"?
I have two tables in two databases that are the same name and exactly the same structure. One table contains "active" data and one table contains "archive" data. Ideally, I'd like to issue a "use activedb;", run my query, issue "use archivedb;" and run it again.
I've seen a couple references to a method called selectdb from Mysql.pm, but I don't think it's defined in the DBI (or maybe just the version I am using). Besides, Mysql.pm's selectdb just did a disconnect/reconnect to switch the db.
My PlanB is to open two connections, one to the "activeDB" and one to the "archivedb", but selecting the db seems like a better method. Has anybody ever done this using straight DBI?
Perl: 5.8.2
MySQL: 5.0.27
Edited 1 time(s). Last edit at 05/09/2007 09:27AM by Jeffrey Hunter.
Subject
Written By
Posted
DBI equivelent of "use database"?
May 09, 2007 09:14AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.