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
> 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 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:4484@stripped, sip:0871270137@stripped
Are you MySQL certified? http://www.mysql.com/certification/