"H. Steuer" <[EMAIL PROTECTED]> wrote:
> 
> im just wondering if there are any limitations in cross database queries like:
> SELECT one.* FROM db1.one, db2.two;
> 
> are there any differences in joining tables from within various databases to joinin 
> tables from within the same database?

No.

> the background of my question is that various users which all have their own 
> database need to share common data. so i wanted to create one common database which 
> they all have access to.
> 
> i did some tests and all succeeded. but want to be sure before heading production 
> status.
> 



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   [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]

Reply via email to