Databases Reference
In-Depth Information
On clicking on
Go
, the query is executed and stored as a bookmark. It does not
matter if the query does not find anything. This is how we can generate bookmarks
for non-
SELECT
queries such as
UPDATE
,
DELETE
,
CREATE
TABLE
, and so on.
This technique can also be used for a
SELECT
statement that
either returns results or does not return results.
Making bookmarks public
All bookmarks we create are private by default. When a bookmark is created, the
username, which we are logged in as, is stored with the bookmark. Let us suppose
that we check the
Let every user access this bookmark
checkbox as shown in the
following screenshot:
This would have the following effect:
• All users having access to the same database (the current one) will have
access to the bookmark.
• A user's ability to see meaningful results from the bookmark depends on the
privileges they have on the tables referenced in the bookmark.
Search WWH ::
Custom Search