MySQL5.1 中文手册
这是MySQL参考手册的翻译版本，关于MySQL参考手册，请访问dev.mysql.com。 原始参考手册为英文版。
--------------------------------------------------------------------------------
MySQL 5.1参考手册
前言
1. 一般信息
2. 安装MySQL
3. 教程
4. MySQL程序概述
5. 数据库管理
6. 中的复制
7. 优化
8. 客户端和实用工具程序
9.语言结构
10. 字符集支持
11. 列类型
12. 函数和操作符
13. SQL语句语法
14. 插件式存储引擎体系结构
15. 存储引擎和表类型
16. 编写自定义存储引擎
17. MySQL簇
18. 分区
19. 中的空间扩展
20. 存储程序和函数
21. 触发程序
22. 视图
23. INFORMATION_SCHEMA信息数据库
24. 精度数学
25. API和库
26. 连接器
27. 扩展MySQL
A. 问题和常见错误
B. 错误代码和消息
C. 感谢
D. MySQL变更史
E. 移植到其他系统
F. 环境变量
G. 正则表达式
H. Limits in MySQL
I. 特性限制
J. GNU通用公共许可
K. MySQL FLOSS许可例外
索引
This is the translated version of the MySQL Reference Manual MySQL Reference Manual, please visit dev.mysql.com. The original Reference Manual is in English, compared with the English reference manual.
--------------------------------------------------------------------------------
MySQL 5.1 Reference Manual
Preface and Legal Notice
1 General Information
2 Installing and Upgrading MySQL
3 Tutorial
4 MySQL Programs
5 MySQL Server Administration
6 Security
7 Backup and Recovery
8 Optimization
9 Language Structure
10 Globalization
11 Data Types
12 Functions and Operators
13 SQL Statement Syntax
14 Storage Engines
15 High Availability and Scalability
16 Replication
17 MySQL Cluster NDB 6.1- 7.1
18 Partitioning
19 Stored Programs and Views
20 INFORMATION_SCHEMA Tables
21 Connectors and APIs
22 Extending MySQL
23 MySQL Enterprise Monitor
24 MySQL Enterprise Backup
25 MySQL Workbench
A Licenses for Third-Party Components
B MySQL 5.1 Frequently Asked Questions (2012-05-14, SQL, 4508KB, 下载14次)
SQL是高级的非过程化编程语言，是沟通数据库服务器和客户端的重要工具，允许用户在高层数据结构上工作。它不要求用户指定对数据的存放方法，也不需要用户了解具体的数据存放方式，所以，具有完全不同底层结构的不同数据库系统，可以使用相同的SQL语言作为数据输入与管理的接口。它以记录集合作为操作对象，所有SQL语句接受集合作为输入，返回集合作为输出，这种集合特性允许一条SQL语句的输出作为另一条SQL语句的输入，所以SQL语句可以嵌套，这使它具有极大的灵活性和强大的功能，在多数情况下，在其他语言中需要一大段程序实现的功能只需要一个SQL语句就可以达到目的，这也意味着用SQL语言可以写出非常复杂的语句。
SQL is advanced the process programming language, is communication database server and client important tool that allows users to work on top in data structure. It does not require the user to the storage of data specified method, also do not need to users understand the specific data storage way, so, with a fully different ground floor of the different structure database system, can use the same SQL language input and management as data interface. It set a record as the operation object, all the SQL statement accept set as input, return to set as the output, this set features allow an SQL statement output as another an SQL statement input, so the SQL statement may be nested, this make it has great flexibility and powerful functions, in most cases, in other languages need a large section of the program of the realization of the function only need a SQL statement be able to achieve a goal, it also means using SQL language can write very complex statement.
(2012-05-01, SQL, 98KB, 下载2次)
《Oracle数据库DBA专题技术精粹》从DBA的角度阐述了Oracle数据库的结构内幕、管理经验和优化技巧，并列举了很多实用的案例。本书主要分为五大部分，基础篇主要介绍了一些基础技术与OCP认证相关的一些内容，内各种平台上安装与建库的技巧以及在9i里面出现的新特性；结构篇包括对回滚段、存储结构等的深入讨论，并彻底阐述了困扰许多用户的字符集问题；备份与恢复篇列举了大量实际案例，讲述了在不同的需求环境下所应采取的备份方案以及进行故障恢复的方法；性能篇深入分析了Statspack等常用的调整工具的原理与使用方法、判断依据，并从锁、内存、索引、执行计划等各个角度介绍了各种优化技巧；网络篇主要介绍了监听器、透明网关、数据迁移等方面的。
"Oracle Database DBA special technical essence" from the DBA perspective of the insider Oracle database structure, management experience and optimization techniques, and lists a number of practical cases. This book is divided into five parts, based on article introduces some basic techniques and some of the elements related to OCP certification, installation of various platforms and building a database of skills and which appears in the 9i new features structure of articles including rollback section, the storage structure of the in-depth discussion, and thoroughly describes the user s character set that plagues many problems backup and recovery chapter lists a large number of actual cases, about the needs in different circumstances to be taken by the backup program and fault recovery method performance-depth analysis of articles and other commonly used Statspack to adjust the principle and use tools to determine the basis, and from the lock, memory, indexes, and other point of view (2010-10-19, SQL, 16929KB, 下载18次)
XML Query（XQuery）是在 XML 数据中搜索特定信息的功能强大的新方法。与 XPath 2.0 的起源相同，XQuery 的某些方面 — 如传统的 XPath 表达式 — 看上去很熟悉，而其它方面（如 FLWR 和条件语句）则是全新的。为了帮助消除解释问题，XQuery 工作组创建了“XML Query Use Cases”文档（请参阅参考资料，它提供了样本查询及其预期的结果。本教程中的示例都基于为该文档创建的样本数据。
XQuery 是 XML 规范和 W3C 建议书之间相互关系的优秀示例。XQuery 工作组与 XSL 工作组还一起负责 XPath 2.0 工作草案，XPath 2.0 将包括许多为 XQuery 开发的功能。
除了对 XPath 的增强外，XQuery 还允许您通过嵌套类 SQL 的子句来创建复杂查询，以及通过将 XML 构造器直接包括在输出中来创建复杂结果。本章概述了 XQuery 的这些方面，然后将更详细地讨论每个方面。
XML Query (XQuery) is in the XML data in the powerful search certain information of new methods. XPath 2.0 origin with the same XQuery, some aspects of the traditional XPath expression-- such as very familiar, but look-- other aspects (such as FLWR and conditionals) is new. In order to help eliminate explain a problem, created "XQuery group Use Query XML document on" (please refer to reference material, it provides samples and inquires. This tutorial examples for this document creation based on the sample data.
W3C XML standard and XQuery is the relationship between the proposal outstanding examples. Working with XSL working XQuery XPath 2.0 is responsible for working together, XPath 2.0 will include the draft for the XQuery function of many development.
In addition to the enhancement, XPath XQuery also allow you through the nested class SQL clauses to create complex queries, and through XML constructor directly included in the output to create complex results. This chapter summari (2010-07-30, SQL, 781KB, 下载10次)
sql是目前使用最为广泛的数据库语言之一。本书没有涉及理论，而是从实践出发，由浅入深地讲解了广大读者所必需的sql 知识，适用于各种主流数据库。实例丰富，便于查阅。本书涉及不同平台上数据的排序、过滤和分组，以及表、视图、联结、子查询、游标、存储过程和触发器等内容，通过本书读者可以系统地学习到sql 的知识和方法。.
本书注重实用性，操作性很强，适合于sql 的初学者学习和广大软件开发及管理人员参考。
sql语法简洁，使用方式灵活，功能强大，已经成为当今程序员不可或缺的技能。..
本书是深受世界各地读者欢迎的sql经典畅销书，内容丰富，文字简洁明快，针对Oracle、sql Server、Mysql、 DB2、Sybase、Postgresql、Access等各种主流数据库提供了大量简明的实例。与其他同类图书不同，它没有过多阐述数据库基础理论，而是专门针对一线软件开发人员，直接从sql SELECT开始，讲述实际工作环境中最常用和最必需的sql知识，实用性极强。通过本书，读者能够从没有多少sql经验的新手，迅速编写出世界级的sql！
本书是麻省理工学院、伊利诺伊大学等众多大学的参考教材。除了作为教程之外，独特的编排方式还使本书成为方便的快速查询手册
Sams Teach Yourself SQL in 10 Minutes has established itself as the gold standard for introductory SQL books, offering a fast-paced accessible tutorial to the major themes and techniques involved in applying the SQL language. Forta s examples are clear and his writing style is crisp and concise. As with earlier editions, this revision includes coverage of current versions of all major commercial SQL platforms. New this time around is coverage of MySQL, and PostgreSQL. All examples have been tested against each SQL platform, with incompatibilities or platform distinctives called out and explained. (2010-04-28, SQL, 319KB, 下载68次)
《中文版 SQL Server 2000 开发与管理应用实例》光盘代码--作者邹建
本书全面系统地介绍了SQL Server 2005应用、开发和管理方面的技术，涉及安装和升级SQL Server、T-SQL增强、T-SQL应用、XML数据处理、CLR集成、开发SQL Server应用程序、端点、Service Broker、SQL Server Integration Services、SQL Server配置、SQL Server安全管理、数据的加密与解密、数据备份与还原、数据库的高可用性技术、查询SQL Server对象信息、服务器性能监视等内容。
本书不但融合了作者在使用SQL Server 2005过程中遇到的各种常见问题和应用案例，还总结了作者几年来在CSDN 社区SQL Server版所解决的大量问题，面向实际项目需求，涉及不同类型的应用，能够多角度地引导读者学习相关知识。而且针对各类问题，提供了详细的操作步骤和解决思路，具有很强的实用性和可操作性，因此不仅适用于初学者，也适用于进阶者。
"The Chinese version of SQL Server 2000 Application Development and Management" CD-ROM Code- Author Zou
This book a comprehensive and systematic introduction to SQL Server 2005 applications, development and management of technology, involving the installation and upgrade SQL Server, T-SQL enhancement, T-SQL applications, XML data processing, CLR integration, SQL Server application development, end- , Service Broker, SQL Server Integration Services, SQL Server configuration, SQL Server security management, data encryption and decryption, data backup and restore, high availability database technology, SQL Server query object information, such as server performance monitoring.
This book combines the author not only in the use of SQL Server 2005 encounter in the course of a variety of frequently asked questions and application of the case, but also summarize the author over the past few years in the SQL Server version CSDN community by the large number of issues to resolve, for the a (2009-07-08, SQL, 320KB, 下载11次)
3、使用如下命令更改密码：
shell> mysqladmin -u root -p password ‘newpass’
Enter Password:*******
出现Enter Password的提示后输入原来的密码oldpass即可。
读者可以尝试其它所有本章介绍的方法。
4、首先以root用户的身份连接到服务器：
shell> mysql -u root -p
Enter password:*******
出现Enter password提后输入root用户的密码，然后即进入mysql客户机的交互模式，可以看到下面的提示：
Welcome to the MySQL monitor. Commands end with or \g.
Your MySQL connection id is 4 to server version: 3.23.25-beta-log
Type help or \h for help. Type \c to clear the buffer
mysql>
然后发布查询，直接键入题目中的语句：
mysql> SELECT User,Host FROM mysql.user
3, use the following command to change the password: shell> mysqladmin-u root-p password newpass Enter Password :******* the Enter Password prompt appears enter the original password after you oldpass. Readers can try all other methods described in this chapter. 4, first of all to root the identity of the user to connect to the server: shell> mysql-u root-p Enter password :******* appear Enter password to enter the root after the user s password, and then entering the mysql client interactive mode , we can see the following prompt: Welcome to the MySQL monitor. Commands end with or g.Your MySQL connection id is 4 to server version: 3.23.25-beta-logType help or h for help. Type c to clear the buffermysql> and then release inquiries, directly type the subject of statement: mysql> SELECT User, Host FROM mysql.user (2008-01-07, SQL, 21923KB, 下载119次)
SQL学习宝典2.0的使用说明：
1.在win95,win98下要安装PWS(win98安装盘里有）.
2.把sql2目录设为虚拟目录。
2.在浏览器中运行http://localhost/sql2/index.asp.
SQL学习宝典2.0的功能说明：
1.学习和检验SQL语句,输入SQL语句即可执行，及时显示结果。
2.assess数据库显示，显示数据库中的所有表名和所有表的记录，
包括字段类型。可以在conn.inc文件中把xx.mdb换成你自己的数据库名，
其他程序不用修改即可使用。
3.收藏大量经典SQL语句，用户可以添加收藏。
4.所有程序均有详细说明。是ASP+ACCESS的最好实例。是ASP程序员的好帮手。
使用对象：ASP编程人员，学习和使用SQL语句的人
book learning SQL 2.0 for use : 1. In win95. win98 installed under PWS (win98 installation of a tray). 2. put sql2 Set Virtual Directory Contents . 2. The browser running http :// localhost/sql2/index.asp. learning SQL 2.0 treasury functions Note : 1. learning and testing the SQL statements in SQL input can be executed, timely result will be displayed. 2.assess database, the database shows all the tables in the name of the table and all records, including field type. The documents include the conn.inc xx.mdb replaced by your own database name. other procedures need not be amended in order to use. 3. A collection of classic SQL statements, users can add collections. 4. All procedures were detailed description. ACCESS ASP is the best example. ASP programmer is a good helper. Using Object : (2006-07-13, SQL, 19KB, 下载2次)