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/Identifier_qualifiers.html
Is it possible to select data from different Databases on Different
servers across the network?
Not within the same connection. Depending on your API, you may be
able to open two connections within your program, but joining the
data selected from the two connections is something you have to take
care of. Ugly.
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
