O'Reilly logo

Mastering phpMyAdmin 3.1 for Effective MySQL Management by Marc Delisle

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Automatic joins

phpMyAdmin can generate the joins between the tables in the query it builds. Let's now populate our two unused columns with the title and the genre fields from our book table, and see what happens when we update the query.

Automatic joins

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 previous figure) on the author_id key field. A shortcoming of the current version is that only the internal relations, and not the InnoDB relations, are examined.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required