MySQL Query Browser使用教程-狂野之城-搜狐博客

来源:百度文库 编辑:神马文学网 时间:2024/07/04 17:39:20
MySQL Query Browser
Copyright 2004-2007 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: 2007-02-28 (revision: 5103)
Table of Contents
1. MySQL Enterprise2. Introduction to the MySQL Query Browser3. Installation3.1. Introduction3.2. Installing Under Windows3.2.1. Using the Windows Installer3.2.2. Installing From the ZIP File
3.3. Installing Under Linux3.3.1. Installing the Generic Tarball3.3.2. RPM Installation
3.4. Installing Under Mac OS X
4. Removing MySQL GUI Tools4.1. Uninstall – Windows4.2. Uninstall – Linux4.3. Uninstall – Mac OS X
5. Upgrading MySQL GUI Tools5.1. Upgrading – Windows5.2. Upgrading – Linux5.2.1. Tarball Upgrade5.2.2. RPM Upgrade
5.3. Upgrading – Mac OS X
6. Running MySQL GUI Tools6.1. Running Under Windows6.2. Running Under Linux6.3. Running On Mac OS X
7. The MySQL Query Browser Connection Dialog7.1. Connection Dialog
8. A Tour of the MySQL Query Browser8.1. The Main Query Window8.2. The Query Toolbar8.2.1. The Navigation Buttons8.2.2. The Query Area8.2.3. The Action Buttons
8.3. The Advanced Toolbar8.4. The Result Area8.5. The Object Browser8.5.1. The Database Browser8.5.2. The Bookmark Browser8.5.3. The History Browser
8.6. The Information Browser8.6.1. The Syntax Browser8.6.2. The Function browser8.6.3. The Parameter Browser8.6.4. The Transaction Browser
8.7. The Script Editor8.7.1. The Script Debugging Buttons8.7.2. The Script Area
9. Using The MySQL Query Browser9.1. Entering and Editing Queries Manually9.2. Building Queries9.3. Creating Views9.4. Navigating Result Sets Within the Result Area9.5. Exporting Result Sets9.6. Handling BLOB and TEXT Columns9.7. Editing Result Sets Within the Result Area9.8. Comparing Result Sets9.9. Managing Stored Procedures and Functions with MySQL Query Browser9.10. Editing Queries From a Development Tool
10. The MySQL Table Editor10.1. Introduction10.2. The Main Editor Window10.3. The Columns And Indices Tab10.3.1. The Column Editor10.3.2. The Detail Area
10.4. The Table Options Tab10.5. The Advanced Options Tab10.5.1. The Various Section10.5.2. The Row Options Section10.5.3. The Storage Options Section10.5.4. The Merge Table Options Section10.5.5. The Table RAID Settings Section
10.6. Applying Your Changes
11. Options Dialog11.1. Introduction11.2. General Options11.3. Connections11.3.1. SSL Connections
11.4. Editors11.5. The Browser Section11.5.1. Display Options11.5.2. Query Options11.5.3. Various
A. Installing From SourceA.1. IntroductionA.2. Downloading The Source CodeA.3. Building from Source under WindowsA.3.1. PrerequisitesA.3.2. Compiling and Building
A.4. Building from Source under LinuxA.4.1. Prerequisites
A.5. Compiling and BuildingA.5.1. Building Static BinariesA.5.2. Building RPMs
B. Troubleshooting Application ErrorsB.1. Troubleshooting Connection ErrorsB.2. Troubleshooting Display Problems
C. How Connections Are StoredD. XML Files Common to the MySQL GUI ApplicationsE. XML Files Used by MySQL Query BrowserF. Notes for TranslatorsG. Third-party Software Used by the MySQL GUI ToolsG.1. PCRE LibraryG.2. PNG Support
List of Figures
7.1.Connection dialog8.1.The MySQL Query Browser main query window8.2.The query area expanded to ten lines8.3.The MySQL Query Browser status icons8.4.The advanced toolbar8.5.The database browser8.6.The script editor8.7.The file open dialog9.1.The table tool9.2.The BLOB handling icons9.3.Stored procedure in database browser10.1.The MySQL Table Editor10.2.The column editor10.3.The index editor10.4.The Confirm Table Edit dialog11.1.Options dialog11.2.Options dialog: Connections11.3.Options dialog: Advanced Parameters11.4.The query browser options dialogB.1.Error message dialog
List of Tables
A.1.Required ComponentsA.2.Requirements for MySQL Query Browser