Bookmarks carry an identifying number as well as a user-chosen label.
Bookmarks
[ 222 ]
Then we click Go, which executes and stores the query as a bookmark. It does not
matter if the query finds nothing:
This is how we can generate bookmarks for non-SELECT queries like UPDATE, DELETE,
CREATE TABLE, and so on.
This technique can also be used for a SELECT statement that either
returns or does not return results.
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: SQL sub-page of any table from marc_book
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 marc_book database
Three choices are available when recalling a bookmark: Submit, View only, and
Delete (Submit being the default).
??? ??? ??? ???
Chapter 14
[ 223 ]
Bookmark Execution
Choosing the first bookmark and hitting Go executes the stored query and displays
its results.
Pages:
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209