From the course: Learning phpMyAdmin
Unlock the full course today
Join today to access over 22,400 courses taught by industry experts or purchase this course individually.
Running queries from the console
- If you're using phpMyAdmin 4.3 or later there's this tiny button labeled Consule at the bottom left of the main pane. It might be difficult to see on screen because it is quite small and it is right down at the bottom. If I click Console, the bottom slides up to reveal a command line tool that lists all the recent queries that have been run in phpMyAdmin. To give yourself more room to work in the Console, you can drag the menu bar upwards. You can also scroll through the queries that you've executed in phpMyAdmin. When you hover over a query you get this context menu. The first item on the context menu, Expand, this doesn't always work, let's try it. No, that hasn't really worked so we'll click collapse. I'm going to scroll up a little bit further to see if I can find one that I know that works. Let's try this. There we go. It's expanded it so that it makes it easy to read the contents of that query. To collapse it back to a single line just click Collapse. Let's take a look at the…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
-
-
Performing a simple search8m 28s
-
Using query by example (QBE) to perform a simple search6m 6s
-
Finding and replacing text in a column3m 36s
-
Using QBE to set multiple conditions in a WHERE clause8m 2s
-
Joining multiple tables with QBE5m 2s
-
Building queries manually on a single table6m 48s
-
Building a query manually on multiple tables4m 3s
-
Saving frequently used queries with bookmarks7m 26s
-
Using a variable with a bookmarked query5m 37s
-
Using variables with bookmarks in phpMyAdmin 4.57m 19s
-
Using named parameters in a query4m 53s
-
Running queries from the console6m 31s
-
New Console options in phpMyAdmin 4.52m 17s
-
-
-
-