Database Reference
In-Depth Information
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.
There may be more than two tables involved in a join.
Executing the query
Clicking the
Submit Query
button sends the query for execution. In the following
figure, you can see the complete generated query in the upper part and the resulting
data row in the lower part:
Search WWH ::
Custom Search