3.1. MySQL Query Browser Capabilities


MySQL Query Browser is a cross-platform GUI client program that's intuitive and easy to use. It provides a graphical interface to the MySQL server for querying and analyzing data. It's similar in style of use to MySQL Administrator but is oriented toward accessing database contents rather than server administration.

The following list describes some of the ways that you can use MySQL Query Browser:

  • Interactively enter, edit, and execute queries.

  • Navigate result sets with scrolling. Multiple result sets are tabbed so that you can switch between them easily by selecting the appropriate tab.

  • Browse the databases available on the server, the tables and stored routines in databases, and the columns in tables.

  • Browse your query history to see what queries you've issued, or recall and re-execute previous queries.

  • Bookmark queries for easy recall.

  • Create or drop databases and tables, and modify the structure of existing tables.

  • Create and edit SQL scripts, with debugging.

  • Edit connection profiles that can be used to connect to servers more easily.

  • Access information from the MySQL Reference Manual, such as statement syntax and function descriptions.

MySQL Query Browser supports multiple server connections and opens a separate window for each connection that you establish.



MySQL 5 Certification Study Guide
MySQL 5.0 Certification Study Guide
ISBN: 0672328127
EAN: 2147483647
Year: 2006
Pages: 312

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net