- MySQL 5.1 Reference Manual :: 1 General Information
-
- MySQL 5.1 Reference Manual
- Preface, Notes, Licenses
- 1 General Information
- 2 Installing and Upgrading MySQL
- 3 Tutorial
- 4 MySQL Programs
- 5 MySQL Server Administration
- 6 Backup and Recovery
- 7 Optimization
- 8 Language Structure
- 9 Internationalization and Localization
- 10 Data Types
- 11 Functions and Operators
- 12 SQL Statement Syntax
- 13 Storage Engines
- 14 High Availability and Scalability
- 15 MySQL Enterprise Monitor
- 16 Replication
- 17 MySQL Cluster NDB 6.X/7.X
- 18 Partitioning
- 19 Stored Programs and Views
- 20 INFORMATION_SCHEMA Tables
- 21 Connectors and APIs
- 22 Extending MySQL
- A MySQL 5.1 Frequently Asked Questions
- B Errors, Error Codes, and Common Problems
- C MySQL Change History
- D Restrictions and Limits
- Index
- Standard Index
- C Function Index
- Command Index
- Function Index
- INFORMATION_SCHEMA Index
- Transaction Isolation Level Index
- JOIN Types Index
- Operator Index
- Option Index
- Privileges Index
- SQL Modes Index
- Status Variable Index
- Statement/Syntax Index
- System Variable Index
Table of Contents [+/-]
- 1.1. About This Manual
- 1.2. Typographical and Syntax Conventions
- 1.3. Overview of the MySQL Database Management System [+/-]
- 1.4. MySQL Development History
- 1.5. What Is New in MySQL 5.1
- 1.6. MySQL Information Sources [+/-]
- 1.7. How to Report Bugs or Problems
- 1.8. MySQL Standards Compliance [+/-]
- 1.9. Credits [+/-]
The MySQL™ software delivers a very fast, multi-threaded, multi-user, and robust SQL (Structured Query Language) database server. MySQL Server is intended for mission-critical, heavy-load production systems as well as for embedding into mass-deployed software. 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 by Customer without Oracle's express written authorization. Other names may be trademarks of their respective owners.
The MySQL software is Dual Licensed. Users can choose to use the MySQL software as an Open Source product under the terms of the GNU General Public License (http://www.fsf.org/licenses/) or can purchase a standard commercial license from Oracle. See http://www.mysql.com/company/legal/licensing/ for more information on our licensing policies.
The following list describes some sections of particular interest in this manual:
For a discussion about the capabilities of the MySQL Database Server, see Section 1.3.3, “The Main Features of MySQL”.
For development history, see Section 1.4, “MySQL Development History”.
For installation instructions, see Chapter 2, Installing and Upgrading MySQL. For information about upgrading MySQL, see Section 2.4.1, “Upgrading MySQL”, and the change notes at Appendix C, MySQL Change History.
For a tutorial introduction to the MySQL Database Server, see Chapter 3, Tutorial.
For information about configuring and administering MySQL Server, see Chapter 5, MySQL Server Administration.
For information about setting up replication servers, see Chapter 16, Replication.
For answers to a number of questions that are often asked concerning the MySQL Database Server and its capabilities, see Appendix A, MySQL 5.1 Frequently Asked Questions.
For a list of currently known bugs and misfeatures, see Section B.5.8, “Known Issues in MySQL”.
For a list of all the contributors to this project, see Section 1.9, “Credits”.
For a history of new features and bugfixes, see Appendix C, MySQL Change History.
For tips on porting the MySQL Database Software to new architectures or operating systems, see MySQL Internals: Porting.
For benchmarking information, see the
sql-bench
benchmarking directory in your MySQL distribution.
Important
To report errors (often called “bugs”), please use the instructions at Section 1.7, “How to Report Bugs or Problems”.
If you have found a sensitive security bug in MySQL Server, please let us know immediately by sending an email message to
<security@mysql.com>
.