第1页 / 共442页
第2页 / 共442页
第3页 / 共442页
第4页 / 共442页
第5页 / 共442页
第6页 / 共442页
第7页 / 共442页
第8页 / 共442页
mysql workbench使用手册完整版.pdf
MySQL Workbench
Table of Contents
Preface and Legal Notice
Chapter 1. MySQL Workbench Introduction
Chapter 2. MySQL Workbench Editions
Chapter 3. Installing and Launching MySQL Workbench
Hardware Requirements
Software Requirements
Starting MySQL Workbench
Installing MySQL Workbench on Windows
Launching MySQL Workbench on Windows
Uninstalling MySQL Workbench on Windows
Installing MySQL Workbench on Linux
Launching MySQL Workbench on Linux
Uninstalling MySQL Workbench on Linux
Installing MySQL Workbench on Mac OS X
Launching MySQL Workbench on Mac OS X
Uninstalling MySQL Workbench on Mac OS X
Chapter 4. Getting Started Tutorial
Administering a MySQL Server
Creating a Model
Adding Data to Your Database
Chapter 5. The Home Window
Workbench Central
Workspace
Workbench Application Minimum Window Size
Workbench Preferences
The General Tab
The Administrator Tab
The SQL Editor Tab
The Model Tab
The MySQL Tab
The Diagram Tab
The Appearance Tab
Chapter 6. SQL Development
Open Connection to Start Querying
New Connection
Edit Table Data
Edit SQL Script
Manage Connections
Manage DB Connections Dialog
The Password Storage Vault
Standard TCP/IP Connection
Local Socket/Pipe Connection
Standard TCP/IP over SSH Connection
SQL Editor
Main Menu
Toolbar
SQL Query Panel
Main Tabsheets
Output and History Tabsheet
Results Tabsheets
Live Editing Tabsheets
Sidebar
Snippets panel
Session and Object Information Panel
Object Browser
Chapter 7. Data Modeling
Open an Existing EER Model
Create New EER Model
Create EER Model from Existing Database
Create EER Model from SQL Script
Model Editor
Modeling Menus
The File Menu
The Edit Menu
Find Dialog Window
Workbench Preferences
The View Menu
The Arrange Menu
The Model Menu
The DBDoc Model Reporting Dialog Window (Commercial Version)
The Validation Submenus (Commercial Version)
The Object Notation Submenu
The Relationship Notation Submenu
The Database Menu
The Plugins Menu
The Scripting Menu
The Community Menu
The Help Menu
System Info
The Toolbar
Tool-Specific Toolbar Items
EER Diagrams
The Physical Schemata Panel
The Schema Objects Panel
The Schema Privileges Panel
Adding Roles
Adding Users
The SQL Scripts Panel
The Model Notes Panel
The History Palette
The Model Navigator Panel
The Catalog Tree Palette
The Layers Palette
Finding Invisible Objects Using the Layers Palette
The Properties Palette
EER Diagram Editor
The Vertical Toolbar
The Standard Mouse Pointer
The Hand Tool
The Eraser Tool
The Layer Tool
The Text Tool
The Image Tool
The Table Tool
The View Tool
The Routine Group Tool
The Relationship Tools
Working with Models
Creating Tables
Adding Tables to the Physical Schemata
Adding Tables to an EER Diagram
The MySQL Table Editor
The Main Editor Window
The Columns Tab
The Indexes Tab
The Foreign Keys Tab
The Triggers Tab
The Partitioning Tab
The Options Tab
The Inserts Tab
The Privileges Tab
Creating Foreign Key Relationships
Adding Foreign Key Relationships Using an EER Diagram
The Relationship Editor
Connection Properties
Creating Views
Adding Views to the Physical Schemata
Adding Views to an EER Diagram
The View Editor
Modifying a View Using the Properties Palette
Creating Routines and Routine Groups
Routines
Adding Routines to the Physical Schemata
The Routine Editor
The Routine Tab
The Privileges Tab
Routine Groups
Adding Routine Groups to the Physical Schemata
Adding Routine Groups to an EER Diagram
The Routine Group Editor
The Routine Groups Tab
The Privileges Tab
Modifying a Routine Group Using the Properties Palette
Creating Layers
Adding Layers to an EER Diagram
Adding Objects to a Layer
Modifying a Layer Using the Properties Palette
Creating Notes
Adding Notes
The Note Editor
Creating Text Objects
Adding Text Objects to an EER Diagram
The Text Object Editor
Modifying a Text Object Using the Properties Palette
Creating Images
Adding Images to an EER Diagram
The Image Editor
The Image Tab
Reverse Engineering
Reverse Engineering Using a Create Script
Reverse Engineering a Live Database
Errors During Reverse Engineering
Forward Engineering
Forward Engineering Using an SQL Script
Creating a Schema
Altering a Schema
Forward Engineering to a Live Server
Database Synchronization
Creating a Catalog Diff Report
Modeling Tutorials
Importing a Data Definition SQL Script
Adding an EER Diagram
Using the Default Schema
Creating a New Table
Creating Other Schema Objects
Basic Modeling
Adding a Table
Creating a Foreign Key
Documenting the sakila Database
A PNG File of the sakila Database
Printing
Printing Options
MySQL Workbench Schema Validation Plugins (Commercial Version)
General Validation
MySQL-Specific Validation
The DBDoc Model Reporting Dialog Window (Commercial Version)
Customizing DBDoc Model Reporting Templates
Supported Template Markers
Creating a Custom Template
Chapter 8. Server Administration
Server Administration
New Server Instance
Manage Data Import/Export
Manage Security
Manage Server Instances
Creating and Managing Server Instances
New Server Instance Wizard
Manage Server Instances Dialog
Server Administration and Configuration
The Startup Tab
The Configuration Tab
The Accounts Tab
Administrative Roles
The Connections Tab
The Variables Tab
The Data Dump Tab
Export to Disk
Import from Disk
Advanced Export Options
The Logs Tab
Chapter 9. Extending Workbench
GRT and Workbench Data Organization
Modules
Plugins
Adding a GUI to a Plugin Using MForms
The Workbench Scripting Shell
Exploring the Workbench Scripting Shell
The Shell Window
The Globals, Classes, and Modules Tabs
Tutorial: Writing Plugins
Chapter 10. Keyboard Shortcuts
Chapter 11. MySQL Utilities
Introduction
Introduction to MySQL Utilities
Connection Parameters
Introduction to extending the MySQL Utilities
Commands
mysql.utilities.command.grep — Search Databases for Objects
mysql.utilities.command.proc — Search Processes on Servers
Manual Pages
Brief overview of command-line utilities
mut - MySQL Utilities Testing
mysqldbcompare - Compare Two Databases and Identify Differences
mysqldbcopy - Copy Database Objects Between Servers
mysqldbexport - Export Object Definitions or Data from a Database
mysqldbimport - Import Object Definitions or Data into a Database
mysqldiff - Identify Differences Among Database Objects
mysqldiskusage - Show Database Disk Usage
mysqlfailover - Automatic replication health monitoring and failover
mysqlindexcheck - Identify Potentially Redundant Table Indexes
mysqlmetagrep - Search Database Object Definitions
mysqlprocgrep - Search Server Process Lists
mysqlreplicate - Set Up and Start Replication Between Two Servers
mysqlrpladmin - Administration utility for MySQL replication
mysqlrplcheck - Check Replication Prerequisities
mysqlrplshow - Show Slaves for Master Server
mysqlserverclone - Clone Existing Server to Create New Server
mysqlserverinfo - Display Common Diagnostic Information from a Server
mysqluserclone - Clone Existing User to Create New User
Parsers
mysql.utilities.parser — Parse MySQL Log Files
Appendix A. Third Party Licenses
.NET Flat TabControl License
Bitstream Vera License
Boost Library License
Cairo License
CTemplate (Google Template System) License
cURL (libcurl) License
DockPanel Suite License
Dojo Toolkit v1.7.0b1 License
GLib License (for MySQL Workbench)
Glitz License
GNU Lesser General Public License Version 2.1, February 1999
HtmlRenderer (System.Drawing.Html)
Libiconv License
Libintl License
Libxml2 License
Libzip License
Lua (liblua) License
Paramiko License
PCRE License
Pixman License
PyCrypto License
Python License
Scintilla License
ScintillaNET License
TinyXML License
TreeViewAdv for .NET License
VSQLite++ License
zlib License
Appendix B. MySQL Workbench FAQ
Appendix C. MySQL Workbench and Utilities Change History
MySQL Workbench Change History
Changes in Release 5.2
Changes in MySQL Workbench 5.2.40 (Not yet released)
Changes in MySQL Workbench 5.2.39 (10 April 2012)
Changes in MySQL Workbench 5.2.38 (23 February 2012)
Changes in MySQL Workbench 5.2.37 (26 December 2011)
Changes in MySQL Workbench 5.2.36 (3 December 2011)
Changes in MySQL Workbench 5.2.35 (23 September 2011)
Changes in MySQL Workbench 5.2.34 (26 May 2011)
Changes in MySQL Workbench 5.2.33b (21 March 2011)
Changes in MySQL Workbench 5.2.33 (11 March 2011)
Changes in MySQL Workbench 5.2.32 (05 March 2011)
Changes in MySQL Workbench 5.2.31a (13 December 2010)
Changes in MySQL Workbench 5.2.31 (08 December 2010)
Changes in MySQL Workbench 5.2.30 (20 November 2010)
Changes in MySQL Workbench 5.2.29 (12 October 2010)
Changes in MySQL Workbench 5.2.28 (19 September 2010)
Changes in MySQL Workbench 5.2.27 (01 September 2010)
Changes in MySQL Workbench 5.2.26 (06 August 2010)
Changes in MySQL Workbench 5.2.25 (30 June 2010, General Availability)
Changes in MySQL Workbench 5.2.24 (21 June 2010)
Changes in MySQL Workbench 5.2.23 (Internal release only)
Changes in MySQL Workbench 5.2.22 (02 June 2010)
Changes in MySQL Workbench 5.2.21 (12 May 2010, Release Candidate)
Changes in MySQL Workbench 5.2.20 (27 April 2010)
Changes in MySQL Workbench 5.2.19 (16 April 2010)
Changes in MySQL Workbench 5.2.18 (13 April 2010)
Changes in MySQL Workbench 5.2.17 (02 April 2010)
Changes in MySQL Workbench 5.2.16 (17 February 2010)
Changes in MySQL Workbench 5.2.15 (28 January 2010)
Changes in MySQL Workbench 5.2.14 (21 January 2010)
Changes in MySQL Workbench 5.2.13 (Not released)
Changes in MySQL Workbench 5.2.12 (Not released)
Changes in MySQL Workbench 5.2.11 (18 December 2009)
Changes in MySQL Workbench 5.2.10 (01 December 2009)
Changes in MySQL Workbench 5.2.9 (Internal release only)
Changes in MySQL Workbench 5.2.8 (18 November 2009, Beta)
Changes in MySQL Workbench 5.2.7 (Internal release only)
Changes in MySQL Workbench 5.2.6 (21 October 2009)
Changes in MySQL Workbench 5.2.5 (Internal Release Only)
Changes in MySQL Workbench 5.2.4 (07 October 2009)
Changes in MySQL Workbench 5.2.3 (15 September 2009)
Changes in MySQL Workbench 5.2.2 (27 July 2009)
Changes in MySQL Workbench 5.2.1 (22 May 2009)
Changes in MySQL Workbench 5.2.0 (30 April 2009, Alpha)
Changes in Release 5.1
Changes in MySQL Workbench 5.1.19 (06 September 2010)
Changes in MySQL Workbench 5.1.18 (03 September 2009, General Availability)
Changes in MySQL Workbench 5.1.17 (14 August 2009)
Changes in MySQL Workbench 5.1.16 (30 June 2009, General Availability)
Changes in MySQL Workbench 5.1.15 (26 June 2009)
Changes in MySQL Workbench 5.1.14 (19 June 2009)
Changes in MySQL Workbench 5.1.13 (12 June 2009)
Changes in MySQL Workbench 5.1.12 (27 April 2009)
Changes in MySQL Workbench 5.1.11 (Not yet released)
Changes in MySQL Workbench 5.1.10 (10 April 2009)
Changes in MySQL Workbench 5.1.9 (Not yet released, Beta)
Changes in MySQL Workbench 5.1.8 (Not yet released)
Changes in MySQL Workbench 5.1.7 (Not yet released)
Changes in MySQL Workbench 5.1.6 (Not yet released)
Changes in MySQL Workbench 5.1.4 (Not yet released)
Changes in Release 5.0
Changes in MySQL Workbench 5.0.30 (18 February 2009)
Changes in MySQL Workbench 5.0.29 (12 December 2008)
Changes in MySQL Workbench 5.0.28 (06 December 2008)
Changes in MySQL Workbench 5.0.27 (07 November 2008)
Changes in MySQL Workbench 5.0.26 (16 October 2008)
Changes in MySQL Workbench 5.0.25 (12 September 2008)
Changes in MySQL Workbench 5.0.24 (12 August 2008)
Changes in MySQL Workbench 5.0.23 (25 June 2008)
Changes in MySQL Workbench 5.0.22 (27 May 2008)
Changes in MySQL Workbench 5.0.21 (27 April 2008)
Changes in MySQL Workbench 5.0.20 (26 April 2008)
Changes in MySQL Workbench 5.0.19 (15 April 2008)
Changes in MySQL Workbench 5.0.18rc (not released)
Changes in MySQL Workbench 5.0.17rc (07 April 2008)
Changes in MySQL Workbench 5.0.16rc (26 March 2008)
Changes in MySQL Workbench 5.0.15rc (17 March 2008)
Changes in MySQL Workbench 5.0.14abeta (28 February 2008)
Changes in MySQL Workbench 5.0.14beta (25 February 2008)
MySQL Utilities Change History
Changes in Release 1.0
Changes in MySQL Utilities 1.0.5 (10 April 2012)
Changes in MySQL Utilities 1.0.4 (22 December 2011)
Changes in MySQL Utilities 1.0.3 (10 October 2011)
Changes in MySQL Utilities 1.0.2 (12 August 2011)
Changes in MySQL Utilities 1.0.1 (11 May 2011)
Changes in MySQL Utilities 1.0.0 (07 December 2010)
MySQL Workbench
MySQL Workbench
Abstract
This manual documents the MySQL Workbench SE version 5.2 and the MySQL Workbench OSS version 5.2.
If you have not yet installed MySQL Workbench OSS please download your free copy from the download site.
MySQL Workbench OSS is available for Windows, Mac OS X, and Linux.
Document generated on: 2012-04-18 (revision: 30126)
For legal information, see the Legal Notice.
Table of Contents
Preface and Legal Notice ............................................................................................................ vii
1. MySQL Workbench Introduction ................................................................................................ 1
2. MySQL Workbench Editions ..................................................................................................... 3
3. Installing and Launching MySQL Workbench ............................................................................. 5
Hardware Requirements ....................................................................................................... 5
Software Requirements ........................................................................................................ 5
Starting MySQL Workbench .................................................................................................. 6
Installing MySQL Workbench on Windows ..................................................................... 6
Launching MySQL Workbench on Windows ................................................................... 7
Uninstalling MySQL Workbench on Windows ................................................................. 8
Installing MySQL Workbench on Linux .......................................................................... 8
Launching MySQL Workbench on Linux ........................................................................ 9
Uninstalling MySQL Workbench on Linux ...................................................................... 9
Installing MySQL Workbench on Mac OS X ................................................................. 10
Launching MySQL Workbench on Mac OS X ............................................................... 10
Uninstalling MySQL Workbench on Mac OS X ............................................................. 11
4. Getting Started Tutorial .......................................................................................................... 13
Administering a MySQL Server ........................................................................................... 13
Creating a Model ............................................................................................................... 25
Adding Data to Your Database ........................................................................................... 30
5. The Home Window ................................................................................................................. 35
Workbench Central ............................................................................................................. 36
Workspace ......................................................................................................................... 37
Workbench Application Minimum Window Size .................................................................... 37
Workbench Preferences ...................................................................................................... 37
The General Tab ........................................................................................................ 38
The Administrator Tab ................................................................................................ 38
The SQL Editor Tab ................................................................................................... 38
The Model Tab .......................................................................................................... 40
The MySQL Tab ........................................................................................................ 41
The Diagram Tab ....................................................................................................... 41
The Appearance Tab .................................................................................................. 41
6. SQL Development .................................................................................................................. 43
Open Connection to Start Querying ..................................................................................... 43
New Connection ................................................................................................................. 44
Edit Table Data .................................................................................................................. 44
Edit SQL Script .................................................................................................................. 44
Manage Connections .......................................................................................................... 44
Manage DB Connections Dialog ......................................................................................... 44
The Password Storage Vault ...................................................................................... 45
Standard TCP/IP Connection ...................................................................................... 46
Local Socket/Pipe Connection ..................................................................................... 47
Standard TCP/IP over SSH Connection ....................................................................... 47
SQL Editor ......................................................................................................................... 48
Main Menu ................................................................................................................. 49
Toolbar ...................................................................................................................... 50
SQL Query Panel ....................................................................................................... 51
Main Tabsheets .......................................................................................................... 52
Sidebar ...................................................................................................................... 57
7. Data Modeling ........................................................................................................................ 63
Open an Existing EER Model ............................................................................................. 64
Create New EER Model ..................................................................................................... 64
Create EER Model from Existing Database ......................................................................... 64
Create EER Model from SQL Script .................................................................................... 64
Model Editor ...................................................................................................................... 65
iii
MySQL Workbench
Modeling Menus ......................................................................................................... 66
The Toolbar ............................................................................................................... 74
EER Diagrams ........................................................................................................... 75
The Physical Schemata Panel .................................................................................... 75
The Schema Privileges Panel ..................................................................................... 76
The SQL Scripts Panel ............................................................................................... 77
The Model Notes Panel .............................................................................................. 77
The History Palette ..................................................................................................... 77
The Model Navigator Panel ........................................................................................ 77
The Catalog Tree Palette ........................................................................................... 78
The Layers Palette ..................................................................................................... 79
The Properties Palette ................................................................................................ 79
EER Diagram Editor ........................................................................................................... 80
The Vertical Toolbar ................................................................................................... 80
Working with Models .......................................................................................................... 83
Creating Tables .......................................................................................................... 83
Creating Foreign Key Relationships ............................................................................. 96
Creating Views ......................................................................................................... 100
Creating Routines and Routine Groups ...................................................................... 102
Creating Layers ........................................................................................................ 105
Creating Notes ......................................................................................................... 107
Creating Text Objects ............................................................................................... 107
Creating Images ....................................................................................................... 108
Reverse Engineering ................................................................................................ 109
Forward Engineering ................................................................................................. 118
Modeling Tutorials ............................................................................................................ 137
Importing a Data Definition SQL Script ...................................................................... 137
Using the Default Schema ........................................................................................ 139
Basic Modeling ......................................................................................................... 141
Documenting the sakila Database .......................................................................... 142
Printing ............................................................................................................................ 144
Printing Options ........................................................................................................ 144
MySQL Workbench Schema Validation Plugins (Commercial Version) ................................. 144
General Validation .................................................................................................... 144
MySQL-Specific Validation ........................................................................................ 145
The DBDoc Model Reporting Dialog Window (Commercial Version) ..................................... 145
Customizing DBDoc Model Reporting Templates ................................................................ 149
Supported Template Markers .................................................................................... 152
Creating a Custom Template .................................................................................... 155
8. Server Administration ............................................................................................................ 159
Server Administration ........................................................................................................ 159
New Server Instance ........................................................................................................ 160
Manage Data Import/Export .............................................................................................. 160
Manage Security .............................................................................................................. 160
Manage Server Instances ................................................................................................. 160
Creating and Managing Server Instances .......................................................................... 160
New Server Instance Wizard ..................................................................................... 160
Manage Server Instances Dialog ............................................................................... 162
Server Administration and Configuration ............................................................................ 165
The Startup Tab ....................................................................................................... 166
The Configuration Tab .............................................................................................. 167
The Accounts Tab .................................................................................................... 168
The Connections Tab ............................................................................................... 170
The Variables Tab .................................................................................................... 171
The Data Dump Tab ................................................................................................. 172
The Logs Tab .......................................................................................................... 175
9. Extending Workbench ........................................................................................................... 177
GRT and Workbench Data Organization ............................................................................ 177
iv
MySQL Workbench
Modules ........................................................................................................................... 178
Plugins ............................................................................................................................. 179
Adding a GUI to a Plugin Using MForms ........................................................................... 180
The Workbench Scripting Shell ......................................................................................... 180
Exploring the Workbench Scripting Shell .................................................................... 181
The Shell Window .................................................................................................... 182
The Globals, Classes, and Modules Tabs .................................................................. 182
Tutorial: Writing Plugins .................................................................................................... 183
10. Keyboard Shortcuts ............................................................................................................ 185
11. MySQL Utilities ................................................................................................................... 189
Introduction ...................................................................................................................... 189
Introduction to MySQL Utilities .................................................................................. 189
Connection Parameters ............................................................................................. 190
Introduction to extending the MySQL Utilities ............................................................. 190
Commands ....................................................................................................................... 196
mysql.utilities.command.grep — Search Databases for Objects ................................... 196
mysql.utilities.command.proc — Search Processes on Servers .................................... 197
Manual Pages .................................................................................................................. 199
Brief overview of command-line utilities ..................................................................... 199
mut - MySQL Utilities Testing ................................................................................... 201
mysqldbcompare - Compare Two Databases and Identify Differences ....................... 203
mysqldbcopy - Copy Database Objects Between Servers ......................................... 209
mysqldbexport - Export Object Definitions or Data from a Database ......................... 213
mysqldbimport - Import Object Definitions or Data into a Database .......................... 220
mysqldiff - Identify Differences Among Database Objects ....................................... 223
mysqldiskusage - Show Database Disk Usage ....................................................... 227
mysqlfailover - Automatic replication health monitoring and failover ....................... 230
mysqlindexcheck - Identify Potentially Redundant Table Indexes ............................. 236
mysqlmetagrep - Search Database Object Definitions .............................................. 238
mysqlprocgrep - Search Server Process Lists ........................................................ 242
mysqlreplicate - Set Up and Start Replication Between Two Servers ..................... 245
mysqlrpladmin - Administration utility for MySQL replication .................................... 248
mysqlrplcheck - Check Replication Prerequisities ................................................... 255
mysqlrplshow - Show Slaves for Master Server ...................................................... 258
mysqlserverclone - Clone Existing Server to Create New Server ............................ 261
mysqlserverinfo - Display Common Diagnostic Information from a Server ............... 262
mysqluserclone - Clone Existing User to Create New User ..................................... 265
Parsers ............................................................................................................................ 267
mysql.utilities.parser — Parse MySQL Log Files ......................................................... 267
A. Third Party Licenses ............................................................................................................ 271
.NET Flat TabControl License ........................................................................................... 272
Bitstream Vera License ..................................................................................................... 272
Boost Library License ....................................................................................................... 273
Cairo License ................................................................................................................... 274
CTemplate (Google Template System) License .................................................................. 274
cURL (libcurl) License ................................................................................................. 275
DockPanel Suite License .................................................................................................. 275
Dojo Toolkit v1.7.0b1 License ........................................................................................... 275
GLib License (for MySQL Workbench) ............................................................................... 276
Glitz License .................................................................................................................... 276
GNU Lesser General Public License Version 2.1, February 1999 ........................................ 277
HtmlRenderer (System.Drawing.Html) ................................................................................ 284
Libiconv License ............................................................................................................... 285
Libintl License .................................................................................................................. 285
Libxml2 License ............................................................................................................... 286
Libzip License .................................................................................................................. 286
Lua (liblua) License .......................................................................................................... 287
Paramiko License ............................................................................................................. 287
v
MySQL Workbench
PCRE License .................................................................................................................. 287
Pixman License ................................................................................................................ 288
PyCrypto License ............................................................................................................. 290
Python License ................................................................................................................. 290
Scintilla License ............................................................................................................... 300
ScintillaNET License ......................................................................................................... 301
TinyXML License .............................................................................................................. 302
TreeViewAdv for .NET License .......................................................................................... 302
VSQLite++ License ........................................................................................................... 302
zlib License ................................................................................................................... 303
B. MySQL Workbench FAQ ...................................................................................................... 305
C. MySQL Workbench and Utilities Change History .................................................................... 307
MySQL Workbench Change History .................................................................................. 307
Changes in Release 5.2 ........................................................................................... 307
Changes in Release 5.1 ........................................................................................... 396
Changes in Release 5.0 ........................................................................................... 415
MySQL Utilities Change History ........................................................................................ 431
Changes in Release 1.0 ........................................................................................... 431
vi
Preface and Legal Notice
This is the User Manual for the MySQL Workbench.
For license information, see the Legal Notice. This product may contain third-party code. For license
information on third-party code, see Appendix A, Third Party Licenses.
Legal Notices
Copyright © 2006, 2012, Oracle and/or its affiliates. All rights reserved.
This software and related documentation are provided under a license agreement containing
restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly
permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate,
broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any
form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless
required by law for interoperability, is prohibited.
The information contained herein is subject to change without notice and is not warranted to be error-
free. If you find any errors, please report them to us in writing.
If this software or related documentation is delivered to the U.S. Government or anyone licensing it on
behalf of the U.S. Government, the following notice is applicable:
U.S. GOVERNMENT RIGHTS Programs, software, databases, and related documentation and
technical data delivered to U.S. Government customers are "commercial computer software" or
"commercial technical data" pursuant to the applicable Federal Acquisition Regulation and agency-
specific supplemental regulations. As such, the use, duplication, disclosure, modification, and
adaptation shall be subject to the restrictions and license terms set forth in the applicable Government
contract, and, to the extent applicable by the terms of the Government contract, the additional rights set
forth in FAR 52.227-19, Commercial Computer Software License (December 2007). Oracle USA, Inc.,
500 Oracle Parkway, Redwood City, CA 94065.
This software is developed for general use in a variety of information management applications. It is not
developed or intended for use in any inherently dangerous applications, including applications which
may create a risk of personal injury. If you use this software in dangerous applications, then you shall
be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure the
safe use of this software. Oracle Corporation and its affiliates disclaim any liability for any damages
caused by use of this software in dangerous applications.
Oracle is a registered trademark of Oracle Corporation and/or its affiliates. MySQL is a trademark
of Oracle Corporation and/or its affiliates, and shall not be used without Oracle's express written
authorization. Other names may be trademarks of their respective owners.
This software and documentation may provide access to or information on content, products, and
services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly
disclaim all warranties of any kind with respect to third-party content, products, and services. Oracle
Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to
your access to or use of third-party content, products, or services.
This document in any form, software or printed matter, contains proprietary information that is the
exclusive property of Oracle. Your access to and use of this material is subject to the terms and
conditions of your Oracle Software License and Service Agreement, which has been executed and with
which you agree to comply. This document and information contained herein may not be disclosed,
copied, reproduced, or distributed to anyone outside Oracle without prior written consent of Oracle
or as specifically provided below. This document is not part of your license agreement nor can it be
incorporated into any contractual agreement with Oracle or its subsidiaries or affiliates.
This documentation is NOT distributed under a GPL license. Use of this documentation is subject to the
following terms:
vii
Legal Notices
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 Oracle 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 Oracle. Oracle and/
or its affiliates reserve any and all rights to this documentation not expressly granted above.
For more information on the terms of this license, or for details on how the MySQL documentation is
built and produced, please visit MySQL Contact & Questions.
For 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 and PDF formats,
see the MySQL Documentation Library.
viii
相关推荐
2023年江西萍乡中考道德与法治真题及答案.doc
2012年重庆南川中考生物真题及答案.doc
2013年江西师范大学地理学综合及文艺理论基础考研真题.doc
2020年四川甘孜小升初语文真题及答案I卷.doc
2020年注册岩土工程师专业基础考试真题及答案.doc
2023-2024学年福建省厦门市九年级上学期数学月考试题及答案.doc
2021-2022学年辽宁省沈阳市大东区九年级上学期语文期末试题及答案.doc
2022-2023学年北京东城区初三第一学期物理期末试卷及答案.doc
2018上半年江西教师资格初中地理学科知识与教学能力真题及答案.doc
2012年河北国家公务员申论考试真题及答案-省级.doc
2020-2021学年江苏省扬州市江都区邵樊片九年级上学期数学第一次质量检测试题及答案.doc
2022下半年黑龙江教师资格证中学综合素质真题及答案.doc
