开发者

PHPMyAdmin: Many-to-Many relations in MyISAM (without foreign key support)

开发者 https://www.devze.com 2023-02-06 00:17 出处:网络
I\'ve discovered that my host may only support MyISAM an开发者_运维问答d not InnoDB.Thus, I lack built-in foreign key support.How would I then implement a many-to-many relationship with three tables i

I've discovered that my host may only support MyISAM an开发者_运维问答d not InnoDB. Thus, I lack built-in foreign key support. How would I then implement a many-to-many relationship with three tables in PHPMyAdmin? The only solution is to enter in the relations manually through MySQL queries, correct?


I would implement it in the same way as you would using Innodb but ensure data integrity in the application layer. If you have a good data abstraction layer then this should be fairly simple to implement.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号