And I believe that MySQL quietly ignores the foreign key keywords if the database doesn't support them, so that you can use the same code on MyISAM or InnoDB -- you just have be aware that under MyISAM funky things can happen :-P
Aaron On Mon, 16 Jun 2003, Ryan Butler wrote: > On Mon, 2003-06-16 at 12:36, lou wrote: > > > I think using references constraints(foreign keys) will guarantee that the > > message is > > going to the right user in the right mailbox and things like unconnected > > message wont > > exist rather than undelivered, at least the undelivered might stay in the > > MTA's queue for > > second retry where the unconnected will be deleted. > > > > outs: mysql doesnt support it no portability :) > > > > Anyone seeing something wrong in that except the above? > > > > > > cheers > > > > MySQL using INNODB tables supports foreign key constraints just fine. > >
