On Thu, Apr 3, 2008 at 2:04 AM, Ben Roberts <[EMAIL PROTECTED]> wrote:
> > Hello, > > Does anybody have any info on cross-database joins? > > i.e. doing a join across various tables that are located inside different > databases (albeit on the same database server). Yes, Implemented and working fine without any issue. > > I'm interesested in any potential pitfalls, limitations, and performance > issues. There doesn't appear to be much information about this on the web > (at least not that I can find so far). > > Does querying multiple databases in a single query count as multiple > connections? No I'm using the InnoDB engine. Do foreign key constraints work across > different databases too? > Haven't tried > > Is using cross-database joins considered good practice? Its just like a single database > > > Thanks in advance for any help. > > Ben > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- Krishna Chandra Prajapati Email-id: [EMAIL PROTECTED]