tags:

views:

26

answers:

1
Q: 

Is it possible to have a mysql table refer to a table in a foreign database?

Is it possible to use a mysql table transparently though the table is an alias for a table in a foreign database?

+1  A: 

The standard doesn't support it, neither implementation of mysql db.

Artem Barger  2009-06-11 08:47:33

related questions

Can user defined variable be used with ADODB connections from PHP5 to a MySQL4.x server?
Not your usual MySQL4 + ODBC connection issue...
Create table trouble in MySQL 4.1
PHP: keep track of requests by user and by product brand?
MySQL: select distinct names for each date?
Fastest way to join mysql 4.0 data from multiple tables?
Need MySQL 4 to ignore ALTER TABLE errors
Drop constraints only if it exists in mysql server 5.0
Difference between php 4 and php 5?
MySQL: Migrating Queries from v4 to v5
updating primary key of master and child tables for large tables
C MySQL client library behaviour
MySQL And C applications
MySQL Alter syntax to drop a column if it exists