<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"><title>MySQL 5.1 Reference Manual</title><link rel="stylesheet" href="mysql-html.css" type="text/css"><meta name="generator" content="DocBook XSL Stylesheets V1.69.1"><meta name="description" content="
This is the MySQL™ Reference Manual. It documents MySQL
5.1 through 5.1.41, as well as MySQL
Cluster releases based on versions 6.1, 6.2, 6.3, and 7.0 of
NDBCLUSTER through
5.1.15-ndb-6.1.23, 5.1.39-ndb-6.2.19,
5.1.39-ndb-6.3.28, and 5.1.39-ndb-7.0.9.
MySQL 5.1 features
This manual describes features that are not included in every
edition of MySQL 5.1; such features may not be
included in the edition of MySQL 5.1 licensed to
you. If you have any questions about the features included in
your edition of MySQL 5.1, refer to your MySQL
5.1 license agreement or contact your Sun
Microsystems sales representative.
Document generated on:
(revision: 17276)
Getting StartedPlatformsAdministratorsDevelopersFunctionalityConnectorsHA/ScalabilityTutorial» Linux/UnixServer Option/Variable ReferenceServer Option/Variable ReferenceSQL SyntaxConnector/J» HA/Scalability GuideInstallation» Mac OS XMySQL Change History» MySQL Version ReferenceViewsConnector/ODBCMySQL and DRBDUpgrading» Windows» MySQL Version ReferenceSQL SyntaxStored RoutinesConnector/NETMySQL and VirtualizationServer Administration» Solaris» SecurityOptimizationReplicationConnector/C++MemcachedFAQs» Building from Source» Startup/ShutdownConnectors & APIsSpatial ExtensionsConnector/OOoMySQL ProxyMySQL Enterprise MonitorFunctions and OperatorsPrecision MathPHPReplication» Backup and RecoveryI18N & L18NC APIPartitioningPartitioningInformation Schema"><link rel="start" href="index.html" title="MySQL 5.1 Reference Manual"><link rel="next" href="preface.html" title="Preface, Notes, Licenses"></head><body bgcolor="white" text="black" link="#0000FF" vlink="#840084" alink="#0000FF"><div class="navheader"><table width="100%" summary="Navigation header"><tr><th colspan="3" align="center">MySQL 5.1 Reference Manual</th></tr><tr><td width="20%" align="left"> </td><th width="60%" align="center"> </th><td width="20%" align="right"> <a accesskey="n" href="preface.html">Next</a></td></tr></table><hr></div><div class="book" lang="en"><div class="titlepage"><div><div><h1 class="title"><a name="refman-5-1"></a>MySQL 5.1 Reference Manual</h1></div><div><h2 class="subtitle">Including MySQL Cluster NDB 6.X/7.X Reference Guide</h2></div><div><div class="legalnotice"><a name="id3981724"></a><p>
Copyright © 1997-2008 MySQL AB, 2009 Sun Microsystems, Inc. All
rights reserved. U.S. Government Rights - Commercial software.
Government users are subject to the Sun Microsystems, Inc. standard
license agreement and applicable provisions of the FAR and its
supplements. Use is subject to license terms. Sun, Sun Microsystems,
the Sun logo, Java, Solaris, StarOffice, MySQL Enterprise Monitor
2.0, MySQL logo™ and MySQL™ are trademarks or registered
trademarks of Sun Microsystems, Inc. in the U.S. and other
countries. UNIX is a registered trademark in the U.S. and other
countries, exclusively licensed through X/Open Company, Ltd.
</p><p>
Copyright © 1997-2008 MySQL AB, 2009 Sun Microsystems, Inc.
Tous droits réservés. L'utilisation est soumise aux termes du
contrat de licence.Sun, Sun Microsystems, le logo Sun, Java,
Solaris, StarOffice, MySQL Enterprise Monitor 2.0, MySQL logo™
et MySQL™ sont des marques de fabrique ou des marques
déposées de Sun Microsystems, Inc. aux Etats-Unis et dans d'autres
pays. UNIX est une marque déposée aux Etats-Unis et dans d'autres
pays et licenciée exlusivement par X/Open Company, Ltd.
</p><p>
This documentation is NOT distributed under a GPL license. Use of
this documentation is subject to the following terms: You may create
a printed copy of this documentation solely for your own personal
use. Conversion to other formats is allowed as long as the actual
content is not altered or edited in any way. You shall not publish
or distribute this documentation in any form or on any media, except
if you distribute the documentation in a manner similar to how Sun
disseminates it (that is, electronically for download on a Web site
with the software) or on a CD-ROM or similar medium, provided
however that the documentation is disseminated together with the
software on the same medium. Any other use, such as any
dissemination of printed copies or use of this documentation, in
whole or in part, in another publication, requires the prior written
consent from an authorized representative of Sun Microsystems, Inc.
Sun Microsystems, Inc. and MySQL AB reserve any and all rights to
this documentation not expressly granted above.
</p><p>
For more information on the terms of this license, for details on
how the MySQL documentation is built and produced, or if you are
interested in doing a translation, please contact the
<a href="http://www.mysql.com/company/contact/" target="_top">Documentation
Team</a>.
</p><p>
For additional licensing information, including licenses for
libraries used by MySQL, see <a href="preface.html" title="Preface, Notes, Licenses">Preface, Notes, Licenses</a>.
</p><p>
If you want help with using MySQL, please visit either the
<a href="http://forums.mysql.com" target="_top">MySQL Forums</a> or
<a href="http://lists.mysql.com" target="_top">MySQL Mailing Lists</a>
where you can discuss your issues with other MySQL users.
</p><p>
For additional documentation on MySQL products, including
translations of the documentation into other languages, and
downloadable versions in variety of formats, including HTML, CHM,
and PDF formats, see <a href="http://dev.mysql.com/doc" target="_top">MySQL
Documentation Library</a>.
</p></div></div><div><div class="abstract"><p class="title"><b>Abstract</b></p><p>
This is the MySQL™ Reference Manual. It documents MySQL
5.1 through 5.1.41, as well as MySQL
Cluster releases based on versions 6.1, 6.2, 6.3, and 7.0 of
<code class="literal">NDBCLUSTER</code> through
5.1.15-ndb-6.1.23, 5.1.39-ndb-6.2.19,
5.1.39-ndb-6.3.28, and 5.1.39-ndb-7.0.9.
</p><p><b>MySQL 5.1 features. </b>
This manual describes features that are not included in every
edition of MySQL 5.1; such features may not be
included in the edition of MySQL 5.1 licensed to
you. If you have any questions about the features included in
your edition of MySQL 5.1, refer to your MySQL
5.1 license agreement or contact your Sun
Microsystems sales representative.
</p><p>
Document generated on:
2009-10-23
(revision: 17276)
</p><p>
</p><div class="informaltable"><table border="1"><colgroup><col><col><col><col><col><col><col></colgroup><thead><tr><th>Getting Started</th><th>Platforms</th><th>Administrators</th><th>Developers</th><th>Functionality</th><th>Connectors</th><th>HA/Scalability</th></tr></thead><tbody><tr><td><a href="tutorial.html" title="Chapter 3. Tutorial">Tutorial</a></td><td><a href="http://dev.mysql.com/doc/mysql-linuxunix-excerpt/5.1/en/index.html" target="_top">» Linux/Unix</a></td><td><a href="server-administration.html#mysqld-option-tables" title="5.1.1. Server Option and Variable Reference">Server Option/Variable Reference</a></td><td><a href="server-administration.html#mysqld-option-tables" title="5.1.1. Server Option and Variable Reference">Server Option/Variable Reference</a></td><td><a href="sql-syntax.html" title="Chapter 12. SQL Statement Syntax">SQL Syntax</a></td><td><a href="connectors-apis.html#connector-j" title="21.3. MySQL Connector/J">Connector/J</a></td><td><a href="http://dev.mysql.com/doc/mysql-ha-scalability/en/index.html" target="_top">» HA/Scalability Guide</a></td></tr><tr><td><a href="installing.html" title="Chapter 2. Installing and Upgrading MySQL">Installation</a></td><td><a href="http://dev.mysql.com/doc/mysql-macosx-excerpt/5.1/en/index.html" target="_top">» Mac OS X</a></td><td><a href="news.html" title="Appendix C. MySQL Change History">MySQL Change History</a></td><td><a href="http://dev.mysql.com/doc/mysqld-version-reference/en/index.html" target="_top">» MySQL Version Reference</a></td><td><a href="stored-programs-views.html#views" title="19.5. Using Views">Views</a></td><td><a href="connectors-apis.html#connector-odbc" title="21.1. MySQL Connector/ODBC">Connector/ODBC</a></td><td><a href="ha-overview.html#ha-drbd" title="14.1. Using MySQL with DRBD">MySQL and DRBD</a></td></tr><tr><td><a href="installing.html#upgrade" title="2.4.1. Upgrading MySQL">Upgrading</a></td><td><a href="http://dev.mysql.com/doc/mysql-windows-excerpt/5.1/en/index.html" target="_top">» Windows</a></td><td><a href="http://dev.mysql.com/doc/mysqld-version-reference/en/index.html" target="_top">» MySQL Version Reference</a></td><td><a href="sql-syntax.html" title="Chapter 12. SQL Statement Syntax">SQL Syntax</a></td><td><a href="stored-programs-views.html#stored-routines" title="19.2. Using Stored Routines (Procedures and Functions)">Stored Routines</a></td><td><a href="connectors-apis.html#connector-net" title="21.2. MySQL Connector/NET">Connector/NET</a></td><td><a href="ha-overview.html#ha-vm" title="14.3. MySQL and Virtualization">MySQL and Virtualization</a></td></tr><tr><td><a href="server-administration.html" title="Chapter 5. MySQL Server Administration">Server Administration</a></td><td><a href="http://dev.mysql.com/doc/mysql-solaris-excerpt/5.1/en/index.html" target="_top">» Solaris</a></td><td><a href="http://dev.mysql.com/doc/mysql-security-excerpt/5.1/en/index.html" target="_top">» Security</a></td><td><a href="optimization.html" title="Chapter 7. Optimization">Optimization</a></td><td><a href="replication.html" title="Chapter 16. Replication">Replication</a></td><td><a href="connectors-apis.html#connector-net" title="21.2. MySQL Connector/NET">Connector/C++</a></td><td><a href="ha-overview.html#ha-memcached" title="14.5. Using MySQL with memcached">Memcached</a></td></tr><tr><td><a href="faqs.html" title="Appendix A. MySQL 5.1 Frequently Asked Questions">FAQs</a></td><td><a href="http://dev.mysql.com/doc/mysql-sourcebuild-excerpt/5.1/en/index.html" target="_top">» Building from Source</a></td><td><a href="http://dev.mysql.com/doc/mysql-startstop-excerpt/5.1/en/index.html" target="_top">» Startup/Shutdown</a></td><td><a href="connectors-apis.html" title="Chapter 21. Connectors and APIs">Connectors & APIs</a></td><td><a href="functions.html#spatial-extensions" title="11.13. Spatial Extensions">Spatial Extensions</a></td><td><a href="connectors-apis.html#connector-ooo" title="21.7. MySQL Connector/OpenOffice.org">Connector/OOo</a></td><td><a href="ha-overview.html#mysql-proxy" title="14.6. MySQL Proxy">MySQL Proxy</a></td></tr><tr><td><a href="mem-introduction.html" title="Chapter 15. MySQL Enterprise Monitor">MySQL Enterprise Monitor</a></td><td><a href="functions.html" title="Chapter 11. Functions and Operators">Functions and Operators</a></td><td><a href="functions.html#precision-math" title="11.14. Precision Math">Precision Math</a></td><td><a href="connectors-apis.html#apis-php" title="21.10. MySQL PHP API">PHP</a></td><td><a href="replication.html" title="Chapter 16. Replication">Replication</a></td><td class="auto-generated"> </td><td class="auto-generated"> </td></tr><tr><td><a href="http://dev.mysql.com/doc/mysql-backup-excerpt/5.1/en/index.html" target="_top">» Backup and Recovery</a></td><td><a href="internationalization-localization.html" title="Chapter 9. Internationalization and Localization">I18N & L18N</a></td><td><a href="connectors-apis.html#c" title="21.9. MySQL C API">C API</a></td><td class="auto-generated"> </td><td class="auto-generated"> </td><td class="auto-generated"> </td><td class="auto-generated"> </td></tr><tr><td><a href="partitioning.html" title="Chapter 18. Partitioning">Partitioning</a></td><td><a href="partitioning.html" title="Chapter 18. Partitioning">Partitioning</a></td><td class="auto-generated"> </td><td class="auto-generated"> </td><td class="auto-generated"> </td><td class="auto-generated"> </td><td class="auto-generated"> </td></tr><tr><td><a href="information-schema.html" title="Chapter 20. INFORMATION_SCHEMA Tables">Information Schema</a></td><td class="auto-generated"> </td><td class="auto-generated"> </td><td class="auto-generated"> </td><td class="auto-generated"> </td><td class="auto-generated"> </td><td class="auto-generated"> </td></tr></tbody></table></div></div></div></div><hr></div><div class="toc"><p><b>Table of Contents</b></p><dl><dt><span class="preface"><a href="preface.html">Preface, Notes, Licenses</a></span></dt><dd><dl><dt><span class="section"><a href="preface.html#copyright-mysql">1. MySQL Copyright Notice</a></span></dt><dt><span class="section"><a href="preface.html#license-regex">2. <code class="literal">regex</code> Library License</a></span></dt><dt><span class="section"><a href="preface.html#license-libedit">3. <code class="literal">libedit</code> License</a></span></dt><dt><span class="section"><a href="preface.html#license-getarg">4. <code class="literal">getarg</code> License</a></span></dt></dl></dd><dt><span class="chapter"><a href="introduction.html">1. General Information</a></span></dt><dd><dl><dt><span class="section"><a href="introduction.html#manual-info">1.1. About This Manual</a></span></dt><dt><span class="section"><a href="introduction.html#manual-conventions">1.2. Typographical and Syntax Conventions</a></span></dt><dt><span class="section"><a href="introduction.html#what-is">1.3. Overview of the MySQL Database Management System</a></span></dt><dd><dl><dt><span class="section"><a href="introduction.html#what-is-mysql">1.3.1. What is MySQL?</a></span></dt><dt><span class="section"><a href="introduction.html#history">1.3.2. History of MySQL</a></span></dt><dt><span class="section"><a href="introduction.html#features">1.3.3. The Main Features of MySQL</a></span></dt></dl></dd><dt><span class="section"><a href="introduction.html#roadmap">1.4. MySQL Development Roadmap</a></span></dt><dd><dl><dt><span class="section"><a href="introduction.html#mysql-nutshell">1.4.1. What Is New in MySQL 5.1</a></span></dt><dt><span class="section"><a href="introduction.html#mysql-next-series-plans">1.4.2. What Is Planned for MySQL 5.4</a></span></dt></dl></dd><dt><span class="section"><a href="introduction.html#information-sources">1.5. MySQL Information Sources</a></span></dt><dd><dl><dt><span class="section"><a href="introduction.html#mailing-lists">1.5.1. MySQL Mailing Lists</a></span></dt><dt><span class="section"><a href="introduction.html#forums">1.5.2. MySQL Community Support at the MySQL Forums</a></span></dt><dt><span class="section"><a href="introduction.html#irc">1.5.3. MySQL Community Support on Internet Relay Chat (IRC)</a></span></dt><dt><span class="section"><a href="introduction.html#mysql-enterprise-information">1.5.4. MySQL Enterprise</a></span></dt></dl></dd><dt><span class="section"><a href="introduction.html#bug-reports">1.6. How to Report Bugs or Problems</a></span></dt><dt><span class="section"><a href="introduction.html#compatibility">1.7. MySQL Standards Compliance</a></span></dt><dd><dl><dt><span class="section"><a href="introduction.html#standards">1.7.1. What Standards MySQL Follows</a></span></dt><dt><span class="section"><a href="introduction.html#sql-mode">1.7.2. Selecting SQL Modes</a></span></dt><dt><span class="section"><a href="introduction.html#ansi-mode">1.7.3. Running MySQL in ANSI Mode</a></span></dt><dt><span class="section"><a href="introduction.html#extensions-to-ansi">1.7.4. MySQL Extensions to Standard SQL</a></span></dt><dt><span class="section"><a href="introduction.html#differences-from-ansi">1.7.5. MySQL Differences from Standard SQL</a></span></dt><dt><span class="section"><a href="introduction.html#constraints">1.7.6. How MySQL Deals with Constraints</a></span></dt></dl></dd><dt><span class="section"><a href="introduction.html#credits">1.8. Credits</a></span></dt><dd><dl><dt><span class="section"><a href="introduction.html#contributors">1.8.1. Contributors to MySQL</a></span></dt><dt><span class="section"><a href="introduction.html#documenters-translators">1.8.2. Documenters and translators</a></span></dt><dt><span class="section"><a href="introduction.html#packages">1.8.3. Packages that support MySQL</a></span></dt><dt><span class="section"><a href="introduction.html#tools-used-to-create-mysql">1.8.4. Tools that were used to create MySQL</a></span></dt><dt><span class="section"><a href="introduction.html#supporters">1.8.5. Supporters of MySQL</a></span></dt></dl></dd></dl></dd><dt><span class="chapter"><a href="installing.html">2. Installing and Upgrading MySQL</a></span></dt><dd><dl><dt><span class="section"><a href="installing.html#general-installation-issues">2.1. General Installation Guidance</a></span></dt><dd><dl><dt><span class="section"><a href="installing.html#supported-os">2.1.1. Operating Systems Supported by MySQL Community Server</a></span></dt><dt><span class="section"><a href="installing.html#which-version">2.1.2. Choosing Which MySQL Distribution to Install</a></span></dt><dt><span class="section"><a href="installing.html#getting-mysql">2.1.3. How to Get MySQL</a></span></dt><dt><span class="section"><a href="installing.html#verifying-package-integrity">2.1.4. Verifying Package Integrity Using MD5 Checksums or
<code class="literal">GnuPG</code></a></span></dt><dt><span class="section"><a href="installing.html#installation-layouts">2.1.5. Installation Layouts</a></span></dt></dl></dd><dt><span class="section"><a href="installing.html#installing-binary">2.2. Installing MySQL from Generic Binaries on Unix/Linux</a></span></dt><dt><span class="section"><a href="installing.html#installing-source">2.3. MySQL Installation Using a Source Distribution</a></span></dt><dd><dl><dt><span class="section"><a href="installing.html#quick-install">2.3.1. Source Installation Overview</a></span></dt><dt><span class="section"><a href="installing.html#configure-options">2.3.2. Typical <span><strong class="command">configure</strong></span> Options</a></span></dt><dt><span class="section"><a href="installing.html#installing-source-tree">2.3.3. Installing from the Development Source Tree</a></span></dt><dt><span class="section"><a href="installing.html#compilation-problems">2.3.4. Dealing with Problems Compiling MySQL</a></span></dt><dt><span class="section"><a href="installing.html#mit-pthreads">2.3.5. MIT-pthreads Notes</a></span></dt></dl></dd><dt><span class="section"><a href="installing.html#upgrade-downgrade">2.4. Upgrading or Downgrading MySQL</a></span></dt><dd><dl><dt><span class="section"><a href="installing.html#upgrade">2.4.1. Upgrading MySQL</a></span></dt><dt><span class="section"><a href="installing.html#downgrading">2.4.2. Downgrading MySQL</a></span></dt><dt><span class="section"><a href="installing.html#checking-index-changes">2.4.3. Checking Whether Table Indexes Must Be Rebuilt</a></span></dt><dt><span class="section"><a href="installing.html#rebuilding-tables">2.4.4. Rebuilding or Repairing Tables or Indexes</a></span></dt><dt><span class="section"><a href="installing.html#copying-databases">2.4.5. Copying MySQL Databases to Another Machine</a></span></dt></dl></dd><dt><span class="section"><a href="installing.html#windows-installation">2.5. Installing MySQL on Windows</a></span></dt><dd><dl><dt><span class="section"><a href="installing.html#windows-choosing-package">2.5.1. Choosing An Installation Package</a></span></dt><dt><span class="section"><a href="installing.html#windows-using-installer">2.5.2. Installing MySQL with the MSI Package</a></span></dt><dt><span class="section"><a href="installing.html#mysql-config-wizard">2.5.3. MySQL Server Instance Config Wizard</a></span></dt><dt><span class="section"><a href="installing.html#windows-install-archive">2.5.4. Installing MySQL from a <code class="literal">noinstall</code> Zip Archive</a></span></dt><dt><span class="section"><a href="installing.html#windows-troubleshooting">2.5.5. Troubleshooting a MySQL Installation Under Windows</a></span></dt><dt><span class="section"><a href="installing.html#windows-upgrading">2.5.6. Upgrading MySQL on Windows</a></span></dt><dt><span class="section"><a href="installing.html#windows-vs-unix">2.5.7. MySQL on Windows Compared to MySQL on Unix</a></span></dt><dt><span class="section"><a href="installing.html#windows-source-build">2.5.8. Installing MySQL from Source on Windows</a></span></dt><dt><span class="section"><a href="installing.html#windows-client-compiling">2.5.9. Compiling MySQL Clients on Windows</a></span></dt></dl></dd><dt><span class="section"><a href="installing.html#linux">2.6. Installing MySQL on Linux</a></span></dt><dd><dl><dt><span class="section"><a href="installing.html#linux-rpm">2.6.1. Installing MySQL from RPM Packages on Linux</a></span></dt></dl></dd><dt><span class="section"><a href="installing.html#mac-os-x-installation">2.7. Installing MySQL on Mac OS X</a></span></dt><dd><dl><dt><span class="section"><a href="installing.html#mysql-installation-macosx-pkg">2.7.1. Installing MySQL Using the Installation Package</a></span></dt><dt><span class="section"><a href="installing.html#mysql-installation-macosx-startupitem">2.7.2. Installing the MySQL Startup Item</a></span></dt><dt><span class="section"><a href="installing.html#mysql-installation-macosx-prefpane">2.7.3. Installing and Using the MySQL Preference Pane</a></span></dt><dt><span class="section"><a href="installing.html#mysql-installation-macosx-server">2.7.4. Using MySQL on Mac OS X Server</a></span></dt><dt><span class="section"><a href="installing.html#mysql-installation-macosx-notes">2.7.5. MySQL Installation on Mac OS X Notes</a></span></dt></dl></dd><dt><span class="section"><a href="installing.html#solaris-installation">2.8. Installing MySQL on Solaris</a></span></dt><dd><dl><dt><span class="section"><a href="installing.html#solaris">2.8.1. Solaris Notes</a></span></dt></dl></dd><dt><span class="section"><a href="installing.html#installation-i5os">2.9. Installing MySQL on i5/OS</a></span></dt><dt><span class="section"><a href="installing.html#mysql-installation-freebsd">2.10. Installing MySQL on FreeBSD</a></span></dt><dt><span class="section"><a href="installing.html#mysql-installation-hpux">2.11. Installing MySQL on HP-UX</a></span></dt><dt><span class="section"><a href="installing.html#ibm-aix">2.12. Installing MySQL on AIX</a></span></dt><dt><span class="section"><a href="installing.html#post-installation">2.13. Post-Installation Setup and Testing</a></span></dt><dd><dl><dt><span class="section"><a href="installing.html#windows-post-installation">2.13.1. Windows Post-Installation Procedures</a></span></dt><dt><span class="section"><a href="installing.html#unix-post-installation">2.13.2. Unix Post-Installation Procedures</a></span></dt><dt><span class="section"><a href="installing.html#default-privileges">2.13.3. Securing the Initial MySQL Accounts</a></span></dt></dl></dd><dt><span class="section"><a href="installing.html#environment-variables">2.14. Environment Variables</a></span></dt><dt><span class="section"><a href="installing.html#perl-support">2.15. Perl Installation Notes</a></span></dt><dd><dl><dt><span class="section"><a href="installing.html#perl-installation">2.15.1. Installing Perl on Unix</a></span></dt><dt><span class="section"><a href="installing.html#activestate-perl">2.15.2. Installing ActiveState Perl on Windows</a></span></dt><dt><span class="section"><a href="installing.html#perl-support-problems">2.15.3. Problems Using the Perl <code class="literal">DBI</code>/<code class="literal">DBD</code>
Interface</a></span></dt></dl></dd></dl></dd><dt><span class="chapter"><a href="tutorial.html">3. Tutorial</a></span></dt><dd><dl><dt><span class="section"><a href="tutorial.html#connecting-disconnecting">3.1. Connecting to and Disconnecting from the Server</a></span></dt><dt><span class="section"><a href="tutorial.html#entering-queries">3.2. Entering Queries</a></span></dt><dt><span class="section"><a href="tutorial.html#database-use">3.3. Creating and Using a Database</a></span></dt><dd><dl><dt><span class="section"><a href="tutorial.html#creating-database">3.3.1. Creating and Selecting a Database</a></span></dt><dt><span class="section"><a href="tutorial.html#creating-tables">3.3.2. Creating a Table</a></span></dt><dt><span class="section"><a href="tutorial.html#loading-tables">3.3.3. Loading Data into a Table</a></span></dt><dt><span class="section"><a href="tutorial.html#retrieving-data">3.3.4. Retrieving Information from a Table</a></span></dt></dl></dd><dt><span class="section"><a href="tutorial.html#getting-information">3.4. Getting Information About Databases and Tables</a></span></dt><dt><span class="section"><a href="tutorial.html#batch-mode">3.5. Using <span><strong class="command">mysql</strong></span> in Batch Mode</a></span></dt><dt><span class="section"><a href="tutorial.html#examples">3.6. Examples of Common Queries</a></span></dt><dd><dl><dt><span class="section"><a href="tutorial.html#example-maximum-column">3.6.1. The Maximum Value for a Column</a></span></dt><dt><span class="section"><a href="tutorial.html#example-maximum-row">3.6.2. The Row Holding the Maximum of a Certain Column</a></span></dt><dt><span class="section"><a href="tutorial.html#example-maximum-column-group">3.6.3. Maximum of Column per Group</a></span></dt><dt><span class="section"><a href="tutorial.html#example-maximum-column-group-row">3.6.4. The Rows Holding the Group-wise Maximum of a Certain Column</a></span></dt><dt><span class="section"><a href="tutorial.html#example-user-variables">3.6.5. Using User-Defined Variables</a></span></dt><dt><span class="section"><a href="tutorial.html#example-foreign-keys">3.6.6. Using Foreign Keys</a></span></dt><dt><span class="section"><a href="tutorial.html#searching-on-two-keys">3.6.7. Searching on Two Keys</a></span></dt><dt><span class="section"><a href="tutorial.html#calculating-days">3.6.8. Calculating Visits Per Day</a></span></dt><dt><span class="section"><a href="tutorial.html#example-auto-increment">3.6.9. Using <code class="literal">AUTO_INCREMENT</code></a></span></dt></dl></dd><dt><span class="section"><a href="tutorial.html#twin">3.7. Queries from the Twin Project</a></span></dt><dd><dl><dt><span class="section"><a href="tutorial.html#twin-pool">3.7.1. Find All Nondistributed Twins</a></span></dt><dt><span class="section"><a href="tutorial.html#twin-event">3.7.2. Show a Table of Twin Pair Status</a></span></dt></dl></dd><dt><span class="section"><a href="tutorial.html#apache">3.8. Using MySQL with Apache</a></span></dt></dl></dd><dt><span class="chapter"><a href="programs.html">4. MySQL Programs</a></span></dt><dd><dl><dt><span class="section"><a href="programs.html#programs-overview">4.1. Overview of MySQL Programs</a></span></dt><dt><span class="section"><a href="programs.html#programs-using">4.2. Using MySQL Programs</a></span></dt><dd><dl><dt><span class="section"><a href="programs.html#invoking-programs">4.2.1. Invoking MySQL Programs</a></span></dt><dt><span class="section"><a href="programs.html#connecting">4.2.2. Connecting to the MySQL Server</a></span></dt><dt><span class="section"><a href="programs.html#program-options">4.2.3. Specifying Program Options</a></span></dt><dt><span class="section"><a href="programs.html#setting-environment-variables">4.2.4. Setting Environment Variables</a></span></dt></dl></dd><dt><span class="section"><a href="programs.html#programs-server">4.3. MySQL Server and Server-Startup Programs</a></span></dt><dd><dl><dt><span class="section"><a href="programs.html#mysqld">4.3.1. <span><strong class="command">mysqld</strong></span> — The MySQL Server</a></span></dt><dt><span class="section"><a href="programs.html#mysqld-safe">4.3.2. <span><strong class="command">mysqld_safe</strong></span> — MySQL Server Startup Script</a></span></dt><dt><span class="section"><a href="programs.html#mysql-server">4.3.3. <span><strong class="command">mysql.server</strong></span> — MySQL Server Startup Script</a></span></dt><dt><span class="section"><a href="programs.html#mysqld-multi">4.3.4. <span><strong class="command">mysqld_multi</strong></span> — Manage Multiple MySQL Servers</a></span></dt></dl></dd><dt><span class="section"><a href="programs.html#programs-installation">4.4. MySQL Installation-Related Programs</a></span></dt><dd><dl><dt><span class="section"><a href="programs.html#comp-err">4.4.1. <span><strong class="command">comp_err</strong></span> — Compile MySQL Error Message File</a></span></dt><dt><span class="section"><a href="programs.html#make-win-bin-dist">4.4.2. <span><strong class="command">make_win_bin_dist</strong></span> — Package MySQL Distribution as ZIP Archive</a></span></dt><dt><span class="section"><a href="programs.html#mysqlbug">4.4.3. <span><strong class="command">mysqlbug</strong></span> — Generate Bug Report</a></span></dt><dt><span class="section"><a href="programs.html#mysql-fix-privilege-tables">4.4.4. <span><strong class="command">mysql_fix_privilege_tables</strong></span> — Upgrade MySQL System Tables</a></span></dt><dt><span class="section"><a href="programs.html#mysql-install-db">4.4.5. <span><strong class="command">mysql_install_db</strong></span> — Initialize MySQL Data Directory</a></span></dt><dt><span class="section"><a href="programs.html#mysql-secure-installation">4.4.6. <span><strong class="command">mysql_secure_installation</strong></span> — Improve MySQL Installation Security</a></span></dt><dt><span class="section"><a href="programs.html#mysql-tzinfo-to-sql">4.4.7. <span><strong class="command">mysql_tzinfo_to_sql</strong></span> — Load the Time Zone Tables</a></span></dt><dt><span class="section"><a href="programs.html#mysql-upgrade">4.4.8. <span><strong class="command">mysql_upgrade</strong></span> — Check Tables for MySQL Upgrade</a></span></dt></dl></dd><dt><span class="section"><a href="programs.html#programs-client">4.5. MySQL Client Programs</a></span></dt><dd><dl><dt><span class="section"><a href="programs.html#mysql">4.5.1. <span><strong class="command">mysql</strong></span> — The MySQL Command-Line Tool</a></span></dt><dt><span class="section"><a href="programs.html#mysqladmin">4.5.2. <span><strong class="command">mysqladmin</strong></span> — Client for Administering a MySQL Server</a></span></dt><dt><span class="section"><a href="programs.html#mysqlcheck">4.5.3. <span><strong class="command">mysqlcheck</strong></span> — A Table Maintenance Program</a></span></dt><dt><span class="section"><a href="programs.html#mysqldump">4.5.4. <span><strong class="command">mysqldump</strong></span> — A Database Backup Program</a></span></dt><dt><span class="section"><a href="programs.html#mysqlimport">4.5.5. <span><strong class="command">mysqlimport</strong></span> — A Data Import Program</a></span></dt><dt><span class="section"><a href="programs.html#mysqlshow">4.5.6. <span><strong class="command">mysqlshow</strong></span> — Display Database, Table, and Column Information</a></span></dt><dt><span class="section"><a href="programs.html#mysqlslap">4.5.7. <span><strong class="command">mysqlslap</strong></span> — Load Emulation Client</a></span></dt></dl></dd><dt><span class="section"><a href="programs.html#programs-admin-utils">4.6. MySQL Administrative and Utility Programs</a></span></dt><dd><dl><dt><span class="section"><a href="programs.html#innochecksum">4.6.1. <span><strong class="command">innochecksum</strong></span> — Offline InnoDB File Checksum Utility</a></span></dt><dt><span class="section"><a href="programs.html#myisam-ftdump">4.6.2. <span><strong class="command">myisam_ftdump</strong></span> — Display Full-Text Index information</a></span></dt><dt><span class="section"><a href="programs.html#myisamchk">4.6.3. <span><strong class="command">myisamchk</strong></span> — MyISAM Table-Maintenance Utility</a></span></dt><dt><span class="section"><a href="programs.html#myisamlog">4.6.4. <span><strong class="command">myisamlog</strong></span> — Display MyISAM Log File Contents</a></span></dt><dt><span class="section"><a href="programs.html#myisampack">4.6.5. <span><strong class="command">myisampack</strong></span> — Generate Compressed, Read-Only MyISAM Tables</a></span></dt><dt><span class="section"><a href="programs.html#mysqlaccess">4.6.6. <span><strong class="command">mysqlaccess</strong></span> — Client for Checking Access Privileges</a></span></dt><dt><span class="section"><a href="programs.html#mysqlbinlog">4.6.7. <span><strong class="command">mysqlbinlog</strong></span> — Utility for Processing Binary Log Files</a></span></dt><dt><span class="section"><a href="programs.html#mysqldumpslow">4.6.8. <span><strong class="command">mysqldumpslow</strong></span> — Summarize Slow Query Log Files</a></span></dt><dt><span class="section"><a href="programs.html#mysqlhotcopy">4.6.9. <span><strong class="command">mysqlhotcopy</strong></span> — A Database Backup Program</a></span></dt><dt><span class="section"><a href="programs.html#instance-manager">4.6.10. <span><strong class="command">mysqlmanager</strong></span> — The MySQL Instance Manager</a></span></dt><dt><span class="section"><a href="programs.html#mysql-convert-table-format">4.6.11. <span><strong class="command">mysql_convert_table_format</strong></span> — Convert Tables to Use a Given Storage
Engine</a></span></dt><dt><span class="section"><a href="programs.html#mysql-find-rows">4.6.12. <span><strong class="command">mysql_find_rows</strong></span> — Extract SQL Statements from Files</a></span></dt><dt><span class="section"><a href="programs.html#mysql-fix-extensions">4.6.13. <span><strong class="command">mysql_fix_extensions</strong></span> — Normalize Table File Name Extensions</a></span></dt><dt><span class="section"><a href="programs.html#mysql-setpermission">4.6.14. <span><strong class="command">mysql_setpermission</strong></span> — Interactively Set Permissions in Grant
Tables</a></span></dt><dt><span class="section"><a href="programs.html#mysql-waitpid">4.6.15. <span><strong class="command">mysql_waitpid</strong></span> — Kill Process and Wait for Its Termination</a></span></dt><dt><span class="section"><a href="programs.html#mysql-zap">4.6.16. <span><strong class="command">mysql_zap</strong></span> — Kill Processes That Match a Pattern</a></span></dt></dl></dd><dt><span class="section"><a href="programs.html#programs-development">4.7. MySQL Program Development Utilities</a></span></dt><dd><dl><dt><span class="section"><a href="programs.html#msql2mysql">4.7.1. <span><strong class="command">msql2mysql</strong></span> — Convert mSQL Programs for Use with MySQL</a></span></dt><dt><span class="section"><a href="programs.html#mysql-config">4.7.2. <span><strong class="command">mysql_config</strong></span> — Get Compile Options for Compiling Clients</a></span></dt><dt><span class="section"><a href="programs.html#my-print-defaults">4.7.3. <span><strong class="command">my_print_defaults</strong></span> — Display Options from Option Files</a></span></dt><dt><span class="section"><a href="programs.html#resolve-stack-dump">4.7.4. <span><strong class="command">resolve_stack_dump</strong></span> — Resolve Numeric Stack Trace Dump to Symbols</a></span></dt></dl></dd><dt><span class="section"><a href="programs.html#programs-miscellaneous">4.8. Miscellaneous Programs</a></span></dt><dd><dl><dt><span class="section"><a href="programs.html#perror">4.8.1. <span><strong class="command">perror</strong></span> — Explain Error Codes</a></span></dt><dt><span class="section"><a href="programs.html#replace-utility">4.8.2. <span><strong class="command">replace</strong></span> — A String-Replacement Utility</a></span></dt><dt><span class="section"><a href="programs.html#resolveip">4.8.3. <span><strong class="command">resolveip</strong></span> — Resolve Host name to IP Address or Vice
Versa</a></span></dt></dl></dd></dl></dd><dt><span class="chapter"><a href="server-administration.html">5. MySQL Server Administration</a></span></dt><dd><dl><dt><span class="section"><a href="server-administration.html#mysqld-server">5.1. The MySQL Server</a></span></dt><dd><dl><dt><span class="section"><a href="server-administration.html#mysqld-option-tables">5.1.1. Server Option and Variable Reference</a></span></dt><dt><span class="section"><a href="server-administration.html#server-options">5.1.2. Server Command Options</a></span></dt><dt><span class="section"><a href="server-administration.html#server-plugin-options">5.1.3. Server Options for Loading Plugins</a></span></dt><dt><span class="section"><a href="server-administration.html#server-system-variables">5.1.4. Server System Variables</a></span></dt><dt><span class="section"><a href="server-administration.html#server-session-variables">5.1.5. Session System Variables</a></span></dt><dt><span class="section"><a href="server-administration.html#using-system-variables">5.1.6. Using System Variables</a></span></dt><dt><span class="section"><a href="server-administration.html#server-status-variables">5.1.7. Server Status Variables</a></span></dt><dt><span class="section"><a href="server-administration.html#server-sql-mode">5.1.8. Server SQL Modes</a></span></dt><dt><span class="section"><a href="server-administration.html#server-side-help-support">5.1.9. Server-Side Help</a></span></dt><dt><span class="section"><a href="server-administration.html#server-signal-response">5.1.10. Server Response to Signals</a></span></dt><dt><span class="section"><a href="server-administration.html#server-shutdown">5.1.11. The Shutdown Process</a></span></dt></dl></dd><dt><span class="section"><a href="server-administration.html#server-logs">5.2. MySQL Server Logs</a></span></dt><dd><dl><dt><span class="section"><a href="server-administration.html#log-tables">5.2.1. Selecting General Query and Slow Query Log Output Destinations</a></span></dt><dt><span class="section"><a href="server-administration.html#error-log">5.2.2. The Error Log</a></span></dt><dt><span class="section"><a href="server-administration.html#query-log">5.2.3. The General Query Log</a></span></dt><dt><span class="section"><a href="server-administration.html#binary-log">5.2.4. The Binary Log</a></span></dt><dt><span class="section"><a href="server-administration.html#slow-query-log">5.2.5. The Slow Query Log</a></span></dt><dt><span class="section"><a href="server-administration.html#log-file-maintenance">5.2.6. Server Log Maintenance</a></span></dt></dl></dd><dt><span class="section"><a href="server-administration.html#security">5.3. General Security Issues</a></span></dt><dd><dl><dt><span class="section"><a href="server-administration.html#security-guidelines">5.3.1. General Security Guidelines</a></span></dt><dt><span class="section"><a href="server-administration.html#security-against-attack">5.3.2. Making MySQL Secure Against Attackers</a></span></dt><dt><span class="section"><a href="server-administration.html#privileges-options">5.3.3. Security-Related <span><strong class="command">mysqld</strong></span> Options</a></span></dt><dt><span class="section"><a href="server-administration.html#load-data-local">5.3.4. Security Issues with <code class="literal">LOAD
DATA LOCAL</code></a></span></dt><dt><span class="section"><a href="server-administration.html#changing-mysql-user">5.3.5. How to Run MySQL as a Normal User</a></span></dt></dl></dd><dt><span class="section"><a href="server-administration.html#privilege-system">5.4. The MySQL Access Privilege System</a></span></dt><dd><dl><dt><span class="section"><a href="server-administration.html#privileges-provided">5.4.1. Privileges Provided by MySQL</a></span></dt><dt><span class="section"><a href="server-administration.html#grant-table-structure">5.4.2. Privilege System Grant Tables</a></span></dt><dt><span class="section"><a href="server-administration.html#account-names">5.4.3. Specifying Account Names</a></span></dt><dt><span class="section"><a href="server-administration.html#connection-access">5.4.4. Access Control, Stage 1: Connection Verification</a></span></dt><dt><span class="section"><a href="server-administration.html#request-access">5.4.5. Access Control, Stage 2: Request Verification</a></span></dt><dt><span class="section"><a href="server-administration.html#privilege-changes">5.4.6. When Privilege Changes Take Effect</a></span></dt><dt><span class="section"><a href="server-administration.html#access-denied">5.4.7. Causes of Access-Denied Errors</a></span></dt></dl></dd><dt><span class="section"><a href="server-administration.html#user-account-management">5.5. MySQL User Account Management</a></span></dt><dd><dl><dt><span class="section"><a href="server-administration.html#user-names">5.5.1. User Names and Passwords</a></span></dt><dt><span class="section"><a href="server-administration.html#adding-users">5.5.2. Adding User Accounts</a></span></dt><dt><span class="section"><a href="server-administration.html#removing-users">5.5.3. Removing User Accounts</a></span></dt><dt><span class="section"><a href="server-administration.html#user-resources">5.5.4. Limiting Account Resources</a></span></dt><dt><span class="section"><a href="server-administration.html#passwords">5.5.5. Assigning Account Passwords</a></span></dt><dt><span class="section"><a href="server-administration.html#password-security">5.5.6. Password Security in MySQL</a></span></dt><dt><span class="section"><a href="server-administration.html#secure-connections">5.5.7. Using SSL for Secure Connections</a></span></dt><dt><span class="section"><a href="server-administration.html#windows-and-ssh">5.5.8. Connecting to MySQL Remotely from Windows with SSH</a></span></dt><dt><span class="section"><a href="server-administration.html#account-activity-auditing">5.5.9. Auditing MySQL Account Activity</a></span></dt></dl></dd><dt><span class="section"><a href="server-administration.html#multiple-servers">5.6. Running Multiple MySQL Servers on the Same Machine</a></span></dt><dd><dl><dt><span class="section"><a href="server-administration.html#multiple-windows-servers">5.6.1. Running Multiple Servers on Windows</a></span></dt><dt><span class="section"><a href="server-administration.html#multiple-unix-servers">5.6.2. Running Multiple Servers on Unix</a></span></dt><dt><span class="section"><a href="server-administration.html#multiple-server-clients">5.6.3. Using Client Programs in a Multiple-Server Environment</a></span></dt></dl></dd></dl></dd><dt><span class="chapter"><a href="backup-and-recovery.html">6. Backup and Recovery</a></span></dt><dd><dl><dt><span class="section"><a href="backup-and-recovery.html#backup-methods">6.1. Database Backup Methods</a></span></dt><dt><span class="section"><a href="backup-and-recovery.html#backup-strategy-example">6.2. Example Backup and Recovery Strategy</a></span></dt><dd><dl><dt><span class="section"><a href="backup-and-recovery.html#backup-policy">6.2.1. Backup Policy</a></span></dt><dt><span class="section"><a href="backup-and-recovery.html#recovery-from-backups">6.2.2. Using Backups for Recovery</a></span></dt><dt><span class="section"><a href="backup-and-recovery.html#backup-strategy-summary">6.2.3. Backup Strategy Summary</a></span></dt></dl></dd><dt><span class="section"><a href="backup-and-recovery.html#point-in-time-recovery">6.3. Point-in-Time Recovery</a></span></dt><dd><dl><dt><span class="section"><a href="backup-and-recovery.html#point-in-time-recovery-times">6.3.1. Point-in-Time Recovery from a Specific Time</a></span></dt><dt><span class="section"><a href="backup-and-recovery.html#point-in-time-recovery-positions">6.3.2. Point-in-Time Recovery from a Specific Log Position</a></span></dt></dl></dd><dt><span class="section"><a href="backup-and-recovery.html#table-maintenance">6.4. Table Maintenance and Crash Recovery</a></span></dt><dd><dl><dt><span class="section"><a href="backup-and-recovery.html#crash-recovery">6.4.1. Using <span><strong class="command">myisamchk</strong></span> for Crash Recovery</a></span></dt><dt><span class="section"><a href="backup-and-recovery.html#check">6.4.2. How to Check <code class="literal">MyISAM</code> Tables for Errors</a></span></dt><dt><span class="section"><a href="backup-and-recovery.html#repair">6.4.3. How to Repair Tables</a></span></dt><dt><span class="section"><a href="backup-and-recovery.html#table-optimization">6.4.4. Table Optimization</a></span></dt><dt><span class="section"><a href="backup-and-recovery.html#maintenance-schedule">6.4.5. Setting Up a Table Maintenance Schedule</a></span></dt></dl></dd></dl></dd><dt><span class="chapter"><a href="optimization.html">7. Optimization</a></span></dt><dd><dl><dt><span class="section"><a href="optimization.html#optimize-overview">7.1. Optimization Overview</a></span></dt><dd><dl><dt><span class="section"><a href="optimization.html#design-limitations">7.1.1. MySQL Design Limitations and Tradeoffs</a></span></dt><dt><span class="section"><a href="optimization.html#portability">7.1.2. Designing Applications for Portability</a></span></dt><dt><span class="section"><a href="optimization.html#internal-use">7.1.3. What We Have Used MySQL For</a></span></dt><dt><span class="section"><a href="optimization.html#mysql-benchmarks">7.1.4. The MySQL Benchmark Suite</a></span></dt><dt><span class="section"><a href="optimization.html#custom-benchmarks">7.1.5. Using Your Own Benchmarks</a></span></dt></dl></dd><dt><span class="section"><a href="optimization.html#query-speed">7.2. Optimizing <code class="literal">SELECT</code> and Other Statements</a></span></dt><dd><dl><dt><span class="section"><a href="optimization.html#using-explain">7.2.1. Optimizing Queries with <code class="literal">EXPLAIN</code></a></span></dt><dt><span class="section"><a href="optimization.html#estimating-performance">7.2.2. Estimating Query Performance</a></span></dt><dt><span class="section"><a href="optimization.html#select-speed">7.2.3. Speed of <code class="literal">SELECT</code> Queries</a></span></dt><dt><span class="section"><a href="optimization.html#where-optimizations">7.2.4. <code class="literal">WHERE</code> Clause Optimization</a></span></dt><dt><span class="section"><a href="optimization.html#range-optimization">7.2.5. Range Optimization</a></span></dt><dt><span class="section"><a href="optimization.html#index-merge-optimization">7.2.6. Index Merge Optimization</a></span></dt><dt><span class="section"><a href="optimization.html#condition-pushdown-optimization">7.2.7. Condition Pushdown Optimization</a></span></dt><dt><span class="section"><a href="optimization.html#is-null-optimization">7.2.8. <code class="literal">IS NULL</code> Optimization</a></span></dt><dt><span class="section"><a href="optimization.html#left-join-optimization">7.2.9. <code class="literal">LEFT JOIN</code> and <code class="literal">RIGHT JOIN</code>
Optimization</a></span></dt><dt><span class="section"><a href="optimization.html#nested-loop-joins">7.2.10. Nested-Loop Join Algorithms</a></span></dt><dt><span class="section"><a href="optimization.html#nested-join-optimization">7.2.11. Nested Join Optimization</a></span></dt><dt><span class="section"><a href="optimization.html#outer-join-simplification">7.2.12. Outer Join Simplification</a></span></dt><dt><span class="section"><a href="optimization.html#order-by-optimization">7.2.13. <code class="literal">ORDER BY</code> Optimization</a></span></dt><dt><span class="section"><a href="optimization.html#group-by-optimization">7.2.14. <code class="literal">GROUP BY</code> Optimization</a></span></dt><dt><span class="section"><a href="optimization.html#distinct-optimization">7.2.15. <code class="literal">DISTINCT</code> Optimization</a></span></dt><dt><span class="section"><a href="optimization.html#in-subquery-optimization">7.2.16. Optimizing <code class="literal">IN</code>/<code class="literal">=ANY</code> Subqueries</a></span></dt><dt><span class="section"><a href="optimization.html#limit-optimization">7.2.17. <code class="literal">LIMIT</code> Optimization</a></span></dt><dt><span class="section"><a href="optimization.html#switchable-optimizations">7.2.18. Using <code class="literal">optimizer_switch</code> to Control the
Optimizer</a></span></dt><dt><span class="section"><a href="optimization.html#how-to-avoid-table-scan">7.2.19. How to Avoid Table Scans</a></span></dt><dt><span class="section"><a href="optimization.html#information-schema-optimization">7.2.20. <code class="literal">INFORMATION_SCHEMA</code> Optimization</a></span></dt><dt><span class="section"><a href="optimization.html#insert-speed">7.2.21. Speed of <code class="literal">INSERT</code> Statements</a></span></dt><dt><span class="section"><a href="optimization.html#update-speed">7.2.22. Speed of <code class="literal">UPDATE</code> Statements</a></span></dt><dt><span class="section"><a href="optimization.html#delete-speed">7.2.23. Speed of <code class="literal">DELETE</code> Statements</a></span></dt><dt><span class="section"><a href="optimization.html#miscellaneous-optimization-tips">7.2.24. Other Optimization Tips</a></span></dt></dl></dd><dt><span class="section"><a href="optimization.html#locking-issues">7.3. Locking Issues</a></span></dt><dd><dl><dt><span class="section"><a href="optimization.html#internal-locking">7.3.1. Internal Locking Methods</a></span></dt><dt><span class="section"><a href="optimization.html#table-locking">7.3.2. Table Locking Issues</a></span></dt><dt><span class="section"><a href="optimization.html#concurrent-inserts">7.3.3. Concurrent Inserts</a></span></dt><dt><span class="section"><a href="optimization.html#external-locking">7.3.4. External Locking</a></span></dt></dl></dd><dt><span class="section"><a href="optimization.html#optimizing-database-structure">7.4. Optimizing Database Structure</a></span></dt><dd><dl><dt><span class="section"><a href="optimization.html#data-size">7.4.1. Make Your Data as Small as Possible</a></span></dt><dt><span class="section"><a href="optimization.html#indexes">7.4.2. Column Indexes</a></span></dt><dt><span class="section"><a href="optimization.html#multiple-column-indexes">7.4.3. Multiple-Column Indexes</a></span></dt><dt><span class="section"><a href="optimization.html#mysql-indexes">7.4.4. How MySQL Uses Indexes</a></span></dt><dt><span class="section"><a href="optimization.html#myisam-key-cache">7.4.5. The <code class="literal">MyISAM</code> Key Cache</a></span></dt><dt><span class="section"><a href="optimization.html#myisam-index-statistics">7.4.6. <code class="literal">MyISAM</code> Index Statistics Collection</a></span></dt><dt><span class="section"><a href="optimization.html#table-cache">7.4.7. How MySQL Opens and Closes Tables</a></span></dt><dt><span class="section"><a href="optimization.html#creating-many-tables">7.4.8. Disadvantages of Creating Many Tables in the Same Database</a></span></dt></dl></dd><dt><span class="section"><a href="optimization.html#optimizing-the-server">7.5. Optimizing the MySQL Server</a></span></dt><dd><dl><dt><span class="section"><a href="optimization.html#compile-and-link-options">7.5.1. How Compiling and Linking Affects the Speed of MySQL</a></span></dt><dt><span class="section"><a href="optimization.html#system-optimization">7.5.2. System Factors and Startup Parameter Tuning</a></span></dt><dt><span class="section"><a href="optimization.html#server-parameters">7.5.3. Tuning Server Parameters</a></span></dt><dt><span class="section"><a href="optimization.html#controlling-optimizer">7.5.4. Controlling Query Optimizer Performance</a></span></dt><dt><span class="section"><a href="optimization.html#query-cache">7.5.5. The MySQL Query Cache</a></span></dt><dt><span class="section"><a href="optimization.html#thread-information">7.5.6. Examining Thread Information</a></span></dt><dt><span class="section"><a href="optimization.html#connection-threads">7.5.7. How MySQL Uses Threads for Client Connections</a></span></dt><dt><span class="section"><a href="optimization.html#memory-use">7.5.8. How MySQL Uses Memory</a></span></dt><dt><span class="section"><a href="optimization.html#large-page-support">7.5.9. Enabling Large Page Support</a></span></dt><dt><span class="section"><a href="optimization.html#internal-temporary-tables">7.5.10. How MySQL Uses Internal Temporary Tables</a></span></dt><dt><span class="section"><a href="optimization.html#dns">7.5.11. How MySQL Uses DNS</a></span></dt></dl></dd><dt><span class="section"><a href="optimization.html#disk-issues">7.6. Disk Issues</a></span></dt><dd><dl><dt><span class="section"><a href="optimization.html#symbolic-links">7.6.1. Using Symbolic Links</a></span></dt></dl></dd></dl></dd><dt><span class="chapter"><a href="language-structure.html">8. Language Structure</a></span></dt><dd><dl><dt><span class="section"><a href="language-structure.html#literals">8.1. Literal Values</a></span></dt><dd><dl><dt><span class="section"><a href="language-structure.html#string-syntax">8.1.1. Strings</a></span></dt><dt><span class="section"><a href="language-structure.html#number-syntax">8.1.2. Numbers</a></span></dt><dt><span class="section"><a href="language-structure.html#hexadecimal-values">8.1.3. Hexadecimal Values</a></span></dt><dt><span class="section"><a href="language-structure.html#boolean-values">8.1.4. Boolean Values</a></span></dt><dt><span class="section"><a href="language-structure.html#bit-field-values">8.1.5. Bit-Field Values</a></span></dt><dt><span class="section"><a href="language-structure.html#null-values">8.1.6. <code class="literal">NULL</code> Values</a></span></dt></dl></dd><dt><span class="section"><a href="language-structure.html#identifiers">8.2. Schema Object Names</a></span></dt><dd><dl><dt><span class="section"><a href="language-structure.html#identifier-qualifiers">8.2.1. Identifier Qualifiers</a></span></dt><dt><span class="section"><a href="language-structure.html#identifier-case-sensitivity">8.2.2. Identifier Case Sensitivity</a></span></dt><dt><span class="section"><a href="language-structure.html#identifier-mapping">8.2.3. Mapping of Identifiers to File Names</a></span></dt><dt><span class="section"><a href="language-structure.html#function-resolution">8.2.4. Function Name Parsing and Resolution</a></span></dt></dl></dd><dt><span class="section"><a href="language-structure.html#reserved-words">8.3. Reserved Words</a></span></dt><dt><span class="section"><a href="language-structure.html#user-variables">8.4. User-Defined Variables</a></span></dt><dt><span class="section"><a href="language-structure.html#comments">8.5. Comment Syntax</a></span></dt></dl></dd><dt><span class="chapter"><a href="internationalization-localization.html">9. Internationalization and Localization</a></span></dt><dd><dl><dt><span class="section"><a href="internationalization-localization.html#charset">9.1. Character Set Support</a></span></dt><dd><dl><dt><span class="section"><a href="internationalization-localization.html#charset-general">9.1.1. Character Sets and Collations in General</a></span></dt><dt><span class="section"><a href="internationalization-localization.html#charset-mysql">9.1.2. Character Sets and Collations in MySQL</a></span></dt><dt><span class="section"><a href="internationalization-localization.html#charset-syntax">9.1.3. Specifying Character Sets and Collations</a></span></dt><dt><span class="section"><a href="internationalization-localization.html#charset-connection">9.1.4. Connection Character Sets and Collations</a></span></dt><dt><span class="section"><a href="internationalization-localization.html#charset-applications">9.1.5. Configuring the Character Set and Collation for Applications</a></span></dt><dt><span class="section"><a href="internationalization-localization.html#charset-errors">9.1.6. Character Set for Error Messages</a></span></dt><dt><span class="section"><a href="internationalization-localization.html#charset-collations">9.1.7. Collation Issues</a></span></dt><dt><span class="section"><a href="internationalization-localization.html#charset-repertoire">9.1.8. String Repertoire</a></span></dt><dt><span class="section"><a href="internationalization-localization.html#charset-operations">9.1.9. Operations Affected by Character Set Support</a></span></dt><dt><span class="section"><a href="internationalization-localization.html#charset-unicode">9.1.10. Unicode Support</a></span></dt><dt><span class="section"><a href="internationalization-localization.html#charset-metadata">9.1.11. UTF-8 for Metadata</a></span></dt><dt><span class="section"><a href="internationalization-localization.html#charset-conversion">9.1.12. Column Character Set Conversion</a></span></dt><dt><span class="section"><a href="internationalization-localization.html#charset-charsets">9.1.13. Character Sets and Collations That MySQL Supports</a></span></dt></dl></dd><dt><span class="section"><a href="internationalization-localization.html#charset-configuration">9.2. The Character Set Used for Data and Sorting</a></span></dt><dt><span class="section"><a href="internationalization-localization.html#error-message-language">9.3. Setting the Error Message Language</a></span></dt><dt><span class="section"><a href="internationalization-localization.html#adding-character-set">9.4. Adding a New Character Set</a></span></dt><dd><dl><dt><span class="section"><a href="internationalization-localization.html#character-arrays">9.4.1. The Character Definition Arrays</a></span></dt><dt><span class="section"><a href="internationalization-localization.html#string-collating">9.4.2. String Collating Support</a></span></dt><dt><span class="section"><a href="internationalization-localization.html#multi-byte-characters">9.4.3. Multi-Byte Character Support</a></span></dt></dl></dd><dt><span class="section"><a href="internationalization-localization.html#adding-collation">9.5. How to Add a New Collation to a Character Set</a></span></dt><dd><dl><dt><span class="section"><a href="internationalization-localization.html#charset-collation-implementations">9.5.1. Collation Implementation Types</a></span></dt><dt><span class="section"><a href="internationalization-localization.html#adding-collation-choosing-id">9.5.2. Choosing a Collation ID</a></span></dt><dt><span class="section"><a href="internationalization-localization.html#adding-collation-simple-8bit">9.5.3. Adding a Simple Collation to an 8-Bit Character Set</a></span></dt><dt><span class="section"><a href="internationalization-localization.html#adding-collation-unicode-uca">9.5.4. Adding a UCA Collation to a Unicode Character Set</a></span></dt></dl></dd><dt><span class="section"><a href="internationalization-localization.html#problems-with-character-sets">9.6. Problems With Character Sets</a></span></dt><dt><span class="section"><a href="internationalization-localization.html#time-zone-support">9.7. MySQL Server Time Zone Support</a></span></dt><dd><dl><dt><span class="section"><a href="internationalization-localization.html#time-zone-upgrades">9.7.1. Staying Current with Time Zone Changes</a></span></dt><dt><span class="section"><a href="internationalization-localization.html#time-zone-leap-seconds">9.7.2. Time Zone Leap Second Support</a></span></dt></dl></dd><dt><span class="section"><a href="internationalization-localization.html#locale-support">9.8. MySQL Server Locale Support</a></span></dt></dl></dd><dt><span class="chapter"><a href="data-types.html">10. Data Types</a></span></dt><dd><dl><dt><span class="section"><a href="data-types.html#data-type-overview">10.1. Data Type Overview</a></span></dt><dd><dl><dt><span class="section"><a href="data-types.html#numeric-type-overview">10.1.1. Overview of Numeric Types</a></span></dt><dt><span class="section"><a href="data-types.html#date-and-time-type-overview">10.1.2. Overview of Date and Time Types</a></span></dt><dt><span class="section"><a href="data-types.html#string-type-overview">10.1.3. Overview of String Types</a></span></dt><dt><span class="section"><a href="data-types.html#data-type-defaults">10.1.4. Data Type Default Values</a></span></dt></dl></dd><dt><span class="section"><a href="data-types.html#numeric-types">10.2. Numeric Types</a></span></dt><dt><span class="section"><a href="data-types.html#date-and-time-types">10.3. Date and Time Types</a></span></dt><dd><dl><dt><span class="section"><a href="data-types.html#datetime">10.3.1. The <code class="literal">DATETIME</code>,
<code class="literal">DATE</code>, and
<code class="literal">TIMESTAMP</code> Types</a></span></dt><dt><span class="section"><a href="data-types.html#time">10.3.2. The <code class="literal">TIME</code> Type</a></span></dt><dt><span class="section"><a href="data-types.html#year">10.3.3. The <code class="literal">YEAR</code> Type</a></span></dt><dt><span class="section"><a href="data-types.html#y2k-issues">10.3.4. Year 2000 Issues and Date Types</a></span></dt></dl></dd><dt><span class="section"><a href="data-types.html#string-types">10.4. String Types</a></span></dt><dd><dl><dt><span class="section"><a href="data-types.html#char">10.4.1. The <code class="literal">CHAR</code> and
<code class="literal">VARCHAR</code> Types</a></span></dt><dt><span class="section"><a href="data-types.html#binary-varbinary">10.4.2. The <code class="literal">BINARY</code> and
<code class="literal">VARBINARY</code> Types</a></span></dt><dt><span class="section"><a href="data-types.html#blob">10.4.3. The <code class="literal">BLOB</code> and
<code class="literal">TEXT</code> Types</a></span></dt><dt><span class="section"><a href="data-types.html#enum">10.4.4. The <code class="literal">ENUM</code> Type</a></span></dt><dt><span class="section"><a href="data-types.html#set">10.4.5. The <code class="literal">SET</code> Type</a></span></dt></dl></dd><dt><span class="section"><a href="data-types.html#storage-requirements">10.5. Data Type Storage Requirements</a></span></dt><dt><span class="section"><a href="data-types.html#choosing-types">10.6. Choosing the Right Type for a Column</a></span></dt><dt><span class="section"><a href="data-types.html#other-vendor-data-types">10.7. Using Data Types from Other Database Engines</a></span></dt></dl></dd><dt><span class="chapter"><a href="functions.html">11. Functions and Operators</a></span></dt><dd><dl><dt><span class="section"><a href="functions.html#func-op-summary-ref">11.1. Operator and Function Reference</a></span></dt><dt><span class="section"><a href="functions.html#non-typed-operators">11.2. Operators</a></span></dt><dd><dl><dt><span class="section"><a href="functions.html#operator-precedence">11.2.1. Operator Precedence</a></span></dt><dt><span class="section"><a href="functions.html#type-conversion">11.2.2. Type Conversion in Expression Evaluation</a></span></dt><dt><span class="section"><a href="functions.html#comparison-operators">11.2.3. Comparison Functions and Operators</a></span></dt><dt><span class="section"><a href="functions.html#logical-operators">11.2.4. Logical Operators</a></span></dt></dl></dd><dt><span class="section"><a href="functions.html#control-flow-functions">11.3. Control Flow Functions</a></span></dt><dt><span class="section"><a href="functions.html#string-functions">11.4. String Functions</a></span></dt><dd><dl><dt><span class="section"><a href="functions.html#string-comparison-functions">11.4.1. String Comparison Functions</a></span></dt><dt><span class="section"><a href="functions.html#regexp">11.4.2. Regular Expressions</a></span></dt></dl></dd><dt><span class="section"><a href="functions.html#numeric-functions">11.5. Numeric Functions</a></span></dt><dd><dl><dt><span class="section"><a href="functions.html#arithmetic-functions">11.5.1. Arithmetic Operators</a></span></dt><dt><span class="section"><a href="functions.html#mathematical-functions">11.5.2. Mathematical Functions</a></span></dt></dl></dd><dt><span class="section"><a href="functions.html#date-and-time-functions">11.6. Date and Time Functions</a></span></dt><dt><span class="section"><a href="functions.html#mysql-calendar">11.7. What Calendar Is Used By MySQL?</a></span></dt><dt><span class="section"><a href="functions.html#fulltext-search">11.8. Full-Text Search Functions</a></span></dt><dd><dl><dt><span class="section"><a href="functions.html#fulltext-natural-language">11.8.1. Natural Language Full-Text Searches</a></span></dt><dt><span class="section"><a href="functions.html#fulltext-boolean">11.8.2. Boolean Full-Text Searches</a></span></dt><dt><span class="section"><a href="functions.html#fulltext-query-expansion">11.8.3. Full-Text Searches with Query Expansion</a></span></dt><dt><span class="section"><a href="functions.html#fulltext-stopwords">11.8.4. Full-Text Stopwords</a></span></dt><dt><span class="section"><a href="functions.html#fulltext-restrictions">11.8.5. Full-Text Restrictions</a></span></dt><dt><span class="section"><a href="functions.html#fulltext-fine-tuning">11.8.6. Fine-Tuning MySQL Full-Text Search</a></span></dt></dl></dd><dt><span class="section"><a href="functions.html#cast-functions">11.9. Cast Functions and Operators</a></span></dt><dt><span class="section"><a href="functions.html#xml-functions">11.10. XML Functions</a></span></dt><dt><span class="section"><a href="functions.html#other-functions">11.11. Other Functions</a></span></dt><dd><dl><dt><span class="section"><a href="functions.html#bit-functions">11.11.1. Bit Functions</a></span></dt><dt><span class="section"><a href="functions.html#encryption-functions">11.11.2. Encryption and Compression Functions</a></span></dt><dt><span class="section"><a href="functions.html#information-functions">11.11.3. Information Functions</a></span></dt><dt><span class="section"><a href="functions.html#miscellaneous-functions">11.11.4. Miscellaneous Functions</a></span></dt></dl></dd><dt><span class="section"><a href="functions.html#group-by-functions-and-modifiers">11.12. Functions and Modifiers for Use with <code class="literal">GROUP BY</code> Clauses</a></span></dt><dd><dl><dt><span class="section"><a href="functions.html#group-by-functions">11.12.1. <code class="literal">GROUP BY</code> (Aggregate) Functions</a></span></dt><dt><span class="section"><a href="functions.html#group-by-modifiers">11.12.2. <code class="literal">GROUP BY</code> Modifiers</a></span></dt><dt><span class="section"><a href="functions.html#group-by-hidden-columns">11.12.3. <code class="literal">GROUP BY</code> and <code class="literal">HAVING</code> with Hidden
Columns</a></span></dt></dl></dd><dt><span class="section"><a href="functions.html#spatial-extensions">11.13. Spatial Extensions</a></span></dt><dd><dl><dt><span class="section"><a href="functions.html#gis-introduction">11.13.1. Introduction to MySQL Spatial Support</a></span></dt><dt><span class="section"><a href="functions.html#opengis-geometry-model">11.13.2. The OpenGIS Geometry Model</a></span></dt><dt><span class="section"><a href="functions.html#supported-spatial-data-formats">11.13.3. Supported Spatial Data Formats</a></span></dt><dt><span class="section"><a href="functions.html#creating-a-spatially-enabled-mysql-database">11.13.4. Creating a Spatially Enabled MySQL Database</a></span></dt><dt><span class="section"><a href="functions.html#analysing-spatial-information">11.13.5. Analyzing Spatial Information</a></span></dt><dt><span class="section"><a href="functions.html#optimizing-spatial-analysis">11.13.6. Optimizing Spatial Analysis</a></span></dt><dt><span class="section"><a href="functions.html#mysql-gis-conformance-and-compatibility">11.13.7. MySQL Conformance and Compatibility</a></span></dt></dl></dd><dt><span class="section"><a href="functions.html#precision-math">11.14. Precision Math</a></span></dt><dd><dl><dt><span class="section"><a href="functions.html#precision-math-numbers">11.14.1. Types of Numeric Values</a></span></dt><dt><span class="section"><a href="functions.html#precision-math-decimal-changes">11.14.2. <code class="literal">DECIMAL</code> Data Type Changes</a></span></dt><dt><span class="section"><a href="functions.html#precision-math-expressions">11.14.3. Expression Handling</a></span></dt><dt><span class="section"><a href="functions.html#precision-math-rounding">11.14.4. Rounding Behavior</a></span></dt><dt><span class="section"><a href="functions.html#precision-math-examples">11.14.5. Precision Math Examples</a></span></dt></dl></dd></dl></dd><dt><span class="chapter"><a href="sql-syntax.html">12. SQL Statement Syntax</a></span></dt><dd><dl><dt><span class="section"><a href="sql-syntax.html#sql-syntax-data-definition">12.1. Data Definition Statements</a></span></dt><dd><dl><dt><span class="section"><a href="sql-syntax.html#alter-database">12.1.1. <code class="literal">ALTER DATABASE</code> Syntax</a></span></dt><dt><span class="section"><a href="sql-syntax.html#alter-event">12.1.2. <code class="literal">ALTER EVENT</code> Syntax</a></span></dt><dt><span class="section"><a href="sql-syntax.html#alter-logfile-group">12.1.3. <code class="literal">ALTER LOGFILE GROUP</code> Syntax</a></span></dt><dt><span class="section"><a href="sql-syntax.html#alter-function">12.1.4. <code class="literal">ALTER FUNCTION</code> Syntax</a></span></dt><dt><span class="section"><a href="sql-syntax.html#alter-procedure">12.1.5. <code class="literal">ALTER PROCEDURE</code> Syntax</a></span></dt><dt><span class="section"><a href="sql-syntax.html#alter-server">12.1.6. <code class="literal">ALTER SERVER</code> Syntax</a></span></dt><dt><span class="section"><a href="sql-syntax.html#alter-table">12.1.7. <code class="literal">ALTER TABLE</code> Syntax</a></span></dt><dt><span class="section"><a href="sql-syntax.html#alter-tablespace">12.1.8. <code class="literal">ALTER TABLESPACE</code> Syntax</a></span></dt><dt><span class="section"><a href="sql-syntax.html#alter-view">12.1.9. <code class="literal">ALTER VIEW</code> Syntax</a></span></dt><dt><span class="section"><a href="sql-syntax.html#create-database">12.1.10. <code class="literal">CREATE DATABASE</code> Syntax</a></span></dt><dt><span class="section"><a href="sql-syntax.html#create-event">12.1.11. <code class="literal">CREATE EVENT</code> Syntax</a></span></dt><dt><span class="section"><a href="sql-syntax.html#create-function">12.1.12. <code class="literal">CREATE FUNCTION</code> Syntax</a></span></dt><dt><span class="section"><a href="sql-syntax.html#create-index">12.1.13. <code class="literal">CREATE INDEX</code> Syntax</a></span></dt><dt><span class="section"><a href="sql-syntax.html#create-logfile-group">12.1.14. <code class="literal">CREATE LOGFILE GROUP</code> Syntax</a></span></dt><dt><span class="section"><a href="sql-syntax.html#create-procedure">12.1.15. <code class="literal">CREATE PROCEDURE</code> and
<code class="literal">CREATE FUNCTION</code> Syntax</a></span></dt><dt><span class="section"><a href="sql-syntax.html#create-server">12.1.16. <code class="literal">CREATE SERVER</code> Syntax</a></span></dt><dt><span class="section"><a href="sql-syntax.html#create-table">12.1.17. <code class="literal">CREATE TABLE</code> Syntax</a></span></dt><dt><span class="section"><a href="sql-syntax.html#create-tablespace">12.1.18. <code class="literal">CREATE TABLESPACE</code> Syntax</a></span></dt><dt><span class="section"><a href="sql-syntax.html#create-trigger">12.1.19. <code class="literal">CREATE TRIGGER</code> Syntax</a></span></dt><dt><span class="section"><a href="sql-syntax.html#create-view">12.1.20. <code class="literal">CREATE VIEW</code> Syntax</a></span></dt><dt><span class="section"><a href="sql-syntax.html#drop-database">12.1.21. <code class="literal">DROP DATABASE</code> Syntax</a></span></dt><dt><span class="section"><a href="sql-syntax.html#drop-event">12.1.22. <code class="literal">DROP EVENT</code> Syntax</a></span></dt><dt><span class="section"><a href="sql-syntax.html#drop-function">12.1.23. <code class="literal">DROP FUNCTION</code> Syntax</a></span></dt><dt><span class="section"><a href="sql-syntax.html#drop-index">12.1.24. <code class="literal">DROP INDEX</code> Syntax</a></span></dt><dt><span class="section"><a href="sql-syntax.html#drop-logfile-group">12.1.25. <code class="literal">DROP LOGFILE GROUP</code> Syntax</a></span></dt><dt><span class="section"><a href="sql-syntax.html#drop-procedure">12.1.26. <code class="literal">DROP PROCEDURE</code> and
<code class="literal">DROP FUNCTION</code> Syntax</a></span></dt><dt><span class="section"><a href="sql-syntax.html#drop-server">12.1.27. <code class="literal">DROP SERVER</code> Syntax</a></span></dt><dt><span class="section"><a href="sql-syntax.html#drop-table">12.1.28. <code class="literal">DROP TABLE</code> Syntax</a></span></dt><dt><span class="section"><a href="sql-syntax.html#drop-tablespace">12.1.29. <code class="literal">DROP TABLESPACE</code> Syntax</a></span></dt><dt><span class="section"><a href="sql-syntax.html#drop-trigger">12.1.30. <code class="literal">DROP TRIGGER</code> Syntax</a></span></dt><dt><span class="section"><a href="sql-syntax.html#drop-view">12.1.31. <code class="literal">DROP VIEW</code> Syntax</a></span></dt><dt><span class="section"><a href="sql-syntax.html#rename-database">12.1.32. <code class="literal">RENAME DATABASE</code> Syntax</a></span></dt><dt><span class="section"><a href="sql-syntax.html#rename-table">12.1.33. <code class="literal">RENAME TABLE</code> Syntax</a></span></dt></dl></dd><dt><span class="section"><a href="sql-syntax.html#sql-syntax-data-manipulation">12.2. Data Manipulation Statements</a></span></dt><dd><dl><dt><span class="section"><a href="sql-syntax.html#call">12.2.1. <code class="literal">CALL</code> Syntax</a></span></dt><dt><span class="section"><a href="sql-syntax.html#delete">12.2.2. <code class="literal">DELETE</code> Syntax</a></span></dt><dt><span class="section"><a href="sql-syntax.html#do">12.2.3. <code class="literal">DO</code> Syntax</a></span></dt><dt><span class="section"><a href="sql-syntax.html#handler">12.2.4. <code class="literal">HANDLER</code> Syntax</a></span></dt><dt><span class="section"><a href="sql-syntax.html#insert">12.2.5. <code class="literal">INSERT</code> Syntax</a></span></dt><dt><span class="section"><a href="sql-syntax.html#load-data">12.2.6. <code class="literal">LOAD DATA INFILE</code>
Syntax</a></span></dt><dt><span class="section"><a href="sql-syntax.html#replace">12.2.7. <code class="literal">REPLACE</code> Syntax</a></span></dt><dt><span class="section"><a href="sql-syntax.html#select">12.2.8. <code class="literal">SELECT</code> Syntax</a></span></dt><dt><span class="section"><a href="sql-syntax.html#subqueries">12.2.9. Subquery Syntax</a></span></dt><dt><span class="section"><a href="sql-syntax.html#truncate">12.2.10. <code class="literal">TRUNCATE</code> Syntax</a></span></dt><dt><span class="section"><a href="sql-syntax.html#update">12.2.11. <code class="literal">UPDATE</code> Syntax</a></span></dt></dl></dd><dt><span class="section"><a href="sql-syntax.html#sql-syntax-utility">12.3. MySQL Utility Statements</a></span></dt><dd><dl><dt><span class="section"><a href="sql-syntax.html#describe">12.3.1. <code class="literal">DESCRIBE</code> Syntax</a></span></dt><dt><span class="section"><a href="sql-syntax.html#explain">12.3.2. <code class="literal">EXPLAIN</code> Syntax</a></span></dt><dt><span class="section"><a href="sql-syntax.html#help">12.3.3. <code class="literal">HELP</code> Syntax</a></span></dt><dt><span class="section"><a href="sql-syntax.html#use">12.3.4. <code class="literal">USE</code> Syntax</a></span></dt></dl></dd><dt><span class="section"><a href="sql-syntax.html#sql-syntax-transactions">12.4. MySQL Transactional and Locking Statements</a></span></dt><dd><dl><dt><span class="section"><a href="sql-syntax.html#commit">12.4.1. <code class="literal">START TRANSACTION</code>,
<code class="literal">COMMIT</code>, and
<code class="literal">ROLLBACK</code> Syntax</a></span></dt><dt><span class="section"><a href="sql-syntax.html#cannot-roll-back">12.4.2. Statements That Cannot Be Rolled Back</a></span></dt><dt><span class="section"><a href="sql-syntax.html#implicit-commit">12.4.3. Statements That Cause an Implicit Commit</a></span></dt><dt><span class="section"><a href="sql-syntax.html#savepoint">12.4.4. <code class="literal">SAVEPOINT</code> and
<code class="literal">ROLLBACK TO
SAVEPOINT</code> Syntax</a></span></dt><dt><span class="section"><a href="sql-syntax.html#lock-tables">12.4.5. <code class="literal">LOCK TABLES</code> and
<code class="literal">UNLOCK
TABLES</code> Syntax</a></span></dt><dt><span class="section"><a href="sql-syntax.html#set-transaction">12.4.6. <code class="literal">SET TRANSACTION</code> Syntax</a></span></dt><dt><span class="section"><a href="sql-syntax.html#xa">12.4.7. XA Transactions</a></span></dt></dl></dd><dt><span class="section"><a href="sql-syntax.html#sql-syntax-server-administration">12.5. Database Administration Statements</a></span></dt><dd><dl><dt><span class="section"><a href="sql-syntax.html#account-management-sql">12.5.1. Account Management Statements</a></span></dt><dt><span class="section"><a href="sql-syntax.html#table-maintenance-sql">12.5.2. Table Maintenance Statements</a></span></dt><dt><span class="section"><a href="sql-syntax.html#plugin-sql">12.5.3. Plugin and User-Defined Function Statements</a></span></dt><dt><span class="section"><a href="sql-syntax.html#set-option">12.5.4. <code class="literal">SET</code> Syntax</a></span></dt><dt><span class="section"><a href="sql-syntax.html#show">12.5.5. <code class="literal">SHOW</code> Syntax</a></span></dt><dt><span class="section"><a href="sql-syntax.html#other-administrative-sql">12.5.6. Other Administrative Statements</a></span></dt></dl></dd><dt><span class="section"><a href="sql-syntax.html#sql-syntax-replication">12.6. Replication Statements</a></span></dt><dd><dl><dt><span class="section"><a href="sql-syntax.html#replication-master-sql">12.6.1. SQL Statements for Controlling Master Servers</a></span></dt><dt><span class="section"><a href="sql-syntax.html#replication-slave-sql">12.6.2. SQL Statements for Controlling Slave Servers</a></span></dt></dl></dd><dt><span class="section"><a href="sql-syntax.html#sql-syntax-prepared-statements">12.7. SQL Syntax for Prepared Statements</a></span></dt><dd><dl><dt><span class="section"><a href="sql-syntax.html#prepare">12.7.1. <code class="literal">PREPARE</code> Syntax</a></span></dt><dt><span class="section"><a href="sql-syntax.html#execute">12.7.2. <code class="literal">EXECUTE</code> Syntax</a></span></dt><dt><span class="section"><a href="sql-syntax.html#deallocate-prepare">12.7.3. <code class="literal">DEALLOCATE PREPARE</code> Syntax</a></span></dt><dt><span class="section"><a href="sql-syntax.html#statement-repreparation">12.7.4. Automatic Prepared Statement Repreparation</a></span></dt></dl></dd><dt><span class="section"><a href="sql-syntax.html#sql-syntax-compound-statements">12.8. MySQL Compound-Statement Syntax</a></span></dt><dd><dl><dt><span class="section"><a href="sql-syntax.html#begin-end">12.8.1. <code class="literal">BEGIN ... END</code> Compound Statement Syntax</a></span></dt><dt><span class="section"><a href="sql-syntax.html#declare">12.8.2. <code class="literal">DECLARE</code> Syntax</a></span></dt><dt><span class="section"><a href="sql-syntax.html#variables-in-stored-programs">12.8.3. Variables in Stored Programs</a></span></dt><dt><span class="section"><a href="sql-syntax.html#conditions-and-handlers">12.8.4. Conditions and Handlers</a></span></dt><dt><span class="section"><a href="sql-syntax.html#cursors">12.8.5. Cursors</a></span></dt><dt><span class="section"><a href="sql-syntax.html#flow-control-constructs">12.8.6. Flow Control Constructs</a></span></dt><dt><span class="section"><a href="sql-syntax.html#return">12.8.7. <code class="literal">RETURN</code> Syntax</a></span></dt></dl></dd></dl></dd><dt><span class="chapter"><a href="storage-engines.html">13. Storage Engines</a></span></dt><dd><dl><dt><span class="section"><a href="storage-engines.html#storage-engine-compare-transactions">13.1. Comparing Transaction and Nontransaction Engines</a></span></dt><dt><span class="section"><a href="storage-engines.html#storage-engines-other">13.2. Other Storage Engines</a></span></dt><dt><span class="section"><a href="storage-engines.html#storage-engine-setting">13.3. Setting the Storage Engine</a></span></dt><dt><span class="section"><a href="storage-engines.html#pluggable-storage-overview">13.4. Overview of MySQL Storage Engine Architecture</a></span></dt><dd><dl><dt><span class="section"><a href="storage-engines.html#pluggable-storage">13.4.1. Pluggable Storage Engine Architecture</a></span></dt><dt><span class="section"><a href="storage-engines.html#pluggable-storage-common-layer">13.4.2. The Common Database Server Layer</a></span></dt></dl></dd><dt><span class="section"><a href="storage-engines.html#myisam-storage-engine">13.5. The <code class="literal">MyISAM</code> Storage Engine</a></span></dt><dd><dl><dt><span class="section"><a href="storage-engines.html#myisam-start">13.5.1. <code class="literal">MyISAM</code> Startup Options</a></span></dt><dt><span class="section"><a href="storage-engines.html#key-space">13.5.2. Space Needed for Keys</a></span></dt><dt><span class="section"><a href="storage-engines.html#myisam-table-formats">13.5.3. <code class="literal">MyISAM</code> Table Storage Formats</a></span></dt><dt><span class="section"><a href="storage-engines.html#myisam-table-problems">13.5.4. <code class="literal">MyISAM</code> Table Problems</a></span></dt></dl></dd><dt><span class="section"><a href="storage-engines.html#innodb">13.6. The <code class="literal">InnoDB</code> Storage Engine</a></span></dt><dd><dl><dt><span class="section"><a href="storage-engines.html#innodb-contact-information">13.6.1. <code class="literal">InnoDB</code> Contact Information</a></span></dt><dt><span class="section"><a href="storage-engines.html#innodb-configuration">13.6.2. <code class="literal">InnoDB</code> Configuration</a></span></dt><dt><span class="section"><a href="storage-engines.html#innodb-parameters">13.6.3. <code class="literal">InnoDB</code> Startup Options and System Variables</a></span></dt><dt><span class="section"><a href="storage-engines.html#using-innodb-tables">13.6.4. Creating and Using <code class="literal">InnoDB</code> Tables</a></span></dt><dt><span class="section"><a href="storage-engines.html#adding-and-removing">13.6.5. Adding, Removing, or Resizing <code class="literal">InnoDB</code> Data and Log
Files</a></span></dt><dt><span class="section"><a href="storage-engines.html#innodb-backup">13.6.6. Backing Up and Recovering an <code class="literal">InnoDB</code> Database</a></span></dt><dt><span class="section"><a href="storage-engines.html#moving">13.6.7. Moving an <code class="literal">InnoDB</code> Database to Another Machine</a></span></dt><dt><span class="section"><a href="storage-engines.html#innodb-transaction-model">13.6.8. The <code class="literal">InnoDB</code> Transaction Model and Locking</a></span></dt><dt><span class="section"><a href="storage-engines.html#innodb-multi-versioning">13.6.9. <code class="literal">InnoDB</code> Multi-Versioning</a></span></dt><dt><span class="section"><a href="storage-engines.html#innodb-table-and-index">13.6.10. <code class="literal">InnoDB</code> Table and Index Structures</a></span></dt><dt><span class="section"><a href="storage-engines.html#file-space-management">13.6.11. <code class="literal">InnoDB</code> Disk I/O and File Space Management</a></span></dt><dt><span class="section"><a href="storage-engines.html#innodb-error-handling">13.6.12. <code class="literal">InnoDB</code> Error Handling</a></span></dt><dt><span class="section"><a href="storage-engines.html#innodb-tuning-troubleshooting">13.6.13. <code class="literal">InnoDB</code> Performance Tuning and Troubleshooting</a></span></dt><dt><span class="section"><a href="storage-engines.html#innodb-restrictions">13.6.14. Restrictions on <code class="literal">InnoDB</code> Tables</a></span></dt></dl></dd><dt><span class="section"><a href="storage-engines.html#se-db2">13.7. The <code class="literal">IBMDB2I</code> Storage Engine</a></span></dt><dd><dl><dt><span class="section"><a href="storage-engines.html#se-db2-installation">13.7.1. Installation</a></span></dt><dt><span class="section"><a href="storage-engines.html#se-db2-configuration">13.7.2. Configuration Options</a></span></dt><dt><span class="section"><a href="storage-engines.html#se-db2-creating-tables">13.7.3. Creating schemas and tables</a></span></dt><dt><span class="section"><a href="storage-engines.html#se-db2-metadata">13.7.4. Database/metadata management</a></span></dt><dt><span class="section"><a href="storage-engines.html#se-db2-transactions">13.7.5. Transaction behavior</a></span></dt><dt><span class="section"><a href="storage-engines.html#se-db2-terms">13.7.6. Principles and Terminology</a></span></dt><dt><span class="section"><a href="storage-engines.html#se-db2-notes">13.7.7. Notes and Limitations</a></span></dt><dt><span class="section"><a href="storage-engines.html#se-db2-collations">13.7.8. Character sets and collations</a></span></dt><dt><span class="section"><a href="storage-engines.html#se-db2-errors">13.7.9. Error codes and trouble-shooting information</a></span></dt></dl></dd><dt><span class="section"><a href="storage-engines.html#merge-storage-engine">13.8. The <code class="literal">MERGE</code> Storage Engine</a></span></dt><dd><dl><dt><span class="section"><a href="storage-engines.html#merge-table-problems">13.8.1. <code class="literal">MERGE</code> Table Problems</a></span></dt></dl></dd><dt><span class="section"><a href="storage-engines.html#memory-storage-engine">13.9. The <code class="literal">MEMORY</code> (<code class="literal">HEAP</code>) Storage Engine</a></span></dt><dt><span class="section"><a href="storage-engines.html#example-storage-engine">13.10. The <code class="literal">EXAMPLE</code> Storage Engine</a></span></dt><dt><span class="section"><a href="storage-engines.html#federated-storage-engine">13.11. The <code class="literal">FEDERATED</code> Storage Engine</a></span></dt><dd><dl><dt><span class="section"><a href="storage-engines.html#federated-description">13.11.1. <code class="literal">FEDERATED</code> Storage Engine Overview</a></span></dt><dt><span class="section"><a href="storage-engines.html#federated-create">13.11.2. How to Create <code class="literal">FEDERATED</code> Tables</a></span></dt><dt><span class="section"><a href="storage-engines.html#federated-usagenotes">13.11.3. <code class="literal">FEDERATED</code> Storage Engine Notes and Tips</a></span></dt><dt><span class="section"><a href="storage-engines.html#federated-storage-engine-resources">13.11.4. <code class="literal">FEDERATED</code> Storage Engine Resources</a></span></dt></dl></dd><dt><span class="section"><a href="storage-engines.html#archive-storage-engine">13.12. The <code class="literal">ARCHIVE</code> Storage Engine</a></span></dt><dt><span class="section"><a href="storage-engines.html#csv-storage-engine">13.13. The <code class="literal">CSV</code> Storage Engine</a></span></dt><dd><dl><dt><span class="section"><a href="storage-engines.html#se-csv-repair">13.13.1. Repairing and Checking CSV Tables</a></span></dt><dt><span class="section"><a href="storage-engines.html#se-csv-limitations">13.13.2. CSV Limitations</a></span></dt></dl></dd><dt><span class="section"><a href="storage-engines.html#blackhole-storage-engine">13.14. The <code class="literal">BLACKHOLE</code> Storage Engine</a></span></dt></dl></dd><dt><span class="chapter"><a href="ha-overview.html">14. High Availability and Scalability</a></span></dt><dd><dl><dt><span class="section"><a href="ha-overview.html#ha-drbd">14.1. Using MySQL with DRBD</a></span></dt><dd><dl><dt><span class="section"><a href="ha-overview.html#ha-drbd-install">14.1.1. Configuring the DRBD Environment</a></span></dt><dt><span class="section"><a href="ha-overview.html#ha-drbd-install-mysql">14.1.2. Configuring MySQL for DRBD</a></span></dt><dt><span class="section"><a href="ha-overview.html#ha-drbd-performance">14.1.3. Optimizing Performance and Reliability</a></span></dt></dl></dd><dt><span class="section"><a href="ha-overview.html#ha-heartbeat">14.2. Using Linux HA Heartbeat</a></span></dt><dd><dl><dt><span class="section"><a href="ha-overview.html#ha-heartbeat-config">14.2.1. Heartbeat Configuration</a></span></dt><dt><span class="section"><a href="ha-overview.html#ha-heartbeat-drbd">14.2.2. Using Heartbeat with MySQL and DRBD</a></span></dt><dt><span class="section"><a href="ha-overview.html#ha-heartbeat-drbd-dopd">14.2.3. Using Heartbeat with DRBD and <span><strong class="command">dopd</strong></span></a></span></dt><dt><span class="section"><a href="ha-overview.html#ha-heartbeat-errors">14.2.4. Dealing with System Level Errors</a></span></dt></dl></dd><dt><span class="section"><a href="ha-overview.html#ha-vm">14.3. MySQL and Virtualization</a></span></dt><dd><dl><dt><span class="section"><a href="ha-overview.html#ha-vm-commonissues">14.3.1. Common Issues with Virtualization</a></span></dt><dt><span class="section"><a href="ha-overview.html#ha-vm-aws">14.3.2. Using MySQL within an Amazon EC2 Instance</a></span></dt><dt><span class="section"><a href="ha-overview.html#ha-vm-resources">14.3.3. Virtualization Resources</a></span></dt></dl></dd><dt><span class="section"><a href="ha-overview.html#ha-zfs-replication">14.4. Using ZFS Replication</a></span></dt><dd><dl><dt><span class="section"><a href="ha-overview.html#ha-zfs-config">14.4.1. Using ZFS for Filesystem Replication</a></span></dt><dt><span class="section"><a href="ha-overview.html#ha-zfs-mysql">14.4.2. Configuring MySQL for ZFS Replication</a></span></dt><dt><span class="section"><a href="ha-overview.html#ha-zfs-mysql-recovery">14.4.3. Handling MySQL Recovery with ZFS</a></span></dt></dl></dd><dt><span class="section"><a href="ha-overview.html#ha-memcached">14.5. Using MySQL with <span><strong class="command">memcached</strong></span></a></span></dt><dd><dl><dt><span class="section"><a href="ha-overview.html#ha-memcached-install">14.5.1. Installing <span><strong class="command">memcached</strong></span></a></span></dt><dt><span class="section"><a href="ha-overview.html#ha-memcached-using">14.5.2. Using <span><strong class="command">memcached</strong></span></a></span></dt><dt><span class="section"><a href="ha-overview.html#ha-memcached-interfaces">14.5.3. <span><strong class="command">memcached</strong></span> Interfaces</a></span></dt><dt><span class="section"><a href="ha-overview.html#ha-memcached-stats">14.5.4. Getting <span><strong class="command">memcached</strong></span> Statistics</a></span></dt><dt><span class="section"><a href="ha-overview.html#ha-memcached-faq">14.5.5. <span><strong class="command">memcached</strong></span> FAQ</a></span></dt></dl></dd><dt><span class="section"><a href="ha-overview.html#mysql-proxy">14.6. MySQL Proxy</a></span></dt><dd><dl><dt><span class="section"><a href="ha-overview.html#mysql-proxy-platforms">14.6.1. MySQL Proxy Supported Platforms</a></span></dt><dt><span class="section"><a href="ha-overview.html#mysql-proxy-install">14.6.2. Installing MySQL Proxy</a></span></dt><dt><span class="section"><a href="ha-overview.html#mysql-proxy-cmdline">14.6.3. MySQL Proxy Command-Line Options</a></span></dt><dt><span class="section"><a href="ha-overview.html#mysql-proxy-scripting">14.6.4. MySQL Proxy Scripting</a></span></dt><dt><span class="section"><a href="ha-overview.html#mysql-proxy-using">14.6.5. Using MySQL Proxy</a></span></dt><dt><span class="section"><a href="ha-overview.html#mysql-proxy-faq">14.6.6. MySQL Proxy FAQ</a></span></dt></dl></dd></dl></dd><dt><span class="chapter"><a href="mem-introduction.html">15. MySQL Enterprise Monitor</a></span></dt><dd><dl><dt><span class="section"><a href="mem-introduction.html#mem-overview">15.1. An Overview of the Service</a></span></dt><dd><dl><dt><span class="section"><a href="mem-introduction.html#mem-service-architecture">15.1.1. The Service Architecture</a></span></dt><dt><span class="section"><a href="mem-introduction.html#mem-features">15.1.2. Service Features</a></span></dt><dt><span class="section"><a href="mem-introduction.html#mem-security">15.1.3. Security</a></span></dt></dl></dd><dt><span class="section"><a href="mem-introduction.html#mem-conventions">15.2. Conventions Used in This Document</a></span></dt><dt><span class="section"><a href="mem-introduction.html#mem-install">15.3. Installation and Upgrades</a></span></dt><dd><dl><dt><span class="section"><a href="mem-introduction.html#mem-user-roles">15.3.1. User Roles</a></span></dt><dt><span class="section"><a href="mem-introduction.html#mem-install-server">15.3.2. Service Manager Installation</a></span></dt><dt><span class="section"><a href="mem-introduction.html#mem-install-agent">15.3.3. Monitor Agent Installation</a></span></dt><dt><span class="section"><a href="mem-introduction.html#mem-unattended-installation">15.3.4. Unattended Installation</a></span></dt><dt><span class="section"><a href="mem-introduction.html#mem-install-post-installation">15.3.5. Post-Installation Considerations</a></span></dt><dt><span class="section"><a href="mem-introduction.html#mem-upgradeorchange">15.3.6. Upgrading, Re-Installing or Changing Your Installation</a></span></dt><dt><span class="section"><a href="mem-introduction.html#mem-uninstall">15.3.7. Uninstalling the MySQL Enterprise Monitor</a></span></dt></dl></dd><dt><span class="section"><a href="mem-introduction.html#mem-dashboard">15.4. MySQL Enterprise Dashboard</a></span></dt><dd><dl><dt><span class="section"><a href="mem-introduction.html#mem-server-tree">15.4.1. The Server Tree</a></span></dt><dt><span class="section"><a href="mem-introduction.html#mem-monitor-page-graphs">15.4.2. The Server Graphs and Critical Events</a></span></dt><dt><span class="section"><a href="mem-introduction.html#mem-heat-chart">15.4.3. The Heat Chart</a></span></dt></dl></dd><dt><span class="section"><a href="mem-introduction.html#mem-dashboard-settings">15.5. The Settings Page</a></span></dt><dd><dl><dt><span class="section"><a href="mem-introduction.html#mem-global-settings">15.5.1. Global Settings</a></span></dt><dt><span class="section"><a href="mem-introduction.html#mem-user-preferences">15.5.2. User Preferences</a></span></dt><dt><span class="section"><a href="mem-introduction.html#mem-managing-servers">15.5.3. Manage Servers</a></span></dt><dt><span class="section"><a href="mem-introduction.html#mem-managing-users">15.5.4. Managing Users</a></span></dt><dt><span class="section"><a href="mem-introduction.html#mem-notification-groups">15.5.5. Manage Notification Groups</a></span></dt><dt><span class="section"><a href="mem-introduction.html#mem-logs">15.5.6. Logs</a></span></dt><dt><span class="section"><a href="mem-introduction.html#mem-product-info">15.5.7. The Product Information Screen</a></span></dt></dl></dd><dt><span class="section"><a href="mem-introduction.html#mem-advisors">15.6. The Advisors Page</a></span></dt><dd><dl><dt><span class="section"><a href="mem-introduction.html#mem-update-advisors">15.6.1. Installing and Updating Advisors</a></span></dt><dt><span class="section"><a href="mem-introduction.html#mem-scheduling-rules">15.6.2. Scheduling Rules</a></span></dt><dt><span class="section"><a href="mem-introduction.html#mem-editing-built-in-rules">15.6.3. Editing Built-in Rules</a></span></dt><dt><span class="section"><a href="mem-introduction.html#mem-creating-advisors-and-rules">15.6.4. Creating Advisors and Rules</a></span></dt><dt><span class="section"><a href="mem-introduction.html#mem-unscheduling-advisors">15.6.5. Disabling and Unscheduling Rules</a></span></dt><dt><span class="section"><a href="mem-introduction.html#mem-advisor-blackouts">15.6.6. Advisor Blackout Periods</a></span></dt></dl></dd><dt><span class="section"><a href="mem-introduction.html#mem-events">15.7. The Events Page</a></span></dt><dd><dl><dt><span class="section"><a href="mem-introduction.html#mem-closing-events">15.7.1. Closing an Event</a></span></dt><dt><span class="section"><a href="mem-introduction.html#mem-events-notification">15.7.2. Notification of Events</a></span></dt></dl></dd><dt><span class="section"><a href="mem-introduction.html#mem-graphs">15.8. The Graphs Page</a></span></dt><dd><dl><dt><span class="section"><a href="mem-introduction.html#mem-available-graphs">15.8.1. Displaying Graphs</a></span></dt><dt><span class="section"><a href="mem-introduction.html#mem-setting-graph-interval">15.8.2. Setting an Interval</a></span></dt><dt><span class="section"><a href="mem-introduction.html#mem-setting-graph-time-span">15.8.3. Setting a Time Span</a></span></dt></dl></dd><dt><span class="section"><a href="mem-introduction.html#mem-query-analyzer">15.9. The Query Analyzer Page</a></span></dt><dd><dl><dt><span class="section"><a href="mem-introduction.html#mem-query-analyzer-enabling">15.9.1. Enabling Query Analyzer</a></span></dt><dt><span class="section"><a href="mem-introduction.html#mem-query-analyzer-queries">15.9.2. Getting Detailed Query Information</a></span></dt><dt><span class="section"><a href="mem-introduction.html#mem-query-analyzer-filtering">15.9.3. Filtering Query Analyzer Data</a></span></dt><dt><span class="section"><a href="mem-introduction.html#mem-query-analyzer-using">15.9.4. Using Query Analyzer Data</a></span></dt><dt><span class="section"><a href="mem-introduction.html#mem-query-analyzer-troubleshooting">15.9.5. Troubleshooting Query Analyzer</a></span></dt><dt><span class="section"><a href="mem-introduction.html#mem-query-analyzer-settings">15.9.6. Query Analyzer Settings</a></span></dt></dl></dd><dt><span class="section"><a href="mem-introduction.html#mem-replication">15.10. The Replication Page</a></span></dt><dd><dl><dt><span class="section"><a href="mem-introduction.html#mem-replication-details">15.10.1. Replication Page Details</a></span></dt></dl></dd><dt><span class="section"><a href="mem-introduction.html#mem-reference">15.11. MySQL Enterprise Monitor Reference</a></span></dt><dd><dl><dt><span class="section"><a href="mem-introduction.html#mem-reference-limitations">15.11.1. MySQL Enterprise Monitor Limitations</a></span></dt><dt><span class="section"><a href="mem-introduction.html#mem-reference-browser">15.11.2. Supported Browsers</a></span></dt><dt><span class="section"><a href="mem-introduction.html#mem-reference-requirements">15.11.3. Installation Requirements</a></span></dt><dt><span class="section"><a href="mem-introduction.html#mem-deployment-config">15.11.4. Choosing Suitable MySQL Enterprise Service Manager Hardware Configurations</a></span></dt><dt><span class="section"><a href="mem-introduction.html#mem-deployment-backup">15.11.5. Backing up MySQL Enterprise Service Manager</a></span></dt><dt><span class="section"><a href="mem-introduction.html#mem-deployment-migration-2-0">15.11.6. Migrating 1.3.x Historical Data to MySQL Enterprise Monitor 2.0</a></span></dt><dt><span class="section"><a href="mem-introduction.html#mem-deployment-maintenance">15.11.7. Regular MySQL Enterprise Monitor Maintenance</a></span></dt><dt><span class="section"><a href="mem-introduction.html#mem-reference-advgraph">15.11.8. Advisor/Graph Reference</a></span></dt></dl></dd><dt><span class="section"><a href="mem-introduction.html#mem-faq">15.12. MySQL Enterprise Monitor Frequently Asked Questions</a></span></dt></dl></dd><dt><span class="chapter"><a href="replication.html">16. Replication</a></span></dt><dd><dl><dt><span class="section"><a href="replication.html#replication-configuration">16.1. Replication Configuration</a></span></dt><dd><dl><dt><span class="section"><a href="replication.html#replication-howto">16.1.1. How to Set Up Replication</a></span></dt><dt><span class="section"><a href="replication.html#replication-formats">16.1.2. Replication Formats</a></span></dt><dt><span class="section"><a href="replication.html#replication-options">16.1.3. Replication and Binary Logging Options and Variables</a></span></dt><dt><span class="section"><a href="replication.html#replication-administration">16.1.4. Common Replication Administration Tasks</a></span></dt></dl></dd><dt><span class="section"><a href="replication.html#replication-solutions">16.2. Replication Solutions</a></span></dt><dd><dl><dt><span class="section"><a href="replication.html#replication-solutions-backups">16.2.1. Using Replication for Backups</a></span></dt><dt><span class="section"><a href="replication.html#replication-solutions-diffengines">16.2.2. Using Replication with Different Master and Slave Storage Engines</a></span></dt><dt><span class="section"><a href="replication.html#replication-solutions-scaleout">16.2.3. Using Replication for Scale-Out</a></span></dt><dt><span class="section"><a href="replication.html#replication-solutions-partitioning">16.2.4. Replicating Different Databases to Different Slaves</a></span></dt><dt><span class="section"><a href="replication.html#replication-solutions-performance">16.2.5. Improving Replication Performance</a></span></dt><dt><span class="section"><a href="replication.html#replication-solutions-switch">16.2.6. Switching Masters During Failover</a></span></dt><dt><span class="section"><a href="replication.html#replication-solutions-ssl">16.2.7. Setting Up Replication Using SSL</a></span></dt></dl></dd><dt><span class="section"><a href="replication.html#replication-notes">16.3. Replication Notes and Tips</a></span></dt><dd><dl><dt><span class="section"><a href="replication.html#replication-features">16.3.1. Replication Features and Issues</a></span></dt><dt><span class="section"><a href="replication.html#replication-compatibility">16.3.2. Replication Compatibility Between MySQL Versions</a></span></dt><dt><span class="section"><a href="replication.html#replication-upgrade">16.3.3. Upgrading a Replication Setup</a></span></dt><dt><span class="section"><a href="replication.html#replication-faq">16.3.4. Replication FAQ</a></span></dt><dt><span class="section"><a href="replication.html#replication-problems">16.3.5. Troubleshooting Replication</a></span></dt><dt><span class="section"><a href="replication.html#replication-bugs">16.3.6. How to Report Replication Bugs or Problems</a></span></dt></dl></dd><dt><span class="section"><a href="replication.html#replication-implementation">16.4. Replication Implementation</a></span></dt><dd><dl><dt><span class="section"><a href="replication.html#replication-implementation-details">16.4.1. Replication Implementation Details</a></span></dt><dt><span class="section"><a href="replication.html#slave-logs">16.4.2. Replication Relay and Status Files</a></span></dt><dt><span class="section"><a href="replication.html#replication-rules">16.4.3. How Servers Evaluate Replication Filtering Rules</a></span></dt></dl></dd></dl></dd><dt><span class="chapter"><a href="mysql-cluster.html">17. MySQL Cluster NDB 6.X/7.X</a></span></dt><dd><dl><dt><span class="section"><a href="mysql-cluster.html#mysql-cluster-overview">17.1. MySQL Cluster Overview</a></span></dt><dd><dl><dt><span class="section"><a href="mysql-cluster.html#mysql-cluster-basics">17.1.1. MySQL Cluster Core Concepts</a></span></dt><dt><span class="section"><a href="mysql-cluster.html#mysql-cluster-nodes-groups">17.1.2. MySQL Cluster Nodes, Node Groups, Replicas, and Partitions</a></span></dt><dt><span class="section"><a href="mysql-cluster.html#mysql-cluster-overview-requirements">17.1.3. MySQL Cluster Hardware, Software, and Networking Requirements</a></span></dt><dt><span class="section"><a href="mysql-cluster.html#mysql-cluster-roadmap">17.1.4. MySQL Cluster Development Roadmap</a></span></dt><dt><span class="section"><a href="mysql-cluster.html#mysql-cluster-limitations">17.1.5. Known Limitations of MySQL Cluster</a></span></dt></dl></dd><dt><span class="section"><a href="mysql-cluster.html#mysql-cluster-multi-computer">17.2. MySQL Cluster Multi-Computer How-To</a></span></dt><dd><dl><dt><span class="section"><a href="mysql-cluster.html#mysql-cluster-multi-install">17.2.1. MySQL Cluster Multi-Computer Installation</a></span></dt><dt><span class="section"><a href="mysql-cluster.html#mysql-cluster-multi-config">17.2.2. MySQL Cluster Multi-Computer Configuration</a></span></dt><dt><span class="section"><a href="mysql-cluster.html#mysql-cluster-multi-initial">17.2.3. Initial Startup of MySQL Cluster</a></span></dt><dt><span class="section"><a href="mysql-cluster.html#mysql-cluster-multi-load-data-queries">17.2.4. Loading Sample Data into MySQL Cluster and Performing Queries</a></span></dt><dt><span class="section"><a href="mysql-cluster.html#mysql-cluster-multi-shutdown-restart">17.2.5. Safe Shutdown and Restart of MySQL Cluster</a></span></dt><dt><span class="section"><a href="mysql-cluster.html#mysql-cluster-upgrade-downgrade">17.2.6. Upgrading and Downgrading MySQL Cluster</a></span></dt></dl></dd><dt><span class="section"><a href="mysql-cluster.html#mysql-cluster-configuration">17.3. MySQL Cluster Configuration</a></span></dt><dd><dl><dt><span class="section"><a href="mysql-cluster.html#mysql-cluster-quick">17.3.1. Quick Test Setup of MySQL Cluster</a></span></dt><dt><span class="section"><a href="mysql-cluster.html#mysql-cluster-config-file">17.3.2. MySQL Cluster Configuration Files</a></span></dt><dt><span class="section"><a href="mysql-cluster.html#mysql-cluster-params-overview">17.3.3. Overview of MySQL Cluster Configuration Parameters</a></span></dt><dt><span class="section"><a href="mysql-cluster.html#mysql-cluster-options-variables">17.3.4. MySQL Server Options and Variables for MySQL Cluster</a></span></dt><dt><span class="section"><a href="mysql-cluster.html#mysql-cluster-interconnects">17.3.5. Using High-Speed Interconnects with MySQL Cluster</a></span></dt></dl></dd><dt><span class="section"><a href="mysql-cluster.html#mysql-cluster-programs">17.4. MySQL Cluster Programs</a></span></dt><dd><dl><dt><span class="section"><a href="mysql-cluster.html#mysql-cluster-programs-mysqld">17.4.1. MySQL Server Usage for MySQL Cluster</a></span></dt><dt><span class="section"><a href="mysql-cluster.html#mysql-cluster-programs-ndbd">17.4.2. <span><strong class="command">ndbd</strong></span> — The MySQL Cluster Data Node Daemon</a></span></dt><dt><span class="section"><a href="mysql-cluster.html#mysql-cluster-programs-ndbmtd">17.4.3. <span><strong class="command">ndbmtd</strong></span> — The MySQL Cluster Data Node Daemon (Multi-Threaded)</a></span></dt><dt><span class="section"><a href="mysql-cluster.html#mysql-cluster-programs-ndb-mgmd">17.4.4. <span><strong class="command">ndb_mgmd</strong></span> — The MySQL Cluster Management Server Daemon</a></span></dt><dt><span class="section"><a href="mysql-cluster.html#mysql-cluster-programs-ndb-mgm">17.4.5. <span><strong class="command">ndb_mgm</strong></span> — The MySQL Cluster Management Client</a></span></dt><dt><span class="section"><a href="mysql-cluster.html#mysql-cluster-programs-ndb-config">17.4.6. <span><strong class="command">ndb_config</strong></span> — Extract MySQL Cluster Configuration Information</a></span></dt><dt><span class="section"><a href="mysql-cluster.html#mysql-cluster-programs-ndb-cpcd">17.4.7. <span><strong class="command">ndb_cpcd</strong></span> — Automate Testing for NDB Development</a></span></dt><dt><span class="section"><a href="mysql-cluster.html#mysql-cluster-programs-ndb-delete-all">17.4.8. <span><strong class="command">ndb_delete_all</strong></span> — Delete All Rows from an NDB Table</a></span></dt><dt><span class="section"><a href="mysql-cluster.html#mysql-cluster-programs-ndb-desc">17.4.9. <span><strong class="command">ndb_desc</strong></span> — Describe NDB Tables</a></span></dt><dt><span class="section"><a href="mysql-cluster.html#mysql-cluster-programs-ndb-drop-index">17.4.10. <span><strong class="command">ndb_drop_index</strong></span> — Drop Index from an NDB Table</a></span></dt><dt><span class="section"><a href="mysql-cluster.html#mysql-cluster-programs-ndb-drop-table">17.4.11. <span><strong class="command">ndb_drop_table</strong></span> — Drop an NDB Table</a></span></dt><dt><span class="section"><a href="mysql-cluster.html#mysql-cluster-programs-ndb-error-reporter">17.4.12. <span><strong class="command">ndb_error_reporter</strong></span> — NDB Error-Reporting Utility</a></span></dt><dt><span class="section"><a href="mysql-cluster.html#mysql-cluster-programs-ndb-print-backup-file">17.4.13. <span><strong class="command">ndb_print_backup_file</strong></span> — Print NDB Backup File Contents</a></span></dt><dt><span class="section"><a href="mysql-cluster.html#mysql-cluster-programs-ndb-print-schema-file">17.4.14. <span><strong class="command">ndb_print_schema_file</strong></span> — Print NDB Schema File Contents</a></span></dt><dt><span class="section"><a href="mysql-cluster.html#mysql-cluster-programs-ndb-print-sys-file">17.4.15. <span><strong class="command">ndb_print_sys_file</strong></span> — Print NDB System File Contents</a></span></dt><dt><span class="section"><a href="mysql-cluster.html#mysql-cluster-programs-ndbd-redo-log-reader">17.4.16. <span><strong class="command">ndbd_redo_log_reader</strong></span> — Check and Print Content of Cluster Redo Log</a></span></dt><dt><span class="section"><a href="mysql-cluster.html#mysql-cluster-programs-ndb-restore">17.4.17. <span><strong class="command">ndb_restore</strong></span> — Restore a MySQL Cluster Backup</a></span></dt><dt><span class="section"><a href="mysql-cluster.html#mysql-cluster-programs-ndb-select-all">17.4.18. <span><strong class="command">ndb_select_all</strong></span> — Print Rows from an NDB Table</a></span></dt><dt><span class="section"><a href="mysql-cluster.html#mysql-cluster-programs-ndb-select-count">17.4.19. <span><strong class="command">ndb_select_count</strong></span> — Print Row Counts for NDB Tables</a></span></dt><dt><span class="section"><a href="mysql-cluster.html#mysql-cluster-programs-ndb-show-tables">17.4.20. <span><strong class="command">ndb_show_tables</strong></span> — Display List of NDB Tables</a></span></dt><dt><span class="section"><a href="mysql-cluster.html#mysql-cluster-programs-ndb-size-pl">17.4.21. <span><strong class="command">ndb_size.pl</strong></span> — NDBCLUSTER Size Requirement Estimator</a></span></dt><dt><span class="section"><a href="mysql-cluster.html#mysql-cluster-programs-ndb-waiter">17.4.22. <span><strong class="command">ndb_waiter</strong></span> — Wait for MySQL Cluster to Reach a Given Status</a></span></dt><dt><span class="section"><a href="mysql-cluster.html#mysql-cluster-program-options-common">17.4.23. Options Common to MySQL Cluster Programs</a></span></dt></dl></dd><dt><span class="section"><a href="mysql-cluster.html#mysql-cluster-management">17.5. Management of MySQL Cluster</a></span></dt><dd><dl><dt><span class="section"><a href="mysql-cluster.html#mysql-cluster-start-phases">17.5.1. Summary of MySQL Cluster Start Phases</a></span></dt><dt><span class="section"><a href="mysql-cluster.html#mysql-cluster-mgm-client-commands">17.5.2. Commands in the MySQL Cluster Management Client</a></span></dt><dt><span class="section"><a href="mysql-cluster.html#mysql-cluster-backup">17.5.3. Online Backup of MySQL Cluster</a></span></dt><dt><span class="section"><a href="mysql-cluster.html#mysql-cluster-event-reports">17.5.4. Event Reports Generated in MySQL Cluster</a></span></dt><dt><span class="section"><a href="mysql-cluster.html#mysql-cluster-logs-ndb-messages">17.5.5. MySQL Cluster Log Messages</a></span></dt><dt><span class="section"><a href="mysql-cluster.html#mysql-cluster-single-user-mode">17.5.6. MySQL Cluster Single User Mode</a></span></dt><dt><span class="section"><a href="mysql-cluster.html#mysql-cluster-sql-statements">17.5.7. Quick Reference: MySQL Cluster SQL Statements</a></span></dt><dt><span class="section"><a href="mysql-cluster.html#mysql-cluster-security">17.5.8. MySQL Cluster Security Issues</a></span></dt><dt><span class="section"><a href="mysql-cluster.html#mysql-cluster-disk-data">17.5.9. MySQL Cluster Disk Data Tables</a></span></dt><dt><span class="section"><a href="mysql-cluster.html#mysql-cluster-online-add-node">17.5.10. Adding MySQL Cluster Data Nodes Online</a></span></dt></dl></dd><dt><span class="section"><a href="mysql-cluster.html#mysql-cluster-replication">17.6. MySQL Cluster Replication</a></span></dt><dd><dl><dt><span class="section"><a href="mysql-cluster.html#mysql-cluster-replication-abbreviations">17.6.1. MySQL Cluster Replication — Abbreviations and Symbols</a></span></dt><dt><span class="section"><a href="mysql-cluster.html#mysql-cluster-replication-general">17.6.2. MySQL Cluster Replication — Assumptions and General Requirements</a></span></dt><dt><span class="section"><a href="mysql-cluster.html#mysql-cluster-replication-issues">17.6.3. Known Issues in MySQL Cluster Replication</a></span></dt><dt><span class="section"><a href="mysql-cluster.html#mysql-cluster-replication-schema">17.6.4. MySQL Cluster Replication Schema and Tables</a></span></dt><dt><span class="section"><a href="mysql-cluster.html#mysql-cluster-replication-preparation">17.6.5. Preparing the MySQL Cluster for Replication</a></span></dt><dt><span class="section"><a href="mysql-cluster.html#mysql-cluster-replication-starting">17.6.6. Starting MySQL Cluster Replication (Single Replication Channel)</a></span></dt><dt><span class="section"><a href="mysql-cluster.html#mysql-cluster-replication-two-channels">17.6.7. Using Two Replication Channels for MySQL Cluster Replication</a></span></dt><dt><span class="section"><a href="mysql-cluster.html#mysql-cluster-replication-failover">17.6.8. Implementing Failover with MySQL Cluster Replication</a></span></dt><dt><span class="section"><a href="mysql-cluster.html#mysql-cluster-replication-backups">17.6.9. MySQL Cluster Backups With MySQL Cluster Replication</a></span></dt><dt><span class="section"><a href="mysql-cluster.html#mysql-cluster-replication-multi-master">17.6.10. MySQL Cluster Replication — Multi-Master and Circular Replication</a></span></dt><dt><span class="section"><a href="mysql-cluster.html#mysql-cluster-replication-conflict-resolution">17.6.11. MySQL Cluster Replication Conflict Resolution</a></span></dt></dl></dd><dt><span class="section"><a href="mysql-cluster.html#mysql-cluster-news">17.7. Changes in MySQL Cluster NDB 6.X and 7.X</a></span></dt><dd><dl><dt><span class="section"><a href="mysql-cluster.html#mysql-cluster-news-releases">17.7.1. MySQL Cluster NDB 6.X and 7.X Release Changelogs</a></span></dt><dt><span class="section"><a href="mysql-cluster.html#mysql-cluster-news-series">17.7.2. Release Series Changelogs — MySQL Cluster NDB 6.X and 7.X</a></span></dt></dl></dd></dl></dd><dt><span class="chapter"><a href="partitioning.html">18. Partitioning</a></span></dt><dd><dl><dt><span class="section"><a href="partitioning.html#partitioning-overview">18.1. Overview of Partitioning in MySQL</a></span></dt><dt><span class="section"><a href="partitioning.html#partitioning-types">18.2. Partition Types</a></span></dt><dd><dl><dt><span class="section"><a href="partitioning.html#partitioning-range">18.2.1. <code class="literal">RANGE</code> Partitioning</a></span></dt><dt><span class="section"><a href="partitioning.html#partitioning-list">18.2.2. <code class="literal">LIST</code> Partitioning</a></span></dt><dt><span class="section"><a href="partitioning.html#partitioning-hash">18.2.3. <code class="literal">HASH</code> Partitioning</a></span></dt><dt><span class="section"><a href="partitioning.html#partitioning-key">18.2.4. <code class="literal">KEY</code> Partitioning</a></span></dt><dt><span class="section"><a href="partitioning.html#partitioning-subpartitions">18.2.5. Subpartitioning</a></span></dt><dt><span class="section"><a href="partitioning.html#partitioning-handling-nulls">18.2.6. How MySQL Partitioning Handles <code class="literal">NULL</code></a></span></dt></dl></dd><dt><span class="section"><a href="partitioning.html#partitioning-management">18.3. Partition Management</a></span></dt><dd><dl><dt><span class="section"><a href="partitioning.html#partitioning-management-range-list">18.3.1. Management of <code class="literal">RANGE</code> and <code class="literal">LIST</code>
Partitions</a></span></dt><dt><span class="section"><a href="partitioning.html#partitioning-management-hash-key">18.3.2. Management of <code class="literal">HASH</code> and <code class="literal">KEY</code>
Partitions</a></span></dt><dt><span class="section"><a href="partitioning.html#partitioning-maintenance">18.3.3. Maintenance of Partitions</a></span></dt><dt><span class="section"><a href="partitioning.html#partitioning-info">18.3.4. Obtaining Information About Partitions</a></span></dt></dl></dd><dt><span class="section"><a href="partitioning.html#partitioning-pruning">18.4. Partition Pruning</a></span></dt><dt><span class="section"><a href="partitioning.html#partitioning-limitations">18.5. Restrictions and Limitations on Partitioning</a></span></dt><dd><dl><dt><span class="section"><a href="partitioning.html#partitioning-limitations-partitioning-keys-unique-keys">18.5.1. Partitioning Keys, Primary Keys, and Unique Keys</a></span></dt><dt><span class="section"><a href="partitioning.html#partitioning-limitations-storage-engines">18.5.2. Partitioning Limitations Relating to Storage Engines</a></span></dt><dt><span class="section"><a href="partitioning.html#partitioning-limitations-functions">18.5.3. Partitioning Limitations Relating to Functions</a></span></dt></dl></dd></dl></dd><dt><span class="chapter"><a href="stored-programs-views.html">19. Stored Programs and Views</a></span></dt><dd><dl><dt><span class="section"><a href="stored-programs-views.html#stored-programs-defining">19.1. Defining Stored Programs</a></span></dt><dt><span class="section"><a href="stored-programs-views.html#stored-routines">19.2. Using Stored Routines (Procedures and Functions)</a></span></dt><dd><dl><dt><span class="section"><a href="stored-programs-views.html#stored-routines-syntax">19.2.1. Stored Routine Syntax</a></span></dt><dt><span class="section"><a href="stored-programs-views.html#stored-routines-privileges">19.2.2. Stored Routines and MySQL Privileges</a></span></dt><dt><span class="section"><a href="stored-programs-views.html#stored-routines-metadata">19.2.3. Stored Routine Metadata</a></span></dt><dt><span class="section"><a href="stored-programs-views.html#stored-routines-last-insert-id">19.2.4. Stored Procedures, Functions, Triggers, and
<code class="literal">LAST_INSERT_ID()</code></a></span></dt></dl></dd><dt><span class="section"><a href="stored-programs-views.html#triggers">19.3. Using Triggers</a></span></dt><dd><dl><dt><span class="section"><a href="stored-programs-views.html#trigger-syntax">19.3.1. Trigger Syntax</a></span></dt><dt><span class="section"><a href="stored-programs-views.html#trigger-metadata">19.3.2. Trigger Metadata</a></span></dt></dl></dd><dt><span class="section"><a href="stored-programs-views.html#events">19.4. Using the Event Scheduler</a></span></dt><dd><dl><dt><span class="section"><a href="stored-programs-views.html#events-overview">19.4.1. Event Scheduler Overview</a></span></dt><dt><span class="section"><a href="stored-programs-views.html#events-configuration">19.4.2. Event Scheduler Configuration</a></span></dt><dt><span class="section"><a href="stored-programs-views.html#events-syntax">19.4.3. Event Syntax</a></span></dt><dt><span class="section"><a href="stored-programs-views.html#events-metadata">19.4.4. Event Metadata</a></span></dt><dt><span class="section"><a href="stored-programs-views.html#events-status-info">19.4.5. Event Scheduler Status</a></span></dt><dt><span class="section"><a href="stored-programs-views.html#events-privileges">19.4.6. The Event Scheduler and MySQL Privileges</a></span></dt></dl></dd><dt><span class="section"><a href="stored-programs-views.html#views">19.5. Using Views</a></span></dt><dd><dl><dt><span class="section"><a href="stored-programs-views.html#view-syntax">19.5.1. View Syntax</a></span></dt><dt><span class="section"><a href="stored-programs-views.html#view-algorithms">19.5.2. View Processing Algorithms</a></span></dt><dt><span class="section"><a href="stored-programs-views.html#view-updatability">19.5.3. Updatable and Insertable Views</a></span></dt><dt><span class="section"><a href="stored-programs-views.html#view-metadata">19.5.4. View Metadata</a></span></dt></dl></dd><dt><span class="section"><a href="stored-programs-views.html#stored-programs-logging">19.6. Binary Logging of Stored Programs</a></span></dt></dl></dd><dt><span class="chapter"><a href="information-schema.html">20. <code class="literal">INFORMATION_SCHEMA</code> Tables</a></span></dt><dd><dl><dt><span class="section"><a href="information-schema.html#schemata-table">20.1. The <code class="literal">INFORMATION_SCHEMA SCHEMATA</code> Table</a></span></dt><dt><span class="section"><a href="information-schema.html#tables-table">20.2. The <code class="literal">INFORMATION_SCHEMA TABLES</code> Table</a></span></dt><dt><span class="section"><a href="information-schema.html#columns-table">20.3. The <code class="literal">INFORMATION_SCHEMA COLUMNS</code> Table</a></span></dt><dt><span class="section"><a href="information-schema.html#statistics-table">20.4. The <code class="literal">INFORMATION_SCHEMA STATISTICS</code> Table</a></span></dt><dt><span class="section"><a href="information-schema.html#user-privileges-table">20.5. The <code class="literal">INFORMATION_SCHEMA USER_PRIVILEGES</code> Table</a></span></dt><dt><span class="section"><a href="information-schema.html#schema-privileges-table">20.6. The <code class="literal">INFORMATION_SCHEMA SCHEMA_PRIVILEGES</code> Table</a></span></dt><dt><span class="section"><a href="information-schema.html#table-privileges-table">20.7. The <code class="literal">INFORMATION_SCHEMA TABLE_PRIVILEGES</code> Table</a></span></dt><dt><span class="section"><a href="information-schema.html#column-privileges-table">20.8. The <code class="literal">INFORMATION_SCHEMA COLUMN_PRIVILEGES</code> Table</a></span></dt><dt><span class="section"><a href="information-schema.html#character-sets-table">20.9. The <code class="literal">INFORMATION_SCHEMA CHARACTER_SETS</code> Table</a></span></dt><dt><span class="section"><a href="information-schema.html#collations-table">20.10. The <code class="literal">INFORMATION_SCHEMA COLLATIONS</code> Table</a></span></dt><dt><span class="section"><a href="information-schema.html#collation-character-set-applicability-table">20.11. The <code class="literal">INFORMATION_SCHEMA
COLLATION_CHARACTER_SET_APPLICABILITY</code> Table</a></span></dt><dt><span class="section"><a href="information-schema.html#table-constraints-table">20.12. The <code class="literal">INFORMATION_SCHEMA TABLE_CONSTRAINTS</code> Table</a></span></dt><dt><span class="section"><a href="information-schema.html#key-column-usage-table">20.13. The <code class="literal">INFORMATION_SCHEMA KEY_COLUMN_USAGE</code> Table</a></span></dt><dt><span class="section"><a href="information-schema.html#routines-table">20.14. The <code class="literal">INFORMATION_SCHEMA ROUTINES</code> Table</a></span></dt><dt><span class="section"><a href="information-schema.html#views-table">20.15. The <code class="literal">INFORMATION_SCHEMA VIEWS</code> Table</a></span></dt><dt><span class="section"><a href="information-schema.html#triggers-table">20.16. The <code class="literal">INFORMATION_SCHEMA TRIGGERS</code> Table</a></span></dt><dt><span class="section"><a href="information-schema.html#plugins-table">20.17. The <code class="literal">INFORMATION_SCHEMA PLUGINS</code> Table</a></span></dt><dt><span class="section"><a href="information-schema.html#engines-table">20.18. The <code class="literal">INFORMATION_SCHEMA ENGINES</code> Table</a></span></dt><dt><span class="section"><a href="information-schema.html#partitions-table">20.19. The <code class="literal">INFORMATION_SCHEMA PARTITIONS</code> Table</a></span></dt><dt><span class="section"><a href="information-schema.html#events-table">20.20. The <code class="literal">INFORMATION_SCHEMA EVENTS</code> Table</a></span></dt><dt><span class="section"><a href="information-schema.html#files-table">20.21. The <code class="literal">INFORMATION_SCHEMA FILES</code> Table</a></span></dt><dt><span class="section"><a href="information-schema.html#processlist-table">20.22. The <code class="literal">INFORMATION_SCHEMA PROCESSLIST</code> Table</a></span></dt><dt><span class="section"><a href="information-schema.html#referential-constraints-table">20.23. The <code class="literal">INFORMATION_SCHEMA REFERENTIAL_CONSTRAINTS</code> Table</a></span></dt><dt><span class="section"><a href="information-schema.html#status-table">20.24. The <code class="literal">INFORMATION_SCHEMA GLOBAL_STATUS</code> and
<code class="literal">SESSION_STATUS</code>
Tables</a></span></dt><dt><span class="section"><a href="information-schema.html#variables-table">20.25. The <code class="literal">INFORMATION_SCHEMA GLOBAL_VARIABLES</code> and
<code class="literal">SESSION_VARIABLES</code>
Tables</a></span></dt><dt><span class="section"><a href="information-schema.html#profiling-table">20.26. The <code class="literal">INFORMATION_SCHEMA PROFILING</code> Table</a></span></dt><dt><span class="section"><a href="information-schema.html#other-information-schema-tables">20.27. Other <code class="literal">INFORMATION_SCHEMA</code> Tables</a></span></dt><dt><span class="section"><a href="information-schema.html#extended-show">20.28. Extensions to <code class="literal">SHOW</code> Statements</a></span></dt></dl></dd><dt><span class="chapter"><a href="connectors-apis.html">21. Connectors and APIs</a></span></dt><dd><dl><dt><span class="section"><a href="connectors-apis.html#connector-odbc">21.1. MySQL Connector/ODBC</a></span></dt><dd><dl><dt><span class="section"><a href="connectors-apis.html#connector-odbc-versions">21.1.1. Connector/ODBC Versions</a></span></dt><dt><span class="section"><a href="connectors-apis.html#connector-odbc-introduction">21.1.2. Connector/ODBC Introduction</a></span></dt><dt><span class="section"><a href="connectors-apis.html#connector-odbc-installation">21.1.3. Connector/ODBC Installation</a></span></dt><dt><span class="section"><a href="connectors-apis.html#connector-odbc-configuration">21.1.4. Connector/ODBC Configuration</a></span></dt><dt><span class="section"><a href="connectors-apis.html#connector-odbc-examples">21.1.5. Connector/ODBC Examples</a></span></dt><dt><span class="section"><a href="connectors-apis.html#connector-odbc-reference">21.1.6. Connector/ODBC Reference</a></span></dt><dt><span class="section"><a href="connectors-apis.html#connector-odbc-usagenotes">21.1.7. Connector/ODBC Notes and Tips</a></span></dt><dt><span class="section"><a href="connectors-apis.html#connector-odbc-support">21.1.8. Connector/ODBC Support</a></span></dt></dl></dd><dt><span class="section"><a href="connectors-apis.html#connector-net">21.2. MySQL Connector/NET</a></span></dt><dd><dl><dt><span class="section"><a href="connectors-apis.html#connector-net-versions">21.2.1. Connector/NET Versions</a></span></dt><dt><span class="section"><a href="connectors-apis.html#connector-net-installation">21.2.2. Connector/NET Installation</a></span></dt><dt><span class="section"><a href="connectors-apis.html#connector-net-visual-studio">21.2.3. Connector/NET Visual Studio Integration</a></span></dt><dt><span class="section"><a href="connectors-apis.html#connector-net-tutorials">21.2.4. Connector/NET Tutorials</a></span></dt><dt><span class="section"><a href="connectors-apis.html#connector-net-programming">21.2.5. Connector/NET Programming</a></span></dt><dt><span class="section"><a href="connectors-apis.html#connector-net-programming-connection-options">21.2.6. Connector/NET Connection String Options Reference</a></span></dt><dt><span class="section"><a href="connectors-apis.html#connector-net-ref">21.2.7. Connector/NET API Reference</a></span></dt><dt><span class="section"><a href="connectors-apis.html#connect-net-support">21.2.8. Connector/NET Support</a></span></dt><dt><span class="section"><a href="connectors-apis.html#connector-net-faq">21.2.9. Connector/NET FAQ</a></span></dt></dl></dd><dt><span class="section"><a href="connectors-apis.html#connector-j">21.3. MySQL Connector/J</a></span></dt><dd><dl><dt><span class="section"><a href="connectors-apis.html#connector-j-versions">21.3.1. Connector/J Versions</a></span></dt><dt><span class="section"><a href="connectors-apis.html#connector-j-installing">21.3.2. Connector/J Installation</a></span></dt><dt><span class="section"><a href="connectors-apis.html#connector-j-examples">21.3.3. Connector/J Examples</a></span></dt><dt><span class="section"><a href="connectors-apis.html#connector-j-reference">21.3.4. Connector/J (JDBC) Reference</a></span></dt><dt><span class="section"><a href="connectors-apis.html#connector-j-usagenotes">21.3.5. Connector/J Notes and Tips</a></span></dt><dt><span class="section"><a href="connectors-apis.html#connector-j-support">21.3.6. Connector/J Support</a></span></dt></dl></dd><dt><span class="section"><a href="connectors-apis.html#connector-mxj">21.4. MySQL Connector/MXJ</a></span></dt><dd><dl><dt><span class="section"><a href="connectors-apis.html#connector-mxj-overview">21.4.1. Connector/MXJ Overview</a></span></dt><dt><span class="section"><a href="connectors-apis.html#connector-mxj-versions">21.4.2. Connector/MXJ Versions</a></span></dt><dt><span class="section"><a href="connectors-apis.html#connector-mxj-install">21.4.3. Connector/MXJ Installation</a></span></dt><dt><span class="section"><a href="connectors-apis.html#connector-mxj-configuration">21.4.4. Connector/MXJ Configuration</a></span></dt><dt><span class="section"><a href="connectors-apis.html#connector-mxj-ref">21.4.5. Connector/MXJ Reference</a></span></dt><dt><span class="section"><a href="connectors-apis.html#connector-mxj-usagenotes">21.4.6. Connector/MXJ Notes and Tips</a></span></dt><dt><span class="section"><a href="connectors-apis.html#connector-mxj-support">21.4.7. Connector/MXJ Support</a></span></dt></dl></dd><dt><span class="section"><a href="connectors-apis.html#connector-cpp">21.5. MySQL Connector/C++</a></span></dt><dd><dl><dt><span class="section"><a href="connectors-apis.html#connector-cpp-installation-binary">21.5.1. MySQL Connector/C++ Binary Installation</a></span></dt><dt><span class="section"><a href="connectors-apis.html#connector-cpp-installation-source">21.5.2. MySQL Connector/C++ Source Installation</a></span></dt><dt><span class="section"><a href="connectors-apis.html#connector-cpp-apps-windows-visual-studio">21.5.3. MySQL Connector/C++ Building Windows applications with Microsoft Visual Studio</a></span></dt><dt><span class="section"><a href="connectors-apis.html#connector-cpp-apps-linux-netbeans">21.5.4. MySQL Connector/C++ Building Linux applications with NetBeans</a></span></dt><dt><span class="section"><a href="connectors-apis.html#connector-cpp-getting-started-examples">21.5.5. MySQL Connector/C++ Getting Started: Usage Examples</a></span></dt><dt><span class="section"><a href="connectors-apis.html#connector-cpp-tutorials">21.5.6. MySQL Connector/C++ Tutorials</a></span></dt><dt><span class="section"><a href="connectors-apis.html#connector-cpp-debug-tracing">21.5.7. MySQL Connector/C++ Debug Tracing</a></span></dt><dt><span class="section"><a href="connectors-apis.html#connector-cpp-usage-notes">21.5.8. MySQL Connector/C++ Usage Notes</a></span></dt><dt><span class="section"><a href="connectors-apis.html#connector-cpp-bugs">21.5.9. MySQL Connector/C++ Known Bugs and Issues</a></span></dt><dt><span class="section"><a href="connectors-apis.html#connector-cpp-requests">21.5.10. MySQL Connector/C++ Feature requests</a></span></dt><dt><span class="section"><a href="connectors-apis.html#connector-cpp-support">21.5.11. MySQL Connector/C++ Support</a></span></dt><dt><span class="section"><a href="connectors-apis.html#connector-cpp-faq">21.5.12. MySQL Connector/C++ FAQ</a></span></dt></dl></dd><dt><span class="section"><a href="connectors-apis.html#connector-c">21.6. MySQL Connector/C</a></span></dt><dd><dl><dt><span class="section"><a href="connectors-apis.html#connector-c-building">21.6.1. Building MySQL Connector/C from the Source Code</a></span></dt><dt><span class="section"><a href="connectors-apis.html#connector-c-testing">21.6.2. Testing MySQL Connector/C</a></span></dt><dt><span class="section"><a href="connectors-apis.html#connector-c-faq">21.6.3. MySQL Connector/C FAQ</a></span></dt></dl></dd><dt><span class="section"><a href="connectors-apis.html#connector-ooo">21.7. MySQL Connector/OpenOffice.org</a></span></dt><dd><dl><dt><span class="section"><a href="connectors-apis.html#connector-ooo-installation">21.7.1. Installation</a></span></dt><dt><span class="section"><a href="connectors-apis.html#connector-ooo-getting-started">21.7.2. Getting Started: Connecting to MySQL</a></span></dt><dt><span class="section"><a href="connectors-apis.html#connector-ooo-getting-started-examples">21.7.3. Getting Started: Usage Examples</a></span></dt><dt><span class="section"><a href="connectors-apis.html#connector-ooo-references">21.7.4. References</a></span></dt><dt><span class="section"><a href="connectors-apis.html#connector-ooo-bugs">21.7.5. Known Bugs</a></span></dt><dt><span class="section"><a href="connectors-apis.html#connector-ooo-contact">21.7.6. Contact</a></span></dt></dl></dd><dt><span class="section"><a href="connectors-apis.html#libmysqld">21.8. libmysqld, the Embedded MySQL Server Library</a></span></dt><dd><dl><dt><span class="section"><a href="connectors-apis.html#libmysqld-compiling">21.8.1. Compiling Programs with <code class="literal">libmysqld</code></a></span></dt><dt><span class="section"><a href="connectors-apis.html#libmysqld-restrictions">21.8.2. Restrictions When Using the Embedded MySQL Server</a></span></dt><dt><span class="section"><a href="connectors-apis.html#libmysqld-options">21.8.3. Options with the Embedded Server</a></span></dt><dt><span class="section"><a href="connectors-apis.html#libmysqld-example">21.8.4. Embedded Server Examples</a></span></dt><dt><span class="section"><a href="connectors-apis.html#libmysqld-licensing">21.8.5. Licensing the Embedded Server</a></span></dt></dl></dd><dt><span class="section"><a href="connectors-apis.html#c">21.9. MySQL C API</a></span></dt><dd><dl><dt><span class="section"><a href="connectors-apis.html#c-api-datatypes">21.9.1. C API Data Types</a></span></dt><dt><span class="section"><a href="connectors-apis.html#c-api-function-overview">21.9.2. C API Function Overview</a></span></dt><dt><span class="section"><a href="connectors-apis.html#c-api-functions">21.9.3. C API Function Descriptions</a></span></dt><dt><span class="section"><a href="connectors-apis.html#c-api-prepared-statements">21.9.4. C API Prepared Statements</a></span></dt><dt><span class="section"><a href="connectors-apis.html#c-api-prepared-statement-datatypes">21.9.5. C API Prepared Statement Data types</a></span></dt><dt><span class="section"><a href="connectors-apis.html#c-api-prepared-statement-function-overview">21.9.6. C API Prepared Statement Function Overview</a></span></dt><dt><span class="section"><a href="connectors-apis.html#c-api-prepared-statement-functions">21.9.7. C API Prepared Statement Function Descriptions</a></span></dt><dt><span class="section"><a href="connectors-apis.html#c-thread-functions">21.9.8. C API Threaded Function Descriptions</a></span></dt><dt><span class="section"><a href="connectors-apis.html#c-embedded-server-functions">21.9.9. C API Embedded Server Function Descriptions</a></span></dt><dt><span class="section"><a href="connectors-apis.html#c-api-problems">21.9.10. Common Questions and Problems When Using the C API</a></span></dt><dt><span class="section"><a href="connectors-apis.html#auto-reconnect">21.9.11. Controlling Automatic Reconnection Behavior</a></span></dt><dt><span class="section"><a href="connectors-apis.html#c-api-multiple-queries">21.9.12. C API Support for Multiple Statement Execution</a></span></dt><dt><span class="section"><a href="connectors-apis.html#c-api-prepared-statement-problems">21.9.13. C API Prepared Statement Problems</a></span></dt><dt><span class="section"><a href="connectors-apis.html#c-api-prepared-statement-date-handling">21.9.14. C API Prepared Statement Handling of Date and Time Values</a></span></dt><dt><span class="section"><a href="connectors-apis.html#c-api-prepared-call-statements">21.9.15. C API Support for Prepared <code class="literal">CALL</code>
Statements</a></span></dt><dt><span class="section"><a href="connectors-apis.html#building-clients">21.9.16. Building Client Programs</a></span></dt></dl></dd><dt><span class="section"><a href="connectors-apis.html#apis-php">21.10. MySQL PHP API</a></span></dt><dd><dl><dt><span class="section"><a href="connectors-apis.html#apis-php-mysql">21.10.1. MySQL</a></span></dt><dt><span class="section"><a href="connectors-apis.html#apis-php-mysqli">21.10.2. MySQL Improved Extension (<code class="literal">Mysqli</code>)</a></span></dt><dt><span class="section"><a href="connectors-apis.html#apis-php-mysqlnd">21.10.3. MySQL Native Driver (<code class="literal">Mysqlnd</code>)</a></span></dt><dt><span class="section"><a href="connectors-apis.html#apis-php-pdo-mysql">21.10.4. MySQL Functions (PDO_MYSQL)</a></span></dt><dt><span class="section"><a href="connectors-apis.html#connector-php">21.10.5. Connector/PHP</a></span></dt><dt><span class="section"><a href="connectors-apis.html#apis-php-problems">21.10.6. Common Problems with MySQL and PHP</a></span></dt><dt><span class="section"><a href="connectors-apis.html#php-mysql-mysqli">21.10.7. Enabling Both <code class="literal">mysql</code> and <code class="literal">mysqli</code> in
PHP</a></span></dt></dl></dd><dt><span class="section"><a href="connectors-apis.html#apis-perl">21.11. MySQL Perl API</a></span></dt><dt><span class="section"><a href="connectors-apis.html#apis-cplusplus">21.12. MySQL C++ API</a></span></dt><dt><span class="section"><a href="connectors-apis.html#apis-python">21.13. MySQL Python API</a></span></dt><dt><span class="section"><a href="connectors-apis.html#apis-ruby">21.14. MySQL Ruby APIs</a></span></dt><dd><dl><dt><span class="section"><a href="connectors-apis.html#apis-ruby-mysqlruby">21.14.1. The MySQL/Ruby API</a></span></dt><dt><span class="section"><a href="connectors-apis.html#apis-ruby-rubymysql">21.14.2. The Ruby/MySQL API</a></span></dt></dl></dd><dt><span class="section"><a href="connectors-apis.html#apis-tcl">21.15. MySQL Tcl API</a></span></dt><dt><span class="section"><a href="connectors-apis.html#apis-eiffel">21.16. MySQL Eiffel Wrapper</a></span></dt></dl></dd><dt><span class="chapter"><a href="extending-mysql.html">22. Extending MySQL</a></span></dt><dd><dl><dt><span class="section"><a href="extending-mysql.html#mysql-internals">22.1. MySQL Internals</a></span></dt><dd><dl><dt><span class="section"><a href="extending-mysql.html#mysql-threads">22.1.1. MySQL Threads</a></span></dt><dt><span class="section"><a href="extending-mysql.html#mysql-test-suite">22.1.2. MySQL Test Suite</a></span></dt></dl></dd><dt><span class="section"><a href="extending-mysql.html#plugin-api">22.2. The MySQL Plugin Interface</a></span></dt><dd><dl><dt><span class="section"><a href="extending-mysql.html#plugin-api-characteristics">22.2.1. Characteristics of the Plugin Interface</a></span></dt><dt><span class="section"><a href="extending-mysql.html#plugin-full-text-plugins">22.2.2. Full-Text Parser Plugins</a></span></dt><dt><span class="section"><a href="extending-mysql.html#plugin-writing">22.2.3. Writing Plugins</a></span></dt></dl></dd><dt><span class="section"><a href="extending-mysql.html#adding-functions">22.3. Adding New Functions to MySQL</a></span></dt><dd><dl><dt><span class="section"><a href="extending-mysql.html#udf-features">22.3.1. Features of the User-Defined Function Interface</a></span></dt><dt><span class="section"><a href="extending-mysql.html#adding-udf">22.3.2. Adding a New User-Defined Function</a></span></dt><dt><span class="section"><a href="extending-mysql.html#adding-native-function">22.3.3. Adding a New Native Function</a></span></dt></dl></dd><dt><span class="section"><a href="extending-mysql.html#adding-procedures">22.4. Adding New Procedures to MySQL</a></span></dt><dd><dl><dt><span class="section"><a href="extending-mysql.html#procedure-analyse">22.4.1. <code class="literal">PROCEDURE ANALYSE</code></a></span></dt><dt><span class="section"><a href="extending-mysql.html#writing-a-procedure">22.4.2. Writing a Procedure</a></span></dt></dl></dd><dt><span class="section"><a href="extending-mysql.html#porting">22.5. Debugging and Porting MySQL</a></span></dt><dd><dl><dt><span class="section"><a href="extending-mysql.html#debugging-server">22.5.1. Debugging a MySQL Server</a></span></dt><dt><span class="section"><a href="extending-mysql.html#debugging-client">22.5.2. Debugging a MySQL Client</a></span></dt><dt><span class="section"><a href="extending-mysql.html#the-dbug-package">22.5.3. The DBUG Package</a></span></dt><dt><span class="section"><a href="extending-mysql.html#rts-threads">22.5.4. Comments about RTS Threads</a></span></dt><dt><span class="section"><a href="extending-mysql.html#thread-packages">22.5.5. Differences Between Thread Packages</a></span></dt></dl></dd></dl></dd><dt><span class="appendix"><a href="faqs.html">A. MySQL 5.1 Frequently Asked Questions</a></span></dt><dd><dl><dt><span class="section"><a href="faqs.html#faqs-general">A.1. MySQL 5.1 FAQ — General</a></span></dt><dt><span class="section"><a href="faqs.html#faqs-storage-engines">A.2. MySQL 5.1 FAQ — Storage Engines</a></span></dt><dt><span class="section"><a href="faqs.html#faqs-sql-modes">A.3. MySQL 5.1 FAQ — Server SQL Mode</a></span></dt><dt><span class="section"><a href="faqs.html#faqs-stored-procs">A.4. MySQL 5.1 FAQ — Stored Procedures and Functions</a></span></dt><dt><span class="section"><a href="faqs.html#faqs-triggers">A.5. MySQL 5.1 FAQ — Triggers</a></span></dt><dt><span class="section"><a href="faqs.html#faqs-views">A.6. MySQL 5.1 FAQ — Views</a></span></dt><dt><span class="section"><a href="faqs.html#faqs-information-schema">A.7. MySQL 5.0 FAQ — <code class="literal">INFORMATION_SCHEMA</code></a></span></dt><dt><span class="section"><a href="faqs.html#faqs-migration">A.8. MySQL 5.1 FAQ — Migration</a></span></dt><dt><span class="section"><a href="faqs.html#faqs-security">A.9. MySQL 5.1 FAQ — Security</a></span></dt><dt><span class="section"><a href="faqs.html#faqs-mysql-cluster">A.10. MySQL 5.1 FAQ — MySQL Cluster</a></span></dt><dt><span class="section"><a href="faqs.html#faqs-cjk">A.11. MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean
Character Sets</a></span></dt><dt><span class="section"><a href="faqs.html#faqs-connectors-apis">A.12. MySQL 5.1 FAQ — Connectors & APIs</a></span></dt><dt><span class="section"><a href="faqs.html#faqs-replication">A.13. MySQL 5.1 FAQ — Replication</a></span></dt><dt><span class="section"><a href="faqs.html#faqs-mysql-drbd-heartbeat">A.14. MySQL 5.1 FAQ — MySQL, DRBD, and Heartbeat</a></span></dt><dd><dl><dt><span class="section"><a href="faqs.html#faqs-drbd">A.14.1. Distributed Replicated Block Device (DRBD)</a></span></dt><dt><span class="section"><a href="faqs.html#drbd-linux-heartbeat">A.14.2. Linux Heartbeat</a></span></dt><dt><span class="section"><a href="faqs.html#drbd-architecture">A.14.3. DRBD Architecture</a></span></dt><dt><span class="section"><a href="faqs.html#drbd-mysql-replication-scale">A.14.4. DRBD and MySQL Replication</a></span></dt><dt><span class="section"><a href="faqs.html#drbd-file-systems">A.14.5. DRBD and File Systems</a></span></dt><dt><span class="section"><a href="faqs.html#drbd-lvm">A.14.6. DRBD and LVM</a></span></dt><dt><span class="section"><a href="faqs.html#drbd-virtualization">A.14.7. DRBD and Virtualization</a></span></dt><dt><span class="section"><a href="faqs.html#drbd-security">A.14.8. DRBD and Security</a></span></dt><dt><span class="section"><a href="faqs.html#drbd-system-requirements">A.14.9. DRBD and System Requirements</a></span></dt><dt><span class="section"><a href="faqs.html#drbd-support-consulting">A.14.10. DBRD and Support and Consulting</a></span></dt></dl></dd></dl></dd><dt><span class="appendix"><a href="error-handling.html">B. Errors, Error Codes, and Common Problems</a></span></dt><dd><dl><dt><span class="section"><a href="error-handling.html#problems">B.1. Problems and Common Errors</a></span></dt><dd><dl><dt><span class="section"><a href="error-handling.html#what-is-crashing">B.1.1. How to Determine What Is Causing a Problem</a></span></dt><dt><span class="section"><a href="error-handling.html#common-errors">B.1.2. Common Errors When Using MySQL Programs</a></span></dt><dt><span class="section"><a href="error-handling.html#installation-issues">B.1.3. Installation-Related Issues</a></span></dt><dt><span class="section"><a href="error-handling.html#administration-issues">B.1.4. Administration-Related Issues</a></span></dt><dt><span class="section"><a href="error-handling.html#query-issues">B.1.5. Query-Related Issues</a></span></dt><dt><span class="section"><a href="error-handling.html#optimizer-issues">B.1.6. Optimizer-Related Issues</a></span></dt><dt><span class="section"><a href="error-handling.html#table-definition-issues">B.1.7. Table Definition-Related Issues</a></span></dt><dt><span class="section"><a href="error-handling.html#bugs">B.1.8. Known Issues in MySQL</a></span></dt></dl></dd><dt><span class="section"><a href="error-handling.html#error-types">B.2. Types of Error Values</a></span></dt><dt><span class="section"><a href="error-handling.html#error-messages-server">B.3. Server Error Codes and Messages</a></span></dt><dt><span class="section"><a href="error-handling.html#error-messages-client">B.4. Client Error Codes and Messages</a></span></dt></dl></dd><dt><span class="appendix"><a href="news.html">C. MySQL Change History</a></span></dt><dd><dl><dt><span class="section"><a href="news.html#news-5-1-x">C.1. Changes in Release 5.1.x (Production)</a></span></dt><dd><dl><dt><span class="section"><a href="news.html#news-5-1-41">C.1.1. Changes in MySQL 5.1.41 (Not yet released)</a></span></dt><dt><span class="section"><a href="news.html#news-5-1-40">C.1.2. Changes in MySQL 5.1.40 (06 October 2009)</a></span></dt><dt><span class="section"><a href="news.html#news-5-1-39">C.1.3. Changes in MySQL 5.1.39 (04 September 2009)</a></span></dt><dt><span class="section"><a href="news.html#news-5-1-38">C.1.4. Changes in MySQL 5.1.38 (01 September 2009)</a></span></dt><dt><span class="section"><a href="news.html#news-5-1-37sp1">C.1.5. Release Notes for MySQL Enterprise 5.1.37sp1 [QSP] (10 October 2009)</a></span></dt><dt><span class="section"><a href="news.html#news-5-1-37">C.1.6. Changes in MySQL 5.1.37 (13 July 2009)</a></span></dt><dt><span class="section"><a href="news.html#news-5-1-36">C.1.7. Changes in MySQL 5.1.36 (16 June 2009)</a></span></dt><dt><span class="section"><a href="news.html#news-5-1-35">C.1.8. Changes in MySQL 5.1.35 (13 May 2009)</a></span></dt><dt><span class="section"><a href="news.html#news-5-1-34sp1">C.1.9. Release Notes for MySQL Enterprise 5.1.34sp1 [QSP] (25 June 2009)</a></span></dt><dt><span class="section"><a href="news.html#news-5-1-34">C.1.10. Changes in MySQL 5.1.34 (02 April 2009)</a></span></dt><dt><span class="section"><a href="news.html#news-5-1-33">C.1.11. Changes in MySQL 5.1.33 (13 March 2009)</a></span></dt><dt><span class="section"><a href="news.html#news-5-1-32">C.1.12. Changes in MySQL 5.1.32 (14 February 2009)</a></span></dt><dt><span class="section"><a href="news.html#news-5-1-31sp1">C.1.13. Release Notes for MySQL Enterprise 5.1.31sp1 [QSP] (19 March 2009)</a></span></dt><dt><span class="section"><a href="news.html#news-5-1-31">C.1.14. Changes in MySQL 5.1.31 (19 January 2009)</a></span></dt><dt><span class="section"><a href="news.html#news-5-1-30">C.1.15. Changes in MySQL 5.1.30 (14 November 2008 General Availability)</a></span></dt><dt><span class="section"><a href="news.html#news-5-1-29">C.1.16. Changes in MySQL 5.1.29 (11 October 2008)</a></span></dt><dt><span class="section"><a href="news.html#news-5-1-28">C.1.17. Changes in MySQL 5.1.28 (28 August 2008)</a></span></dt><dt><span class="section"><a href="news.html#news-5-1-27">C.1.18. Changes in MySQL 5.1.27 (Not released)</a></span></dt><dt><span class="section"><a href="news.html#news-5-1-26">C.1.19. Changes in MySQL 5.1.26 (30 June 2008)</a></span></dt><dt><span class="section"><a href="news.html#news-5-1-25">C.1.20. Changes in MySQL 5.1.25 (28 May 2008)</a></span></dt><dt><span class="section"><a href="news.html#news-5-1-24">C.1.21. Changes in MySQL 5.1.24 (08 April 2008)</a></span></dt><dt><span class="section"><a href="news.html#news-5-1-23">C.1.22. Changes in MySQL 5.1.23 (29 January 2008)</a></span></dt><dt><span class="section"><a href="news.html#news-5-1-22">C.1.23. Changes in MySQL 5.1.22 (24 September 2007 Release Candidate)</a></span></dt><dt><span class="section"><a href="news.html#news-5-1-21">C.1.24. Changes in MySQL 5.1.21 (16 August 2007)</a></span></dt><dt><span class="section"><a href="news.html#news-5-1-20">C.1.25. Changes in MySQL 5.1.20 (25 June 2007)</a></span></dt><dt><span class="section"><a href="news.html#news-5-1-19">C.1.26. Changes in MySQL 5.1.19 (25 May 2007)</a></span></dt><dt><span class="section"><a href="news.html#news-5-1-18">C.1.27. Changes in MySQL 5.1.18 (08 May 2007)</a></span></dt><dt><span class="section"><a href="news.html#news-5-1-17">C.1.28. Changes in MySQL 5.1.17 (04 April 2007)</a></span></dt><dt><span class="section"><a href="news.html#news-5-1-16">C.1.29. Changes in MySQL 5.1.16 (26 February 2007)</a></span></dt><dt><span class="section"><a href="news.html#news-5-1-15">C.1.30. Changes in MySQL 5.1.15 (25 January 2007)</a></span></dt><dt><span class="section"><a href="news.html#news-5-1-14">C.1.31. Changes in MySQL 5.1.14 (05 December 2006)</a></span></dt><dt><span class="section"><a href="news.html#news-5-1-13">C.1.32. Changes in MySQL 5.1.13 (Not released)</a></span></dt><dt><span class="section"><a href="news.html#news-5-1-12">C.1.33. Changes in MySQL 5.1.12 (24 October 2006)</a></span></dt><dt><span class="section"><a href="news.html#news-5-1-11">C.1.34. Changes in MySQL 5.1.11 (26 May 2006)</a></span></dt><dt><span class="section"><a href="news.html#news-5-1-10">C.1.35. Changes in MySQL 5.1.10 (Not released)</a></span></dt><dt><span class="section"><a href="news.html#news-5-1-9">C.1.36. Changes in MySQL 5.1.9 (12 April 2006)</a></span></dt><dt><span class="section"><a href="news.html#news-5-1-8">C.1.37. Changes in MySQL 5.1.8 (Not released)</a></span></dt><dt><span class="section"><a href="news.html#news-5-1-7">C.1.38. Changes in MySQL 5.1.7 (27 February 2006)</a></span></dt><dt><span class="section"><a href="news.html#news-5-1-6">C.1.39. Changes in MySQL 5.1.6 (01 February 2006)</a></span></dt><dt><span class="section"><a href="news.html#news-5-1-5">C.1.40. Changes in MySQL 5.1.5 (10 January 2006)</a></span></dt><dt><span class="section"><a href="news.html#news-5-1-4">C.1.41. Changes in MySQL 5.1.4 (21 December 2005)</a></span></dt><dt><span class="section"><a href="news.html#news-5-1-3">C.1.42. Changes in MySQL 5.1.3 (29 November 2005)</a></span></dt><dt><span class="section"><a href="news.html#news-5-1-2">C.1.43. Changes in MySQL 5.1.2 (Not released)</a></span></dt><dt><span class="section"><a href="news.html#news-5-1-1">C.1.44. Changes in MySQL 5.1.1 (Not released)</a></span></dt></dl></dd><dt><span class="section"><a href="news.html#mem-news">C.2. MySQL Enterprise Monitor Change History</a></span></dt><dd><dl><dt><span class="section"><a href="news.html#mem-news-2-0-7">C.2.1. Changes in MySQL Enterprise Monitor 2.0.7 (Not yet released)</a></span></dt><dt><span class="section"><a href="news.html#mem-news-2-0-6">C.2.2. Changes in MySQL Enterprise Monitor 2.0.6 (27th August 2009)</a></span></dt><dt><span class="section"><a href="news.html#mem-news-2-0-5">C.2.3. Changes in MySQL Enterprise Monitor 2.0.5 (18th March 2009)</a></span></dt><dt><span class="section"><a href="news.html#mem-news-2-0-4">C.2.4. Changes in MySQL Enterprise Monitor 2.0.4 (5th February 2009)</a></span></dt><dt><span class="section"><a href="news.html#mem-news-2-0-3">C.2.5. Changes in MySQL Enterprise Monitor 2.0.3 (23rd January 2009)</a></span></dt><dt><span class="section"><a href="news.html#mem-news-2-0-2">C.2.6. Changes in MySQL Enterprise Monitor 2.0.2 (14th January 2009)</a></span></dt><dt><span class="section"><a href="news.html#mem-news-2-0-1">C.2.7. Changes in MySQL Enterprise Monitor 2.0.1 (15th December 2008)</a></span></dt><dt><span class="section"><a href="news.html#mem-news-2-0-0">C.2.8. Changes in MySQL Enterprise Monitor 2.0.0 (11th December 2008)</a></span></dt></dl></dd><dt><span class="section"><a href="news.html#connector-odbc-news">C.3. MySQL Connector/ODBC (MyODBC) Change History</a></span></dt><dd><dl><dt><span class="section"><a href="news.html#connector-odbc-news-5-1-6">C.3.1. Changes in MySQL Connector/ODBC 5.1.6 (Not yet released)</a></span></dt><dt><span class="section"><a href="news.html#connector-odbc-news-5-1-5">C.3.2. Changes in MySQL Connector/ODBC 5.1.5 (18 August 2008)</a></span></dt><dt><span class="section"><a href="news.html#connector-odbc-news-5-1-4">C.3.3. Changes in MySQL Connector/ODBC 5.1.4 (15 April 2008)</a></span></dt><dt><span class="section"><a href="news.html#connector-odbc-news-5-1-3">C.3.4. Changes in MySQL Connector/ODBC 5.1.3 (26 March 2008)</a></span></dt><dt><span class="section"><a href="news.html#connector-odbc-news-5-1-2">C.3.5. Changes in MySQL Connector/ODBC 5.1.2 (13 February 2008)</a></span></dt><dt><span class="section"><a href="news.html#connector-odbc-news-5-1-1">C.3.6. Changes in MySQL Connector/ODBC 5.1.1 (13 December 2007)</a></span></dt><dt><span class="section"><a href="news.html#connector-odbc-news-5-1-0">C.3.7. Changes in MySQL Connector/ODBC 5.1.0 (10 September 2007)</a></span></dt><dt><span class="section"><a href="news.html#connector-odbc-news-5-0-12">C.3.8. Changes in MySQL Connector/ODBC 5.0.12 (Never released)</a></span></dt><dt><span class="section"><a href="news.html#connector-odbc-news-5-0-11">C.3.9. Changes in MySQL Connector/ODBC 5.0.11 (31 January 2007)</a></span></dt><dt><span class="section"><a href="news.html#connector-odbc-news-5-0-10">C.3.10. Changes in MySQL Connector/ODBC 5.0.10 (14 December 2006)</a></span></dt><dt><span class="section"><a href="news.html#connector-odbc-news-5-0-9">C.3.11. Changes in MySQL Connector/ODBC 5.0.9 (22 November 2006)</a></span></dt><dt><span class="section"><a href="news.html#connector-odbc-news-5-0-8">C.3.12. Changes in MySQL Connector/ODBC 5.0.8 (17 November 2006)</a></span></dt><dt><span class="section"><a href="news.html#connector-odbc-news-5-0-7">C.3.13. Changes in MySQL Connector/ODBC 5.0.7 (08 November 2006)</a></span></dt><dt><span class="section"><a href="news.html#connector-odbc-news-5-0-6">C.3.14. Changes in MySQL Connector/ODBC 5.0.6 (03 November 2006)</a></span></dt><dt><span class="section"><a href="news.html#connector-odbc-news-5-0-5">C.3.15. Changes in MySQL Connector/ODBC 5.0.5 (17 October 2006)</a></span></dt><dt><span class="section"><a href="news.html#connector-odbc-news-5-0-3">C.3.16. Changes in Connector/ODBC 5.0.3 (Connector/ODBC 5.0 Alpha 3) (20 June
2006)</a></span></dt><dt><span class="section"><a href="news.html#connector-odbc-news-5-0-2">C.3.17. Changes in Connector/ODBC 5.0.2 (Never released)</a></span></dt><dt><span class="section"><a href="news.html#connector-odbc-news-5-0-1">C.3.18. Changes in Connector/ODBC 5.0.1 (Connector/ODBC 5.0 Alpha 2) (05 June
2006)</a></span></dt><dt><span class="section"><a href="news.html#connector-odbc-news-3-51-27">C.3.19. Changes in MySQL Connector/ODBC 3.51.27 (20 November 2008)</a></span></dt><dt><span class="section"><a href="news.html#connector-odbc-news-3-51-26">C.3.20. Changes in MySQL Connector/ODBC 3.51.26 (07 July 2008)</a></span></dt><dt><span class="section"><a href="news.html#connector-odbc-news-3-51-25">C.3.21. Changes in MySQL Connector/ODBC 3.51.25 (11 April 2008)</a></span></dt><dt><span class="section"><a href="news.html#connector-odbc-news-3-51-24">C.3.22. Changes in MySQL Connector/ODBC 3.51.24 (14 March 2008)</a></span></dt><dt><span class="section"><a href="news.html#connector-odbc-news-3-51-23">C.3.23. Changes in MySQL Connector/ODBC 3.51.23 (09 January 2008)</a></span></dt><dt><span class="section"><a href="news.html#connector-odbc-news-3-51-22">C.3.24. Changes in MySQL Connector/ODBC 3.51.22 (13 November 2007)</a></span></dt><dt><span class="section"><a href="news.html#connector-odbc-news-3-51-21">C.3.25. Changes in MySQL Connector/ODBC 3.51.21 (08 October 2007)</a></span></dt><dt><span class="section"><a href="news.html#connector-odbc-news-3-51-20">C.3.26. Changes in MySQL Connector/ODBC 3.51.20 (10 September 2007)</a></span></dt><dt><span class="section"><a href="news.html#connector-odbc-news-3-51-19">C.3.27. Changes in MySQL Connector/ODBC 3.51.19 (10 August 2007)</a></span></dt><dt><span class="section"><a href="news.html#connector-odbc-news-3-51-18">C.3.28. Changes in MySQL Connector/ODBC 3.51.18 (08 August 2007)</a></span></dt><dt><span class="section"><a href="news.html#connector-odbc-news-3-51-17">C.3.29. Changes in MySQL Connector/ODBC 3.51.17 (14 July 2007)</a></span></dt><dt><span class="section"><a href="news.html#connector-odbc-news-3-51-16">C.3.30. Changes in MySQL Connector/ODBC 3.51.16 (14 June 2007)</a></span></dt><dt><span class="section"><a href="news.html#connector-odbc-news-3-51-15">C.3.31. Changes in MySQL Connector/ODBC 3.51.15 (07 May 2007)</a></span></dt><dt><span class="section"><a href="news.html#connector-odbc-news-3-51-14">C.3.32. Changes in MySQL Connector/ODBC 3.51.14 (08 March 2007)</a></span></dt><dt><span class="section"><a href="news.html#connector-odbc-news-3-51-13">C.3.33. Changes in MySQL Connector/ODBC 3.51.13 (Never released)</a></span></dt><dt><span class="section"><a href="news.html#connector-odbc-news-3-51-12">C.3.34. Changes in MySQL Connector/ODBC 3.51.12 (11 February 2005)</a></span></dt><dt><span class="section"><a href="news.html#connector-odbc-news-3-51-11">C.3.35. Changes in MySQL Connector/ODBC 3.51.11 (28 January 2005)</a></span></dt></dl></dd><dt><span class="section"><a href="news.html#connector-net-news">C.4. MySQL Connector/NET Change History</a></span></dt><dd><dl><dt><span class="section"><a href="news.html#changes-6.2.x">C.4.1. Changes in MySQL Connector/NET Version 6.2.x</a></span></dt><dt><span class="section"><a href="news.html#changes-6.1.x">C.4.2. Changes in MySQL Connector/NET Version 6.1.x</a></span></dt><dt><span class="section"><a href="news.html#changes-6.0.x">C.4.3. Changes in MySQL Connector/NET Version 6.0.x</a></span></dt><dt><span class="section"><a href="news.html#changes-5.3.x">C.4.4. Changes in MySQL Connector/NET Version 5.3.x</a></span></dt><dt><span class="section"><a href="news.html#changes-5.2.x">C.4.5. Changes in MySQL Connector/NET Version 5.2.x</a></span></dt><dt><span class="section"><a href="news.html#changes-5.1.x">C.4.6. Changes in MySQL Connector/NET Version 5.1.x</a></span></dt><dt><span class="section"><a href="news.html#changes-5.0.x">C.4.7. Changes in MySQL Connector/NET Version 5.0.x</a></span></dt><dt><span class="section"><a href="news.html#changes-1.0.x">C.4.8. Changes in MySQL Connector/NET Version 1.0.x</a></span></dt><dt><span class="section"><a href="news.html#connector-net-0-9-0">C.4.9. Changes in MySQL Connector/NET Version 0.9.0 (30 August 2004)</a></span></dt><dt><span class="section"><a href="news.html#connector-net-news-0-76">C.4.10. Changes in MySQL Connector/NET Version 0.76</a></span></dt><dt><span class="section"><a href="news.html#connector-net-news-0-75">C.4.11. Changes in MySQL Connector/NET Version 0.75</a></span></dt><dt><span class="section"><a href="news.html#connector-net-0-74">C.4.12. Changes in MySQL Connector/NET Version 0.74</a></span></dt><dt><span class="section"><a href="news.html#connector-net-news-0-71">C.4.13. Changes in MySQL Connector/NET Version 0.71</a></span></dt><dt><span class="section"><a href="news.html#connector-net-news-0-70">C.4.14. Changes in MySQL Connector/NET Version 0.70</a></span></dt><dt><span class="section"><a href="news.html#connector-net-news-0-68">C.4.15. Changes in MySQL Connector/NET Version 0.68</a></span></dt><dt><span class="section"><a href="news.html#connector-net-news-0-65">C.4.16. Changes in MySQL Connector/NET Version 0.65</a></span></dt><dt><span class="section"><a href="news.html#connector-net-news-0-60">C.4.17. Changes in MySQL Connector/NET Version 0.60</a></span></dt><dt><span class="section"><a href="news.html#connector-net-news-0-50">C.4.18. Changes in MySQL Connector/NET Version 0.50</a></span></dt></dl></dd><dt><span class="section"><a href="news.html#vstudio-plugin-news">C.5. MySQL Visual Studio Plugin Change History</a></span></dt><dd><dl><dt><span class="section"><a href="news.html#vstudio-plugin-news-1-0-3">C.5.1. Changes in MySQL Visual Studio Plugin 1.0.3 (Not yet released)</a></span></dt><dt><span class="section"><a href="news.html#vstudio-plugin-news-1-0-2">C.5.2. Changes in MySQL Visual Studio Plugin 1.0.2 (Not yet released)</a></span></dt><dt><span class="section"><a href="news.html#vstudio-plugin-news-1-0-1">C.5.3. Changes in MySQL Visual Studio Plugin 1.0.1 (4 October 2006)</a></span></dt><dt><span class="section"><a href="news.html#vstudio-plugin-news-1-0-0">C.5.4. Changes in MySQL Visual Studio Plugin 1.0.0 (4 October 2006)</a></span></dt></dl></dd><dt><span class="section"><a href="news.html#cj-news">C.6. MySQL Connector/J Change History</a></span></dt><dd><dl><dt><span class="section"><a href="news.html#cj-news-5-1">C.6.1. Changes in MySQL Connector/J 5.1.x</a></span></dt><dt><span class="section"><a href="news.html#cj-news-5-0">C.6.2. Changes in MySQL Connector/J 5.0.x</a></span></dt><dt><span class="section"><a href="news.html#cg-news-3-1">C.6.3. Changes in MySQL Connector/J 3.1.x</a></span></dt><dt><span class="section"><a href="news.html#cg-news-3-0">C.6.4. Changes in MySQL Connector/J 3.0.x</a></span></dt><dt><span class="section"><a href="news.html#cj-news-2-0">C.6.5. Changes in MySQL Connector/J 2.0.x</a></span></dt><dt><span class="section"><a href="news.html#cj-news-1-2b">C.6.6. Changes in MySQL Connector/J 1.2b (04 July 1999)</a></span></dt><dt><span class="section"><a href="news.html#cg-news-1-0">C.6.7. Changes in MySQL Connector/J 1.2.x and lower</a></span></dt></dl></dd><dt><span class="section"><a href="news.html#news-connector-mxj">C.7. MySQL Connector/MXJ Change History</a></span></dt><dd><dl><dt><span class="section"><a href="news.html#news-connector-mxj-5-0-6">C.7.1. Changes in MySQL Connector/MXJ 5.0.6 (04 May 2007)</a></span></dt><dt><span class="section"><a href="news.html#news-connector-mxj-5-0-5">C.7.2. Changes in MySQL Connector/MXJ 5.0.5 (14 March 2007)</a></span></dt><dt><span class="section"><a href="news.html#news-connector-mxj-5-0-4">C.7.3. Changes in MySQL Connector/MXJ 5.0.4 (28 January 2007)</a></span></dt><dt><span class="section"><a href="news.html#news-connector-mxj-5-0-3">C.7.4. Changes in MySQL Connector/MXJ 5.0.3 (24 June 2006)</a></span></dt><dt><span class="section"><a href="news.html#news-connector-mxj-5-0-2">C.7.5. Changes in MySQL Connector/MXJ 5.0.2 (15 June 2006)</a></span></dt><dt><span class="section"><a href="news.html#news-connector-mxj-5-0-1">C.7.6. Changes in MySQL Connector/MXJ 5.0.1 (Never released)</a></span></dt><dt><span class="section"><a href="news.html#news-connector-mxj-5-0-0">C.7.7. Changes in MySQL Connector/MXJ 5.0.0 (09 December 2005)</a></span></dt></dl></dd><dt><span class="section"><a href="news.html#ccpp-news">C.8. MySQL Connector/C++ Change History</a></span></dt><dd><dl><dt><span class="section"><a href="news.html#ccpp-news-1-1">C.8.1. Changes in MySQL Connector/C++ 1.1.x</a></span></dt><dt><span class="section"><a href="news.html#ccpp-news-1-0">C.8.2. Changes in MySQL Connector/C++ 1.0.x</a></span></dt></dl></dd><dt><span class="section"><a href="news.html#mysql-proxy-news">C.9. MySQL Proxy Change History</a></span></dt><dd><dl><dt><span class="section"><a href="news.html#mysql-proxy-news-0-8-0">C.9.1. Changes in MySQL Proxy 0.8.0 (Not Yet Released)</a></span></dt><dt><span class="section"><a href="news.html#mysql-proxy-news-0-7-3">C.9.2. Changes in MySQL Proxy 0.7.3 (Not Yet Released)</a></span></dt><dt><span class="section"><a href="news.html#mysql-proxy-news-0-7-2">C.9.3. Changes in MySQL Proxy 0.7.2 (30 June 2009)</a></span></dt><dt><span class="section"><a href="news.html#mysql-proxy-news-0-7-1">C.9.4. Changes in MySQL Proxy 0.7.1 (15 May 2009)</a></span></dt><dt><span class="section"><a href="news.html#mysql-proxy-news-0-7-0">C.9.5. Changes in MySQL Proxy 0.7.0 (Never Released)</a></span></dt><dt><span class="section"><a href="news.html#mysql-proxy-news-0-6-1">C.9.6. Changes in MySQL Proxy 0.6.1 (06 February 2008)</a></span></dt><dt><span class="section"><a href="news.html#mysql-proxy-news-0-6-0">C.9.7. Changes in MySQL Proxy 0.6.0 (11 September 2007)</a></span></dt><dt><span class="section"><a href="news.html#mysql-proxy-news-0-5-1">C.9.8. Changes in MySQL Proxy 0.5.1 (30 June 2007)</a></span></dt><dt><span class="section"><a href="news.html#mysql-proxy-news-0-5-0">C.9.9. Changes in MySQL Proxy 0.5.0 (19 June 2007)</a></span></dt></dl></dd></dl></dd><dt><span class="appendix"><a href="restrictions.html">D. Restrictions and Limits</a></span></dt><dd><dl><dt><span class="section"><a href="restrictions.html#stored-program-restrictions">D.1. Restrictions on Stored Routines, Triggers, and Events</a></span></dt><dt><span class="section"><a href="restrictions.html#cursor-restrictions">D.2. Restrictions on Server-Side Cursors</a></span></dt><dt><span class="section"><a href="restrictions.html#subquery-restrictions">D.3. Restrictions on Subqueries</a></span></dt><dt><span class="section"><a href="restrictions.html#view-restrictions">D.4. Restrictions on Views</a></span></dt><dt><span class="section"><a href="restrictions.html#xa-restrictions">D.5. Restrictions on XA Transactions</a></span></dt><dt><span class="section"><a href="restrictions.html#charset-restrictions">D.6. Restrictions on Character Sets</a></span></dt><dt><span class="section"><a href="restrictions.html#limits">D.7. Limits in MySQL</a></span></dt><dd><dl><dt><span class="section"><a href="restrictions.html#joins-limits">D.7.1. Limits of Joins</a></span></dt><dt><span class="section"><a href="restrictions.html#column-count-limit">D.7.2. The Maximum Number of Columns Per Table</a></span></dt><dt><span class="section"><a href="restrictions.html#limits-windows">D.7.3. Windows Platform Limitations</a></span></dt></dl></dd></dl></dd><dt><span class="index"><a href="ix01.html">Index</a></span></dt><dt><span class="index"><a href="ix02.html">Standard Index</a></span></dt><dt><span class="index"><a href="dynindex-cfunction.html">C Function Index</a></span></dt><dt><span class="index"><a href="dynindex-command.html">Command Index</a></span></dt><dt><span class="index"><a href="dynindex-function.html">Function Index</a></span></dt><dt><span class="index"><a href="dynindex-is.html"><code class="literal">INFORMATION_SCHEMA</code> Index</a></span></dt><dt><span class="index"><a href="dynindex-isolevel.html">Transaction Isolation Level Index</a></span></dt><dt><span class="index"><a href="dynindex-jointype.html"><code class="literal">JOIN</code> Types Index</a></span></dt><dt><span class="index"><a href="dynindex-operator.html">Operator Index</a></span></dt><dt><span class="index"><a href="dynindex-option.html">Option Index</a></span></dt><dt><span class="index"><a href="dynindex-priv.html">Privileges Index</a></span></dt><dt><span class="index"><a href="dynindex-sqlmode.html">SQL Modes Index</a></span></dt><dt><span class="index"><a href="dynindex-statvar.html">Status Variable Index</a></span></dt><dt><span class="index"><a href="dynindex-statement.html">Statement/Syntax Index</a></span></dt><dt><span class="index"><a href="dynindex-sysvar.html">System Variable Index</a></span></dt></dl></div><div class="list-of-figures"><p><b>List of Figures</b></p><dl><dt>13.1. <a href="storage-engines.html#figure-storage-engine-architecture">MySQL Architecture with Pluggable Storage Engines</a></dt><dt>13.2. <a href="storage-engines.html#figure-se-federated-structure"><code class="literal">FEDERATED</code> Table Structure</a></dt><dt>14.1. <a href="ha-overview.html#ha-drbd-overview">DRBD Architecture Overview</a></dt><dt>14.2. <a href="ha-overview.html#ha-drbd-performance-sepinterface">DRBD Architecture Using Separate Network Interfaces</a></dt><dt>14.3. <a href="ha-overview.html#ha-heartbeat-overview">Heartbeat Architecture</a></dt><dt>14.4. <a href="ha-overview.html#ha-memcached-fig-overview"><span>memcached</span> Architecture Overview</a></dt><dt>14.5. <a href="ha-overview.html#ha-memcached-using-hashtypes-fig-selection"><span>memcached</span> Hash Selection</a></dt><dt>14.6. <a href="ha-overview.html#ha-memcached-using-hashtypes-fig-addselect"><span>memcached</span> Hash Selection with New
<span>memcached</span> instance</a></dt><dt>14.7. <a href="ha-overview.html#ha-memcached-fig-slabs">Memory Allocation in <span>memcached</span></a></dt><dt>14.8. <a href="ha-overview.html#ha-memcached-fig-basicflow">Typical <span>memcached</span> Application Flowchart</a></dt><dt>15.1. <a href="mem-introduction.html#fig-mem-overview">MySQL Enterprise Monitor Architecture</a></dt><dt>15.2. <a href="mem-introduction.html#fig-monitor-install-win1">MySQL Enterprise Monitor: Installing Monitor on Windows: Language
Selection</a></dt><dt>15.3. <a href="mem-introduction.html#fig-monitor-install-win3">MySQL Enterprise Monitor: Installing Monitor on Windows: Installation
Directory</a></dt><dt>15.4. <a href="mem-introduction.html#fig-monitor-install-win4">MySQL Enterprise Monitor: Installing Monitor on Windows: Tomcat Server
Options</a></dt><dt>15.5. <a href="mem-introduction.html#fig-monitor-install-win5">MySQL Enterprise Monitor: Installing Monitor on Windows: Repository
Configuration</a></dt><dt>15.6. <a href="mem-introduction.html#fig-monitor-install-osx1">MySQL Enterprise Monitor: Installing Monitor on OS X: Language Selection</a></dt><dt>15.7. <a href="mem-introduction.html#fig-monitor-install-osx2">MySQL Enterprise Monitor: Installing Monitor on OS X: Java Selection</a></dt><dt>15.8. <a href="mem-introduction.html#fig-monitor-install-osx4">MySQL Enterprise Monitor: Installing Monitor on OS X: Installation
Directory</a></dt><dt>15.9. <a href="mem-introduction.html#fig-monitor-install-osx5">MySQL Enterprise Monitor: Installing Monitor on OS X: Tomcat Server
Options</a></dt><dt>15.10. <a href="mem-introduction.html#fig-monitor-install-osx6">MySQL Enterprise Monitor: Installing Monitor on OS X: Repository
Configuration</a></dt><dt>15.11. <a href="mem-introduction.html#fig-first-dashboard-login">MySQL Enterprise Monitor: Initial Dashboard Log-In</a></dt><dt>15.12. <a href="mem-introduction.html#fig-email-settings">MySQL Enterprise Monitor: Outgoing Email Settings</a></dt><dt>15.13. <a href="mem-introduction.html#fig-agent-install-win1">MySQL Enterprise Monitor: Installing Agent on Windows: Language
Selection</a></dt><dt>15.14. <a href="mem-introduction.html#fig-agent-install-win3">MySQL Enterprise Monitor: Installing Agent on Windows: Installation
Directory</a></dt><dt>15.15. <a href="mem-introduction.html#fig-agent-install-win4">MySQL Enterprise Monitor: Installing Agent on Windows: Monitored
Database Information</a></dt><dt>15.16. <a href="mem-introduction.html#fig-agent-install-win5">MySQL Enterprise Monitor: Installing Agent on Windows: Query Analyzer
Configuration</a></dt><dt>15.17. <a href="mem-introduction.html#fig-agent-install-win6">MySQL Enterprise Monitor: Installing Agent on Windows: MySQL Enterprise Service Manager
Options</a></dt><dt>15.18. <a href="mem-introduction.html#fig-agent-install-osx1">MySQL Enterprise Monitor: Installing Agent on Mac OS X: Language
Selection</a></dt><dt>15.19. <a href="mem-introduction.html#fig-agent-install-osx3">MySQL Enterprise Monitor: Installing Agent on Mac OS X: Installation
Directory</a></dt><dt>15.20. <a href="mem-introduction.html#fig-agent-install-osx4">MySQL Enterprise Monitor: Installing Agent on Mac OS X: Monitored
Database Information</a></dt><dt>15.21. <a href="mem-introduction.html#fig-agent-install-osx5">MySQL Enterprise Monitor: Installing Agent on Mac OS X: Monitored
Database Information</a></dt><dt>15.22. <a href="mem-introduction.html#fig-agent-install-osx6">MySQL Enterprise Monitor: Installing Agent on Mac OS X: Query Analyzer
Configuration</a></dt><dt>15.23. <a href="mem-introduction.html#fig-agent-install-osx7">MySQL Enterprise Monitor: Installing Agent on Mac OS X: MySQL Enterprise Service Manager
Options</a></dt><dt>15.24. <a href="mem-introduction.html#fig-monitor-update-install-1">MySQL Enterprise Monitor: Server Update: Language Selection</a></dt><dt>15.25. <a href="mem-introduction.html#fig-monitor-update-install-3">MySQL Enterprise Monitor: Server Update: Previous Installation</a></dt><dt>15.26. <a href="mem-introduction.html#fig-monitor-update-install-4">MySQL Enterprise Monitor: Server Update: Backup of Previous Installation</a></dt><dt>15.27. <a href="mem-introduction.html#fig-monitor-update-install-7">MySQL Enterprise Monitor: Server Update: Completed installing files</a></dt><dt>15.28. <a href="mem-introduction.html#fig-monitor-update-install-9">MySQL Enterprise Monitor: Server Update: Final Setup</a></dt><dt>15.29. <a href="mem-introduction.html#mem-server-graphs">MySQL Enterprise Dashboard: The Graphs Screen</a></dt><dt>15.30. <a href="mem-introduction.html#fig-mem-heat-chart">MySQL Enterprise Dashboard: The Heat Chart</a></dt><dt>15.31. <a href="mem-introduction.html#fig-mem-heat-chart-legend">MySQL Enterprise Dashboard: The Heat Chart Legend</a></dt><dt>15.32. <a href="mem-introduction.html#id4596010">MySQL Enterprise Dashboard: Settings</a></dt><dt>15.33. <a href="mem-introduction.html#fig-mem-settings-user">MySQL Enterprise Dashboard: User Preferences</a></dt><dt>15.34. <a href="mem-introduction.html#fig-mem-settings-servers">MySQL Enterprise Dashboard: Manage Servers</a></dt><dt>15.35. <a href="mem-introduction.html#fig-mem-server-rename">MySQL Enterprise Dashboard: Server Renaming</a></dt><dt>15.36. <a href="mem-introduction.html#fig-mem-settings-users">MySQL Enterprise Dashboard: Manage Users</a></dt><dt>15.37. <a href="mem-introduction.html#fig-mem-settings-notification">MySQL Enterprise Dashboard: Manage Notification Groups</a></dt><dt>15.38. <a href="mem-introduction.html#fig-mem-settings-notification-group">MySQL Enterprise Dashboard: Edit Notification Groups</a></dt><dt>15.39. <a href="mem-introduction.html#fig-mem-settings-logs">MySQL Enterprise Dashboard: Logs</a></dt><dt>15.40. <a href="mem-introduction.html#fig-mem-usage-advisor-configuration">MySQL Enterprise Dashboard: Scheduling Dialog</a></dt><dt>15.41. <a href="mem-introduction.html#fig-mem-edit-advisor">MySQL Enterprise Dashboard: Editing Rules</a></dt><dt>15.42. <a href="mem-introduction.html#mem-events-screen">MySQL Enterprise Dashboard: Events Screen</a></dt><dt>15.43. <a href="mem-introduction.html#fig-mem-quan-main">MySQL Enterprise Dashboard: Query Analyzer</a></dt><dt>15.44. <a href="mem-introduction.html#fig-mem-quan-layout1">MySQL Enterprise Dashboard: Standard Agent/Monitor Topology</a></dt><dt>15.45. <a href="mem-introduction.html#fig-mem-quan-layout2">MySQL Enterprise Dashboard: Query Analyzer Agent/Monitor Topology</a></dt><dt>15.46. <a href="mem-introduction.html#fig-mem-quan-item-summary">MySQL Enterprise Dashboard: Canonical Query Tab for a Query</a></dt><dt>15.47. <a href="mem-introduction.html#fig-mem-quan-item-example">MySQL Enterprise Dashboard: Example Query Tab for a Query</a></dt><dt>15.48. <a href="mem-introduction.html#fig-mem-quan-item-explain">MySQL Enterprise Dashboard: Explain Query Tab for a Query</a></dt><dt>15.49. <a href="mem-introduction.html#fig-mem-quan-config">MySQL Enterprise Dashboard: Query Analyzer Configuration</a></dt><dt>15.50. <a href="mem-introduction.html#fig-mem-replication">MySQL Enterprise Dashboard: Replication Groups</a></dt><dt>15.51. <a href="mem-introduction.html#fig-monitor-migration-check">MySQL Enterprise Monitor: Historical Data Migration Availability</a></dt><dt>15.52. <a href="mem-introduction.html#fig-monitor-migration-confirm">MySQL Enterprise Monitor: Confirming Historical Data Migration</a></dt><dt>15.53. <a href="mem-introduction.html#monitor-migration-progress">MySQL Enterprise Monitor: Historical Data Migration Progress</a></dt><dt>16.1. <a href="replication.html#figure_replication-scaleout">Using Replication to Improve the Performance During Scaleout</a></dt><dt>16.2. <a href="replication.html#figure_replication-multi-db">Using Replication to Replicate Databases to Separate Replication Slaves</a></dt><dt>16.3. <a href="replication.html#figure_replication-performance">Using an Additional Replication Host to Improve Performance</a></dt><dt>16.4. <a href="replication.html#figure_replication-redundancy-before">Redundancy Using Replication, Initial Structure</a></dt><dt>16.5. <a href="replication.html#figure_replication-redundancy-after">Redundancy Using Replication, After Master Failure</a></dt><dt>21.1. <a href="connectors-apis.html#connector-net-visual-studio-add-connection">Add Connection Context Menu</a></dt><dt>21.2. <a href="connectors-apis.html#connector-net-visual-studio-choose-data-source">Choose Data Source</a></dt><dt>21.3. <a href="connectors-apis.html#connector-net-visual-studio-add-connection-dialog">Add Connection Dialog</a></dt><dt>21.4. <a href="connectors-apis.html#connector-net-visual-studio-new-data-connection">New Data Connection</a></dt><dt>21.5. <a href="connectors-apis.html#connector-net-visual-studio-editing-new-table">Editing New Table</a></dt><dt>21.6. <a href="connectors-apis.html#connector-net-visual-studio-choose-table-name">Choose Table Name</a></dt><dt>21.7. <a href="connectors-apis.html#connector-net-visual-studio-newly-created-table">Newly Created Table</a></dt><dt>21.8. <a href="connectors-apis.html#connector-net-visual-studio-table-desginer-menu-item">Table Designer Main Menu</a></dt><dt>21.9. <a href="connectors-apis.html#connector-net-visual-studio-indexes-dialog">Indexes Dialog</a></dt><dt>21.10. <a href="connectors-apis.html#connector-net-visual-studio-foreign-key-relationships">Foreign Key Relationships Dialog</a></dt><dt>21.11. <a href="connectors-apis.html#connector-net-visual-studio-table-properties-menu">Table Properties Menu Item</a></dt><dt>21.12. <a href="connectors-apis.html#connector-net-visual-studio-selecting-table-properties">Table Properties</a></dt><dt>21.13. <a href="connectors-apis.html#connector-net-visual-studio-views-edit-sql">Editing View SQL</a></dt><dt>21.14. <a href="connectors-apis.html#connector-net-visual-studio-views-sql-added">View SQL Added</a></dt><dt>21.15. <a href="connectors-apis.html#connector-net-visual-studio-views-sql-saved">View SQL Saved</a></dt><dt>21.16. <a href="connectors-apis.html#connector-net-visual-studio-stored-procedure-edit">Edit Stored Procedure SQL</a></dt><dt>21.17. <a href="connectors-apis.html#connector-net-visual-studio-stored-procedure-saved">Stored Procedure SQL Saved</a></dt><dt>21.18. <a href="connectors-apis.html#connector-net-website-config-tool">MySQL Website Configuration Tool</a></dt><dt>21.19. <a href="connectors-apis.html#connector-net-website-config-tool-membership">MySQL Website Configuration Tool - Membership</a></dt><dt>21.20. <a href="connectors-apis.html#connector-net-website-config-tool-string-editor">MySQL Website Configuration Tool - Connection String Editor</a></dt><dt>21.21. <a href="connectors-apis.html#connector-net-website-config-tool-options">MySQL Website Configuration Tool - Advanced Options</a></dt><dt>21.22. <a href="connectors-apis.html#connector-net-website-config-tool-roles">MySQL Website Configuration Tool - Roles</a></dt><dt>21.23. <a href="connectors-apis.html#connector-net-website-config-tool-profiles">MySQL Website Configuration Tool - Profiles</a></dt><dt>21.24. <a href="connectors-apis.html#connector-net-website-config-tool-session-state">MySQL Website Configuration Tool - Session State</a></dt><dt>21.25. <a href="connectors-apis.html#connector-net-website-config-tool-tables">MySQL Website Configuration Tool - Tables</a></dt><dt>21.26. <a href="connectors-apis.html#connector-net-tutorials-1">World Database Application</a></dt><dt>21.27. <a href="connectors-apis.html#connector-net-tutorials-authentication-type">Authentication Type</a></dt><dt>21.28. <a href="connectors-apis.html#connector-net-tutorials-select-provider">Select Membership and Role Provider</a></dt><dt>21.29. <a href="connectors-apis.html#connector-net-tutorials-tables">Membership and Role Provider Tables</a></dt><dt>21.30. <a href="connectors-apis.html#connector-net-tutorials-security-tab">Security Tab</a></dt><dt>21.31. <a href="connectors-apis.html#connector-net-tutorials-create-user">Create User</a></dt><dt>21.32. <a href="connectors-apis.html#connector-net-tutorials-users-roles-tables">Membership and Roles Table Contents</a></dt><dt>21.33. <a href="connectors-apis.html#connector-net-tutorials-asp-provider-profile-simple-app">Simple Profile Application</a></dt><dt>21.34. <a href="connectors-apis.html#connector-net-visual-studio-entity-framework-add-entity-data-model">Add Entity Data Model</a></dt><dt>21.35. <a href="connectors-apis.html#connector-net-visual-studio-entity-framework-entity-data-model-wizard-1">Entity Data Model Wizard Screen 1</a></dt><dt>21.36. <a href="connectors-apis.html#connector-net-visual-studio-entity-framework-entity-data-model-wizard-2">Entity Data Model Wizard Screen 2</a></dt><dt>21.37. <a href="connectors-apis.html#connector-net-visual-studio-entity-framework-entity-data-model-wizard-3">Entity Data Model Wizard Screen 3</a></dt><dt>21.38. <a href="connectors-apis.html#connector-net-visual-studio-entity-framework-entity-data-model-diagram">Entity Data Model Diagram</a></dt><dt>21.39. <a href="connectors-apis.html#connector-net-visual-studio-entity-framework-data-source-configuration-wizard-1">Entity Data Source Configuration Wizard Screen 1</a></dt><dt>21.40. <a href="connectors-apis.html#connector-net-visual-studio-entity-framework-data-source-configuration-wizard-2">Entity Data Source Configuration Wizard Screen 2</a></dt><dt>21.41. <a href="connectors-apis.html#connector-net-visual-studio-entity-framework-data-source-configuration-wizard-3">Entity Data Source Configuration Wizard Screen 3</a></dt><dt>21.42. <a href="connectors-apis.html#connector-net-visual-studio-entity-framework-data-sources">Data Sources</a></dt><dt>21.43. <a href="connectors-apis.html#connector-net-visual-studio-entity-framework-data-form-design">Data Form Designer</a></dt><dt>21.44. <a href="connectors-apis.html#connector-net-visual-studio-entity-framework-form-add-code">Adding Code to the Form</a></dt><dt>21.45. <a href="connectors-apis.html#connector-net-visual-studio-entity-framework-app-running-1">The Populated Grid Control</a></dt><dt>21.46. <a href="connectors-apis.html#connector-net-visual-studio-entity-framework-save-enabled">Save Button Enabled</a></dt><dt>21.47. <a href="connectors-apis.html#connector-net-visual-studio-entity-framework-form-add-code-save">Adding Save Code to the Form</a></dt><dt>21.48. <a href="connectors-apis.html#connector-net-visual-studio-entity-framework-tutorial-linq-1">The Design Tab</a></dt><dt>21.49. <a href="connectors-apis.html#connector-net-visual-studio-entity-framework-tutorial-linq-2">Drop Down List</a></dt><dt>21.50. <a href="connectors-apis.html#connector-net-visual-studio-entity-framework-tutorial-linq-3">Enable AutoPostBack</a></dt><dt>21.51. <a href="connectors-apis.html#connector-net-visual-studio-entity-framework-tutorial-linq-4">Grid View Control</a></dt><dt>21.52. <a href="connectors-apis.html#connector-net-visual-studio-entity-framework-tutorial-linq-5">Placed Grid Vew Control</a></dt><dt>21.53. <a href="connectors-apis.html#connector-net-visual-studio-entity-framework-tutorial-linq-6">Source Code</a></dt><dt>21.54. <a href="connectors-apis.html#connector-net-visual-studio-entity-framework-tutorial-linq-7">The Working Web Site</a></dt><dt>21.55. <a href="connectors-apis.html#connector-cpp-installer-welcome-figure">Windows Installer Welcome Screen</a></dt><dt>21.56. <a href="connectors-apis.html#connector-cpp-installer-overview-figure">Windows Installer Overview Screen</a></dt><dt>21.57. <a href="connectors-apis.html#connector-cpp-installer-custom-figure">Windows Installer Custom Setup Screen</a></dt><dt>21.58. <a href="connectors-apis.html#connector-cpp-menu-new-project">Creating a New Project</a></dt><dt>21.59. <a href="connectors-apis.html#connector-cpp-new-project-wizard">The New Project Dialog Box</a></dt><dt>21.60. <a href="connectors-apis.html#connector-cpp-win32-application-wizard">The Win32 Application Wizard</a></dt><dt>21.61. <a href="connectors-apis.html#connector-cpp-select-release-build">Selecting the Release Build</a></dt><dt>21.62. <a href="connectors-apis.html#connector-cpp-menu-project-properties">Selecting Project Properties from the Main Menu</a></dt><dt>21.63. <a href="connectors-apis.html#connector-cpp-properties">Setting Properties</a></dt><dt>21.64. <a href="connectors-apis.html#connector-cpp-mysql-include-dir">MySQL Include Directory</a></dt><dt>21.65. <a href="connectors-apis.html#connector-cpp-mysql-include-select-directory-dialog">Select Directory Dialog</a></dt><dt>21.66. <a href="connectors-apis.html#connector-cpp-mysql-lib-opt-dir">Typical Contents of MySQL lib/opt Directory</a></dt><dt>21.67. <a href="connectors-apis.html#connector-cpp-additional-library-dir">Additional Library Directories</a></dt><dt>21.68. <a href="connectors-apis.html#connector-cpp-additional-lib-dir-select">Additional Library Directories Dialog</a></dt><dt>21.69. <a href="connectors-apis.html#connector-cpp-additional-dependencies"></a></dt><dt>21.70. <a href="connectors-apis.html#connector-cpp-additional-dependencies-added">Adding Additional Dependencies</a></dt><dt>21.71. <a href="connectors-apis.html#connector-cpp-cppconn-public-func">Setting the CPPCONN_PUBLIC_FUNC Define</a></dt><dt>21.72. <a href="connectors-apis.html#connector-cpp-netbeans">The NetBeans IDE</a></dt><dt>21.73. <a href="connectors-apis.html#connector-cpp-netbeans-static-properties-include">Setting the Header Include Directory</a></dt><dt>21.74. <a href="connectors-apis.html#connector-cpp-netbeans-static-properties-lib">Setting the Static Library Directories and File Names</a></dt><dt>21.75. <a href="connectors-apis.html#connector-cpp-netbeans-dynamic-properties-lib">Setting the Dynamic Library Directory and File Name</a></dt><dt>21.76. <a href="connectors-apis.html#connector-cpp-netbeans-static-run">The Example Application Running</a></dt><dt>21.77. <a href="connectors-apis.html#figure_connector-ooo-add-extension">Adding an Extension</a></dt><dt>21.78. <a href="connectors-apis.html#figure_connector-ooo-dbwizard1">Selecting the Database</a></dt><dt>21.79. <a href="connectors-apis.html#figure_connector-ooo-dbwizard2">Selecting the connection type</a></dt><dt>21.80. <a href="connectors-apis.html#figure_connector-ooo-dbwizard3">Entering Connection Settings</a></dt><dt>21.81. <a href="connectors-apis.html#figure_connector-ooo-dbwizard4">Setting Up User Authentication</a></dt><dt>21.82. <a href="connectors-apis.html#figure_connector-ooo-dbwizard5">After Connecting to the Database</a></dt><dt>21.83. <a href="connectors-apis.html#figure_connector-ooo-dbwizard6">Entering the Database File Name</a></dt><dt>21.84. <a href="connectors-apis.html#figure_connector-ooo-base">Listing Tables</a></dt><dt>A.1. <a href="faqs.html#id5072190">Active-Master MySQL Server</a></dt></dl></div><div class="list-of-tables"><p><b>List of Tables</b></p><dl><dt>2.1. <a href="installing.html#id4000490">Build (<code class="literal">configure</code>)
Reference</a></dt><dt>4.1. <a href="programs.html#id4048173"><code class="literal">mysqld_safe</code> Command-line
Options</a></dt><dt>4.2. <a href="programs.html#id4057115"><code class="literal">mysql</code> Options</a></dt><dt>4.3. <a href="programs.html#id4066989"><code class="literal">mysqladmin</code> Options</a></dt><dt>4.4. <a href="programs.html#id4069694"><code class="literal">mysqlcheck</code> Options</a></dt><dt>4.5. <a href="programs.html#id4073146"><code class="literal">mysqldump</code> Options</a></dt><dt>4.6. <a href="programs.html#id4080815"><code class="literal">mysqlimport</code> Options</a></dt><dt>4.7. <a href="programs.html#id4083689"><code class="literal">mysqlshow</code> Options</a></dt><dt>4.8. <a href="programs.html#id4085586"><code class="literal">mysqlslap</code> Options</a></dt><dt>4.9. <a href="programs.html#id4090587"><code class="literal">myisamchk</code> Options</a></dt><dt>4.10. <a href="programs.html#id4098987"><code class="literal">mysqlaccess</code> Options</a></dt><dt>4.11. <a href="programs.html#id4100739"><code class="literal">mysqlbinlog</code> Options</a></dt><dt>4.12. <a href="programs.html#id4105663"><code class="literal">mysqldumpslow</code> Options</a></dt><dt>4.13. <a href="programs.html#id4106577"><code class="literal">mysqlhotcopy</code> Options</a></dt><dt>5.1. <a href="server-administration.html#id4117398">Option/Variable Summary</a></dt><dt>5.2. <a href="server-administration.html#id4156348">System Variable Summary</a></dt><dt>5.3. <a href="server-administration.html#id4206568">Session System Variable Summary</a></dt><dt>5.4. <a href="server-administration.html#id4210370">Dynamic Variable Summary</a></dt><dt>5.5. <a href="server-administration.html#id4214698">Status Variable Summary</a></dt><dt>5.6. <a href="server-administration.html#id4235889">Security Option/Variable Summary</a></dt><dt>5.7. <a href="server-administration.html#id4253165">SSL Option/Variable Summary</a></dt><dt>11.1. <a href="functions.html#id4344225">Operators/Functions</a></dt><dt>11.2. <a href="functions.html#id4347569">Operators</a></dt><dt>11.3. <a href="functions.html#id4348672">Comparison Operators</a></dt><dt>11.4. <a href="functions.html#id4351864">Logical Operators</a></dt><dt>11.5. <a href="functions.html#id4352708">Flow Control Operators</a></dt><dt>11.6. <a href="functions.html#id4353760">String Operators</a></dt><dt>11.7. <a href="functions.html#id4360082">String Comparison Operators</a></dt><dt>11.8. <a href="functions.html#id4361181">String Regular Expression Operators</a></dt><dt>11.9. <a href="functions.html#id4364508">Numeric Functions</a></dt><dt>11.10. <a href="functions.html#id4365042">Arithmetic Functions</a></dt><dt>11.11. <a href="functions.html#id4366027">Mathematical Functions</a></dt><dt>11.12. <a href="functions.html#id4370280">Date/Time Functions</a></dt><dt>11.13. <a href="functions.html#id4386242">Cast Functions</a></dt><dt>11.14. <a href="functions.html#id4387300">XML Functions</a></dt><dt>11.15. <a href="functions.html#id4390027">Other Functions</a></dt><dt>11.16. <a href="functions.html#id4390761">Bitwise Functions</a></dt><dt>11.17. <a href="functions.html#id4391500">Encryption Functions</a></dt><dt>11.18. <a href="functions.html#id4393691">Information Functions</a></dt><dt>11.19. <a href="functions.html#id4396846">Miscellaneous Functions</a></dt><dt>11.20. <a href="functions.html#id4398810">Aggregate (<code class="literal">GROUP BY</code>)
Functions</a></dt><dt>13.1. <a href="storage-engines.html#id4500507">Storage Engine Features</a></dt><dt>13.2. <a href="storage-engines.html#id4501898"><code class="literal">MyISAM</code> Storage Engine
Features</a></dt><dt>13.3. <a href="storage-engines.html#id4502856">MyISAM Option/Variable Reference</a></dt><dt>13.4. <a href="storage-engines.html#id4505337"><code class="literal">InnoDB</code> Storage Engine
Features</a></dt><dt>13.5. <a href="storage-engines.html#id4508629"><code class="literal">InnoDB</code> Option/Variable
Reference</a></dt><dt>13.6. <a href="storage-engines.html#id4537893"><code class="literal">IBMDB2I</code> Storage Engine
Features</a></dt><dt>13.7. <a href="storage-engines.html#id4541374">Naming Behavior in DB2 Storage Engine</a></dt><dt>13.8. <a href="storage-engines.html#id4541736"><code class="literal">IBMDB2I</code> Isolation Levels</a></dt><dt>13.9. <a href="storage-engines.html#id4542325">Data Type Restrictions in <code class="literal">IBMDB2I</code></a></dt><dt>13.10. <a href="storage-engines.html#id4542685">Collation Compatibility in <code class="literal">IBMDB2I</code> and MySQL</a></dt><dt>13.11. <a href="storage-engines.html#id4544693">Error Codes from <code class="literal">IBMDB2I</code></a></dt><dt>13.12. <a href="storage-engines.html#id4545707">Error Codes and Messages in <code class="literal">IBMDB2I</code></a></dt><dt>13.13. <a href="storage-engines.html#id4548458"><code class="literal">MEMORY</code> Storage Engine
Features</a></dt><dt>13.14. <a href="storage-engines.html#id4551595"><code class="literal">ARCHIVE</code> Storage Engine
Features</a></dt><dt>14.1. <a href="ha-overview.html#id4570960"><span>memcached</span> Command Reference</a></dt><dt>14.2. <a href="ha-overview.html#ha-memcached-interfaces-protocol-responses"><span>memcached</span> Protocol Responses</a></dt><dt>15.1. <a href="mem-introduction.html#id4600071">MySQL Enterprise Monitor: Wiki Formatting</a></dt><dt>16.1. <a href="replication.html#id4626230">Replication Option/Variable Summary</a></dt><dt>16.2. <a href="replication.html#id4627977">Binary Logging Option/Variable Summary</a></dt><dt>17.1. <a href="mysql-cluster.html#id4695374">Data Node Configuration Parameters</a></dt><dt>17.2. <a href="mysql-cluster.html#id4697311">Management Node Configuration Parameters</a></dt><dt>17.3. <a href="mysql-cluster.html#id4697650">API Node Configuration Parameters</a></dt><dt>17.4. <a href="mysql-cluster.html#id4698022">COMPUTER Configuration Parameters</a></dt><dt>17.5. <a href="mysql-cluster.html#id4698110">TCP Configuration Parameters</a></dt><dt>17.6. <a href="mysql-cluster.html#id4698369">SHM Configuration Parameters</a></dt><dt>17.7. <a href="mysql-cluster.html#id4698575">SCI Configuration Parameters</a></dt><dt>17.8. <a href="mysql-cluster.html#id4698900">Command Options for MySQL Cluster</a></dt><dt>17.9. <a href="mysql-cluster.html#id4706453"><span>ndbd</span> Command Line
Options</a></dt><dt>17.10. <a href="mysql-cluster.html#id4709335"><span>ndb_mgmd</span> Command Line
Options</a></dt><dt>17.11. <a href="mysql-cluster.html#id4711285"><span>ndb_mgm</span> Command Line
Options</a></dt><dt>17.12. <a href="mysql-cluster.html#id4711533"><span>ndb_config</span> Command Line
Options</a></dt><dt>17.13. <a href="mysql-cluster.html#id4715369"><span>ndbd_redo_log_reader</span> Command
Line Options</a></dt><dt>17.14. <a href="mysql-cluster.html#id4715907"><span>ndb_restore</span> Command Line
Options</a></dt><dt>17.15. <a href="mysql-cluster.html#id4719812"><span>ndb_show_tables</span> Command Line
Options</a></dt><dt>17.16. <a href="mysql-cluster.html#id4720504"><span>ndb_size.pl</span> Command Line
Options</a></dt><dt>17.17. <a href="mysql-cluster.html#id4721668">Common MySQL Cluster Command Line Options</a></dt><dt>21.1. <a href="connectors-apis.html#connectors-apis-summary">MySQL APIs and Interfaces</a></dt><dt>21.2. <a href="connectors-apis.html#connectors-apis-versions">MySQL Connector Versions and MySQL Server Versions</a></dt><dt>21.3. <a href="connectors-apis.html#id4927861">Mapping of MySQL Error Numbers to SQLStates</a></dt><dt>21.4. <a href="connectors-apis.html#id4980237">MySQL Configuration Options</a></dt><dt>21.5. <a href="connectors-apis.html#apis-php-mysql.client-flags">MySQL client constants</a></dt><dt>21.6. <a href="connectors-apis.html#id4980995">MySQL fetch constants</a></dt><dt>21.7. <a href="connectors-apis.html#id4999462">MySQLi Configuration Options</a></dt><dt>21.8. <a href="connectors-apis.html#id5014206">Possible mysqli_info return values</a></dt><dt>21.9. <a href="connectors-apis.html#id5016499">Valid options</a></dt><dt>21.10. <a href="connectors-apis.html#id5019064">Supported flags</a></dt><dt>21.11. <a href="connectors-apis.html#id5026071">Attribute values</a></dt><dt>21.12. <a href="connectors-apis.html#id5026556">Type specification chars</a></dt><dt>21.13. <a href="connectors-apis.html#id5028922">Return Values</a></dt><dt>21.14. <a href="connectors-apis.html#id5034787">Object attributes</a></dt><dt>21.15. <a href="connectors-apis.html#id5035231">Object properties</a></dt><dt>21.16. <a href="connectors-apis.html#id5035691">Object properties</a></dt><dt>21.17. <a href="connectors-apis.html#id5040436">Supported flags</a></dt></dl></div><div class="list-of-examples"><p><b>List of Examples</b></p><dl><dt>21.1. <a href="connectors-apis.html#connector-j-examples-connection-drivermanager">Connector/J: Obtaining a connection from the
<code class="literal">DriverManager</code></a></dt><dt>21.2. <a href="connectors-apis.html#connector-j-examples-execute-select">Connector/J: Using java.sql.Statement to execute a
<code class="literal">SELECT</code> query</a></dt><dt>21.3. <a href="connectors-apis.html#connector-j-examples-stored-procedure">Connector/J: Calling Stored Procedures</a></dt><dt>21.4. <a href="connectors-apis.html#connector-j-examples-preparecall">Connector/J: Using <code class="literal">Connection.prepareCall()</code></a></dt><dt>21.5. <a href="connectors-apis.html#connector-j-examples-output-param">Connector/J: Registering output parameters</a></dt><dt>21.6. <a href="connectors-apis.html#connector-j-examples-callablestatement">Connector/J: Setting <code class="literal">CallableStatement</code> input
parameters</a></dt><dt>21.7. <a href="connectors-apis.html#connector-j-examples-retrieving-results-params">Connector/J: Retrieving results and output parameter values</a></dt><dt>21.8. <a href="connectors-apis.html#connector-j-examples-autoincrement-getgeneratedkeys">Connector/J: Retrieving <code class="literal">AUTO_INCREMENT</code> column values
using <code class="literal">Statement.getGeneratedKeys()</code></a></dt><dt>21.9. <a href="connectors-apis.html#connector-j-examples-autoincrement-select">Connector/J: Retrieving <code class="literal">AUTO_INCREMENT</code> column values
using <code class="literal">SELECT LAST_INSERT_ID()</code></a></dt><dt>21.10. <a href="connectors-apis.html#connector-j-examples-autoincrement-updateable-resultsets">Connector/J: Retrieving <code class="literal">AUTO_INCREMENT</code> column values
in <code class="literal">Updatable ResultSets</code></a></dt><dt>21.11. <a href="connectors-apis.html#connector-j-examples-connectionpool-j2ee">Connector/J: Using a connection pool with a J2EE application server</a></dt><dt>21.12. <a href="connectors-apis.html#connector-j-examples-transaction-retry">Connector/J: Example of transaction with retry logic</a></dt><dt>21.13. <a href="connectors-apis.html#id4981099">MySQL extension overview example</a></dt><dt>21.14. <a href="connectors-apis.html#id4981366"><code class="function">mysql_affected_rows</code>
example</a></dt><dt>21.15. <a href="connectors-apis.html#id4981405"><code class="function">mysql_affected_rows</code>
example using transactions</a></dt><dt>21.16. <a href="connectors-apis.html#id4982054"><code class="function">mysql_client_encoding</code>
example</a></dt><dt>21.17. <a href="connectors-apis.html#id4982336"><code class="function">mysql_close</code>
example</a></dt><dt>21.18. <a href="connectors-apis.html#id4982946"><code class="function">mysql_connect</code>
example</a></dt><dt>21.19. <a href="connectors-apis.html#id4982972"><code class="function">mysql_connect</code>
example using <code class="literal">hostname:port</code> syntax</a></dt><dt>21.20. <a href="connectors-apis.html#id4983010"><code class="function">mysql_connect</code>
example using ":/path/to/socket" syntax</a></dt><dt>21.21. <a href="connectors-apis.html#id4983374"><code class="function">mysql_create_db</code>
alternative example</a></dt><dt>21.22. <a href="connectors-apis.html#id4983778"><code class="function">mysql_data_seek</code>
example</a></dt><dt>21.23. <a href="connectors-apis.html#id4984186"><code class="function">mysql_db_name</code>
example</a></dt><dt>21.24. <a href="connectors-apis.html#id4984653"><code class="function">mysql_db_query</code>
alternative example</a></dt><dt>21.25. <a href="connectors-apis.html#id4984996"><code class="function">mysql_drop_db</code>
alternative example</a></dt><dt>21.26. <a href="connectors-apis.html#id4985285"><code class="function">mysql_errno</code>
example</a></dt><dt>21.27. <a href="connectors-apis.html#id4985560"><code class="function">mysql_error</code>
example</a></dt><dt>21.28. <a href="connectors-apis.html#id4985912"><code class="function">mysql_escape_string</code>
example</a></dt><dt>21.29. <a href="connectors-apis.html#id4986278">Query with aliased duplicate field names</a></dt><dt>21.30. <a href="connectors-apis.html#id4986294"><code class="function">mysql_fetch_array</code>
with
<code class="constant">MYSQL_NUM</code></a></dt><dt>21.31. <a href="connectors-apis.html#id4986326"><code class="function">mysql_fetch_array</code>
with
<code class="constant">MYSQL_ASSOC</code></a></dt><dt>21.32. <a href="connectors-apis.html#id4986358"><code class="function">mysql_fetch_array</code>
with
<code class="constant">MYSQL_BOTH</code></a></dt><dt>21.33. <a href="connectors-apis.html#id4986715">An expanded
<code class="function">mysql_fetch_assoc</code>
example</a></dt><dt>21.34. <a href="connectors-apis.html#id4987199"><code class="function">mysql_fetch_field</code>
example</a></dt><dt>21.35. <a href="connectors-apis.html#id4987490">A
<code class="function">mysql_fetch_lengths</code>
example</a></dt><dt>21.36. <a href="connectors-apis.html#id4987889"><code class="function">mysql_fetch_object</code>
example</a></dt><dt>21.37. <a href="connectors-apis.html#id4987916"><code class="function">mysql_fetch_object</code>
example</a></dt><dt>21.38. <a href="connectors-apis.html#id4988273">Fetching one row with
<code class="function">mysql_fetch_row</code></a></dt><dt>21.39. <a href="connectors-apis.html#id4988702">A
<code class="function">mysql_field_flags</code>
example</a></dt><dt>21.40. <a href="connectors-apis.html#id4989023"><code class="function">mysql_field_len</code>
example</a></dt><dt>21.41. <a href="connectors-apis.html#id4989329"><code class="function">mysql_field_name</code>
example</a></dt><dt>21.42. <a href="connectors-apis.html#id4989900">A
<code class="function">mysql_field_table</code>
example</a></dt><dt>21.43. <a href="connectors-apis.html#id4990236"><code class="function">mysql_field_type</code>
example</a></dt><dt>21.44. <a href="connectors-apis.html#id4990549">A
<code class="function">mysql_free_result</code>
example</a></dt><dt>21.45. <a href="connectors-apis.html#id4990735"><code class="function">mysql_get_client_info</code>
example</a></dt><dt>21.46. <a href="connectors-apis.html#id4990986"><code class="function">mysql_get_host_info</code>
example</a></dt><dt>21.47. <a href="connectors-apis.html#id4991239"><code class="function">mysql_get_proto_info</code>
example</a></dt><dt>21.48. <a href="connectors-apis.html#id4991491"><code class="function">mysql_get_server_info</code>
example</a></dt><dt>21.49. <a href="connectors-apis.html#id4991757">Relevant MySQL Statements</a></dt><dt>21.50. <a href="connectors-apis.html#id4992033"><code class="function">mysql_insert_id</code>
example</a></dt><dt>21.51. <a href="connectors-apis.html#id4992380"><code class="function">mysql_list_dbs</code>
example</a></dt><dt>21.52. <a href="connectors-apis.html#id4992778">Alternate to deprecated
<code class="function">mysql_list_fields</code></a></dt><dt>21.53. <a href="connectors-apis.html#id4993047"><code class="function">mysql_list_processes</code>
example</a></dt><dt>21.54. <a href="connectors-apis.html#id4993427"><code class="function">mysql_list_tables</code>
alternative example</a></dt><dt>21.55. <a href="connectors-apis.html#id4993676">A
<code class="function">mysql_num_fields</code>
example</a></dt><dt>21.56. <a href="connectors-apis.html#id4993953"><code class="function">mysql_num_rows</code>
example</a></dt><dt>21.57. <a href="connectors-apis.html#id4994764">A
<code class="function">mysql_ping</code>
example</a></dt><dt>21.58. <a href="connectors-apis.html#id4995154">Invalid Query</a></dt><dt>21.59. <a href="connectors-apis.html#id4995189">Valid Query</a></dt><dt>21.60. <a href="connectors-apis.html#id4995602">Simple
<code class="function">mysql_real_escape_string</code>
example</a></dt><dt>21.61. <a href="connectors-apis.html#id4995632">An example SQL Injection Attack</a></dt><dt>21.62. <a href="connectors-apis.html#id4996104"><code class="function">mysql_result</code>
example</a></dt><dt>21.63. <a href="connectors-apis.html#id4996435"><code class="function">mysql_select_db</code>
example</a></dt><dt>21.64. <a href="connectors-apis.html#id4996993"><code class="function">mysql_stat</code>
example</a></dt><dt>21.65. <a href="connectors-apis.html#id4997031">Alternative
<code class="function">mysql_stat</code>
example</a></dt><dt>21.66. <a href="connectors-apis.html#id4997346"><code class="function">mysql_tablename</code>
example</a></dt><dt>21.67. <a href="connectors-apis.html#id4997624"><code class="function">mysql_thread_id</code>
example</a></dt><dt>21.68. <a href="connectors-apis.html#id5006415">Object oriented style</a></dt><dt>21.69. <a href="connectors-apis.html#id5006436">Procedural style</a></dt><dt>21.70. <a href="connectors-apis.html#id5006789">Object oriented style</a></dt><dt>21.71. <a href="connectors-apis.html#id5006804">Procedural style</a></dt><dt>21.72. <a href="connectors-apis.html#id5007269">Object oriented style</a></dt><dt>21.73. <a href="connectors-apis.html#id5007291">Procedural style</a></dt><dt>21.74. <a href="connectors-apis.html#id5007551">Object oriented style</a></dt><dt>21.75. <a href="connectors-apis.html#id5007568">Procedural style</a></dt><dt>21.76. <a href="connectors-apis.html#id5007775">mysqli_get_client_info</a></dt><dt>21.77. <a href="connectors-apis.html#id5007988">mysqli_get_client_version</a></dt><dt>21.78. <a href="connectors-apis.html#id5008496">Object oriented style</a></dt><dt>21.79. <a href="connectors-apis.html#id5008517">Procedural style</a></dt><dt>21.80. <a href="connectors-apis.html#id5008748">Object oriented style</a></dt><dt>21.81. <a href="connectors-apis.html#id5008762">Procedural style</a></dt><dt>21.82. <a href="connectors-apis.html#id5008988">Object oriented style</a></dt><dt>21.83. <a href="connectors-apis.html#id5009003">Procedural style</a></dt><dt>21.84. <a href="connectors-apis.html#id5009688">Object oriented style</a></dt><dt>21.85. <a href="connectors-apis.html#id5009712">Object oriented style when extending mysqli class</a></dt><dt>21.86. <a href="connectors-apis.html#id5009732">Procedural style</a></dt><dt>21.87. <a href="connectors-apis.html#id5010122">Generating a Trace File</a></dt><dt>21.88. <a href="connectors-apis.html#id5010605">Object oriented style</a></dt><dt>21.89. <a href="connectors-apis.html#id5010621">Procedural style</a></dt><dt>21.90. <a href="connectors-apis.html#id5010899">Object oriented style</a></dt><dt>21.91. <a href="connectors-apis.html#id5010915">Procedural style</a></dt><dt>21.92. <a href="connectors-apis.html#id5011210">Object oriented style</a></dt><dt>21.93. <a href="connectors-apis.html#id5011232">Procedural style</a></dt><dt>21.94. <a href="connectors-apis.html#id5011404">A <code class="function">mysqli_get_cache_stats</code> example</a></dt><dt>21.95. <a href="connectors-apis.html#id5011816">Object oriented style</a></dt><dt>21.96. <a href="connectors-apis.html#id5011830">Procedural style</a></dt><dt>21.97. <a href="connectors-apis.html#id5012026">mysqli_get_client_info</a></dt><dt>21.98. <a href="connectors-apis.html#id5012233">A <code class="function">mysqli_get_client_stats</code> example</a></dt><dt>21.99. <a href="connectors-apis.html#id5012482">mysqli_get_client_version</a></dt><dt>21.100. <a href="connectors-apis.html#id5012743">A <code class="function">mysqli_get_connection_stats</code> example</a></dt><dt>21.101. <a href="connectors-apis.html#id5013039">Object oriented style</a></dt><dt>21.102. <a href="connectors-apis.html#id5013056">Procedural style</a></dt><dt>21.103. <a href="connectors-apis.html#id5013311">Object oriented style</a></dt><dt>21.104. <a href="connectors-apis.html#id5013328">Procedural style</a></dt><dt>21.105. <a href="connectors-apis.html#id5013577">Object oriented style</a></dt><dt>21.106. <a href="connectors-apis.html#id5013593">Procedural style</a></dt><dt>21.107. <a href="connectors-apis.html#id5013881">Object oriented style</a></dt><dt>21.108. <a href="connectors-apis.html#id5013897">Procedural style</a></dt><dt>21.109. <a href="connectors-apis.html#id5014388">Object oriented style</a></dt><dt>21.110. <a href="connectors-apis.html#id5014408">Procedural style</a></dt><dt>21.111. <a href="connectors-apis.html#id5014948">Object oriented style</a></dt><dt>21.112. <a href="connectors-apis.html#id5014968">Procedural style</a></dt><dt>21.113. <a href="connectors-apis.html#id5015244">Object oriented style</a></dt><dt>21.114. <a href="connectors-apis.html#id5015261">Procedural style</a></dt><dt>21.115. <a href="connectors-apis.html#id5015853">Object oriented style</a></dt><dt>21.116. <a href="connectors-apis.html#id5015878">Procedural style</a></dt><dt>21.117. <a href="connectors-apis.html#id5016919">Object oriented style</a></dt><dt>21.118. <a href="connectors-apis.html#id5016935">Procedural style</a></dt><dt>21.119. <a href="connectors-apis.html#id5017355">A
<code class="function">mysqli_poll</code>
example</a></dt><dt>21.120. <a href="connectors-apis.html#id5017768">Object oriented style</a></dt><dt>21.121. <a href="connectors-apis.html#id5017791">Procedural style</a></dt><dt>21.122. <a href="connectors-apis.html#id5018340">Object oriented style</a></dt><dt>21.123. <a href="connectors-apis.html#id5018363">Procedural style</a></dt><dt>21.124. <a href="connectors-apis.html#id5019222">Object oriented style</a></dt><dt>21.125. <a href="connectors-apis.html#id5019240">Object oriented style when extending mysqli class</a></dt><dt>21.126. <a href="connectors-apis.html#id5019264">Procedural style</a></dt><dt>21.127. <a href="connectors-apis.html#id5019639">Object oriented style</a></dt><dt>21.128. <a href="connectors-apis.html#id5019660">Procedural style</a></dt><dt>21.129. <a href="connectors-apis.html#id5020447">Object oriented style</a></dt><dt>21.130. <a href="connectors-apis.html#id5020477">Procedural style</a></dt><dt>21.131. <a href="connectors-apis.html#id5020816">Object oriented style</a></dt><dt>21.132. <a href="connectors-apis.html#id5020838">Procedural style</a></dt><dt>21.133. <a href="connectors-apis.html#id5021189">Object oriented style</a></dt><dt>21.134. <a href="connectors-apis.html#id5021205">Procedural style</a></dt><dt>21.135. <a href="connectors-apis.html#id5021879">Object oriented style</a></dt><dt>21.136. <a href="connectors-apis.html#id5021900">Procedural style</a></dt><dt>21.137. <a href="connectors-apis.html#id5022190">Object oriented style</a></dt><dt>21.138. <a href="connectors-apis.html#id5022207">Procedural style</a></dt><dt>21.139. <a href="connectors-apis.html#id5022970">Object oriented style</a></dt><dt>21.140. <a href="connectors-apis.html#id5022987">Procedural style</a></dt><dt>21.141. <a href="connectors-apis.html#id5023856">Object oriented style</a></dt><dt>21.142. <a href="connectors-apis.html#id5023873">Procedural style</a></dt><dt>21.143. <a href="connectors-apis.html#id5024226">Object oriented style</a></dt><dt>21.144. <a href="connectors-apis.html#id5024251">Procedural style</a></dt><dt>21.145. <a href="connectors-apis.html#id5024529">Object oriented style</a></dt><dt>21.146. <a href="connectors-apis.html#id5024549">Procedural style</a></dt><dt>21.147. <a href="connectors-apis.html#id5025535">Object oriented style</a></dt><dt>21.148. <a href="connectors-apis.html#id5025557">Procedural style</a></dt><dt>21.149. <a href="connectors-apis.html#id5026694">Object oriented style</a></dt><dt>21.150. <a href="connectors-apis.html#id5026716">Procedural style</a></dt><dt>21.151. <a href="connectors-apis.html#id5027138">Object oriented style</a></dt><dt>21.152. <a href="connectors-apis.html#id5027159">Procedural style</a></dt><dt>21.153. <a href="connectors-apis.html#id5027724">Object oriented style</a></dt><dt>21.154. <a href="connectors-apis.html#id5027748">Procedural style</a></dt><dt>21.155. <a href="connectors-apis.html#id5028019">Object oriented style</a></dt><dt>21.156. <a href="connectors-apis.html#id5028039">Procedural style</a></dt><dt>21.157. <a href="connectors-apis.html#id5028291">Object oriented style</a></dt><dt>21.158. <a href="connectors-apis.html#id5028311">Procedural style</a></dt><dt>21.159. <a href="connectors-apis.html#id5028626">Object oriented style</a></dt><dt>21.160. <a href="connectors-apis.html#id5028648">Procedural style</a></dt><dt>21.161. <a href="connectors-apis.html#id5029001">Object oriented style</a></dt><dt>21.162. <a href="connectors-apis.html#id5029024">Procedural style</a></dt><dt>21.163. <a href="connectors-apis.html#id5029873">Object oriented style</a></dt><dt>21.164. <a href="connectors-apis.html#id5029890">Procedural style</a></dt><dt>21.165. <a href="connectors-apis.html#id5030150">Object oriented style</a></dt><dt>21.166. <a href="connectors-apis.html#id5030170">Procedural style</a></dt><dt>21.167. <a href="connectors-apis.html#id5030525">Object oriented style</a></dt><dt>21.168. <a href="connectors-apis.html#id5030548">Procedural style</a></dt><dt>21.169. <a href="connectors-apis.html#id5031191">Object oriented style</a></dt><dt>21.170. <a href="connectors-apis.html#id5031212">Procedural style</a></dt><dt>21.171. <a href="connectors-apis.html#id5031562">Object oriented style</a></dt><dt>21.172. <a href="connectors-apis.html#id5031842">Object oriented style</a></dt><dt>21.173. <a href="connectors-apis.html#id5031862">Procedural style</a></dt><dt>21.174. <a href="connectors-apis.html#id5032153">Object oriented style</a></dt><dt>21.175. <a href="connectors-apis.html#id5032170">Procedural style</a></dt><dt>21.176. <a href="connectors-apis.html#id5032875">Object oriented style</a></dt><dt>21.177. <a href="connectors-apis.html#id5032898">Procedural style</a></dt><dt>21.178. <a href="connectors-apis.html#id5033261">Object oriented style</a></dt><dt>21.179. <a href="connectors-apis.html#id5033279">Procedural style</a></dt><dt>21.180. <a href="connectors-apis.html#id5034071">Object oriented style</a></dt><dt>21.181. <a href="connectors-apis.html#id5034095">Procedural style</a></dt><dt>21.182. <a href="connectors-apis.html#id5034423">Object oriented style</a></dt><dt>21.183. <a href="connectors-apis.html#id5034440">Procedural style</a></dt><dt>21.184. <a href="connectors-apis.html#id5034948">Object oriented style</a></dt><dt>21.185. <a href="connectors-apis.html#id5034971">Procedural style</a></dt><dt>21.186. <a href="connectors-apis.html#id5035392">Object oriented style</a></dt><dt>21.187. <a href="connectors-apis.html#id5035415">Procedural style</a></dt><dt>21.188. <a href="connectors-apis.html#id5035851">Object oriented style</a></dt><dt>21.189. <a href="connectors-apis.html#id5035875">Procedural style</a></dt><dt>21.190. <a href="connectors-apis.html#id5036339">Object oriented style</a></dt><dt>21.191. <a href="connectors-apis.html#id5036356">Procedural style</a></dt><dt>21.192. <a href="connectors-apis.html#id5036663">Object oriented style</a></dt><dt>21.193. <a href="connectors-apis.html#id5036681">Procedural style</a></dt><dt>21.194. <a href="connectors-apis.html#id5036970">Object oriented style</a></dt><dt>21.195. <a href="connectors-apis.html#id5036992">Procedural style</a></dt><dt>21.196. <a href="connectors-apis.html#id5037320">Object oriented style</a></dt><dt>21.197. <a href="connectors-apis.html#id5037344">Procedural style</a></dt><dt>21.198. <a href="connectors-apis.html#id5037893">Object oriented style</a></dt><dt>21.199. <a href="connectors-apis.html#id5037910">Procedural style</a></dt><dt>21.200. <a href="connectors-apis.html#id5038164">Object oriented style</a></dt><dt>21.201. <a href="connectors-apis.html#id5038185">Procedural style</a></dt><dt>21.202. <a href="connectors-apis.html#id5040566">Object oriented style</a></dt><dt>21.203. <a href="connectors-apis.html#id5045523">Forcing queries to be buffered in mysql</a></dt><dt>21.204. <a href="connectors-apis.html#id5045860">PDO_MYSQL DSN examples</a></dt></dl></div></div><div class="navfooter"><hr><table width="100%" summary="Navigation footer"><tr><td width="40%" align="left"> </td><td width="20%" align="center"> </td><td width="40%" align="right"> <a accesskey="n" href="preface.html">Next</a></td></tr><tr><td width="40%" align="left" valign="top"> </td><td width="20%" align="center"> </td><td width="40%" align="right" valign="top"> Preface, Notes, Licenses</td></tr></table></div></body></html>
