JavaScript Editor Source code editor     What Is Ajax 

MySQL Reference Manual

Table of Contents

1. General Information
2. Installing and Upgrading MySQL
3. Tutorial
4. Using MySQL Programs
5. Database Administration
6. Replication
7. Optimization
8. Client and Utility Programs
9. Language Structure
10. Character Set Support
11. Data Types
12. Functions and Operators
13. SQL Statement Syntax
14. Storage Engines
15. MySQL Cluster
16. Spatial Extensions
17. Stored Procedures and Functions
18. Triggers
21. Precision Math
22. APIs and Libraries
23. Connectors
24. Extending MySQL
A. MySQL Frequently Asked Questions
A.1. MySQL 5.0 FAQ — General
A.2. MySQL 5.0 FAQ — Storage Engines
A.3. MySQL 5.0 FAQ — Server SQL Mode
A.4. MySQL 5.0 FAQ — Stored Procedures
A.5. MySQL 5.0 FAQ — Triggers
A.6. MySQL 5.0 FAQ — Views
A.8. MySQL 5.0 FAQ — Migration
A.9. MySQL 5.0 FAQ — Security
A.10. MySQL 5.0 FAQ — MySQL Cluster
A.11. MySQL 5.0 FAQ — MySQL Chinese, Japanese, and Korean Character Sets
A.12. MySQL 5.0 FAQ — Connectors & APIs
A.13. MySQL 5.0 FAQ — Replication
A.14. MySQL 5.0 FAQ — MySQL, DRBD, and Heartbeat
B. Errors, Error Codes, and Common Problems
B.1. Problems and Common Errors
B.2. Server Error Codes and Messages
B.3. Client Error Codes and Messages
C. MySQL Enterprise Release Notes
C.1. MySQL Enterprise 5.0 Release Notes
D. MySQL Community Server Enhancements and Release Notes
D.1. MySQL Community Server 5.0 Enhancements and Release Notes
E. MySQL Change History
E.1. Changes in release 5.0.x (Production)
E.2. Changes in MySQL Cluster
E.3. MySQL Connector/ODBC (MyODBC) Change History
E.4. Connector/NET Change History
E.5. MySQL Visual Studio Plugin Change History
E.6. MySQL Connector/J Change History
E.7. MySQL Connector/MXJ Change History
F. Limits and Restrictions
F.1. Restrictions on Stored Routines and Triggers
F.2. Restrictions on Server-Side Cursors
F.3. Restrictions on Subqueries
F.4. Restrictions on Views
F.5. Restrictions on XA Transactions
F.6. Limits in MySQL
G. Credits
G.1. Developers at MySQL AB
G.2. Contributors to MySQL
G.3. Documenters and translators
G.4. Libraries used by and included with MySQL
G.5. Packages that support MySQL
G.6. Tools that were used to create MySQL
G.7. Supporters of MySQL

List of Figures

A.1. Availability comparison
A.2. Active-Master MySQL server

List of Tables

23.1. Mapping of MySQL Error Numbers to SQLStates

List of Examples

23.1. Obtaining a connection from the DriverManager
23.2. Using java.sql.Statement to execute a SELECT query
23.3. Stored Procedures
23.4. Using Connection.prepareCall()
23.5. Registering output parameters
23.6. Setting CallableStatement input parameters
23.7. Retrieving results and output parameter values
23.8. Retrieving AUTO_INCREMENT column values using Statement.getGeneratedKeys()
23.9. Retrieving AUTO_INCREMENT column values using SELECT LAST_INSERT_ID()
23.10. Retrieving AUTO_INCREMENT column values in Updatable ResultSets
23.11. Using a connection pool with a J2EE application server
23.12. Example of transaction with retry logic


JavaScript Editor Source code editor     What Is Ajax