do you know that you can specify a database.tablename.column syntax in your queries to go across multiple databases?
Daniel Ek wrote:
Dear list,
I wish to know if anyone have any experience in querying several databases at the same time. Today the company that I work for have about three different databases and I really feel that's fine because of the logic around it. We have one Customer database with customerData table, CustomerProducts table and so on, and two other Productspecific ones.
I feel the information logic in having multiple databases are obvious but are there any way to use like pgsql views over several databases in Mysql? If not, can anyone please advice me to either when such a function will be implemented, or other solutions to the problem? And with that I don't mean the "make more connections" fix, since I don't feel it's a neat way to solve it.
Thanks in advance
Regards
Daniel Ek
-- Jeff Mathis, Ph.D. 505-955-1434 The Prediction Company [EMAIL PROTECTED] 525 Camino de los Marquez, Ste 6 http://www.predict.com Santa Fe, NM 87505
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
