We even get two errors??”one for each backquote.
Summary
In this chapter, we took a look at the purpose of query boxes and where they can be
found. We also looked at query window options, multi-statement queries, how to
use the field selector, how to use the SQL Validator and how to get a history of the
typed commands.
The Multi-Table Query
Generator
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.
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 one database at a time) and click
on Query.
Pages:
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201