Hello.
This question often appears in the list. You can't join tables between databases residing on different MySQL servers. Rakesh Gupta <[EMAIL PROTECTED]> wrote: > When I am logged on to a particular mysql server, is it possible to > - Access table residing on a different mysqlserver? or > - To join tables between two databases residing on two different > mysql servers (on two different H/W boxes or same H/W box). > > Any Ideas???? > > I looked in the manual. It talks about accessing table in a different > database but the same mysql server! > > You can refer to a table within the current database as tbl name > (within the current database), or as db name.tbl name to explicitly > specify a database. You can refer to a column as col name, tbl name.col > name, or db name.tbl name.col name. You need not specify a tbl name or > db name.tbl name prefix for a column reference unless the reference > would be ambiguous. > > Thanks > > Rakesh > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
