Database Reference
In-Depth Information
To accomplish this goal, we store a bookmark (before sending it for execution) that
contains these queries:
update author set phone = replace(phone,'(123)', '(456)');
select * from author;
In the bookmark, we could put many data modification statements such as
INSERT
,
UPDATE
, or
DELETE
, followed optionally by one
SELECT
statement. 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 easily be found on the following pages:
•
The Table view:
SQL
subpage 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
subpage of the
marc_book
database
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.
The results we get are not necessarily the same as when we created the
bookmark. They reflect the current contents of the database. Only the
query is stored as a bookmark.
Search WWH ::
Custom Search