From the course: Learning phpMyAdmin

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Building a query manually on multiple tables

Building a query manually on multiple tables

From the course: Learning phpMyAdmin

Start my 1-month free trial

Building a query manually on multiple tables

“

- We've already seen how the SQL tab works when you have a single table selected. Let's look at it now with a database selected. I'm going to select the up_and_running database from the panel on the left, and the SQL tab is the second from the left at the top. This is all you get, an empty query area and just three buttons: Clear, Format, and Get auto-saved query. If you're using an older version of phpMyAdmin, you get just the one button, Clear. There's no list of columns to choose from, but you're not entirely on your own, at least if you're using a recent version of phpMyAdmin. The query area has code hints and autocompletion for all SQL keywords and the names of the tables in the current database. I tend to use this mainly for testing whether I've got my syntax for SELECT queries right and to see if I get the results I expect. Let's create a SELECT query. As soon as I type S, I get the code hints, so I can select SELECT immediately just by pressing Enter or Return, and then we…

Contents