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. > --------------------------- > > Hi all, > > 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. Martijn Tonies Database Workbench - development tool for MySQL, and more! Upscene Productions http://www.upscene.com My thoughts: http://blog.upscene.com/martijn/ Database development questions? Check the forum! http://www.databasedevelopmentforum.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]