On Tuesday, 28 March 2006 at 10:09:16 +0200, Martijn Tonies wrote: > Hello Taco, > >> I previously tried this same question on the GUI tool list, but not much >> traffic there, so I thought I'd give it a go here. >> I've been reading some articles that suggest I should be able to create a >> relationship on a MyISAM table, it would be great if someone could confirm >> or deny this. >> >> has anyone experienced any problems creating foreign keys >> (relationships) on tables that are of storage engine MyISAM? > > Now, there will be people telling you that you CAN create foreign keys. > > Well, in a way, this is true -> you can create columns with values that > point to other tables. > > What you probably are asking, is if you can referential integrity > constraints. > > The answer, for MyISAM tables, is NO.
Currently foreign key constraints only work for InnoDB tables. We're working making foreign keys table independent, but I can't give you a completion date yet. Greg -- Greg Lehey, Senior Software Engineer MySQL AB, http://www.mysql.com/ Echunga, South Australia Phone: +61-8-8388-8286 Mobile: +61-418-838-708 VoIP: sip:[EMAIL PROTECTED], sip:[EMAIL PROTECTED] Are you MySQL certified? http://www.mysql.com/certification/
pgpxsSKuVLoQT.pgp
Description: PGP signature