Using more then on DB at once
Posted 12 November 2003 - 04:37 AM
I hope I made sense.
Posted 12 November 2003 - 05:21 AM
Can I set up a connection to more then one MySQL database and use them both in a single query?
I am editing this post as I accept the answer give by another member. :wink: Good call!
But you still have to avoid this.
Database name is a just a logical identifer for categorizing. Now how did you have two tables that are linked in two sperate database? I guess you need to spend some time reading RDBMS concepts. :wink:
Posted 12 November 2003 - 06:05 AM
ie : select tb1.pid,tb2.name from database1.tb1,database2.tb2 where whatyouwant=whatyouneed;
Posted 12 November 2003 - 06:51 PM
Now how did you have two tables that are linked in two sperate database? I guess you need to spend some time reading RDBMS concepts.
Let me explain better. There are two applications both have there own database(local) for storeing their own information, but they access a remote database (on another server) where they share a table with all the registered users.
So how can I create a query that can access a local DB and a remote DB at the same time? Can I connect two a local DB and the remote DB and use them both in a query.
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users