PHPMyAdmin: Many-to-Many relations in MyISAM (without foreign key support)
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.
精彩评论