MySQL

The world's most popular open source database

Contact a MySQL Representative

Login | Register


  • MySQL.com
  • Developer Zone
  • Partners & Solutions
  • Customer Login
  • DevZone
  • Downloads
  • Documentation
  • Articles
  • Forums
  • Bugs
  • Forge
  • Blogs
 
  • Documentation Library
    • Table of Contents
Search manual:

Additional languages
  • Greek
  • Italian
  • Portuguese
  • Russian
  • Spanish


MySQL Query Browser
1 MySQL Enterprise »
Section Navigation      [Toggle]
  • MySQL Query Browser
    • 1 MySQL Enterprise
    • 2 Introduction to the MySQL Query Browser
    • 3 Installation
    • 4 Removing MySQL GUI Tools
    • 5 Upgrading MySQL GUI Tools
    • 6 Running MySQL GUI Tools
    • 7 The MySQL Query Browser Connection Dialog
    • 8 A Tour of the MySQL Query Browser
    • 9 Using The MySQL Query Browser
    • 10 The MySQL Table Editor
    • 11 Options Dialog
    • 12 Migrating a Spreadsheet to MySQL
    • A Installing From Source
    • B Troubleshooting Application Errors
    • 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
    • H GNU Free Documentation License

MySQL Query Browser

Copyright 2004-2008 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.

For more information on the terms of this license, for details on how the MySQL documentation is built and produced, or if you are interested in doing a translation, please contact us at <docs@mysql.com>.

If you want help with using MySQL, please visit either the MySQL Forums or MySQL Mailing Lists where you can discuss your issues with other MySQL users.

For additional documentation on MySQL products, including translations of the documentation into other languages, and downloadable versions in variety of formats, including HTML, CHM and PDF formats, see MySQL Documentation Library.

Abstract

This is the MySQL Query Browser Manual.

Document generated on: 2008-02-06 (revision: 9717)

Table of Contents     [+/-]

1. MySQL Enterprise
2. Introduction to the MySQL Query Browser
3. Installation     [+/-]
3.1. Introduction
3.2. Installing Under Windows     [+/-]
3.2.1. Using the Windows Installer
3.2.2. Installing From the ZIP File
3.3. Installing Under Linux     [+/-]
3.3.1. Installing the Generic Tarball
3.3.2. RPM Installation
3.4. Installing Under Mac OS X
4. Removing MySQL GUI Tools     [+/-]
4.1. Uninstall – Windows
4.2. Uninstall – Linux
4.3. Uninstall – Mac OS X
5. Upgrading MySQL GUI Tools     [+/-]
5.1. Upgrading – Windows
5.2. Upgrading – Linux     [+/-]
5.2.1. Tarball Upgrade
5.2.2. RPM Upgrade
5.3. Upgrading – Mac OS X
6. Running MySQL GUI Tools     [+/-]
6.1. Running Under Windows
6.2. Running Under Linux
6.3. Running On Mac OS X
7. The MySQL Query Browser Connection Dialog     [+/-]
7.1. Connection Dialog
8. A Tour of the MySQL Query Browser     [+/-]
8.1. The Main Query Window
8.2. The Query Toolbar     [+/-]
8.2.1. The Navigation Buttons
8.2.2. The Query Area
8.2.3. The Action Buttons
8.3. The Advanced Toolbar
8.4. The Result Area
8.5. The Object Browser     [+/-]
8.5.1. The Database Browser
8.5.2. The Bookmark Browser
8.5.3. The History Browser
8.6. The Information Browser     [+/-]
8.6.1. The Syntax Browser
8.6.2. The Function browser
8.6.3. The Parameter Browser
8.6.4. The Transaction Browser
8.7. The Script Editor     [+/-]
8.7.1. The Script Debugging Buttons
8.7.2. The Script Area
9. Using The MySQL Query Browser     [+/-]
9.1. Entering and Editing Queries Manually
9.2. Building Queries
9.3. Creating Views
9.4. Navigating Result Sets Within the Result Area
9.5. Exporting Result Sets
9.6. Handling BLOB and TEXT Columns
9.7. Editing Result Sets Within the Result Area
9.8. Comparing Result Sets
9.9. Managing Stored Procedures and Functions with MySQL Query Browser
9.10. Editing Queries From a Development Tool
10. The MySQL Table Editor     [+/-]
10.1. Introduction
10.2. The Main Editor Window
10.3. The Columns And Indices Tab     [+/-]
10.3.1. The Column Editor
10.3.2. The Detail Area
10.4. The Table Options Tab
10.5. The Advanced Options Tab     [+/-]
10.5.1. The Various Section
10.5.2. The Row Options Section
10.5.3. The Storage Options Section
10.5.4. The Merge Table Options Section
10.5.5. The Table RAID Settings Section
10.6. Applying Your Changes
11. Options Dialog     [+/-]
11.1. Introduction
11.2. General Options
11.3. Connections     [+/-]
11.3.1. SSL Connections
11.4. Editors
11.5. The Browser Section     [+/-]
11.5.1. Display Options
11.5.2. Query Options
11.5.3. Various
12. Migrating a Spreadsheet to MySQL     [+/-]
12.1. Introduction
12.2. The Spreadsheet File
12.3. Converting a Spreadsheet to a Text File
12.4. Creating a Table with Query Browser
12.5. Loading the Data into a MySQL Database Table
12.6. Creating A Temporary Table of Members
12.7. Creating a Temporary Member Accreditations Table
12.8. The Final Tables
12.9. Confirming Data Integrity
12.10. The Production Database
12.11. Updating a MySQL Database from a Spreadsheet
12.12. The Migration Script
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
H. GNU Free Documentation License     [+/-]
H.1. PREAMBLE
H.2. APPLICABILITY AND DEFINITIONS
H.3. VERBATIM COPYING
H.4. COPYING IN QUANTITY
H.5. MODIFICATIONS
H.6. COMBINING DOCUMENTS
H.7. COLLECTIONS OF DOCUMENTS
H.8. AGGREGATION WITH INDEPENDENT WORKS
H.9. TRANSLATION
H.10. TERMINATION
H.11. FUTURE REVISIONS OF THIS LICENSE
H.12. ADDENDUM: How to use this License for your documents

List of Figures

7.1. Connection dialog
8.1. The MySQL Query Browser main query window
8.2. The query area expanded to ten lines
8.3. The MySQL Query Browser status icons
8.4. The advanced toolbar
8.5. The database browser
8.6. The script editor
8.7. The file open dialog
9.1. The table tool
9.2. The BLOB handling icons
9.3. Stored procedure in database browser
10.1. The MySQL Table Editor
10.2. The column editor
10.3. The index editor
10.4. The Confirm Table Edit dialog
11.1. Options dialog
11.2. Options dialog: Connections
11.3. Options dialog: Advanced Parameters
11.4. The query browser options dialog
B.1. Error message dialog

List of Tables

12.1. Spreadsheet format
A.1. Required Components
A.2. Requirements for MySQL Query Browser
Top / Previous / Next / Up / Table of Contents
© 1995-2008 MySQL AB. All rights reserved.
  • Online Shop
  • Site Map
  • Legal
  • Contact Us
  • Job Opportunities
  • No Software Patents!