Generating automatic joins (internal relations)
phpMyAdmin can generate the joins between the tables in the query it builds, provided internal relations have been defined. Let us now populate our two unused columns with the title and the genre columns from our book table, and see what happens when we update the query.
There are now two additional criteria columns that relate to the `book`.`title` and the `book`.`genre` columns respectively. phpMyAdmin used its knowledge of the relations defined between the tables to generate a LEFT JOIN clause (highlighted in the preceding screenshot) on the author_id key column. A shortcoming of the current version ...
Get Mastering phpMyAdmin 3.4 for Effective MySQL Management now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
