Databases Reference
In-Depth Information
Following this action, every time the user, who created this bookmark, browses the
book table, he sees the following screenshot:
Multi-query bookmarks
A single bookmark can also store more than one query (separated by a semicolon).
This is mostly useful for non- SELECT queries. As an example, let us assume that we
need to clean data about authors by removing an invalid area code from the phone
numbers on a regular basis. This operation would always be followed by a display of
the author table.
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.
 
Search WWH ::




Custom Search