Book Image

Mastering phpMyAdmin 2.11 for Effective MySQL Management

Book Image

Mastering phpMyAdmin 2.11 for Effective MySQL Management

Overview of this book

Table of Contents (25 chapters)
Mastering phpMyAdmin 2.11 for Effective MySQL Management
Credits
About the Author
About the Reviewers
Preface

Chapter 14. Bookmarks

This chapter covers one of the linked-tables infrastructure's features: query bookmarks. Being able to label queries and recall them by label can be a real time saver. In Chapter 12, we learned about the SQL history feature, which automatically stores queries (temporarily or permanently).

Bookmarks are queries that are:

  • Stored permanently

  • Viewable

  • Erasable

  • Related to one database

  • Recorded only as a consequence of a user's wish

  • Labeled

  • Private by default (only available to the user creating them), but possibly public

A bookmark can also have a variable part, as explained in the Passing a Parameter Value to a Bookmark section later in this chapter.

There is no bookmark sub-page to manage bookmarks. Instead, the various actions on bookmarks are available on specific pages such as results pages or query box pages.

Creating a Bookmark after a Successful Query

Initial bookmark creation is made possible by the Bookmark this SQL-query button. This button appears only after execution...