The visual builder

Starting with version 3.4, another method for query building is offered. It leverages the Designer interface that might be more familiar to users, by combining query generation to it. We can open this interface by clicking on the Switch to visual builder link, which produces an initial screen, shown in the following screenshot:

The visual builder

We should now open the list of columns for all tables by clicking on the Small/Big All icon.

The visual builder

Each column has a left-side checkbox and a right-side options icon. The checkbox is used to indicate which column ...

Get Mastering phpMyAdmin 3.4 for Effective MySQL Management now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.