> 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.
> Hi all,
> has anyone experienced any problems creating foreign keys (relationships)
> 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.
Database Workbench - development tool for MySQL, and more!
Database development questions? Check the forum!