中文版的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
[+/-]
3. Tutorial
[+/-]
4. MySQL Programs
[+/-]
5. MySQL Server Administration
[+/-]
6. Optimization
[+/-]
7. Language Structure
[+/-]
8. Internationalization and Localization
[+/-]
9. Data Types
[+/-]
10. Functions and Operators
[+/-]
11. SQL Statement Syntax
[+/-]
12. Storage Engines
[+/-]
13. High Availability, Scalability, and DRBD
[+/-]
14. Replication
[+/-]
15. MySQL Cluster
[+/-]
16. Partitioning
[+/-]
17. Spatial Extensions
[+/-]
18. Stored Procedures and Functions
[+/-]
19. Triggers
[+/-]
20. Event Scheduler
[+/-]
21. Views
[+/-]
22.
INFORMATION_SCHEMA
Tables
[+/-]
23. Precision Math
[+/-]
24. APIs and Libraries
[+/-]
25. Connectors
[+/-]
26. MySQL Proxy
[+/-]
27. Extending MySQL
[+/-]
A. MySQL 5.1 Frequently Asked Questions
[+/-]
B. Errors, Error Codes, and Common Problems
[+/-]
C. MySQL Change History
[+/-]
D. Limits and Restrictions
[+/-]
E. Credits
[+/-]
Index
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