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.
Saving frequently used queries with bookmarks
From the course: Learning phpMyAdmin
Saving frequently used queries with bookmarks
- Earlier in this chapter, I showed you how to bookmark or save a Query by Example in the Query tab. We saved two, BMW Chrysler < 100000 and cars 2005-12. This feature has been available only since phpMyAdmin 4.2. But there's another bookmark feature that's also available in older versions of phpMyAdmin. To my mind, it's far more useful. Unlike these bookmarks in the Query tab which are limited to SELECT queries, the original bookmark feature can also be used with INSERT, UPDATE and DELETE queries. To use either type of bookmarks, you need to have enabled the advanced features in phpMyAdmin as described in chapter two. With the original bookmark feature, you first need to run the query. Let's switch to the SQL tab and I'm going to create a SELECT query that we would use to bookmark. So SELECT car_id, make, price, mileage, description, FROM cars, INNER JOIN makes USING, then in parentheses, make _id. And we'll have a WHERE clause where price is less than or equal to 10000 and we'll…
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)
-
-
-