The Search pages in the Database or Table view are intended for single-table lookups. This chapter covers the multi-table Query by example (QBE) feature available in the Database view.
Many phpMyAdmin users work in the Table view, table-by-table, and thus tend to overlook the multi-table query generator, which is a wonderful feature for fine-tuning queries. The query generator is useful not only in multi-table situations but also for a single table. It enables us to specify multiple criteria for a column, a feature that the Search page in the Table view does not possess.
Note
The examples in this chapter assume that a multi-user installation of the linked-tables infrastructure has been made (see Chapter 11) and that the book-copy
table created during an exercise of Chapter 10 is still there in the marc_book
database.
To open the page for this feature, we go to the Database view for a specific database (the query generator supports working on only...