Hi,
I'm assuming that each client database is contained within the same
MySQL server, and that you're not running 300 MySQL servers on different
machines or different ports?
Yes, why would I do that?
If so, you can reuse the same connections, and just reference the
different database in the query.So :
select *
from db1.table1
select *
from db2.table1
When you connect and specify a database name, you're just specifying the
default database.
I don't know it's even possible in mysql. Its reference docs doesn't say
that it is (http://dev.mysql.com/doc/mysql/en/join.html).
Thanks...
---
Badai Aqrandista
Cheepy (?)
_________________________________________________________________
REALESTATE: biggest buy/rent/share listings
http://ninemsn.realestate.com.au
