Databases Reference
In-Depth Information
Multi-Query Bookmarks
A single bookmark can also store more than one query (separated by semicolon).
This is mostly useful for non-
SELECT
queries. Stacking a lot of
SELECT
statements
would not yield the intended result because we would only see the data fetched by
the last
SELECT
statement.
Recalling from the Bookmarks List
These bookmarks can now be easily found on the following pages:
•
•
•
The Table view:
Structure
or
SQL
sub-page of any table from
dbbook
The query window: the
SQL-History
tab
While browsing the
pma_bookmark
table (See the
Executing Bookmarks from
the pma_bookmark Table
section later)
The Database view:
SQL
sub-page of the
dbbook
database
•
Bookmarks are numbered by the system. Three choices are available when recalling a
bookmark:
Submit
,
View
only
, and
Delete
(
Submit
being the default).
Bookmark Execution
Choosing the first bookmark and hitting
Go
executes the stored query and displays
its results. The page resulting from a bookmark execution does not have another
dialog to create a bookmark, as this would be superfluous.
Search WWH ::
Custom Search