Re: MyISAM vs InnoDB + Foreign Keys

2004-05-13 Thread Josh Trutwin
On Thu, 13 May 2004 10:34:37 -0700 (PDT) David Blomstrom <[EMAIL PROTECTED]> wrote: > I thought that only InnoDB tables could be joined - > and only if they had foreign keys. But it sounds like > any kind of table can be joined, and it doesn't need a > foreign key. Exactly, you can do a join with

Re: MyISAM vs InnoDB + Foreign Keys

2004-05-13 Thread David Griffiths
> I thought that only InnoDB tables could be joined - > and only if they had foreign keys. But it sounds like > any kind of table can be joined, and it doesn't need a > foreign key. The ability to join a bunch of tables in a query is different from foreign keys. A foreign key is a relationhip be

MyISAM vs InnoDB + Foreign Keys

2004-05-13 Thread David Blomstrom
I thought that only InnoDB tables could be joined - and only if they had foreign keys. But it sounds like any kind of table can be joined, and it doesn't need a foreign key. Can someone explain InnoDB, MyISAM and foreign keys in plain English? If I understand correctly, foreign keys simply help en