Database Link In MySQL
Posted on 2003-10-27
Something that I need to find out about the MySQL database ability.
I'm just wondering whether the MySQL database have any functionality similar to the "database link" in oracle?
Actually I have 2 database here. Let's give it a name of "A" database and "B" database.......
Inside the "A" database there is an employee table.
The program that I am writing now is actually using the "B" database but I need to cross reference to the employee table
in "A" database to get some information.
In order not to use 2 simultaneous DB connection in my program, I am just wondering is there any capability that MySQL
had that can clone out a table in "B" database but that table is actually referring to the employee table in "A" database.
I'm just wondering whether is there any ways of doing this in MySQL ? Thanks in advance for any help that I could get here.