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