Re: Can I select from remote tables in mysql 5.0.18-standard-log?

[Paul DuBois]

At 14:38 -0700 4/27/06, P. Evans wrote:
>Hello Listers,
>   Is it possible  to run a query on one mysql server to another 
>database on a different server ?
>   eg creating an alias in database A on server A to table B on 
>database B on server B ?
>
>   Like a federated nickname on db2 udb or synonym on informix ?

You can use FEDERATED to access tables on other MySQL servers.

http://dev.mysql.com/doc/refman/5.0/en/federated-storage-engine.html

-- 
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com