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 queries manually on a single table
From the course: Learning phpMyAdmin
Building queries manually on a single table
- The SQL tab handles queries in a more traditional manner. It works differently depending on whether you've selected an individual table or a whole database. Let's see how it works with a single table. I'm going to select the cars table in the up_and_running database and then the SQL tab. With a single table selected this large text area contains a default select query. There where 1 at the end is a condition that's always true, so this will select all of the columns in the table. The panel on the right lists all of the columns in the table and at the bottom here is a series of buttons. If you're using an older version of phpMyAdmin, you won't have all of the options that are shown here. So let's take a look at these options. The first button, select *, reinserts that default select query. Select inserts a select query that names each column individually. Insert creates an insert statement with placeholders for the value for each column. Update similarly creates an update statement…
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
-
-
-
-
-
-
-
-
(Locked)
Performing a simple search8m 28s
-
(Locked)
Using query by example (QBE) to perform a simple search6m 6s
-
(Locked)
Finding and replacing text in a column3m 36s
-
(Locked)
Using QBE to set multiple conditions in a WHERE clause8m 2s
-
(Locked)
Joining multiple tables with QBE5m 2s
-
(Locked)
Building queries manually on a single table6m 48s
-
(Locked)
Building a query manually on multiple tables4m 3s
-
(Locked)
Saving frequently used queries with bookmarks7m 26s
-
(Locked)
Using a variable with a bookmarked query5m 37s
-
(Locked)
Using variables with bookmarks in phpMyAdmin 4.57m 19s
-
(Locked)
Using named parameters in a query4m 53s
-
(Locked)
Running queries from the console6m 31s
-
(Locked)
New Console options in phpMyAdmin 4.52m 17s
-
(Locked)
-
-
-