MySQL Language Reference: The Official Guide to the MySQL Language and APIs

Description:

With more than 4 million active installations, MySQL is the world's most popular open-source database.

Known for its speed, high reliability, and ease of use, MySQL is rapidly becoming a low-cost alternative to high-priced, high-maintenance database systems from Oracle, IMB and Microsoft-and it already has more users than any of these more established proprietary databases.

The MySQL Language Reference is the only official guide to the MySQL language and programming APIs.

Written by the creators of MySQL, and edited by the highly respected MySQL authors, the MySQL Language Reference is designed for database administrators and programmers who need a reliable, detailed reference to every part of the MySQL language and all the available APIs.

 

Table of Contents:

1. General Information.

About This Guide. Overview of the MySQL Database Management System. Overview of MySQL AB. MySQL Support and Licensing. MySQL Development Roadmap. MySQL and the Future (the TODO). MySQL Information Sources. MySQL Standards Compliance.

2. Language Structure.

Literal Values. Database, Table, Index, Column, and Alias Names. User Variables. System Variables. Comment Syntax. Treatment of Reserved Words in MySQL.

3. Character Set Support.

Character Sets and Collations in General. Character Sets and Collations in MySQL. Determining the Default Character Set and Collation. Operations Affected by Character Set Support. Unicode Support. UTF8 for Metadata. Compatibility with Other DBMSs. New Character Set Configuration File Format. National Character Set. Upgrading Character Sets from MySQL 4.0. Character Sets and Collations That MySQL Supports.

4. Column Types.

Column Type Overview. Numeric Types. Date and Time Types. String Types. Column Type Storage Requirements. Choosing the Right Type for a Column. Using Column Types from Other Database Engines.

5. Functions and Operators.

Operators. Control Flow Functions. String Functions. Numeric Functions. Date and Time Functions. Full-Text Search Functions. Cast Functions. Other Functions. Functions and Modifiers for Use with GROUP BY Clauses.

6. SQL Statement Syntax.

Data Manipulation Statements. Data Definition Statements. MySQL Utility Statements. MySQL Transactional and Locking Statements. Database Administration Statements. Replication Statements.

7. Spatial Extensions in MySQL.

Introduction. The OpenGIS Geometry Model. Supported Spatial Data Formats. Creating a Spatially Enabled MySQL Database. Analyzing Spatial Information. Optimizing Spatial Analysis. MySQL Conformance and Compatibility.

8. Stored Procedures and Functions.

Stored Procedure Syntax.

9. Error Handling in MySQL

Error Returns. Error Messages.

Appendix A: Troubleshooting Query Problem.

Query-Related Issues. Optimizer-Related Issues. Table Definition-Related Issues.

Appendix B: MySQL Regular Expressions.

Index.