PHPMyAdmin: Many-to-Many relations in MyISAM (without foreign key support)
Answers
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.
More
- PHPMyAdmin: Many-to-Many relations in MyISAM (without foreign key support)
- MySQL BETWEEN query w/ BETWEEN ? AND?
- select row where the slot is the biggest
- mysql and php suddenly case-sensitive?
- select random data with a nested query?
- How innodb tables are locked when ON INSERT trigger is processed?
- A little help required on sending email notifications something similar to Job alerts
- running a mysql query inside a loop of another without a sync error
- MySQL, need some advice about how to setup sitemaps for a site with a lot of pages?
- Is there a tool to check database integrity in Django?
I've discovered that my host may only support MyISAM and 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?