MySQL Query Browser

Copyright 2004-2006 MySQL AB

This documentation is NOT distributed under a GPL license. Use of this documentation is subject to the following terms: You may create a printed copy of this documentation solely for your own personal use. Conversion to other formats is allowed as long as the actual content is not altered or edited in any way. You shall not publish or distribute this documentation in any form or on any media, except if you distribute the documentation in a manner similar to how MySQL disseminates it (that is, electronically for download on a Web site with the software) or on a CD-ROM or similar medium, provided however that the documentation is disseminated together with the software on the same medium. Any other use, such as any dissemination of printed copies or use of this documentation, in whole or in part, in another publication, requires the prior written consent from an authorized representative of MySQL AB. MySQL AB reserves any and all rights to this documentation not expressly granted above.

Please email for more information or if you are interested in doing a translation.

Abstract

This is the MySQL Query Browser Manual.

Document generated on: 2006-11-10 (revision: 3902)


Table of Contents

1. Introduction to the MySQL Query Browser
2. Installation
2.1. Introduction
2.2. Installing Under Windows
2.2.1. Using the Windows Installer
2.2.2. Installing From the ZIP File
2.3. Installing Under Linux
2.3.1. Installing the Generic Tarball
2.3.2. RPM Installation
2.4. Installing Under Mac OS X
3. Removing MySQL GUI Tools
3.1. Uninstall – Windows
3.2. Uninstall – Linux
3.3. Uninstall – OS X
4. Running MySQL GUI Tools
4.1. Running Under Windows
4.2. Running Under Linux
4.3. Running On Mac OS X
5. The MySQL Query Browser Connection Dialog
5.1. Connection Dialog
6. A Tour of the MySQL Query Browser
6.1. The Main Query Window
6.2. The Query Toolbar
6.2.1. The Navigation Buttons
6.2.2. The Query Area
6.2.3. The Action Buttons
6.3. The Advanced Toolbar
6.4. The Result Area
6.5. The Object Browser
6.5.1. The Database Browser
6.5.2. The Bookmark Browser
6.5.3. The History Browser
6.6. The Information Browser
6.6.1. The Syntax Browser
6.6.2. The Function browser
6.6.3. The Parameter Browser
6.6.4. The Transaction Browser
6.7. The Script Editor
6.7.1. The Script Debugging Buttons
6.7.2. The Script Area
7. Using The MySQL Query Browser
7.1. Entering and Editing Queries Manually
7.2. Building Queries
7.3. Creating Views
7.4. Navigating Result Sets Within the Result Area
7.5. Exporting Result Sets
7.6. Handling BLOB and TEXT Columns
7.7. Editing Result Sets Within the Result Area
7.8. Comparing Result Sets
7.9. Creating Master-Detail Views
7.10. Managing Stored Procedures and Functions with MySQL Query Browser
7.11. Editing Queries From a Development Tool
8. The MySQL Table Editor
8.1. Introduction
8.2. The Main Editor Window
8.3. The Columns And Indices Tab
8.3.1. The Column Editor
8.3.2. The Detail Area
8.4. The Table Options Tab
8.5. The Advanced Options Tab
8.5.1. The Various Section
8.5.2. The Row Options Section
8.5.3. The Storage Options Section
8.5.4. The Merge Table Options Section
8.5.5. The Table RAID Settings Section
8.6. Applying Your Changes
9. Options Dialog
9.1. Introduction
9.2. General Options
9.3. Connections
9.4. Editors
9.5. The Browser Section
9.5.1. Display Options
9.5.2. Query Options
9.5.3. Various
A. Installing From Source
A.1. Introduction
A.2. Downloading The Source Code
A.3. Building from Source under Windows
A.3.1. Prerequisites
A.3.2. Compiling and Building
A.4. Building from Source under Linux
A.4.1. Prerequisites
A.5. Compiling and Building
A.5.1. Building Static Binaries
A.5.2. Building RPMs
B. Troubleshooting Application Errors
B.1. Troubleshooting Connection Errors
B.2. Troubleshooting Display Problems
C. How Connections Are Stored
D. XML Files Common to the MySQL GUI Applications
E. XML Files Used by MySQL Query Browser
F. Notes for Translators
G. Third-party Software Used by the MySQL GUI Tools
G.1. PCRE Library
G.2. PNG Support

List of Figures

5.1. Connection dialog
6.1. The MySQL Query Browser main query window
6.2. The query area expanded to ten lines
6.3. The MySQL Query Browser status icons
6.4. The advanced toolbar
6.5. The database browser
6.6. The script editor
6.7. The file open dialog
7.1. The table tool
7.2. The BLOB handling icons
7.3. The dynamic parameter list
7.4. Stored procedure in database browser
8.1. The MySQL Table Editor
8.2. The column editor
8.3. The index editor
8.4. The Confirm Table Edit dialog
9.1. Options dialog
9.2. Options dialog: Connections
9.3. The query browser options dialog
B.1. Error message dialog

List of Tables

A.1. Required Components
A.2. Requirements for MySQL Query Browser