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

20. The INFORMATION_SCHEMA Database

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.7. MySQL 5.0 FAQ — INFORMATION_SCHEMA
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.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