At 13:57 -0500 6/2/04, Oropeza Querejeta, Alejandro wrote:
Hi, two questions:
Is it possible to select data from different Databases on the same
server?
Yes. You can qualify table and column names with the database name
to specify which database you mean.
http://dev.mysql.com/doc/mysql/en/Identifi
Yes Local.
SELECT databasename.tablename.columnname
> Hi, two questions:
> Is it possible to select data from different Databases on the same
> server?
> Is it possible to select data from different Databases on Different
> servers across the network?
>
> I searched for information on how to do
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wednesday 02 June 2004 01:57 pm, Oropeza Querejeta, Alejandro wrote:
> Hi, two questions:
> Is it possible to select data from different Databases on the same
> server?
Select *
from db1.table
,db2.table blah blah..
> Is it possible
Hi, two questions:
Is it possible to select data from different Databases on the same
server?
Is it possible to select data from different Databases on Different
servers across the network?
I searched for information on how to do it, but i haven't found any.
thanks in advance
Alejandro
