O'Reilly logo

Mastering phpMyAdmin 3.4 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

Chapter 12. Generating Multi-table Queries

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 in single-table situations. 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 phpMyAdmin configuration storage has been made ...

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