Database Reference
In-Depth Information
Adjusting the number of criteria columns
Using a similar mechanism, we can add or delete coloumns by checking the
INS
or
Del
checkboxes under each column, or the
Add/Delete Field Columns
dialog. We
already had one unused column (not shown on the previous images to save space).
Here, we have added one column using the
Ins
checkbox located under the unused
column (this time, we will need it):
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.
Search WWH ::
Custom Search