中文版的MySQL 5.1参考手册 :
http://dev.mysql.com/doc/refman/5.1/zh/index.html
英文版本的MySQL 5.1 Reference Manual :
http://dev.mysql.com/doc/refman/5.1/en/index.html
英文版的MySQL 5.0 Reference Manual :
http://dev.mysql.com/doc/refman/5.0/en/index.html
英文版的MySQL 6.0 Reference Manual :
http://dev.mysql.com/doc/refman/6.0/en/index.html
英文版的MySQL 3.23, 4.0, 4.1 Reference Manual
http://dev.mysql.com/doc/refman/4.1/en/index.html
下载网址:
http://dev.mysql.com/downloads/mysql/6.0.html
MySQL是著名的数据库软件,与Oracle 和SQL Server 2000一样.
这个软件是开源的.
The world's most popular open source database
MySQL 5.1 Reference Manual
Copyright 1997-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 Reference Manual. It documents MySQL 5.1 through 5.1.23-rc.
Document generated on: 2008-01-12 (revision: 9569)
Table of Contents [+/-]
-
Preface
1. General Information
[+/-]
- 2. Installing and Upgrading MySQL [+/-]
-
-
2.1. General Installation Issues
[+/-]
- 2.2. Standard MySQL Installation Using a Binary Distribution 2.3. Installing MySQL on Windows [+/-]
-
-
2.3.1. Choosing An Installation Package
2.3.2. Installing MySQL with the Automated Installer
2.3.3. Using the MySQL Installation Wizard
2.3.4. Using the Configuration Wizard
2.3.5. Installing MySQL from a Noinstall Zip Archive
2.3.6. Extracting the Install Archive
2.3.7. Creating an Option File
2.3.8. Selecting a MySQL Server Type
2.3.9. Starting the Server for the First Time
2.3.10. Starting MySQL from the Windows Command Line
2.3.11. Starting MySQL as a Windows Service
2.3.12. Testing The MySQL Installation
2.3.13. Troubleshooting a MySQL Installation Under Windows
2.3.14. Upgrading MySQL on Windows
2.3.15. MySQL on Windows Compared to MySQL on Unix
2.4. Installing MySQL from RPM Packages on Linux
2.5. Installing MySQL on Mac OS X
2.6. Installing MySQL on Solaris
2.7. Installing MySQL on NetWare
2.8. Installing MySQL from - 2.10. Post-Installation Setup and Testing [+/-]
- 2.11. Upgrading MySQL [+/-]
- 2.12. Downgrading MySQL [+/-]
- 2.13. Operating System-Specific Notes [+/-]
- 2.14. Environment Variables 2.15. Perl Installation Notes [+/-]
tar.gz
Packages on Other Unix-Like Systems 2.9. MySQL Installation Using a Source Distribution [+/-]
3. Tutorial
[+/-]
-
-
3.1. Connecting to and Disconnecting from the Server
3.2. Entering Queries
3.3. Creating and Using a Database
[+/-]
- 3.4. Getting Information About Databases and Tables 3.5. Using mysql in Batch Mode 3.6. Examples of Common Queries [+/-]
-
-
3.6.1. The Maximum Value for a Column
3.6.2. The Row Holding the Maximum of a Certain Column
3.6.3. Maximum of Column per Group
3.6.4. The Rows Holding the Group-wise Maximum of a Certain Field
3.6.5. Using User-Defined Variables
3.6.6. Using Foreign Keys
3.6.7. Searching on Two Keys
3.6.8. Calculating Visits Per Day
3.6.9. Using
AUTO_INCREMENT
3.7. Queries from the Twin Project
[+/-]
- 3.8. Using MySQL with Apache
4. MySQL Programs
[+/-]
-
-
4.1. Overview of MySQL Programs
4.2. Using MySQL Programs
[+/-]
- 4.3. MySQL Server and Server-Startup Programs [+/-]
- 4.4. MySQL Installation-Related Programs [+/-]
-
-
4.4.1. comp_err — Compile MySQL Error Message File
4.4.2. make_win_bin_dist — Package MySQL Distribution as ZIP Archive
4.4.3. mysql_fix_privilege_tables — Upgrade MySQL System Tables
4.4.4. mysql_install_db — Initialize MySQL Data Directory
4.4.5. mysql_secure_installation — Improve MySQL Installation Security
4.4.6. mysql_tzinfo_to_sql — Load the Time Zone Tables
4.4.7. mysql_upgrade — Check Tables for MySQL Upgrade
4.5. MySQL Client Programs
[+/-]
-
-
4.5.1. mysql — The MySQL Command-Line Tool
4.5.2. mysqladmin — Client for Administering a MySQL Server
4.5.3. mysqlcheck — A Table Maintenance and Repair Program
4.5.4. mysqldump — A Database Backup Program
4.5.5. mysqlimport — A Data Import Program
4.5.6. mysqlshow — Display Database, Table, and Column Information
4.5.7. mysqlslap — Load Emulation Client
4.6. MySQL Administrative and Utility Programs
[+/-]
-
-
4.6.1. innochecksum — Offline InnoDB File Checksum Utility
4.6.2. myisam_ftdump — Display Full-Text Index information
4.6.3. myisamchk — MyISAM Table-Maintenance Utility
4.6.4. myisamlog — Display MyISAM Log File Contents
4.6.5. myisampack — Generate Compressed, Read-Only MyISAM Tables
4.6.6. mysqlaccess — Client for Checking Access Privileges
4.6.7. mysqlbinlog — Utility for Processing Binary Log Files
4.6.8. mysqlhotcopy — A Database Backup Program
4.6.9. mysqlmanager — The MySQL Instance Manager
4.6.10. mysql_convert_table_format — Convert Tables to Use a Given Storage Engine
4.6.11. mysql_find_rows — Extract SQL Statements from Files
4.6.12. mysql_fix_extensions — Normalize Table Filename Extensions
4.6.13. mysql_setpermission — Interactively Set Permissions in Grant Tables
4.6.14. mysql_tableinfo — Generate Database Metadata
4.6.15. mysql_waitpid — Kill Process and Wait for Its Termination
4.6.16. mysql_zap — Kill Processes That Match a Pattern
4.7. MySQL Program Development Utilities
[+/-]
- 4.8. Miscellaneous Programs [+/-]
5. MySQL Server Administration
[+/-]
-
-
5.1. The MySQL Server
[+/-]
- 5.2. MySQL Server Logs [+/-]
- 5.3. General Security Issues [+/-]
- 5.4. The MySQL Access Privilege System [+/-]
-
-
5.4.1. What the Privilege System Does
5.4.2. How the Privilege System Works
5.4.3. Privileges Provided by MySQL
5.4.4. Connecting to the MySQL Server
5.4.5. Access Control, Stage 1: Connection Verification
5.4.6. Access Control, Stage 2: Request Verification
5.4.7. When Privilege Changes Take Effect
5.4.8. Causes of
Access denied
Errors 5.4.9. Password Hashing as of MySQL 4.1
5.5. MySQL User Account Management
[+/-]
- 5.6. Backup and Recovery [+/-]
- 5.7. Running Multiple MySQL Servers on the Same Machine [+/-]
6. Optimization
[+/-]
-
-
6.1. Optimization Overview
[+/-]
- 6.2. Optimizing
-
-
6.2.1. Optimizing Queries with
EXPLAIN
6.2.2. Estimating Query Performance 6.2.3. Speed ofSELECT
Queries 6.2.4.WHERE
Clause Optimization 6.2.5. Range Optimization 6.2.6. Index Merge Optimization 6.2.7.IS NULL
Optimization 6.2.8.LEFT JOIN
andRIGHT JOIN
Optimization 6.2.9. Nested Join Optimization 6.2.10. Outer Join Simplification 6.2.11.ORDER BY
Optimization 6.2.12.GROUP BY
Optimization 6.2.13.DISTINCT
Optimization 6.2.14. OptimizingIN
/=ANY
Subqueries 6.2.15.LIMIT
Optimization 6.2.16. How to Avoid Table Scans 6.2.17.INFORMATION_SCHEMA
Optimization 6.2.18. Speed ofINSERT
Statements 6.2.19. Speed ofUPDATE
Statements 6.2.20. Speed ofDELETE
Statements 6.2.21. Other Optimization Tips
6.3. Locking Issues
[+/-]
- 6.4. Optimizing Database Structure [+/-]
-
-
6.4.1. Design Choices
6.4.2. Make Your Data as Small as Possible
6.4.3. Column Indexes
6.4.4. Multiple-Column Indexes
6.4.5. How MySQL Uses Indexes
6.4.6. The
MyISAM
Key Cache 6.4.7.MyISAM
Index Statistics Collection 6.4.8. How MySQL Opens and Closes Tables 6.4.9. Drawbacks to Creating Many Tables in the Same Database
6.5. Optimizing the MySQL Server
[+/-]
-
-
6.5.1. System Factors and Startup Parameter Tuning
6.5.2. Tuning Server Parameters
6.5.3. Controlling Query Optimizer Performance
6.5.4. The MySQL Query Cache
6.5.5. Examining Thread Information
6.5.6. How Compiling and Linking Affects the Speed of MySQL
6.5.7. How MySQL Uses Memory
6.5.8. How MySQL Uses Internal Temporary Tables
6.5.9. How MySQL Uses DNS
6.6. Disk Issues
[+/-]
SELECT
and Other Statements [+/-]
7. Language Structure
[+/-]
- 8. Internationalization and Localization [+/-]
-
-
8.1. Character Set Support
[+/-]
-
-
8.1.1. Character Sets and Collations in General
8.1.2. Character Sets and Collations in MySQL
8.1.3. Specifying Character Sets and Collations
8.1.4. Connection Character Sets and Collations
8.1.5. Collation Issues
8.1.6. String Repertoire
8.1.7. Operations Affected by Character Set Support
8.1.8. Unicode Support
8.1.9. UTF-8 for Metadata
8.1.10. Column Character Set Conversion
8.1.11. Character Sets and Collations That MySQL Supports
8.2. The Character Set Used for Data and Sorting
[+/-]
- 8.3. Setting the Error Message Language 8.4. Adding a New Character Set 8.5. The Character Definition Arrays 8.6. String Collating Support 8.7. Multi-Byte Character Support 8.8. Problems With Character Sets 8.9. MySQL Server Time Zone Support 8.10. MySQL Server Locale Support
9. Data Types
[+/-]
-
- 10. Functions and Operators [+/-]
-
-
10.1. Operator and Function Reference
10.2. Operators
[+/-]
- 10.3. Control Flow Functions 10.4. String Functions [+/-]
- 10.5. Numeric Functions [+/-]
- 10.6. Date and Time Functions 10.7. What Calendar Is Used By MySQL? 10.8. Full-Text Search Functions [+/-]
- 10.9. Cast Functions and Operators 10.10. XML Functions 10.11. Other Functions [+/-]
- 10.12. Functions and Modifiers for Use with
GROUP BY
Clauses [+/-]
11. SQL Statement Syntax
[+/-]
-
-
11.1. Data Definition Statements
[+/-]
-
-
11.1.1.
ALTER DATABASE
Syntax 11.1.2.ALTER LOGFILE GROUP
Syntax 11.1.3.ALTER SERVER
Syntax 11.1.4.ALTER TABLE
Syntax 11.1.5.ALTER TABLESPACE
Syntax 11.1.6.CREATE DATABASE
Syntax 11.1.7.CREATE INDEX
Syntax 11.1.8.CREATE LOGFILE GROUP
Syntax 11.1.9.CREATE SERVER
Syntax 11.1.10.CREATE TABLE
Syntax 11.1.11.CREATE TABLESPACE
Syntax 11.1.12.DROP DATABASE
Syntax 11.1.13.DROP INDEX
Syntax 11.1.14.DROP LOGFILE GROUP
Syntax 11.1.15.DROP SERVER
Syntax 11.1.16.DROP TABLE
Syntax 11.1.17.DROP TABLESPACE
Syntax 11.1.18.RENAME DATABASE
Syntax 11.1.19.RENAME TABLE
Syntax
11.2. Data Manipulation Statements
[+/-]
- 11.3. MySQL Utility Statements [+/-]
- 11.4. MySQL Transactional and Locking Statements [+/-]
-
-
11.4.1.
START TRANSACTION
,COMMIT
, andROLLBACK
Syntax 11.4.2. Statements That Cannot Be Rolled Back 11.4.3. Statements That Cause an Implicit Commit 11.4.4.SAVEPOINT
andROLLBACK TO SAVEPOINT
Syntax 11.4.5.LOCK TABLES
andUNLOCK TABLES
Syntax 11.4.6.SET TRANSACTION
Syntax 11.4.7. XA Transactions
11.5. Database Administration Statements
[+/-]
- 11.6. Replication Statements [+/-]
- 11.7. SQL Syntax for Prepared Statements
12. Storage Engines
[+/-]
-
-
-
12.1. Overview of MySQL Storage Engine Architecture
[+/-]
- 12.2. Supported Storage Engines [+/-]
- 12.3. Setting the Storage Engine 12.4. The
- 12.5. The
-
-
12.5.1.
InnoDB
Overview 12.5.2.InnoDB
Contact Information 12.5.3.InnoDB
Configuration 12.5.4.InnoDB
Startup Options and System Variables 12.5.5. Creating theInnoDB
Tablespace 12.5.6. Creating and UsingInnoDB
Tables 12.5.7. Adding and RemovingInnoDB
Data and Log Files 12.5.8. Backing Up and Recovering anInnoDB
Database 12.5.9. Moving anInnoDB
Database to Another Machine 12.5.10.InnoDB
Transaction Model and Locking 12.5.11.InnoDB
Performance Tuning Tips 12.5.12. Implementation of Multi-Versioning 12.5.13.InnoDB
Table and Index Structures 12.5.14.InnoDB
File Space Management and Disk I/O 12.5.15.InnoDB
Error Handling 12.5.16. Restrictions onInnoDB
Tables 12.5.17.InnoDB
Troubleshooting
12.6. The - 12.7. The
- 12.10. The
- 12.12. The
MyISAM
Storage Engine [+/-]InnoDB
Storage Engine [+/-]MERGE
Storage Engine [+/-]MEMORY
(HEAP
) Storage Engine 12.8. TheEXAMPLE
Storage Engine 12.9. TheFEDERATED
Storage Engine [+/-]ARCHIVE
Storage Engine 12.11. TheCSV
Storage Engine [+/-]BLACKHOLE
Storage Engine
13. High Availability, Scalability, and DRBD
[+/-]
- 14. Replication [+/-]
-
-
14.1. Replication Configuration
[+/-]
- 14.2. Replication Solutions [+/-]
-
-
14.2.1. Using Replication for Backups
14.2.2. Using Replication with Different Master and Slave Storage Engines
14.2.3. Using Replication for Scale-Out
14.2.4. Replicating Different Databases to Different Slaves
14.2.5. Improving Replication Performance
14.2.6. Switching Masters During Failover
14.2.7. Setting Up Replication Using SSL
14.3. Replication Notes and Tips
[+/-]
- 14.4. Replication Implementation [+/-]
15. MySQL Cluster
[+/-]
-
-
15.1. MySQL Cluster Overview
[+/-]
- 15.2. MySQL Cluster 5.1 Carrier Grade Edition [+/-]
- 15.3. Simple Multi-Computer How-To [+/-]
- 15.4. MySQL Cluster Configuration [+/-]
- 15.5. Upgrading and Downgrading MySQL Cluster [+/-]
- 15.6. Process Management in MySQL Cluster [+/-]
- 15.7. Management of MySQL Cluster [+/-]
- 15.8. On-line Backup of MySQL Cluster [+/-]
- 15.9. Cluster Utility Programs [+/-]
-
-
15.9.1. ndb_config — Extract NDB Configuration Information
15.9.2. ndb_cpcd — Automate Testing for NDB Development
15.9.3. ndb_delete_all — Delete All Rows from NDB Table
15.9.4. ndb_desc — Describe NDB Tables
15.9.5. ndb_drop_index — Drop Index from NDB Table
15.9.6. ndb_drop_table — Drop NDB Table
15.9.7. ndb_error_reporter — NDB Error-Reporting Utility
15.9.8. ndb_print_backup_file — Print NDB Backup File Contents
15.9.9. ndb_print_schema_file — Print NDB Schema File Contents
15.9.10. ndb_print_sys_file — Print NDB System File Contents
15.9.11. ndbd_redo_log_reader — Check and Print Content of Cluster Redo Log
15.9.12. ndb_select_all — Print Rows from NDB Table
15.9.13. ndb_select_count — Print Row Counts for NDB Tables
15.9.14. ndb_show_tables — Display List of NDB Tables
15.9.15. ndb_size.pl — NDBCluster Size Requirement Estimator
15.9.16. ndb_waiter — Wait for Cluster to Reach a Given Status
15.10. MySQL Cluster Replication
[+/-]
-
-
15.10.1. Abbreviations and Symbols
15.10.2. Assumptions and General Requirements
15.10.3. Known Issues in MySQL Cluster Replication
15.10.4. Cluster Replication Schema and Tables
15.10.5. Preparing the Cluster for Replication
15.10.6. Starting Replication (Single Replication Channel)
15.10.7. Using Two Replication Channels
15.10.8. Implementing Failover with MySQL Cluster
15.10.9. MySQL Cluster Backups With Replication
15.10.10. MySQL Cluster Replication Conflict Resolution
15.11. MySQL Cluster Disk Data Tables
[+/-]
- 15.12. Using High-Speed Interconnects with MySQL Cluster [+/-]
- 15.13. Known Limitations of MySQL Cluster [+/-]
-
-
15.13.1. Non-Compliance In SQL Syntax
15.13.2. Limits and Differences from Standard MySQL Limits
15.13.3. Limits Relating to Transaction Handling
15.13.4. Error Handling
15.13.5. Limits Associated with Database Objects
15.13.6. Unsupported Or Missing Features
15.13.7. Limitations Relating to Performance
15.13.8. Issues Exclusive to MySQL Cluster
15.13.9. Limitations Relating to Disk Data Storage
15.13.10. Limitations Relating to Multiple Cluster Nodes
15.13.11. Previous MySQL Cluster Issues Resolved in MySQL 5.1
15.14. MySQL Cluster Development Roadmap
[+/-]
- 15.15. MySQL Cluster Glossary
16. Partitioning
[+/-]
- 17. Spatial Extensions [+/-]
-
-
17.1. Introduction to MySQL Spatial Support
17.2. The OpenGIS Geometry Model
[+/-]
-
-
17.2.1. The Geometry Class Hierarchy
17.2.2. Class
Geometry
17.2.3. ClassPoint
17.2.4. ClassCurve
17.2.5. ClassLineString
17.2.6. ClassSurface
17.2.7. ClassPolygon
17.2.8. ClassGeometryCollection
17.2.9. ClassMultiPoint
17.2.10. ClassMultiCurve
17.2.11. ClassMultiLineString
17.2.12. ClassMultiSurface
17.2.13. ClassMultiPolygon
17.3. Supported Spatial Data Formats
[+/-]
- 17.4. Creating a Spatially Enabled MySQL Database [+/-]
- 17.5. Analyzing Spatial Information [+/-]
-
-
17.5.1. Geometry Format Conversion Functions
17.5.2.
Geometry
Functions 17.5.3. Functions That Create New Geometries from Existing Ones 17.5.4. Functions for Testing Spatial Relations Between Geometric Objects 17.5.5. Relations on Geometry Minimal Bounding Rectangles (MBRs) 17.5.6. Functions That Test Spatial Relationships Between Geometries
17.6. Optimizing Spatial Analysis
[+/-]
- 17.7. MySQL Conformance and Compatibility
18. Stored Procedures and Functions
[+/-]
-
-
-
18.1. Stored Routines and the Grant Tables
18.2. Stored Routine Syntax
[+/-]
-
-
18.2.1.
CREATE PROCEDURE
andCREATE FUNCTION
Syntax 18.2.2.ALTER PROCEDURE
andALTER FUNCTION
Syntax 18.2.3.DROP PROCEDURE
andDROP FUNCTION
Syntax 18.2.4.CALL
Statement Syntax 18.2.5.BEGIN ... END
Compound Statement Syntax 18.2.6.DECLARE
Statement Syntax 18.2.7. Variables in Stored Routines 18.2.8. Conditions and Handlers 18.2.9. Cursors 18.2.10. Flow Control Constructs
18.3. Stored Procedures, Functions, Triggers, and
LAST_INSERT_ID()
18.4. Binary Logging of Stored Routines and Triggers
19. Triggers
[+/-]
-
- 20. Event Scheduler [+/-]
- 21. Views [+/-]
- 22.
-
-
22.1. The
INFORMATION_SCHEMA SCHEMATA
Table 22.2. TheINFORMATION_SCHEMA TABLES
Table 22.3. TheINFORMATION_SCHEMA COLUMNS
Table 22.4. TheINFORMATION_SCHEMA STATISTICS
Table 22.5. TheINFORMATION_SCHEMA USER_PRIVILEGES
Table 22.6. TheINFORMATION_SCHEMA SCHEMA_PRIVILEGES
Table 22.7. TheINFORMATION_SCHEMA TABLE_PRIVILEGES
Table 22.8. TheINFORMATION_SCHEMA COLUMN_PRIVILEGES
Table 22.9. TheINFORMATION_SCHEMA CHARACTER_SETS
Table 22.10. TheINFORMATION_SCHEMA COLLATIONS
Table 22.11. TheINFORMATION_SCHEMA COLLATION_CHARACTER_SET_APPLICABILITY
Table 22.12. TheINFORMATION_SCHEMA TABLE_CONSTRAINTS
Table 22.13. TheINFORMATION_SCHEMA KEY_COLUMN_USAGE
Table 22.14. TheINFORMATION_SCHEMA ROUTINES
Table 22.15. TheINFORMATION_SCHEMA VIEWS
Table 22.16. TheINFORMATION_SCHEMA TRIGGERS
Table 22.17. TheINFORMATION_SCHEMA PLUGINS
Table 22.18. TheINFORMATION_SCHEMA ENGINES
Table 22.19. TheINFORMATION_SCHEMA PARTITIONS
Table 22.20. TheINFORMATION_SCHEMA EVENTS
Table 22.21. TheINFORMATION_SCHEMA FILES
Table 22.22. TheINFORMATION_SCHEMA PROCESSLIST
Table 22.23. TheINFORMATION_SCHEMA REFERENTIAL_CONSTRAINTS
Table 22.24. TheINFORMATION_SCHEMA GLOBAL_STATUS
andSESSION_STATUS
Tables 22.25. TheINFORMATION_SCHEMA GLOBAL_VARIABLES
andSESSION_VARIABLES
Tables 22.26. OtherINFORMATION_SCHEMA
Tables 22.27. Extensions toSHOW
Statements
23. Precision Math
[+/-]
- 24. APIs and Libraries [+/-]
-
-
24.1. libmysqld, the Embedded MySQL Server Library
[+/-]
- 24.2. MySQL C API [+/-]
-
-
24.2.1. C API Data Types
24.2.2. C API Function Overview
24.2.3. C API Function Descriptions
24.2.4. C API Prepared Statements
24.2.5. C API Prepared Statement Data types
24.2.6. C API Prepared Statement Function Overview
24.2.7. C API Prepared Statement Function Descriptions
24.2.8. C API Prepared Statement Problems
24.2.9. C API Handling of Multiple Statement Execution
24.2.10. C API Handling of Date and Time Values
24.2.11. C API Threaded Function Descriptions
24.2.12. C API Embedded Server Function Descriptions
24.2.13. Controlling Automatic Reconnect Behavior
24.2.14. Common Questions and Problems When Using the C API
24.2.15. Building Client Programs
24.2.16. How to Make a Threaded Client
24.3. MySQL PHP API
[+/-]
- 24.4. MySQL Perl API 24.5. MySQL C++ API 24.6. MySQL Python API 24.7. MySQL Tcl API 24.8. MySQL Eiffel Wrapper
25. Connectors
[+/-]
- 26. MySQL Proxy [+/-]
-
-
26.1. MySQL Proxy Supported Platforms
26.2. Installing MySQL Proxy
[+/-]
- 26.3. MySQL Proxy Command Line Options 26.4. MySQL Proxy Scripting [+/-]
-
-
26.4.1. Proxy Scripting Sequence During Query Injection
26.4.2. Internal Structures
26.4.3. Capturing a connection with
connect_server()
26.4.4. Examining the handshake withread_handshake()
26.4.5. Examining the authentication credentials withread_auth()
26.4.6. Accessing authentication information withread_auth_result()
26.4.7. Manipulating Queries withread_query()
26.4.8. Manipulating Results withread_query_result()
26.5. Using MySQL Proxy
[+/-]
27. Extending MySQL
[+/-]
- A. MySQL 5.1 Frequently Asked Questions [+/-]
-
-
A.1. MySQL 5.1 FAQ — General
A.2. MySQL 5.1 FAQ — Storage Engines
A.3. MySQL 5.1 FAQ — Server SQL Mode
A.4. MySQL 5.1 FAQ — Stored Procedures
A.5. MySQL 5.1 FAQ — Triggers
A.6. MySQL 5.1 FAQ — Views
A.7. MySQL 5.0 FAQ —
-
-
A.14.1. Distributed Replicated Block Device
A.14.2. Linux Heartbeat
A.14.3. DRBD Architecture
A.14.4. DRBD and MySQL Replication
A.14.5. DRBD and File Systems
A.14.6. DRBD and LVM
A.14.7. DRBD and Virtualization
A.14.8. DRBD and Security
A.14.9. DRBD and System Requirements
A.14.10. DBRD and Support and Consulting
INFORMATION_SCHEMA
A.8. MySQL 5.1 FAQ — Migration A.9. MySQL 5.1 FAQ — Security A.10. MySQL 5.1 FAQ — MySQL Cluster A.11. MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets A.12. MySQL 5.1 FAQ — Connectors & APIs A.13. MySQL 5.1 FAQ — Replication A.14. MySQL 5.1 FAQ — MySQL, DRBD, and Heartbeat [+/-]
B. Errors, Error Codes, and Common Problems
[+/-]
-
- C. MySQL Change History [+/-]
-
-
C.1. Changes in release 5.1.x (Development)
[+/-]
-
-
C.1.1. Changes in MySQL 5.1.23 (Not yet released)
C.1.2. Changes in MySQL 5.1.23 Carrier Grade Edition
C.1.3. Changes in MySQL 5.1.22 (24 September 2007: Release Candidate)
C.1.4. Changes in MySQL 5.1.22 Carrier Grade Edition
C.1.5. Changes in MySQL 5.1.21 (16 August 2007)
C.1.6. Changes in MySQL 5.1.20 (25 June 2007)
C.1.7. Changes in MySQL 5.1.19 (25 May 2007)
C.1.8. Changes in MySQL 5.1.19 Carrier Grade Edition
C.1.9. Changes in MySQL 5.1.18 (08 May 2007)
C.1.10. Changes in MySQL 5.1.18 Carrier Grade Edition
C.1.11. Changes in MySQL 5.1.17 (04 April 2007)
C.1.12. Changes in MySQL 5.1.16 (26 February 2007)
C.1.13. Changes in MySQL 5.1.16 Carrier Grade Edition
C.1.14. Changes in MySQL 5.1.15 (25 January 2007)
C.1.15. Changes in MySQL 5.1.15 Carrier Grade Edition
C.1.16. Changes in MySQL 5.1.14 (05 December 2006)
C.1.17. Changes in MySQL 5.1.14 Carrier Grade Edition
C.1.18. Changes in MySQL 5.1.13 (Not released)
C.1.19. Changes in MySQL 5.1.12 (24 October 2006)
C.1.20. Changes in MySQL 5.1.11 (26 May 2006)
C.1.21. Changes in MySQL 5.1.10 (Not released)
C.1.22. Changes in MySQL 5.1.9 (12 April 2006)
C.1.23. Changes in MySQL 5.1.8 (Not released)
C.1.24. Changes in MySQL 5.1.7 (27 February 2006)
C.1.25. Changes in MySQL 5.1.6 (01 February 2006)
C.1.26. Changes in MySQL 5.1.5 (10 January 2006)
C.1.27. Changes in MySQL 5.1.4 (21 December 2005)
C.1.28. Changes in MySQL 5.1.3 (29 November 2005)
C.1.29. Changes in MySQL 5.1.2 (Not released)
C.1.30. Changes in MySQL 5.1.1 (Not released)
C.2. MySQL Connector/ODBC (MyODBC) Change History
[+/-]
-
-
C.2.1. Changes in MySQL Connector/ODBC 5.1.2 (Not yet released)
C.2.2. Changes in MySQL Connector/ODBC 5.1.1 (13 December 2007)
C.2.3. Changes in MySQL Connector/ODBC 5.1.0 (10 September 2007)
C.2.4. Changes in MySQL Connector/ODBC 5.0.12 (Never released)
C.2.5. Changes in MySQL Connector/ODBC 5.0.11 (31 January 2007)
C.2.6. Changes in MySQL Connector/ODBC 5.0.10 (14 December 2006)
C.2.7. Changes in MySQL Connector/ODBC 5.0.9 (22 November 2006)
C.2.8. Changes in MySQL Connector/ODBC 5.0.8 (17 November 2006)
C.2.9. Changes in MySQL Connector/ODBC 5.0.7 (08 November 2006)
C.2.10. Changes in MySQL Connector/ODBC 5.0.6 (03 November 2006)
C.2.11. Changes in MySQL Connector/ODBC 5.0.5 (17 October 2006)
C.2.12. Changes in Connector/ODBC 5.0.3 (Connector/ODBC 5.0 Alpha 3) (20 June 2006)
C.2.13. Changes in Connector/ODBC 5.0.2 (Never released)
C.2.14. Changes in Connector/ODBC 5.0.1 (Connector/ODBC 5.0 Alpha 2) (05 June 2006)
C.2.15. Changes in MySQL Connector/ODBC 3.51.23 (Not yet released)
C.2.16. Changes in MySQL Connector/ODBC 3.51.22 (13 November 2007)
C.2.17. Changes in MySQL Connector/ODBC 3.51.21 (08 October 2007)
C.2.18. Changes in MySQL Connector/ODBC 3.51.20 (10 September 2007)
C.2.19. Changes in MySQL Connector/ODBC 3.51.19 (10 August 2007)
C.2.20. Changes in MySQL Connector/ODBC 3.51.18 (08 August 2007)
C.2.21. Changes in MySQL Connector/ODBC 3.51.17 (14 July 2007)
C.2.22. Changes in MySQL Connector/ODBC 3.51.16 (14 June 2007)
C.2.23. Changes in MySQL Connector/ODBC 3.51.15 (7 May 2007)
C.2.24. Changes in MySQL Connector/ODBC 3.51.14 (08 March 2007)
C.2.25. Changes in MySQL Connector/ODBC 3.51.13 (Never released)
C.2.26. Changes in MySQL Connector/ODBC 3.51.12 (11 Febrauary 2005)
C.2.27. Changes in MySQL Connector/ODBC 3.51.11 (28 January 2005)
C.3. MySQL Connector/NET Change History
[+/-]
-
-
C.3.1. Changes in MySQL Connector/NET 5.2.0 (Not yet released)
C.3.2. Changes in MySQL Connector/NET 5.1.4 (20 November 2007)
C.3.3. Changes in MySQL Connector/NET 5.1.3 (21 September 2007)
C.3.4. Changes in MySQL Connector/NET 5.1.2 (18 June 2007)
C.3.5. Changes in MySQL Connector/NET 5.1.1 (23 May 2007)
C.3.6. Changes in MySQL Connector/NET 5.1.0 (01 May 2007)
C.3.7. Changes in MySQL Connector/NET 5.0.9 (Not yet released)
C.3.8. Changes in MySQL Connector/NET 5.0.8 (21 August 2007)
C.3.9. Changes in MySQL Connector/NET 5.0.7 (18 May 2007)
C.3.10. Changes in MySQL Connector/NET 5.0.6 (22 March 2007)
C.3.11. Changes in MySQL Connector/NET 5.0.5 (07 March 2007)
C.3.12. Changes in MySQL Connector/NET 5.0.4 (Not released)
C.3.13. Changes in MySQL Connector/NET 5.0.3 (05 January 2007)
C.3.14. Changes in MySQL Connector/NET 5.0.2 (06 November 2006)
C.3.15. Changes in MySQL Connector/NET 5.0.1 (01 October 2006)
C.3.16. Changes in MySQL Connector/NET 5.0.0 (08 August 2006)
C.3.17. Changes in MySQL Connector/NET 1.0.11 (Not yet released)
C.3.18. Changes in MySQL Connector/NET 1.0.10 (24 August 2007)
C.3.19. Changes in MySQL Connector/NET 1.0.9 (02 February 2007)
C.3.20. Changes in MySQL Connector/NET 1.0.8 (20 October 2006)
C.3.21. Changes in MySQL Connector/NET 1.0.7 (21 November 2005)
C.3.22. Changes in MySQL Connector/NET 1.0.6 (03 October 2005)
C.3.23. Changes in MySQL Connector/NET 1.0.5 (29 August 2005)
C.3.24. Changes in MySQL Connector/NET 1.0.4 (20 January 2005)
C.3.25. Changes in MySQL Connector/NET 1.0.3 (12 October 2004)
C.3.26. Changes in MySQL Connector/NET 1.0.2 (15 November 2004)
C.3.27. Changes in MySQL Connector/NET 1.0.1 (27 October 2004)
C.3.28. Changes in MySQL Connector/NET 1.0.0 (01 September 2004)
C.3.29. Changes in MySQL Connector/NET Version 0.9.0 (30 August 2004)
C.3.30. Changes in MySQL Connector/NET Version 0.76
C.3.31. Changes in MySQL Connector/NET Version 0.75
C.3.32. Changes in MySQL Connector/NET Version 0.74
C.3.33. Changes in MySQL Connector/NET Version 0.71
C.3.34. Changes in MySQL Connector/NET Version 0.70
C.3.35. Changes in MySQL Connector/NET Version 0.68
C.3.36. Changes in MySQL Connector/NET Version 0.65
C.3.37. Changes in MySQL Connector/NET Version 0.60
C.3.38. Changes in MySQL Connector/NET Version 0.50
C.4. MySQL Visual Studio Plugin Change History
[+/-]
- C.5. MySQL Connector/J Change History [+/-]
-
-
C.5.1. Changes in MySQL Connector/J 5.1.x
C.5.2. Changes in MySQL Connector/J 5.0.x
C.5.3. Changes in MySQL Connector/J 3.1.x
C.5.4. Changes in MySQL Connector/J 3.0.x
C.5.5. Changes in MySQL Connector/J 2.0.x
C.5.6. Changes in MySQL Connector/J 1.2b (04 July 1999)
C.5.7. Changes in MySQL Connector/J 1.2.x and lower
C.6. MySQL Connector/MXJ Change History
[+/-]
-
-
C.6.1. Changes in MySQL Connector/MXJ 5.0.6 (04 May 2007)
C.6.2. Changes in MySQL Connector/MXJ 5.0.5 (14 March 2007)
C.6.3. Changes in MySQL Connector/MXJ 5.0.4 (28 January 2007)
C.6.4. Changes in MySQL Connector/MXJ 5.0.3 (24 June 2006)
C.6.5. Changes in MySQL Connector/MXJ 5.0.2 (15 June 2006)
C.6.6. Changes in MySQL Connector/MXJ 5.0.1 (Never released)
C.6.7. Changes in MySQL Connector/MXJ 5.0.0 (09 December 2005)
C.7. MySQL Proxy Change History
[+/-]
D. Limits and Restrictions
[+/-]
-
- E. Credits [+/-]
- Index
INFORMATION_SCHEMA
Tables
[+/-]
List of Figures
-
12.1.
The MySQL architecture using pluggable storage engines
12.2.
FEDERATED
table structure
13.1.
DRBD Architecture
13.2.
DRBD Architecture
13.3.
DRBD Architecture
14.1.
Using replication to improve the performance during scaleout
14.2.
Using replication to replicate separate DBs to multiple hosts
14.3.
Using an additional replication host to improve performance
14.4.
Redundancy using replication, initial structure
14.5.
Redundancy using replication, after master failure
A.1.
Active-Master MySQL server
List of Tables
-
2.1.
Build (
configure
) Reference
4.1.
mysqld_safe Option Reference
4.2.
mysql Option Reference
4.3.
mysqladmin Option Reference
4.4.
mysqlcheck Option Reference
4.5.
mysqldump Option Reference
4.6.
mysqlimport Option Reference
4.7.
mysqlimport Option Reference
4.8.
mysqlslap Option Reference
4.9.
myisamchk Option Reference
4.10.
mysqlaccess Option Reference
4.11.
mysqlbinlog Option Reference
4.12.
mysqlhotcopy Option Reference
4.13.
mysql_tableinfo Option Reference
25.1.
Mapping of MySQL Error Numbers to SQLStates
List of Examples
-
25.1.
Obtaining a connection from the
DriverManager
25.2.
Using java.sql.Statement to execute a SELECT
query
25.3.
Stored Procedures
25.4.
Using Connection.prepareCall()
25.5.
Registering output parameters
25.6.
Setting CallableStatement
input parameters
25.7.
Retrieving results and output parameter values
25.8.
Retrieving AUTO_INCREMENT
column values using Statement.getGeneratedKeys()
25.9.
Retrieving AUTO_INCREMENT
column values using SELECT LAST_INSERT_ID()
25.10.
Retrieving AUTO_INCREMENT
column values in Updatable ResultSets
25.11.
Using a connection pool with a J2EE application server
25.12.
Example of transaction with retry logic
MySQL 5.1参考手册
这是MySQL参考手册的翻译版本,关于MySQL参考手册,请访问dev.mysql.com。 原始参考手册为英文版,与英文版参考手册相比,本翻译版可能不是最新的。
This translation was done by MySQL partner GreatLinux, Beijing, People's Republic of China. GreatLinux Inc. 北京万里开源软件有限公司在全国范围提供MySQL产品相关的商务及 技术方面的咨询与支持服务。垂询请致电:8610-65694500,或发送邮件至: sales@greatlinux.com.
摘要
这是MySQL参考手册 它涉及MySQL 5.1至5.1.2-alpha版本。
文档生成于: 2005-11-15
目录
-
前言
1. 一般信息
- 2. 安装MySQL
-
-
2.1. 一般安装问题
- 2.2. 使用二进制分发版的标准MySQL安装 2.3. 在Windows上安装MySQL
-
-
2.3.1. Windows系统要求
2.3.2. 选择安装软件包
2.3.3. 用自动安装器安装MySQL
2.3.4. 使用MySQL安装向导
2.3.5. 使用配置向导
2.3.6. 通过非安装Zip文件安装MySQL
2.3.7. 提取安装档案文件
2.3.8. 创建选项文件
2.3.9. 选择MySQL服务器类型
2.3.10. 首次启动服务器
2.3.11. 从Windows命令行启动MySQL
2.3.12. 以Windows服务方式启动MySQL
2.3.13. 测试MySQL安装
2.3.14. 在Windows环境下对MySQL安装的故障诊断与排除
2.3.15. 在Windows下升级MySQL
2.3.16. Windows版MySQL同Unix版MySQL对比
2.4. 在Linux下安装MySQL
2.5.在Mac OS X中安装MySQL
2.6. 在NetWare中安装MySQL
2.7. 在其它类Unix系统中安装MySQL
2.8. 使用源码分发版安装MySQL
- 2.9. 安装后的设置和测试
- 2.10. 升级MySQL
- 2.11. 降级MySQL 2.12. 具体操作系统相关的注意事项
- 2.13. Perl安装注意事项
3. 教程
- 4. MySQL程序概述
- 5. 数据库管理
- 6. MySQL中的复制
- 7. 优化
-
-
7.1. 优化概述
- 7.2. 优化SELECT语句和其它查询
-
-
7.2.1. EXPLAIN语法(获取SELECT相关信息)
7.2.2. 估计查询性能 7.2.3. SELECT查询的速度 7.2.4. MySQL怎样优化WHERE子句
7.2.5. 范围优化 7.2.6. 索引合并优化 7.2.7. MySQL如何优化IS NULL
7.2.8. MySQL如何优化DISTINCT
7.2.9. MySQL如何优化LEFT JOIN和RIGHT JOIN 7.2.10. MySQL如何优化嵌套Join 7.2.11. MySQL如何简化外部联合 7.2.12. MySQL如何优化ORDER BY
7.2.13. MySQL如何优化GROUP BY
7.2.14. MySQL如何优化LIMIT
7.2.15. 如何避免表扫描 7.2.16. INSERT语句的速度 7.2.17. UPDATE语句的速度 7.2.18. DELETE语句的速度 7.2.19. 其它优化技巧
7.3. 锁定事宜
- 7.4. 优化数据库结构
- 7.5. 优化MySQL服务器
- 7.6. 磁盘事宜
8. 客户端和实用工具程序
-
-
8.1. 客户端脚本和实用工具概述
8.2. myisampack:生成压缩、只读MyISAM表
8.3. mysql:MySQL命令行工具
- 8.4. mysqlaccess:用于检查访问权限的客户端 8.5. mysqladmin:用于管理MySQL服务器的客户端 8.6. mysqlbinlog:用于处理二进制日志文件的实用工具 8.7. mysqlcheck:表维护和维修程序 8.8. mysqldump:数据库备份程序 8.9. mysqlhotcopy:数据库备份程序 8.10. mysqlimport:数据导入程序 8.11. mysqlshow-显示数据库、表和列信息 8.12. myisamlog:显示MyISAM日志文件内容 8.13. perror:解释错误代码 8.14. replace:字符串替换实用工具 8.15. mysql_zap:杀死符合某一模式的进程
9. 语言结构
- 10. 字符集支持
- 11. 列类型
- 12. 函数和操作符
- 13. SQL语句语法
- 14. 插件式存储引擎体系结构
- 15. 存储引擎和表类型
-
-
15.1. MyISAM存储引擎
- 15.2. InnoDB存储引擎
-
-
15.2.1. InnoDB概述
15.2.2. InnoDB联系信息
15.2.3. InnoDB配置
15.2.4. InnoDB启动选项
15.2.5. 创建InnoDB表空间
15.2.6. 创建InnoDB表
15.2.7. 添加和删除InnoDB数据和日志文件
15.2.8. InnoDB数据库的备份和恢复
15.2.9. 将InnoDB数据库移到另一台机器上 15.2.10. InnoDB事务模型和锁定 15.2.11. InnoDB性能调节提示 15.2.12. 多版本的实施 15.2.13. 表和索引结构 15.2.14. 文件空间管理和磁盘I/O 15.2.15. InnoDB错误处理 15.2.16. 对InnoDB表的限制
15.2.17. InnoDB故障诊断与排除
15.3. MERGE存储引擎
- 15.4. MEMORY (HEAP)存储引擎 15.5. BDB (BerkeleyDB)存储引擎
- 15.6. EXAMPLE存储引擎 15.7. FEDERATED存储引擎
- 15.8. ARCHIVE存储引擎 15.9. CSV存储引擎 15.10. BLACKHOLE存储引擎
16. 编写自定义存储引擎
- 17. MySQL簇
- 18. 分区
- 19. MySQL中的空间扩展
- 20. 存储程序和函数
-
-
20.1. 存储程序和授权表
20.2. 存储程序的语法
-
-
20.2.1. CREATE PROCEDURE和CREATE FUNCTION
20.2.2. ALTER PROCEDURE和ALTER FUNCTION
20.2.3. DROP PROCEDURE和DROP FUNCTION
20.2.4. SHOW CREATE PROCEDURE和SHOW CREATE FUNCTION
20.2.5. SHOW PROCEDURE STATUS和SHOW FUNCTION STATUS
20.2.6. CALL语句
20.2.7. BEGIN ... END复合语句
20.2.8. DECLARE语句
20.2.9. 存储程序中的变量
20.2.10. 条件和处理程序
20.2.11. 光标
20.2.12. 流程控制构造
20.3. 存储程序、函数、触发程序和复制:常见问题
20.4. 存储子程序和触发程序的二进制日志功能
21. 触发程序
-
- 22. 视图
- 23. INFORMATION_SCHEMA信息数据库
-
-
23.1. INFORMATION_SCHEMA表
-
-
23.1.1. INFORMATION_SCHEMA SCHEMATA表
23.1.2. INFORMATION_SCHEMA TABLES表
23.1.3. INFORMATION_SCHEMA COLUMNS表
23.1.4. INFORMATION_SCHEMA STATISTICS表
23.1.5. INFORMATION_SCHEMA USER_PRIVILEGES表
23.1.6. INFORMATION_SCHEMA SCHEMA_PRIVILEGES表
23.1.7. INFORMATION_SCHEMA TABLE_PRIVILEGES表
23.1.8. INFORMATION_SCHEMA COLUMN_PRIVILEGES表
23.1.9. INFORMATION_SCHEMA CHARACTER_SETS表
23.1.10. INFORMATION_SCHEMA COLLATIONS表
23.1.11. INFORMATION_SCHEMA COLLATION_CHARACTER_SET_APPLICABILITY表
23.1.12. INFORMATION_SCHEMA TABLE_CONSTRAINTS表
23.1.13. INFORMATION_SCHEMA KEY_COLUMN_USAGE表
23.1.14. INFORMATION_SCHEMA ROUTINES表
23.1.15. INFORMATION_SCHEMA VIEWS表
23.1.16. INFORMATION_SCHEMA TRIGGERS表
23.1.17. 其他INFORMATION_SCHEMA表
23.2. SHOW语句的扩展
24. 精度数学
-
- 25. API和库
-
-
25.1. libmysqld,嵌入式MySQL服务器库
- 25.2. MySQL C API
-
-
25.2.1. C API数据类型
25.2.2. C API函数概述
25.2.3. C API函数描述
25.2.4. C API预处理语句
25.2.5. C API预处理语句的数据类型
25.2.6. C API预处理语句函数概述
25.2.7. C API预处理语句函数描述
25.2.8. C API预处理语句方面的问题
25.2.9. 多查询执行的C API处理
25.2.10. 日期和时间值的C API处理
25.2.11. C API线程函数介绍
25.2.12. C API嵌入式服务器函数介绍
25.2.13. 使用C API时的常见问题
25.2.14. 创建客户端程序
25.2.15. 如何生成线程式客户端
25.3. MySQL PHP API
- 25.4. MySQL Perl API 25.5. MySQL C++ API
- 25.6. MySQL Python API 25.7. MySQL Tcl API 25.8. MySQL Eiffel Wrapper 25.9. MySQL程序开发实用工具
26. 连接器
-
-
26.1. MySQL Connector/ODBC
-
-
26.1.1. MyODBC介绍
26.1.2. 关于ODBC和MyODBC的一般信息
26.1.3. 如何安装MyODBC
26.1.4. 在Windows平台上从二进制版本安装MyODBC
26.1.5. I在Unix平台上从二进制版本安装MyODBC
26.1.6. 在Windows平台上从源码版本安装MyODBC
26.1.7. 在Unix平台上从源码版本安装MyODBC
26.1.8. 从BitKeeper开发源码树安装MyODBC
26.1.9. MyODBC配置
26.1.10. 与MyODBC连接相关的事宜
26.1.11. MyODBC和Microsoft Access
26.1.12. MyODBC和Microsoft VBA及ASP
26.1.13. MyODBC和第三方ODBC工具
26.1.14. MyODBC通用功能
26.1.15. 基本的MyODBC应用步骤
26.1.16. MyODBC API引用
26.1.17. MyODBC数据类型
26.1.18. MyODBC错误代码
26.1.19. MyODBC与VB:ADO、DAO和RDO
26.1.20. MyODBC与Microsoft.NET
26.1.21. 感谢
26.2. MySQL Connector/NET
- 26.3. MySQL Connector/J
- 26.4. MySQL Connector/MXJ
27. 扩展MySQL
-
- A. 问题和常见错误
- B. 错误代码和消息
- C. 感谢
- D. MySQL变更史
- E. 移植到其他系统
- F. 环境变量 G. MySQL正则表达式 H. MySQL中的限制
- I. 特性限制
- J. GNU通用公共许可 K. MySQL FLOSS许可例外 索引
图形清单
-
14.1.
MySQL插件式存储引擎的体系结构
14.2.
存储引擎比较
16.1.
MySQL体系结构
表格清单
-
26.1.
连接属性
26.2.
转换表
26.3.
用于ResultSet.getObject()的MySQL类型和Java类型
26.4.
MySQL对Java编码名称的翻译
示例清单
-
26.1.
从DriverManager获得连接
26.2.
使用java.sql.Statement执行SELECT查询
26.3.
存储程序示例
26.4.
使用Connection.prepareCall()
26.5.
注册输出参数
26.6.
设置CallableStatement输入参数
26.7.
检索结果和输出参数值
26.8.
使用Statement.getGeneratedKeys()检索AUTO_INCREMENT列的值
26.9.
使用SELECT LAST_INSERT_ID()检索AUTO_INCREMENT列的值
26.10.
在可更新的ResultSets中检索AUTO_INCREMENT列的值
26.11.
设置Unix环境下的CLASSPATH
26.12.
与J2EE应用服务器一起使用连接池
26.13.
重试逻辑的事务示例
这是MySQL参考手册的翻译版本,关于MySQL参考手册,请访问dev.mysql.com。 原始参考手册为英文版,与英文版参考手册相比,本翻译版可能不是最新的。
Copyright 1997-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 Reference Manual. It documents MySQL 3.23 through MySQL 4.1.24.
Document generated on: 2008-01-11 (revision: 9563)
End of Product Lifecycle. Active development and support for MySQL database server versions 3.23, 4.0, and 4.1 has ended. However, for MySQL 4.0 and 4.1, there is still extended support available. For details, see http://www.mysql.com/company/legal/lifecycle/#calendar. According to the MySQL Lifecycle Policy (see http://www.mysql.com/company/legal/lifecycle/#policy), only Security and Severity Level 1 issues will still be fixed for MySQL 4.0 and 4.1. Please consider upgrading to a recent version (MySQL 5.0 or 5.1).
Table of Contents [+/-]
-
Preface
1. General Information
[+/-]
- 2. Installing and Upgrading MySQL [+/-]
-
-
2.1. General Installation Issues
[+/-]
- 2.2. Standard MySQL Installation Using a Binary Distribution 2.3. Installing MySQL on Windows [+/-]
-
-
2.3.1. Choosing An Installation Package
2.3.2. Installing MySQL with the Automated Installer
2.3.3. Using the MySQL Installation Wizard
2.3.4. Using the Configuration Wizard
2.3.5. Installing MySQL from a Noinstall Zip Archive
2.3.6. Extracting the Install Archive
2.3.7. Creating an Option File
2.3.8. Selecting a MySQL Server Type
2.3.9. Starting the Server for the First Time
2.3.10. Starting MySQL from the Windows Command Line
2.3.11. Starting MySQL as a Windows Service
2.3.12. Testing The MySQL Installation
2.3.13. Troubleshooting a MySQL Installation Under Windows
2.3.14. Upgrading MySQL on Windows
2.3.15. MySQL on Windows Compared to MySQL on Unix
2.4. Installing MySQL from RPM Packages on Linux
2.5. Installing MySQL on Mac OS X
2.6. Installing MySQL on Solaris
2.7. Installing MySQL on NetWare
2.8. Installing MySQL from - 2.10. Post-Installation Setup and Testing [+/-]
- 2.11. Upgrading MySQL [+/-]
- 2.12. Downgrading MySQL [+/-]
- 2.13. Operating System-Specific Notes [+/-]
- 2.14. Environment Variables 2.15. Perl Installation Notes [+/-]
- 2.16. Porting to Other Systems [+/-]
tar.gz
Packages on Other Unix-Like Systems 2.9. MySQL Installation Using a Source Distribution [+/-]
3. Tutorial
[+/-]
-
-
3.1. Connecting to and Disconnecting from the Server
3.2. Entering Queries
3.3. Creating and Using a Database
[+/-]
- 3.4. Getting Information About Databases and Tables 3.5. Using mysql in Batch Mode 3.6. Examples of Common Queries [+/-]
-
-
3.6.1. The Maximum Value for a Column
3.6.2. The Row Holding the Maximum of a Certain Column
3.6.3. Maximum of Column per Group
3.6.4. The Rows Holding the Group-wise Maximum of a Certain Field
3.6.5. Using User-Defined Variables
3.6.6. Using Foreign Keys
3.6.7. Searching on Two Keys
3.6.8. Calculating Visits Per Day
3.6.9. Using
AUTO_INCREMENT
3.7. Queries from the Twin Project
[+/-]
- 3.8. Using MySQL with Apache
4. MySQL Programs
[+/-]
-
-
4.1. Overview of MySQL Programs
4.2. Using MySQL Programs
[+/-]
- 4.3. MySQL Server and Server-Startup Programs [+/-]
- 4.4. MySQL Installation-Related Programs [+/-]
-
-
4.4.1. comp_err — Compile MySQL Error Message File
4.4.2. make_win_src_distribution — Create Source Distribution for Windows
4.4.3. mysql_create_system_tables — Generate Statements to Initialize MySQL System Tables
4.4.4. mysql_fix_privilege_tables — Upgrade MySQL System Tables
4.4.5. mysql_install_db — Initialize MySQL Data Directory
4.4.6. mysql_secure_installation — Improve MySQL Installation Security
4.4.7. mysql_tzinfo_to_sql — Load the Time Zone Tables
4.5. MySQL Client Programs
[+/-]
-
-
4.5.1. mysql — The MySQL Command-Line Tool
4.5.2. mysqladmin — Client for Administering a MySQL Server
4.5.3. mysqlcheck — A Table Maintenance and Repair Program
4.5.4. mysqldump — A Database Backup Program
4.5.5. mysqlimport — A Data Import Program
4.5.6. mysqlshow — Display Database, Table, and Column Information
4.6. MySQL Administrative and Utility Programs
[+/-]
-
-
4.6.1. myisam_ftdump — Display Full-Text Index information
4.6.2. myisamchk — MyISAM Table-Maintenance Utility
4.6.3. myisamlog — Display MyISAM Log File Contents
4.6.4. myisampack — Generate Compressed, Read-Only MyISAM Tables
4.6.5. mysqlaccess — Client for Checking Access Privileges
4.6.6. mysqlbinlog — Utility for Processing Binary Log Files
4.6.7. mysqlhotcopy — A Database Backup Program
4.6.8. mysqlmanagerc — Internal Test-Suite Program
4.6.9. mysqlmanager-pwgen — Internal Test-Suite Program
4.6.10. mysql_convert_table_format — Convert Tables to Use a Given Storage Engine
4.6.11. mysql_explain_log — Use EXPLAIN on Statements in Query Log
4.6.12. mysql_find_rows — Extract SQL Statements from Files
4.6.13. mysql_fix_extensions — Normalize Table Filename Extensions
4.6.14. mysql_setpermission — Interactively Set Permissions in Grant Tables
4.6.15. mysql_tableinfo — Generate Database Metadata
4.6.16. mysql_waitpid — Kill Process and Wait for Its Termination
4.6.17. mysql_zap — Kill Processes That Match a Pattern
4.7. MySQL Program Development Utilities
[+/-]
- 4.8. Miscellaneous Programs [+/-]
5. MySQL Server Administration
[+/-]
-
-
5.1. The MySQL Server
[+/-]
- 5.2. The mysqld-max Extended MySQL Server 5.3. MySQL Server Logs [+/-]
- 5.4. General Security Issues [+/-]
- 5.5. The MySQL Access Privilege System [+/-]
-
-
5.5.1. What the Privilege System Does
5.5.2. How the Privilege System Works
5.5.3. Privileges Provided by MySQL
5.5.4. Connecting to the MySQL Server
5.5.5. Access Control, Stage 1: Connection Verification
5.5.6. Access Control, Stage 2: Request Verification
5.5.7. When Privilege Changes Take Effect
5.5.8. Causes of
Access denied
Errors 5.5.9. Password Hashing as of MySQL 4.1
5.6. MySQL User Account Management
[+/-]
- 5.7. Backup and Recovery [+/-]
- 5.8. Running Multiple MySQL Servers on the Same Machine [+/-]
6. Replication
[+/-]
-
-
6.1. Introduction to Replication
6.2. Replication Implementation Overview
6.3. Replication Implementation Details
[+/-]
- 6.4. How to Set Up Replication 6.5. Replication Compatibility Between MySQL Versions 6.6. Upgrading a Replication Setup [+/-]
- 6.7. Replication Features and Known Problems 6.8. Replication Startup Options 6.9. How Servers Evaluate Replication Rules 6.10. Replication FAQ 6.11. Troubleshooting Replication 6.12. How to Report Replication Bugs or Problems
7. Optimization
[+/-]
-
-
7.1. Optimization Overview
[+/-]
- 7.2. Optimizing
-
-
7.2.1. Optimizing Queries with
EXPLAIN
7.2.2. Estimating Query Performance 7.2.3. Speed ofSELECT
Queries 7.2.4.WHERE
Clause Optimization 7.2.5. Range Optimization 7.2.6.IS NULL
Optimization 7.2.7.LEFT JOIN
andRIGHT JOIN
Optimization 7.2.8.ORDER BY
Optimization 7.2.9.GROUP BY
Optimization 7.2.10.DISTINCT
Optimization 7.2.11.LIMIT
Optimization 7.2.12. How to Avoid Table Scans 7.2.13. Speed ofINSERT
Statements 7.2.14. Speed ofUPDATE
Statements 7.2.15. Speed ofDELETE
Statements 7.2.16. Other Optimization Tips
7.3. Locking Issues
[+/-]
- 7.4. Optimizing Database Structure [+/-]
-
-
7.4.1. Design Choices
7.4.2. Make Your Data as Small as Possible
7.4.3. Column Indexes
7.4.4. Multiple-Column Indexes
7.4.5. How MySQL Uses Indexes
7.4.6. The
MyISAM
Key Cache 7.4.7.MyISAM
Index Statistics Collection 7.4.8. How MySQL Opens and Closes Tables 7.4.9. Drawbacks to Creating Many Tables in the Same Database
7.5. Optimizing the MySQL Server
[+/-]
-
-
7.5.1. System Factors and Startup Parameter Tuning
7.5.2. Tuning Server Parameters
7.5.3. The MySQL Query Cache
7.5.4. Examining Thread Information
7.5.5. How Compiling and Linking Affects the Speed of MySQL
7.5.6. How MySQL Uses Memory
7.5.7. How MySQL Uses Internal Temporary Tables
7.5.8. How MySQL Uses DNS
7.6. Disk Issues
[+/-]
SELECT
and Other Statements [+/-]
8. Language Structure
[+/-]
- 9. Internationalization and Localization [+/-]
-
-
9.1. Character Set Support
[+/-]
-
-
9.1.1. Character Sets and Collations in General
9.1.2. Character Sets and Collations in MySQL
9.1.3. Specifying Character Sets and Collations
9.1.4. Connection Character Sets and Collations
9.1.5. Collation Issues
9.1.6. Operations Affected by Character Set Support
9.1.7. Unicode Support
9.1.8. UTF-8 for Metadata
9.1.9. Upgrading Character Sets from MySQL 4.0
9.1.10. Character Sets and Collations That MySQL Supports
9.2. The Character Set Used for Data and Sorting
[+/-]
- 9.3. Setting the Error Message Language 9.4. Adding a New Character Set 9.5. The Character Definition Arrays 9.6. String Collating Support 9.7. Multi-Byte Character Support 9.8. Problems With Character Sets 9.9. MySQL Server Time Zone Support 9.10. MySQL Server Locale Support
10. Data Types
[+/-]
-
- 11. Functions and Operators [+/-]
-
-
11.1. Operator and Function Reference
11.2. Operators
[+/-]
- 11.3. Control Flow Functions 11.4. String Functions [+/-]
- 11.5. Numeric Functions [+/-]
- 11.6. Date and Time Functions 11.7. What Calendar Is Used By MySQL? 11.8. Full-Text Search Functions [+/-]
- 11.9. Cast Functions and Operators 11.10. Other Functions [+/-]
- 11.11. Functions and Modifiers for Use with
GROUP BY
Clauses [+/-]
12. SQL Statement Syntax
[+/-]
- 13. Storage Engines [+/-]
-
-
13.1. The
- 13.2. The
-
-
13.2.1.
InnoDB
Overview 13.2.2.InnoDB
Contact Information 13.2.3.InnoDB
in MySQL 3.23 13.2.4.InnoDB
Configuration 13.2.5.InnoDB
Startup Options and System Variables 13.2.6. Creating theInnoDB
Tablespace 13.2.7. Creating and UsingInnoDB
Tables 13.2.8. Adding and RemovingInnoDB
Data and Log Files 13.2.9. Backing Up and Recovering anInnoDB
Database 13.2.10. Moving anInnoDB
Database to Another Machine 13.2.11.InnoDB
Transaction Model and Locking 13.2.12.InnoDB
Performance Tuning Tips 13.2.13. Implementation of Multi-Versioning 13.2.14.InnoDB
Table and Index Structures 13.2.15.InnoDB
File Space Management and Disk I/O 13.2.16.InnoDB
Error Handling 13.2.17. Restrictions onInnoDB
Tables 13.2.18.InnoDB
Troubleshooting
13.3. The - 13.4. The
- 13.6. The
MyISAM
Storage Engine [+/-]InnoDB
Storage Engine [+/-]MERGE
Storage Engine [+/-]MEMORY
(HEAP
) Storage Engine 13.5. TheBDB
(BerkeleyDB
) Storage Engine [+/-]EXAMPLE
Storage Engine 13.7. TheARCHIVE
Storage Engine 13.8. TheCSV
Storage Engine 13.9. TheBLACKHOLE
Storage Engine 13.10. TheISAM
Storage Engine
14. MySQL Cluster
[+/-]
-
-
14.1. MySQL Cluster Overview
[+/-]
- 14.2. Simple Multi-Computer How-To [+/-]
- 14.3. MySQL Cluster Configuration [+/-]
- 14.4. Upgrading and Downgrading MySQL Cluster [+/-]
- 14.5. Process Management in MySQL Cluster [+/-]
- 14.6. Management of MySQL Cluster [+/-]
- 14.7. On-line Backup of MySQL Cluster [+/-]
- 14.8. Cluster Utility Programs [+/-]
-
-
14.8.1. ndb_config — Extract NDB Configuration Information
14.8.2. ndb_cpcd — Automate Testing for NDB Development
14.8.3. ndb_delete_all — Delete All Rows from NDB Table
14.8.4. ndb_desc — Describe NDB Tables
14.8.5. ndb_drop_index — Drop Index from NDB Table
14.8.6. ndb_drop_table — Drop NDB Table
14.8.7. ndb_error_reporter — NDB Error-Reporting Utility
14.8.8. ndb_print_backup_file — Print NDB Backup File Contents
14.8.9. ndb_print_schema_file — Print NDB Schema File Contents
14.8.10. ndb_print_sys_file — Print NDB System File Contents
14.8.11. ndb_select_all — Print Rows from NDB Table
14.8.12. ndb_select_count — Print Row Counts for NDB Tables
14.8.13. ndb_show_tables — Display List of NDB Tables
14.8.14. ndb_size.pl — NDBCluster Size Requirement Estimator
14.8.15. ndb_waiter — Wait for Cluster to Reach a Given Status
14.9. Using High-Speed Interconnects with MySQL Cluster
[+/-]
- 14.10. Known Limitations of MySQL Cluster [+/-]
-
-
14.10.1. Non-Compliance In SQL Syntax
14.10.2. Limits and Differences from Standard MySQL Limits
14.10.3. Limits Relating to Transaction Handling
14.10.4. Error Handling
14.10.5. Limits Associated with Database Objects
14.10.6. Unsupported Or Missing Features
14.10.7. Limitations Relating to Performance
14.10.8. Issues Exclusive to MySQL Cluster
14.10.9. Limitations Relating to Multiple Cluster Nodes
14.11. MySQL Cluster FAQ
14.12. MySQL Cluster Glossary
15. Spatial Extensions
[+/-]
-
-
15.1. Introduction to MySQL Spatial Support
15.2. The OpenGIS Geometry Model
[+/-]
-
-
15.2.1. The Geometry Class Hierarchy
15.2.2. Class
Geometry
15.2.3. ClassPoint
15.2.4. ClassCurve
15.2.5. ClassLineString
15.2.6. ClassSurface
15.2.7. ClassPolygon
15.2.8. ClassGeometryCollection
15.2.9. ClassMultiPoint
15.2.10. ClassMultiCurve
15.2.11. ClassMultiLineString
15.2.12. ClassMultiSurface
15.2.13. ClassMultiPolygon
15.3. Supported Spatial Data Formats
[+/-]
- 15.4. Creating a Spatially Enabled MySQL Database [+/-]
- 15.5. Analyzing Spatial Information [+/-]
-
-
15.5.1. Geometry Format Conversion Functions
15.5.2.
Geometry
Functions 15.5.3. Functions That Create New Geometries from Existing Ones 15.5.4. Functions for Testing Spatial Relations Between Geometric Objects 15.5.5. Relations on Geometry Minimal Bounding Rectangles (MBRs) 15.5.6. Functions That Test Spatial Relationships Between Geometries
15.6. Optimizing Spatial Analysis
[+/-]
- 15.7. MySQL Conformance and Compatibility
16. APIs and Libraries
[+/-]
-
-
-
16.1. libmysqld, the Embedded MySQL Server Library
[+/-]
- 16.2. MySQL C API [+/-]
-
-
16.2.1. C API Data Types
16.2.2. C API Function Overview
16.2.3. C API Function Descriptions
16.2.4. C API Prepared Statements
16.2.5. C API Prepared Statement Data types
16.2.6. C API Prepared Statement Function Overview
16.2.7. C API Prepared Statement Function Descriptions
16.2.8. C API Prepared Statement Problems
16.2.9. C API Handling of Multiple Statement Execution
16.2.10. C API Handling of Date and Time Values
16.2.11. C API Threaded Function Descriptions
16.2.12. C API Embedded Server Function Descriptions
16.2.13. Controlling Automatic Reconnect Behavior
16.2.14. Common Questions and Problems When Using the C API
16.2.15. Building Client Programs
16.2.16. How to Make a Threaded Client
16.3. MySQL PHP API
[+/-]
- 16.4. MySQL Perl API 16.5. MySQL C++ API 16.6. MySQL Python API 16.7. MySQL Tcl API 16.8. MySQL Eiffel Wrapper
17. Connectors
[+/-]
- 18. MySQL Proxy [+/-]
-
-
18.1. MySQL Proxy Supported Platforms
18.2. Installing MySQL Proxy
[+/-]
- 18.3. MySQL Proxy Command Line Options 18.4. MySQL Proxy Scripting [+/-]
-
-
18.4.1. Proxy Scripting Sequence During Query Injection
18.4.2. Internal Structures
18.4.3. Capturing a connection with
connect_server()
18.4.4. Examining the handshake withread_handshake()
18.4.5. Examining the authentication credentials withread_auth()
18.4.6. Accessing authentication information withread_auth_result()
18.4.7. Manipulating Queries withread_query()
18.4.8. Manipulating Results withread_query_result()
18.5. Using MySQL Proxy
[+/-]
19. Extending MySQL
[+/-]
- A. Errors, Error Codes, and Common Problems [+/-]
- B. MySQL Change History [+/-]
-
-
B.1. Changes in release 4.1.x (Production)
[+/-]
-
-
B.1.1. Changes in MySQL 4.1.24 (Not yet released)
B.1.2. Changes in MySQL 4.1.23 (12 June 2007)
B.1.3. Changes in MySQL 4.1.22 (02 November 2006)
B.1.4. Changes in MySQL 4.1.21 (19 July 2006)
B.1.5. Changes in MySQL 4.1.20 (24 May 2006)
B.1.6. Changes in MySQL 4.1.19 (29 April 2006)
B.1.7. Changes in MySQL 4.1.18 (27 January 2006)
B.1.8. Changes in MySQL 4.1.17 (Not released)
B.1.9. Changes in MySQL 4.1.16 (29 November 2005)
B.1.10. Changes in MySQL 4.1.15 (13 October 2005)
B.1.11. Changes in MySQL 4.1.14 (17 August 2005)
B.1.12. Changes in MySQL 4.1.13 (15 July 2005)
B.1.13. Changes in MySQL 4.1.12 (13 May 2005)
B.1.14. Changes in MySQL 4.1.11 (01 April 2005)
B.1.15. Changes in MySQL 4.1.10 (12 February 2005)
B.1.16. Changes in MySQL 4.1.9 (11 January 2005)
B.1.17. Changes in MySQL 4.1.8 (14 December 2004)
B.1.18. Changes in MySQL 4.1.7 (23 October 2004: Production)
B.1.19. Changes in MySQL 4.1.6 (10 October 2004)
B.1.20. Changes in MySQL 4.1.5 (16 September 2004)
B.1.21. Changes in MySQL 4.1.4 (26 August 2004: Gamma)
B.1.22. Changes in MySQL 4.1.3 (28 June 2004: Beta)
B.1.23. Changes in MySQL 4.1.2 (28 May 2004)
B.1.24. Changes in MySQL 4.1.1 (01 December 2003)
B.1.25. Changes in MySQL 4.1.0 (03 April 2003: Alpha)
B.2. Changes in release 4.0.x
[+/-]
-
-
B.2.1. Changes in release 4.0.31 (Not yet released)
B.2.2. Changes in release 4.0.30 (12 February 2007)
B.2.3. Changes in release 4.0.29 (Not released)
B.2.4. Changes in release 4.0.28 (Not released)
B.2.5. Changes in release 4.0.27 (06 May 2006)
B.2.6. Changes in release 4.0.26 (08 September 2005)
B.2.7. Changes in release 4.0.25 (05 July 2005)
B.2.8. Changes in release 4.0.24 (04 March 2005)
B.2.9. Changes in release 4.0.23 (18 December 2004)
B.2.10. Changes in release 4.0.22 (27 October 2004)
B.2.11. Changes in release 4.0.21 (06 September 2004)
B.2.12. Changes in release 4.0.20 (17 May 2004)
B.2.13. Changes in release 4.0.19 (04 May 2004)
B.2.14. Changes in release 4.0.18 (12 February 2004)
B.2.15. Changes in release 4.0.17 (14 December 2003)
B.2.16. Changes in release 4.0.16 (17 October 2003)
B.2.17. Changes in release 4.0.15 (03 September 2003)
B.2.18. Changes in release 4.0.14 (18 July 2003)
B.2.19. Changes in release 4.0.13 (16 May 2003)
B.2.20. Changes in release 4.0.12 (15 March 2003: Production)
B.2.21. Changes in release 4.0.11 (20 February 2003)
B.2.22. Changes in release 4.0.10 (29 January 2003)
B.2.23. Changes in release 4.0.9 (09 January 2003)
B.2.24. Changes in release 4.0.8 (07 January 2003)
B.2.25. Changes in release 4.0.7 (20 December 2002)
B.2.26. Changes in release 4.0.6 (14 December 2002: Gamma)
B.2.27. Changes in release 4.0.5 (13 November 2002)
B.2.28. Changes in release 4.0.4 (29 September 2002)
B.2.29. Changes in release 4.0.3 (26 August 2002: Beta)
B.2.30. Changes in release 4.0.2 (01 July 2002)
B.2.31. Changes in release 4.0.1 (23 December 2001)
B.2.32. Changes in release 4.0.0 (October 2001: Alpha)
B.3. Changes in release 3.23.x
[+/-]
-
-
B.3.1. Changes in release 3.23.59 (Not yet released)
B.3.2. Changes in release 3.23.58 (11 September 2003)
B.3.3. Changes in release 3.23.57 (06 June 2003)
B.3.4. Changes in release 3.23.56 (13 March 2003)
B.3.5. Changes in release 3.23.55 (23 January 2003)
B.3.6. Changes in release 3.23.54 (05 December 2002)
B.3.7. Changes in release 3.23.53 (09 October 2002)
B.3.8. Changes in release 3.23.52 (14 August 2002)
B.3.9. Changes in release 3.23.51 (31 May 2002)
B.3.10. Changes in release 3.23.50 (21 April 2002)
B.3.11. Changes in release 3.23.49 (14 February 2002)
B.3.12. Changes in release 3.23.48 (07 February 2002)
B.3.13. Changes in release 3.23.47 (27 December 2001)
B.3.14. Changes in release 3.23.46 (29 November 2001)
B.3.15. Changes in release 3.23.45 (22 November 2001)
B.3.16. Changes in release 3.23.44 (31 October 2001)
B.3.17. Changes in release 3.23.43 (04 October 2001)
B.3.18. Changes in release 3.23.42 (08 September 2001)
B.3.19. Changes in release 3.23.41 (11 August 2001)
B.3.20. Changes in release 3.23.40 (18 July 2001)
B.3.21. Changes in release 3.23.39 (12 June 2001)
B.3.22. Changes in release 3.23.38 (09 May 2001)
B.3.23. Changes in release 3.23.37 (17 April 2001)
B.3.24. Changes in release 3.23.36 (27 March 2001)
B.3.25. Changes in release 3.23.35 (15 March 2001)
B.3.26. Changes in release 3.23.34a (11 March 2001)
B.3.27. Changes in release 3.23.34 (10 March 2001)
B.3.28. Changes in release 3.23.33 (09 February 2001)
B.3.29. Changes in release 3.23.32 (22 January 2001)
B.3.30. Changes in release 3.23.31 (17 January 2001: Production)
B.3.31. Changes in release 3.23.30 (04 January 2001)
B.3.32. Changes in release 3.23.29 (16 December 2000)
B.3.33. Changes in release 3.23.28 (22 November 2000: Gamma)
B.3.34. Changes in release 3.23.27 (24 October 2000)
B.3.35. Changes in release 3.23.26 (18 October 2000)
B.3.36. Changes in release 3.23.25 (29 September 2000)
B.3.37. Changes in release 3.23.24 (08 September 2000)
B.3.38. Changes in release 3.23.23 (01 September 2000)
B.3.39. Changes in release 3.23.22 (31 July 2000)
B.3.40. Changes in release 3.23.21 (04 July 2000)
B.3.41. Changes in release 3.23.20 (28 June 2000: Beta)
B.3.42. Changes in release 3.23.19
B.3.43. Changes in release 3.23.18 (11 June 2000)
B.3.44. Changes in release 3.23.17 (07 June 2000)
B.3.45. Changes in release 3.23.16 (16 May 2000)
B.3.46. Changes in release 3.23.15 (08 May 2000)
B.3.47. Changes in release 3.23.14 (09 April 2000)
B.3.48. Changes in release 3.23.13 (14 March 2000)
B.3.49. Changes in release 3.23.12 (07 March 2000)
B.3.50. Changes in release 3.23.11 (16 February 2000)
B.3.51. Changes in release 3.23.10 (30 January 2000)
B.3.52. Changes in release 3.23.9 (29 January 2000)
B.3.53. Changes in release 3.23.8 (02 January 2000)
B.3.54. Changes in release 3.23.7 (10 December 1999)
B.3.55. Changes in release 3.23.6 (15 December 1999)
B.3.56. Changes in release 3.23.5 (20 October 1999)
B.3.57. Changes in release 3.23.4 (28 September 1999)
B.3.58. Changes in release 3.23.3 (13 September 1999)
B.3.59. Changes in release 3.23.2 (09 August 1999)
B.3.60. Changes in release 3.23.1 (08 July 1999)
B.3.61. Changes in release 3.23.0 (05 July 1999: Alpha)
B.4. Changes in -
-
B.4.1. Changes in MySQL/InnoDB-4.0.21, September 10, 2004
B.4.2. Changes in MySQL/InnoDB-4.1.4, August 31, 2004
B.4.3. Changes in MySQL/InnoDB-4.1.3, June 28, 2004
B.4.4. Changes in MySQL/InnoDB-4.1.2, May 30, 2004
B.4.5. Changes in MySQL/InnoDB-4.0.20, May 18, 2004
B.4.6. Changes in MySQL/InnoDB-4.0.19, May 4, 2004
B.4.7. Changes in MySQL/InnoDB-4.0.18, February 13, 2004
B.4.8. Changes in MySQL/InnoDB-5.0.0, December 24, 2003
B.4.9. Changes in MySQL/InnoDB-4.0.17, December 17, 2003
B.4.10. Changes in MySQL/InnoDB-4.1.1, December 4, 2003
B.4.11. Changes in MySQL/InnoDB-4.0.16, October 22, 2003
B.4.12. Changes in MySQL/InnoDB-3.23.58, September 15, 2003
B.4.13. Changes in MySQL/InnoDB-4.0.15, September 10, 2003
B.4.14. Changes in MySQL/InnoDB-4.0.14, July 22, 2003
B.4.15. Changes in MySQL/InnoDB-3.23.57, June 20, 2003
B.4.16. Changes in MySQL/InnoDB-4.0.13, May 20, 2003
B.4.17. Changes in MySQL/InnoDB-4.1.0, April 3, 2003
B.4.18. Changes in MySQL/InnoDB-3.23.56, March 17, 2003
B.4.19. Changes in MySQL/InnoDB-4.0.12, March 18, 2003
B.4.20. Changes in MySQL/InnoDB-4.0.11, February 25, 2003
B.4.21. Changes in MySQL/InnoDB-4.0.10, February 4, 2003
B.4.22. Changes in MySQL/InnoDB-3.23.55, January 24, 2003
B.4.23. Changes in MySQL/InnoDB-4.0.9, January 14, 2003
B.4.24. Changes in MySQL/InnoDB-4.0.8, January 7, 2003
B.4.25. Changes in MySQL/InnoDB-4.0.7, December 26, 2002
B.4.26. Changes in MySQL/InnoDB-4.0.6, December 19, 2002
B.4.27. Changes in MySQL/InnoDB-3.23.54, December 12, 2002
B.4.28. Changes in MySQL/InnoDB-4.0.5, November 18, 2002
B.4.29. Changes in MySQL/InnoDB-3.23.53, October 9, 2002
B.4.30. Changes in MySQL/InnoDB-4.0.4, October 2, 2002
B.4.31. Changes in MySQL/InnoDB-4.0.3, August 28, 2002
B.4.32. Changes in MySQL/InnoDB-3.23.52, August 16, 2002
B.4.33. Changes in MySQL/InnoDB-4.0.2, July 10, 2002
B.4.34. Changes in MySQL/InnoDB-3.23.51, June 12, 2002
B.4.35. Changes in MySQL/InnoDB-3.23.50, April 23, 2002
B.4.36. Changes in MySQL/InnoDB-3.23.49, February 17, 2002
B.4.37. Changes in MySQL/InnoDB-3.23.48, February 9, 2002
B.4.38. Changes in MySQL/InnoDB-3.23.47, December 28, 2001
B.4.39. Changes in MySQL/InnoDB-4.0.1, December 23, 2001
B.4.40. Changes in MySQL/InnoDB-3.23.46, November 30, 2001
B.4.41. Changes in MySQL/InnoDB-3.23.45, November 23, 2001
B.4.42. Changes in MySQL/InnoDB-3.23.44, November 2, 2001
B.4.43. Changes in MySQL/InnoDB-3.23.43, October 4, 2001
B.4.44. Changes in MySQL/InnoDB-3.23.42, September 9, 2001
B.4.45. Changes in MySQL/InnoDB-3.23.41, August 13, 2001
B.4.46. Changes in MySQL/InnoDB-3.23.40, July 16, 2001
B.4.47. Changes in MySQL/InnoDB-3.23.39, June 13, 2001
B.4.48. Changes in MySQL/InnoDB-3.23.38, May 12, 2001
B.5. Changes in MySQL Cluster
[+/-]
-
-
B.5.1. Changes in MySQL Cluster-5.0.7 (10 June 2005)
B.5.2. Changes in MySQL Cluster-5.0.6 (26 May 2005)
B.5.3. Changes in MySQL Cluster-5.0.5 (Not released)
B.5.4. Changes in MySQL Cluster-5.0.4 (16 April 2005)
B.5.5. Changes in MySQL Cluster-5.0.3 (23 March 2005: Beta)
B.5.6. Changes in MySQL Cluster-5.0.1 (27 July 2004)
B.5.7. Changes in MySQL Cluster-4.1.13 (15 July 2005)
B.5.8. Changes in MySQL Cluster-4.1.12 (13 May 2005)
B.5.9. Changes in MySQL Cluster-4.1.11 (01 April 2005)
B.5.10. Changes in MySQL Cluster-4.1.10 (12 February 2005)
B.5.11. Changes in MySQL Cluster-4.1.9 (13 January 2005)
B.5.12. Changes in MySQL Cluster-4.1.8 (14 December 2004)
B.5.13. Changes in MySQL Cluster-4.1.7 (23 October 2004)
B.5.14. Changes in MySQL Cluster-4.1.6 (10 October 2004)
B.5.15. Changes in MySQL Cluster-4.1.5 (16 September 2004)
B.5.16. Changes in MySQL Cluster-4.1.4 (31 August 2004)
B.5.17. Changes in MySQL Cluster-4.1.3 (28 June 2004)
B.6. MySQL Connector/ODBC (MyODBC) Change History
[+/-]
-
-
B.6.1. Changes in MySQL Connector/ODBC 5.1.2 (Not yet released)
B.6.2. Changes in MySQL Connector/ODBC 5.1.1 (13 December 2007)
B.6.3. Changes in MySQL Connector/ODBC 5.1.0 (10 September 2007)
B.6.4. Changes in MySQL Connector/ODBC 5.0.12 (Never released)
B.6.5. Changes in MySQL Connector/ODBC 5.0.11 (31 January 2007)
B.6.6. Changes in MySQL Connector/ODBC 5.0.10 (14 December 2006)
B.6.7. Changes in MySQL Connector/ODBC 5.0.9 (22 November 2006)
B.6.8. Changes in MySQL Connector/ODBC 5.0.8 (17 November 2006)
B.6.9. Changes in MySQL Connector/ODBC 5.0.7 (08 November 2006)
B.6.10. Changes in MySQL Connector/ODBC 5.0.6 (03 November 2006)
B.6.11. Changes in MySQL Connector/ODBC 5.0.5 (17 October 2006)
B.6.12. Changes in Connector/ODBC 5.0.3 (Connector/ODBC 5.0 Alpha 3) (20 June 2006)
B.6.13. Changes in Connector/ODBC 5.0.2 (Never released)
B.6.14. Changes in Connector/ODBC 5.0.1 (Connector/ODBC 5.0 Alpha 2) (05 June 2006)
B.6.15. Changes in MySQL Connector/ODBC 3.51.23 (Not yet released)
B.6.16. Changes in MySQL Connector/ODBC 3.51.22 (13 November 2007)
B.6.17. Changes in MySQL Connector/ODBC 3.51.21 (08 October 2007)
B.6.18. Changes in MySQL Connector/ODBC 3.51.20 (10 September 2007)
B.6.19. Changes in MySQL Connector/ODBC 3.51.19 (10 August 2007)
B.6.20. Changes in MySQL Connector/ODBC 3.51.18 (08 August 2007)
B.6.21. Changes in MySQL Connector/ODBC 3.51.17 (14 July 2007)
B.6.22. Changes in MySQL Connector/ODBC 3.51.16 (14 June 2007)
B.6.23. Changes in MySQL Connector/ODBC 3.51.15 (7 May 2007)
B.6.24. Changes in MySQL Connector/ODBC 3.51.14 (08 March 2007)
B.6.25. Changes in MySQL Connector/ODBC 3.51.13 (Never released)
B.6.26. Changes in MySQL Connector/ODBC 3.51.12 (11 Febrauary 2005)
B.6.27. Changes in MySQL Connector/ODBC 3.51.11 (28 January 2005)
B.7. MySQL Connector/NET Change History
[+/-]
-
-
B.7.1. Changes in MySQL Connector/NET 5.2.0 (Not yet released)
B.7.2. Changes in MySQL Connector/NET 5.1.4 (20 November 2007)
B.7.3. Changes in MySQL Connector/NET 5.1.3 (21 September 2007)
B.7.4. Changes in MySQL Connector/NET 5.1.2 (18 June 2007)
B.7.5. Changes in MySQL Connector/NET 5.1.1 (23 May 2007)
B.7.6. Changes in MySQL Connector/NET 5.1.0 (01 May 2007)
B.7.7. Changes in MySQL Connector/NET 5.0.9 (Not yet released)
B.7.8. Changes in MySQL Connector/NET 5.0.8 (21 August 2007)
B.7.9. Changes in MySQL Connector/NET 5.0.7 (18 May 2007)
B.7.10. Changes in MySQL Connector/NET 5.0.6 (22 March 2007)
B.7.11. Changes in MySQL Connector/NET 5.0.5 (07 March 2007)
B.7.12. Changes in MySQL Connector/NET 5.0.4 (Not released)
B.7.13. Changes in MySQL Connector/NET 5.0.3 (05 January 2007)
B.7.14. Changes in MySQL Connector/NET 5.0.2 (06 November 2006)
B.7.15. Changes in MySQL Connector/NET 5.0.1 (01 October 2006)
B.7.16. Changes in MySQL Connector/NET 5.0.0 (08 August 2006)
B.7.17. Changes in MySQL Connector/NET 1.0.11 (Not yet released)
B.7.18. Changes in MySQL Connector/NET 1.0.10 (24 August 2007)
B.7.19. Changes in MySQL Connector/NET 1.0.9 (02 February 2007)
B.7.20. Changes in MySQL Connector/NET 1.0.8 (20 October 2006)
B.7.21. Changes in MySQL Connector/NET 1.0.7 (21 November 2005)
B.7.22. Changes in MySQL Connector/NET 1.0.6 (03 October 2005)
B.7.23. Changes in MySQL Connector/NET 1.0.5 (29 August 2005)
B.7.24. Changes in MySQL Connector/NET 1.0.4 (20 January 2005)
B.7.25. Changes in MySQL Connector/NET 1.0.3 (12 October 2004)
B.7.26. Changes in MySQL Connector/NET 1.0.2 (15 November 2004)
B.7.27. Changes in MySQL Connector/NET 1.0.1 (27 October 2004)
B.7.28. Changes in MySQL Connector/NET 1.0.0 (01 September 2004)
B.7.29. Changes in MySQL Connector/NET Version 0.9.0 (30 August 2004)
B.7.30. Changes in MySQL Connector/NET Version 0.76
B.7.31. Changes in MySQL Connector/NET Version 0.75
B.7.32. Changes in MySQL Connector/NET Version 0.74
B.7.33. Changes in MySQL Connector/NET Version 0.71
B.7.34. Changes in MySQL Connector/NET Version 0.70
B.7.35. Changes in MySQL Connector/NET Version 0.68
B.7.36. Changes in MySQL Connector/NET Version 0.65
B.7.37. Changes in MySQL Connector/NET Version 0.60
B.7.38. Changes in MySQL Connector/NET Version 0.50
B.8. MySQL Connector/J Change History
[+/-]
-
-
B.8.1. Changes in MySQL Connector/J 5.1.x
B.8.2. Changes in MySQL Connector/J 5.0.x
B.8.3. Changes in MySQL Connector/J 3.1.x
B.8.4. Changes in MySQL Connector/J 3.0.x
B.8.5. Changes in MySQL Connector/J 2.0.x
B.8.6. Changes in MySQL Connector/J 1.2b (04 July 1999)
B.8.7. Changes in MySQL Connector/J 1.2.x and lower
B.9. MySQL Connector/MXJ Change History
[+/-]
-
-
B.9.1. Changes in MySQL Connector/MXJ 5.0.6 (04 May 2007)
B.9.2. Changes in MySQL Connector/MXJ 5.0.5 (14 March 2007)
B.9.3. Changes in MySQL Connector/MXJ 5.0.4 (28 January 2007)
B.9.4. Changes in MySQL Connector/MXJ 5.0.3 (24 June 2006)
B.9.5. Changes in MySQL Connector/MXJ 5.0.2 (15 June 2006)
B.9.6. Changes in MySQL Connector/MXJ 5.0.1 (Never released)
B.9.7. Changes in MySQL Connector/MXJ 5.0.0 (09 December 2005)
B.10. MySQL Proxy Change History
[+/-]
InnoDB
[+/-]
C. Limits and Restrictions
[+/-]
-
- D. Credits [+/-]
- Index
List of Tables
List of Examples
-
17.1.
Obtaining a connection from the
DriverManager
17.2.
Using java.sql.Statement to execute a SELECT
query
17.3.
Stored Procedures
17.4.
Using Connection.prepareCall()
17.5.
Registering output parameters
17.6.
Setting CallableStatement
input parameters
17.7.
Retrieving results and output parameter values
17.8.
Retrieving AUTO_INCREMENT
column values using Statement.getGeneratedKeys()
17.9.
Retrieving AUTO_INCREMENT
column values using SELECT LAST_INSERT_ID()
17.10.
Retrieving AUTO_INCREMENT
column values in Updatable ResultSets
17.11.
Using a connection pool with a J2EE application server
17.12.
Example of transaction with retry logic