Databases Reference
In-Depth Information
After clicking on
Go
, we see that the results page shows a bookmark dialog.
We enter only a label,
topics for author 1
, for this bookmark, and then click on
Bookmark this SQL query
to save this query as a bookmark. Bookmarks are saved
in the table defined by
$cfg['Servers'][$i]['bookmarktable']
.
This bookmark dialog can be seen on any page that contains results. As a test, we
could just click on
Browse
for a table to get results, and then store this query as a
bookmark. However, it does not make much sense to store (in a bookmark) a query
that can easily be made with one click.
Storing a bookmark before sending a query
We have seen that it's easy to create a bookmark after the execution of a
SELECT
statement that generates results. Sometimes, we may want to store a bookmark even
if a query does not find any results. This may be the case if the data to which the
query refers is not yet present, or if the query is a statement other than
SELECT
. To
achieve this, we have the
Bookmark this SQL query
dialog available in the
SQL
tab
of the
Database
view,
Table
view, and the Query window.
We now go to the
SQL
page of the
book
table, enter a query to retrieve French topic,
and directly put the
topics in French
bookmark label in the
Bookmark this SQL
query
dialog. If this bookmark label has been used previously, a new bookmark with
the same name will be created, unless we check the
Replace existing bookmark of
same name
checkbox. Bookmarks carry an internal identifying number, as well as a
label chosen by the user.
Search WWH ::
Custom Search