<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"><title>Index</title><meta name="generator" content="DocBook XSL Stylesheets V1.69.1"><link rel="start" href="index.html" title="MySQL 5.0 Reference Manual"><link rel="up" href="index.html" title="MySQL 5.0 Reference Manual"><link rel="prev" href="mysql-floss-license-exception.html" title="Appendix K. MySQL FLOSS License Exception"></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">Index</th></tr><tr><td width="20%" align="left"><a accesskey="p" href="mysql-floss-license-exception.html">Prev</a> </td><th width="60%" align="center"> </th><td width="20%" align="right"> </td></tr></table><hr></div><div class="index"><div class="titlepage"><div><div><h2 class="title"><a name="id3192099"></a>Index</h2></div></div></div><div class="index"><div class="indexdiv"><h3>Symbols</h3><dl><dt>! (logical NOT), <a href="functions.html#logical-operators">Logical Operators</a></dt><dt>!= (not equal), <a href="functions.html#comparison-operators">Comparison Functions and Operators</a></dt><dt>", <a href="language-structure.html#legal-names">Database, Table, Index, Column, and Alias Names</a></dt><dt>% (modulo), <a href="functions.html#mathematical-functions">Mathematical Functions</a></dt><dt>% (wildcard character), <a href="language-structure.html#string-syntax">Strings</a></dt><dt>& (bitwise AND), <a href="functions.html#bit-functions">Bit Functions</a></dt><dt>&& (logical AND), <a href="functions.html#logical-operators">Logical Operators</a></dt><dt>() (parentheses), <a href="functions.html#parentheses">Parentheses</a></dt><dt>(Control-Z) \Z, <a href="language-structure.html#string-syntax">Strings</a></dt><dt>* (multiplication), <a href="functions.html#arithmetic-functions">Arithmetic Operators</a></dt><dt>+ (addition), <a href="functions.html#arithmetic-functions">Arithmetic Operators</a></dt><dt>- (subtraction), <a href="functions.html#arithmetic-functions">Arithmetic Operators</a></dt><dt>- (unary minus), <a href="functions.html#arithmetic-functions">Arithmetic Operators</a></dt><dt>--password option, <a href="database-administration.html#password-security">Keeping Your Password Secure</a></dt><dt>-p option, <a href="database-administration.html#password-security">Keeping Your Password Secure</a></dt><dt>.my.cnf file, <a href="using-mysql-programs.html#option-files">Using Option Files</a>, <a href="database-administration.html#connecting">Connecting to the MySQL Server</a>, <a href="database-administration.html#access-denied">Causes of Access denied Errors</a>, <a href="database-administration.html#password-security">Keeping Your Password Secure</a>, <a href="database-administration.html#multiple-server-clients">Using Client Programs in a Multiple-Server Environment</a></dt><dt>.mysql_history file, <a href="client-side-scripts.html#mysql-command-options">Options</a></dt><dt>.pid (process ID) file, <a href="database-administration.html#maintenance-schedule">Setting Up a Table Maintenance Schedule</a></dt><dt>/ (division), <a href="functions.html#arithmetic-functions">Arithmetic Operators</a></dt><dt>/etc/passwd, <a href="database-administration.html#security-against-attack">Making MySQL Secure Against Attackers</a>, <a href="sql-syntax.html#select">SELECT Syntax</a></dt><dt>< (less than), <a href="functions.html#comparison-operators">Comparison Functions and Operators</a></dt><dt><<, <a href="tutorial.html#calculating-days">Calculating Visits Per Day</a></dt><dt><< (left shift), <a href="functions.html#bit-functions">Bit Functions</a></dt><dt><= (less than or equal), <a href="functions.html#comparison-operators">Comparison Functions and Operators</a></dt><dt><=> (equal to), <a href="functions.html#comparison-operators">Comparison Functions and Operators</a></dt><dt><> (not equal), <a href="functions.html#comparison-operators">Comparison Functions and Operators</a></dt><dt>= (equal), <a href="functions.html#comparison-operators">Comparison Functions and Operators</a></dt><dt>> (greater than), <a href="functions.html#comparison-operators">Comparison Functions and Operators</a></dt><dt>>= (greater than or equal), <a href="functions.html#comparison-operators">Comparison Functions and Operators</a></dt><dt>>> (right shift), <a href="functions.html#bit-functions">Bit Functions</a></dt><dt>\" (double quote), <a href="language-structure.html#string-syntax">Strings</a></dt><dt>\' (single quote), <a href="language-structure.html#string-syntax">Strings</a></dt><dt>\0 (ASCII 0), <a href="language-structure.html#string-syntax">Strings</a></dt><dt>\b (backspace), <a href="language-structure.html#string-syntax">Strings</a></dt><dt>\n (linefeed), <a href="language-structure.html#string-syntax">Strings</a></dt><dt>\n (newline), <a href="language-structure.html#string-syntax">Strings</a></dt><dt>\r (carriage return), <a href="language-structure.html#string-syntax">Strings</a></dt><dt>\t (tab), <a href="language-structure.html#string-syntax">Strings</a></dt><dt>\Z (Control-Z) ASCII 26, <a href="language-structure.html#string-syntax">Strings</a></dt><dt>\\ (escape), <a href="language-structure.html#string-syntax">Strings</a></dt><dt>^ (bitwise XOR), <a href="functions.html#bit-functions">Bit Functions</a></dt><dt>_ (wildcard character), <a href="language-structure.html#string-syntax">Strings</a></dt><dt>`, <a href="language-structure.html#legal-names">Database, Table, Index, Column, and Alias Names</a></dt><dt>| (bitwise OR), <a href="functions.html#bit-functions">Bit Functions</a></dt><dt>|| (logical OR), <a href="functions.html#logical-operators">Logical Operators</a></dt><dt>~, <a href="functions.html#bit-functions">Bit Functions</a></dt></dl></div><div class="indexdiv"><h3>A</h3><dl><dt>aborted clients, <a href="problems.html#communication-errors">Communication Errors and Aborted Connections</a></dt><dt>aborted connection, <a href="problems.html#communication-errors">Communication Errors and Aborted Connections</a></dt><dt>ABS(), <a href="functions.html#mathematical-functions">Mathematical Functions</a></dt><dt>access control, <a href="database-administration.html#connection-access">Access Control, Stage 1: Connection Verification</a></dt><dt>access denied errors, <a href="problems.html#error-access-denied">Access denied</a></dt><dt>access privileges, <a href="database-administration.html#privilege-system">The MySQL Access Privilege System</a></dt><dt>Access program, <a href="connectors.html#programs-known-to-work-with-myodbc">Programs Known to Work With MyODBC</a></dt><dt>account privileges</dt><dd><dl><dt>adding, <a href="database-administration.html#adding-users">Adding New User Accounts to MySQL</a></dt></dl></dd><dt>accounts</dt><dd><dl><dt>anonymous user, <a href="installing.html#default-privileges">Securing the Initial MySQL Accounts</a></dt><dt>root, <a href="installing.html#default-privileges">Securing the Initial MySQL Accounts</a></dt></dl></dd><dt>ACID, <a href="introduction.html#ansi-diff-transactions">Transactions and Atomic Operations</a>, <a href="storage-engines.html#innodb-overview">InnoDB Overview</a></dt><dt>ACLs, <a href="database-administration.html#privilege-system">The MySQL Access Privilege System</a></dt><dt>ACOS(), <a href="functions.html#mathematical-functions">Mathematical Functions</a></dt><dt>ActiveState Perl, <a href="installing.html#activestate-perl">Installing ActiveState Perl on Windows</a></dt><dt>ADDDATE(), <a href="functions.html#date-and-time-functions">Date and Time Functions</a></dt><dt>adding</dt><dd><dl><dt>character sets, <a href="database-administration.html#adding-character-set">Adding a New Character Set</a></dt><dt>native functions, <a href="extending-mysql.html#adding-native-function">Adding a New Native Function</a></dt><dt>new account privileges, <a href="database-administration.html#adding-users">Adding New User Accounts to MySQL</a></dt><dt>new functions, <a href="extending-mysql.html#adding-functions">Adding New Functions to MySQL</a></dt><dt>new user privileges, <a href="database-administration.html#adding-users">Adding New User Accounts to MySQL</a></dt><dt>new users, <a href="installing.html#installing-binary">Installing MySQL on Other Unix-Like Systems</a>, <a href="installing.html#quick-install">Source Installation Overview</a></dt><dt>procedures, <a href="extending-mysql.html#adding-procedures">Adding New Procedures to MySQL</a></dt><dt>user-defined functions, <a href="extending-mysql.html#adding-udf">Adding a New User-Defined Function</a></dt></dl></dd><dt>addition (+), <a href="functions.html#arithmetic-functions">Arithmetic Operators</a></dt><dt>ADDTIME(), <a href="functions.html#date-and-time-functions">Date and Time Functions</a></dt><dt>ADO program, <a href="connectors.html#programs-known-to-work-with-myodbc">Programs Known to Work With MyODBC</a></dt><dt>AES_DECRYPT(), <a href="functions.html#encryption-functions">Encryption Functions</a></dt><dt>AES_ENCRYPT(), <a href="functions.html#encryption-functions">Encryption Functions</a></dt><dt>age</dt><dd><dl><dt>calculating, <a href="tutorial.html#date-calculations">Date Calculations</a></dt></dl></dd><dt>alias, <a href="problems.html#problems-with-alias">Problems with Column Aliases</a></dt><dt>alias names</dt><dd><dl><dt>case sensitivity, <a href="language-structure.html#name-case-sensitivity">Identifier Case Sensitivity</a></dt></dl></dd><dt>aliases</dt><dd><dl><dt>for expressions, <a href="functions.html#group-by-hidden-fields">GROUP BY with Hidden Fields</a></dt><dt>for tables, <a href="sql-syntax.html#select">SELECT Syntax</a></dt><dt>in GROUP BY clauses, <a href="functions.html#group-by-hidden-fields">GROUP BY with Hidden Fields</a></dt><dt>in ORDER BY clauses, <a href="functions.html#group-by-hidden-fields">GROUP BY with Hidden Fields</a></dt><dt>names, <a href="language-structure.html#legal-names">Database, Table, Index, Column, and Alias Names</a></dt><dt>on expressions, <a href="sql-syntax.html#select">SELECT Syntax</a></dt></dl></dd><dt>ALL, <a href="sql-syntax.html#select">SELECT Syntax</a></dt><dt>ALLOW_INVALID_DATES SQL mode, <a href="database-administration.html#server-sql-mode">The Server SQL Mode</a></dt><dt>ALTER COLUMN, <a href="sql-syntax.html#alter-table">ALTER TABLE Syntax</a></dt><dt>ALTER DATABASE, <a href="sql-syntax.html#alter-database">ALTER DATABASE Syntax</a></dt><dt>ALTER FUNCTION, <a href="stored-procedures.html#alter-procedure">ALTER PROCEDURE and ALTER FUNCTION</a></dt><dt>ALTER PROCEDURE, <a href="stored-procedures.html#alter-procedure">ALTER PROCEDURE and ALTER FUNCTION</a></dt><dt>ALTER SCHEMA, <a href="sql-syntax.html#alter-database">ALTER DATABASE Syntax</a></dt><dt>ALTER TABLE, <a href="sql-syntax.html#alter-table">ALTER TABLE Syntax</a>, <a href="problems.html#alter-table-problems">Problems with ALTER TABLE</a></dt><dt>ALTER VIEW, <a href="views.html#alter-view">ALTER VIEW Syntax</a></dt><dt>altering</dt><dd><dl><dt>database, <a href="sql-syntax.html#alter-database">ALTER DATABASE Syntax</a></dt><dt>schema, <a href="sql-syntax.html#alter-database">ALTER DATABASE Syntax</a></dt></dl></dd><dt>ANALYZE TABLE, <a href="sql-syntax.html#analyze-table">ANALYZE TABLE Syntax</a></dt><dt>AND</dt><dd><dl><dt>bitwise, <a href="functions.html#bit-functions">Bit Functions</a></dt><dt>logical, <a href="functions.html#logical-operators">Logical Operators</a></dt></dl></dd><dt>anonymous user, <a href="installing.html#default-privileges">Securing the Initial MySQL Accounts</a>, <a href="database-administration.html#connection-access">Access Control, Stage 1: Connection Verification</a>, <a href="database-administration.html#request-access">Access Control, Stage 2: Request Verification</a></dt><dt>ANSI mode</dt><dd><dl><dt>running, <a href="introduction.html#ansi-mode">Running MySQL in ANSI Mode</a></dt></dl></dd><dt>ANSI SQL mode, <a href="database-administration.html#server-sql-mode">The Server SQL Mode</a></dt><dt>ANSI_QUOTES SQL mode, <a href="database-administration.html#server-sql-mode">The Server SQL Mode</a></dt><dt>answering questions</dt><dd><dl><dt>etiquette, <a href="introduction.html#answering-questions">Guidelines for Answering Questions on the Mailing List</a></dt></dl></dd><dt>Apache, <a href="tutorial.html#apache">Using MySQL with Apache</a></dt><dt>API's</dt><dd><dl><dt>list of, <a href="credits.html#packages">Packages that support MySQL</a></dt></dl></dd><dt>APIs, <a href="apis.html">APIs and Libraries</a></dt><dd><dl><dt>Perl, <a href="apis.html#perl">MySQL Perl API</a></dt></dl></dd><dt>approximate-value literals, <a href="precision-math.html">Precision Math</a></dt><dt>ARCHIVE storage engine, <a href="storage-engines.html">Storage Engines and Table Types</a>, <a href="storage-engines.html#archive-storage-engine">The ARCHIVE Storage Engine</a></dt><dt>ARCHIVE table type, <a href="storage-engines.html">Storage Engines and Table Types</a>, <a href="storage-engines.html#archive-storage-engine">The ARCHIVE Storage Engine</a></dt><dt>Area(), <a href="spatial-extensions-in-mysql.html#polygon-property-functions">Polygon Functions</a>, <a href="spatial-extensions-in-mysql.html#multipolygon-property-functions">MultiPolygon Functions</a></dt><dt>argument processing, <a href="extending-mysql.html#udf-arguments">UDF Argument Processing</a></dt><dt>arithmetic expressions, <a href="functions.html#arithmetic-functions">Arithmetic Operators</a></dt><dt>arithmetic functions, <a href="functions.html#bit-functions">Bit Functions</a></dt><dt>AS, <a href="sql-syntax.html#select">SELECT Syntax</a>, <a href="sql-syntax.html#join">JOIN Syntax</a></dt><dt>AsBinary(), <a href="spatial-extensions-in-mysql.html#functions-to-convert-geometries-between-formats">Geometry Format Conversion Functions</a></dt><dt>ASCII(), <a href="functions.html#string-functions">String Functions</a></dt><dt>ASIN(), <a href="functions.html#mathematical-functions">Mathematical Functions</a></dt><dt>AsText(), <a href="spatial-extensions-in-mysql.html#functions-to-convert-geometries-between-formats">Geometry Format Conversion Functions</a></dt><dt>ATAN(), <a href="functions.html#mathematical-functions">Mathematical Functions</a></dt><dt>ATAN2(), <a href="functions.html#mathematical-functions">Mathematical Functions</a></dt><dt>attackers</dt><dd><dl><dt>security against, <a href="database-administration.html#security-against-attack">Making MySQL Secure Against Attackers</a></dt></dl></dd><dt>AUTO-INCREMENT</dt><dd><dl><dt>ODBC, <a href="connectors.html#odbc-and-last-insert-id">How to Get the Value of an AUTO_INCREMENT Column in ODBC</a></dt></dl></dd><dt>AUTO_INCREMENT, <a href="tutorial.html#example-auto-increment">Using AUTO_INCREMENT</a></dt><dd><dl><dt>and NULL values, <a href="problems.html#problems-with-null">Problems with NULL Values</a></dt></dl></dd><dt>AVG(), <a href="functions.html#group-by-functions">GROUP BY (Aggregate) Functions</a></dt><dt>AVG(DISTINCT), <a href="functions.html#group-by-functions">GROUP BY (Aggregate) Functions</a></dt></dl></div><div class="indexdiv"><h3>B</h3><dl><dt>backslash</dt><dd><dl><dt>escape character, <a href="language-structure.html#literals">Literal Values</a></dt></dl></dd><dt>backspace (\b), <a href="language-structure.html#string-syntax">Strings</a></dt><dt>BACKUP TABLE, <a href="sql-syntax.html#backup-table">BACKUP TABLE Syntax</a></dt><dt>backups, <a href="database-administration.html#backup">Database Backups</a></dt><dd><dl><dt>database, <a href="sql-syntax.html#backup-table">BACKUP TABLE Syntax</a></dt></dl></dd><dt>batch</dt><dd><dl><dt>mysql option, <a href="client-side-scripts.html#mysql-command-options">Options</a></dt></dl></dd><dt>batch mode, <a href="tutorial.html#batch-mode">Using mysql in Batch Mode</a></dt><dt>BDB storage engine, <a href="storage-engines.html">Storage Engines and Table Types</a>, <a href="storage-engines.html#bdb-storage-engine">The BDB (BerkeleyDB) Storage Engine</a></dt><dt>BDB table type, <a href="storage-engines.html">Storage Engines and Table Types</a>, <a href="storage-engines.html#bdb-storage-engine">The BDB (BerkeleyDB) Storage Engine</a></dt><dt>BDB tables, <a href="introduction.html#ansi-diff-transactions">Transactions and Atomic Operations</a></dt><dt>BdMPolyFromText(), <a href="spatial-extensions-in-mysql.html#gis-wkt-functions">Creating Geometry Values Using WKT Functions</a></dt><dt>BdMPolyFromWKB(), <a href="spatial-extensions-in-mysql.html#gis-wkb-functions">Creating Geometry Values Using WKB Functions</a></dt><dt>BdPolyFromText(), <a href="spatial-extensions-in-mysql.html#gis-wkt-functions">Creating Geometry Values Using WKT Functions</a></dt><dt>BdPolyFromWKB(), <a href="spatial-extensions-in-mysql.html#gis-wkb-functions">Creating Geometry Values Using WKB Functions</a></dt><dt>BEGIN, <a href="sql-syntax.html#commit">START TRANSACTION, COMMIT, and ROLLBACK Syntax</a>, <a href="stored-procedures.html#begin-end">BEGIN ... END Compound Statement</a></dt><dd><dl><dt>XA transactions, <a href="sql-syntax.html#xa-statements">XA Transaction SQL Syntax</a></dt></dl></dd><dt>benchmark suite, <a href="optimization.html#mysql-benchmarks">The MySQL Benchmark Suite</a></dt><dt>BENCHMARK(), <a href="functions.html#information-functions">Information Functions</a></dt><dt>benchmarks, <a href="optimization.html#custom-benchmarks">Using Your Own Benchmarks</a></dt><dt>BerkeleyDB storage engine, <a href="storage-engines.html">Storage Engines and Table Types</a>, <a href="storage-engines.html#bdb-storage-engine">The BDB (BerkeleyDB) Storage Engine</a></dt><dt>BerkeleyDB table type, <a href="storage-engines.html">Storage Engines and Table Types</a>, <a href="storage-engines.html#bdb-storage-engine">The BDB (BerkeleyDB) Storage Engine</a></dt><dt>BETWEEN ... AND, <a href="functions.html#comparison-operators">Comparison Functions and Operators</a></dt><dt>Big5 Chinese character encoding, <a href="problems.html#case-sensitivity">Case Sensitivity in Searches</a></dt><dt>BIGINT data type, <a href="column-types.html#numeric-type-overview">Overview of Numeric Types</a></dt><dt>BIN(), <a href="functions.html#string-functions">String Functions</a></dt><dt>BINARY, <a href="functions.html#cast-functions">Cast Functions and Operators</a></dt><dt>BINARY data type, <a href="column-types.html#string-type-overview">Overview of String Types</a>, <a href="column-types.html#binary-varbinary">The BINARY and VARBINARY Types</a></dt><dt>binary distributions, <a href="installing.html#mysql-binaries">MySQL Binaries Compiled by MySQL AB</a></dt><dd><dl><dt>installing, <a href="installing.html#installing-binary">Installing MySQL on Other Unix-Like Systems</a></dt><dt>on Linux, <a href="installing.html#binary-notes-linux">Linux Binary Distribution Notes</a></dt></dl></dd><dt>binary log, <a href="database-administration.html#binary-log">The Binary Log</a></dt><dt>BIT data type, <a href="column-types.html#numeric-type-overview">Overview of Numeric Types</a></dt><dt>BitKeeper tree, <a href="installing.html#installing-source-tree">Installing from the Development Source Tree</a></dt><dt>BIT_AND(), <a href="functions.html#group-by-functions">GROUP BY (Aggregate) Functions</a></dt><dt>BIT_COUNT, <a href="tutorial.html#calculating-days">Calculating Visits Per Day</a></dt><dt>BIT_COUNT(), <a href="functions.html#bit-functions">Bit Functions</a></dt><dt>bit_functions</dt><dd><dl><dt>example, <a href="tutorial.html#calculating-days">Calculating Visits Per Day</a></dt></dl></dd><dt>BIT_LENGTH(), <a href="functions.html#string-functions">String Functions</a></dt><dt>BIT_OR, <a href="tutorial.html#calculating-days">Calculating Visits Per Day</a></dt><dt>BIT_OR(), <a href="functions.html#group-by-functions">GROUP BY (Aggregate) Functions</a></dt><dt>BIT_XOR(), <a href="functions.html#group-by-functions">GROUP BY (Aggregate) Functions</a></dt><dt>BLACKHOLE storage engine, <a href="storage-engines.html">Storage Engines and Table Types</a>, <a href="storage-engines.html#blackhole-storage-engine">The BLACKHOLE Storage Engine</a></dt><dt>BLACKHOLE table type, <a href="storage-engines.html">Storage Engines and Table Types</a>, <a href="storage-engines.html#blackhole-storage-engine">The BLACKHOLE Storage Engine</a></dt><dt>BLOB</dt><dd><dl><dt>inserting binary data, <a href="language-structure.html#string-syntax">Strings</a></dt><dt>size, <a href="column-types.html#storage-requirements">Column Type Storage Requirements</a></dt></dl></dd><dt>BLOB columns</dt><dd><dl><dt>default values, <a href="column-types.html#blob">The BLOB and TEXT Types</a></dt><dt>indexing, <a href="optimization.html#indexes">Column Indexes</a>, <a href="sql-syntax.html#create-table">CREATE TABLE Syntax</a></dt></dl></dd><dt>BLOB data type, <a href="column-types.html#string-type-overview">Overview of String Types</a>, <a href="column-types.html#blob">The BLOB and TEXT Types</a></dt><dt>BOOL data type, <a href="column-types.html#numeric-type-overview">Overview of Numeric Types</a></dt><dt>BOOLEAN data type, <a href="column-types.html#numeric-type-overview">Overview of Numeric Types</a></dt><dt>Borland Builder 4 program, <a href="connectors.html#programs-known-to-work-with-myodbc">Programs Known to Work With MyODBC</a></dt><dt>Borland C++ compiler, <a href="apis.html#borland-c-plus-plus">Borland C++</a></dt><dt>Boundary(), <a href="spatial-extensions-in-mysql.html#general-geometry-property-functions">General Geometry Functions</a></dt><dt>brackets</dt><dd><dl><dt>square, <a href="column-types.html">Column Types</a></dt></dl></dd><dt>buffer sizes</dt><dd><dl><dt>client, <a href="apis.html">APIs and Libraries</a></dt><dt>mysqld server, <a href="optimization.html#server-parameters">Tuning Server Parameters</a></dt></dl></dd><dt>Buffer(), <a href="spatial-extensions-in-mysql.html#spatial-operators">Spatial Operators</a></dt><dt>bug reports</dt><dd><dl><dt>criteria for, <a href="introduction.html#bug-reports">How to Report Bugs or Problems</a></dt></dl></dd><dt>bugs</dt><dd><dl><dt>known, <a href="problems.html#bugs">Known Issues in MySQL</a></dt><dt>reporting, <a href="introduction.html#bug-reports">How to Report Bugs or Problems</a></dt></dl></dd><dt>bugs database, <a href="introduction.html#bug-reports">How to Report Bugs or Problems</a></dt><dt>bugs.mysql.com, <a href="introduction.html#bug-reports">How to Report Bugs or Problems</a></dt><dt>building</dt><dd><dl><dt>client programs, <a href="apis.html#building-clients">Building Client Programs</a></dt></dl></dd></dl></div><div class="indexdiv"><h3>C</h3><dl><dt>C API</dt><dd><dl><dt>data types, <a href="apis.html#c">MySQL C API</a></dt><dt>functions, <a href="apis.html#c-api-function-overview">C API Function Overview</a></dt><dt>linking problems, <a href="apis.html#c-api-linking-problems">Problems Linking with the C API</a></dt></dl></dd><dt>C Prepared statement API</dt><dd><dl><dt>functions, <a href="apis.html#c-api-prepared-statement-function-overview">C API Prepared Statement Function Overview</a></dt></dl></dd><dt>C++ APIs, <a href="apis.html#cplusplus">MySQL C++ API</a></dt><dt>C++ Builder, <a href="connectors.html#programs-known-to-work-with-myodbc">Programs Known to Work With MyODBC</a></dt><dt>C++ compiler</dt><dd><dl><dt>gcc, <a href="installing.html#configure-options">Typical configure Options</a></dt></dl></dd><dt>C++ compiler cannot create executables, <a href="installing.html#compilation-problems">Dealing with Problems Compiling MySQL</a></dt><dt>C:\my.cnf file, <a href="database-administration.html#multiple-server-clients">Using Client Programs in a Multiple-Server Environment</a></dt><dt>CACHE INDEX, <a href="sql-syntax.html#cache-index">CACHE INDEX Syntax</a></dt><dt>caches</dt><dd><dl><dt>clearing, <a href="sql-syntax.html#flush">FLUSH Syntax</a></dt></dl></dd><dt>calculating</dt><dd><dl><dt>dates, <a href="tutorial.html#date-calculations">Date Calculations</a></dt></dl></dd><dt>calendar, <a href="functions.html#mysql-calendar">What Calendar Is Used By MySQL?</a></dt><dt>CALL, <a href="stored-procedures.html#call">CALL Statement</a></dt><dt>calling sequences for aggregate functions</dt><dd><dl><dt>UDF, <a href="extending-mysql.html#udf-aggr-calling">UDF Calling Sequences for Aggregate Functions</a></dt></dl></dd><dt>calling sequences for simple functions</dt><dd><dl><dt>UDF, <a href="extending-mysql.html#udf-calling">UDF Calling Sequences for Simple Functions</a></dt></dl></dd><dt>can't create/write to file, <a href="problems.html#cannot-create">Can't create/write to file</a></dt><dt>carriage return (\r), <a href="language-structure.html#string-syntax">Strings</a></dt><dt>CASE, <a href="functions.html#control-flow-functions">Control Flow Functions</a>, <a href="stored-procedures.html#case-statement">CASE Statement</a></dt><dt>case sensitivity</dt><dd><dl><dt>in identifiers, <a href="language-structure.html#name-case-sensitivity">Identifier Case Sensitivity</a></dt><dt>in names, <a href="language-structure.html#name-case-sensitivity">Identifier Case Sensitivity</a></dt><dt>in searches, <a href="problems.html#case-sensitivity">Case Sensitivity in Searches</a></dt><dt>in string comparisons, <a href="functions.html#string-comparison-functions">String Comparison Functions</a></dt></dl></dd><dt>case-sensitivity</dt><dd><dl><dt>in access checking, <a href="database-administration.html#privileges">How the Privilege System Works</a></dt><dt>of database names, <a href="introduction.html#extensions-to-ansi">MySQL Extensions to Standard SQL</a></dt><dt>of table names, <a href="introduction.html#extensions-to-ansi">MySQL Extensions to Standard SQL</a></dt></dl></dd><dt>CAST, <a href="functions.html#cast-functions">Cast Functions and Operators</a></dt><dt>cast functions, <a href="functions.html#cast-functions">Cast Functions and Operators</a></dt><dt>cast operators, <a href="functions.html#cast-functions">Cast Functions and Operators</a></dt><dt>casts, <a href="functions.html#comparison-operators">Comparison Functions and Operators</a>, <a href="functions.html#cast-functions">Cast Functions and Operators</a></dt><dt>CC environment variable, <a href="installing.html#configure-options">Typical configure Options</a>, <a href="installing.html#compilation-problems">Dealing with Problems Compiling MySQL</a>, <a href="environment-variables.html">Environment Variables</a></dt><dt>cc1plus problems, <a href="installing.html#compilation-problems">Dealing with Problems Compiling MySQL</a></dt><dt>CEILING(), <a href="functions.html#mathematical-functions">Mathematical Functions</a></dt><dt>Centroid(), <a href="spatial-extensions-in-mysql.html#multipolygon-property-functions">MultiPolygon Functions</a></dt><dt>CFLAGS environment variable, <a href="installing.html#configure-options">Typical configure Options</a>, <a href="installing.html#compilation-problems">Dealing with Problems Compiling MySQL</a>, <a href="environment-variables.html">Environment Variables</a></dt><dt>CHANGE MASTER TO, <a href="sql-syntax.html#change-master-to">CHANGE MASTER TO Syntax</a></dt><dt>ChangeLog, <a href="news.html">MySQL Change History</a></dt><dt>changes</dt><dd><dl><dt>Cluster, <a href="news.html#mysql-cluster-change-history">MySQL Cluster Change History</a></dt><dt>log, <a href="news.html">MySQL Change History</a></dt><dt>MySQL 5.0, <a href="news.html#news-5-0-x">Changes in release 5.0.x (Production)</a></dt></dl></dd><dt>changes to privileges, <a href="database-administration.html#request-access">Access Control, Stage 2: Request Verification</a></dt><dt>changing</dt><dd><dl><dt>column, <a href="sql-syntax.html#alter-table">ALTER TABLE Syntax</a></dt><dt>column order, <a href="problems.html#change-column-order">How to Change the Order of Columns in a Table</a></dt><dt>field, <a href="sql-syntax.html#alter-table">ALTER TABLE Syntax</a></dt><dt>table, <a href="sql-syntax.html#alter-table">ALTER TABLE Syntax</a>, <a href="problems.html#alter-table-problems">Problems with ALTER TABLE</a></dt></dl></dd><dt>changing socket location, <a href="installing.html#configure-options">Typical configure Options</a>, <a href="installing.html#automatic-start">Starting and Stopping MySQL Automatically</a>, <a href="problems.html#problems-with-mysql-sock">How to Protect or Change the MySQL Socket File /tmp/mysql.sock</a></dt><dt>CHAR data type, <a href="column-types.html#string-type-overview">Overview of String Types</a>, <a href="column-types.html#string-types">String Types</a></dt><dt>CHAR VARYING data type, <a href="column-types.html#string-type-overview">Overview of String Types</a></dt><dt>CHAR(), <a href="functions.html#string-functions">String Functions</a></dt><dt>CHARACTER data type, <a href="column-types.html#string-type-overview">Overview of String Types</a></dt><dt>character sets, <a href="installing.html#configure-options">Typical configure Options</a>, <a href="database-administration.html#character-sets">The Character Set Used for Data and Sorting</a></dt><dd><dl><dt>adding, <a href="database-administration.html#adding-character-set">Adding a New Character Set</a></dt></dl></dd><dt>Character sets, <a href="charset.html">Character Set Support</a></dt><dt>CHARACTER VARYING data type, <a href="column-types.html#string-type-overview">Overview of String Types</a></dt><dt>character-sets-dir</dt><dd><dl><dt>mysql option, <a href="client-side-scripts.html#mysql-command-options">Options</a></dt></dl></dd><dt>characters</dt><dd><dl><dt>multi-byte, <a href="database-administration.html#multi-byte-characters">Multi-Byte Character Support</a></dt></dl></dd><dt>CHARACTER_LENGTH(), <a href="functions.html#string-functions">String Functions</a></dt><dt>CHARACTER_SETS</dt><dd><dl><dt>INFORMATION_SCHEMA table, <a href="information-schema.html#character-sets-table">The INFORMATION_SCHEMA CHARACTER_SETS Table</a></dt></dl></dd><dt>CHARSET(), <a href="functions.html#information-functions">Information Functions</a></dt><dt>CHAR_LENGTH(), <a href="functions.html#string-functions">String Functions</a></dt><dt>check options</dt><dd><dl><dt>myisamchk, <a href="database-administration.html#myisamchk-check-options">Check Options for myisamchk</a></dt></dl></dd><dt>CHECK TABLE, <a href="sql-syntax.html#check-table">CHECK TABLE Syntax</a></dt><dt>checking</dt><dd><dl><dt>tables for errors, <a href="database-administration.html#check">How to Check MyISAM Tables for Errors</a></dt></dl></dd><dt>checksum errors, <a href="installing.html#solaris">Solaris Notes</a></dt><dt>CHECKSUM TABLE, <a href="sql-syntax.html#checksum-table">CHECKSUM TABLE Syntax</a></dt><dt>Chinese, <a href="problems.html#case-sensitivity">Case Sensitivity in Searches</a></dt><dt>choosing</dt><dd><dl><dt>a MySQL version, <a href="installing.html#which-version">Choosing Which MySQL Distribution to Install</a></dt></dl></dd><dt>choosing types, <a href="column-types.html#choosing-types">Choosing the Right Type for a Column</a></dt><dt>clearing</dt><dd><dl><dt>caches, <a href="sql-syntax.html#flush">FLUSH Syntax</a></dt></dl></dd><dt>client programs</dt><dd><dl><dt>building, <a href="apis.html#building-clients">Building Client Programs</a></dt></dl></dd><dt>client tools, <a href="apis.html">APIs and Libraries</a></dt><dt>clients</dt><dd><dl><dt>debugging, <a href="porting.html#debugging-client">Debugging a MySQL Client</a></dt><dt>threaded, <a href="apis.html#threaded-clients">How to Make a Threaded Client</a></dt></dl></dd><dt>CLOSE, <a href="stored-procedures.html#close">Cursor CLOSE Statement</a></dt><dt>closing</dt><dd><dl><dt>tables, <a href="optimization.html#table-cache">How MySQL Opens and Closes Tables</a></dt></dl></dd><dt>COALESCE(), <a href="functions.html#comparison-operators">Comparison Functions and Operators</a></dt><dt>COERCIBILITY(), <a href="functions.html#information-functions">Information Functions</a></dt><dt>ColdFusion program, <a href="connectors.html#programs-known-to-work-with-myodbc">Programs Known to Work With MyODBC</a></dt><dt>collating</dt><dd><dl><dt>strings, <a href="database-administration.html#string-collating">String Collating Support</a></dt></dl></dd><dt>COLLATION(), <a href="functions.html#information-functions">Information Functions</a></dt><dt>COLLATIONS</dt><dd><dl><dt>INFORMATION_SCHEMA table, <a href="information-schema.html#collations-table">The INFORMATION_SCHEMA COLLATIONS Table</a></dt></dl></dd><dt>COLLATION_CHARACTER_SET_APPLICABILITY</dt><dd><dl><dt>INFORMATION_SCHEMA table, <a href="information-schema.html#collation-character-set-applicability-table">The INFORMATION_SCHEMA COLLATION_CHARACTER_SET_APPLICABILITY Table</a></dt></dl></dd><dt>column</dt><dd><dl><dt>changing, <a href="sql-syntax.html#alter-table">ALTER TABLE Syntax</a></dt></dl></dd><dt>column comments, <a href="sql-syntax.html#create-table">CREATE TABLE Syntax</a></dt><dt>column names</dt><dd><dl><dt>case sensitivity, <a href="language-structure.html#name-case-sensitivity">Identifier Case Sensitivity</a></dt></dl></dd><dt>columns</dt><dd><dl><dt>changing, <a href="problems.html#change-column-order">How to Change the Order of Columns in a Table</a></dt><dt>indexes, <a href="optimization.html#indexes">Column Indexes</a></dt><dt>names, <a href="language-structure.html#legal-names">Database, Table, Index, Column, and Alias Names</a></dt><dt>other types, <a href="column-types.html#other-vendor-column-types">Using Column Types from Other Database Engines</a></dt><dt>selecting, <a href="tutorial.html#selecting-columns">Selecting Particular Columns</a></dt><dt>storage requirements, <a href="column-types.html#storage-requirements">Column Type Storage Requirements</a></dt><dt>types, <a href="column-types.html">Column Types</a></dt></dl></dd><dt>COLUMNS</dt><dd><dl><dt>INFORMATION_SCHEMA table, <a href="information-schema.html#columns-table">The INFORMATION_SCHEMA COLUMNS Table</a></dt></dl></dd><dt>COLUMN_PRIVILEGES</dt><dd><dl><dt>INFORMATION_SCHEMA table, <a href="information-schema.html#column-privileges-table">The INFORMATION_SCHEMA COLUMN_PRIVILEGES Table</a></dt></dl></dd><dt>command syntax, <a href="introduction.html#manual-conventions">Conventions Used in This Manual</a></dt><dt>command-line history</dt><dd><dl><dt>mysql, <a href="client-side-scripts.html#mysql-command-options">Options</a></dt></dl></dd><dt>command-line options, <a href="database-administration.html#server-options">mysqld Command-Line Options</a></dt><dd><dl><dt>mysql, <a href="client-side-scripts.html#mysql-command-options">Options</a></dt><dt>mysqladmin, <a href="client-side-scripts.html#mysqladmin">mysqladmin — Client for Administering a MySQL Server</a></dt></dl></dd><dt>commands</dt><dd><dl><dt>for binary distribution, <a href="installing.html#installing-binary">Installing MySQL on Other Unix-Like Systems</a></dt><dt>replication masters, <a href="sql-syntax.html#replication-master-sql">SQL Statements for Controlling Master Servers</a></dt><dt>replication slaves, <a href="sql-syntax.html#replication-slave-sql">SQL Statements for Controlling Slave Servers</a></dt></dl></dd><dt>commands out of sync, <a href="problems.html#commands-out-of-sync">Commands out of sync</a></dt><dt>Comment syntax, <a href="language-structure.html#comments">Comment Syntax</a></dt><dt>comments</dt><dd><dl><dt>adding, <a href="language-structure.html#comments">Comment Syntax</a></dt><dt>starting, <a href="introduction.html#ansi-diff-comments">'--' as the Start of a Comment</a></dt></dl></dd><dt>COMMIT, <a href="introduction.html#ansi-diff-transactions">Transactions and Atomic Operations</a>, <a href="sql-syntax.html#commit">START TRANSACTION, COMMIT, and ROLLBACK Syntax</a></dt><dd><dl><dt>XA transactions, <a href="sql-syntax.html#xa-statements">XA Transaction SQL Syntax</a></dt></dl></dd><dt>comparison operators, <a href="functions.html#comparison-operators">Comparison Functions and Operators</a></dt><dt>compatibility</dt><dd><dl><dt>between MySQL versions, <a href="installing.html#upgrading-from-4-1">Upgrading from Version 4.1 to 5.0</a></dt><dt>with mSQL, <a href="functions.html#string-comparison-functions">String Comparison Functions</a></dt><dt>with ODBC, <a href="language-structure.html#identifier-qualifiers">Identifier Qualifiers</a>, <a href="column-types.html#numeric-type-overview">Overview of Numeric Types</a>, <a href="functions.html#comparison-operators">Comparison Functions and Operators</a>, <a href="sql-syntax.html#create-table">CREATE TABLE Syntax</a>, <a href="sql-syntax.html#join">JOIN Syntax</a></dt><dt>with Oracle, <a href="introduction.html#extensions-to-ansi">MySQL Extensions to Standard SQL</a>, <a href="functions.html#group-by-functions">GROUP BY (Aggregate) Functions</a>, <a href="sql-syntax.html#describe">DESCRIBE Syntax (Get Information About Columns)</a></dt><dt>with PostgreSQL, <a href="introduction.html#extensions-to-ansi">MySQL Extensions to Standard SQL</a></dt><dt>with standard SQL, <a href="introduction.html#compatibility">MySQL Standards Compliance</a></dt><dt>with Sybase, <a href="sql-syntax.html#use">USE Syntax</a></dt></dl></dd><dt>compiler</dt><dd><dl><dt>C++ gcc, <a href="installing.html#configure-options">Typical configure Options</a></dt></dl></dd><dt>compiling</dt><dd><dl><dt>on Windows, <a href="installing.html#windows-client-compiling">Compiling MySQL Clients on Windows</a></dt><dt>optimizing, <a href="optimization.html#system">System Factors and Startup Parameter Tuning</a></dt><dt>problems, <a href="installing.html#compilation-problems">Dealing with Problems Compiling MySQL</a></dt><dt>speed, <a href="optimization.html#compile-and-link-options">How Compiling and Linking Affects the Speed of MySQL</a></dt><dt>statically, <a href="installing.html#configure-options">Typical configure Options</a></dt><dt>user-defined functions, <a href="extending-mysql.html#udf-compiling">Compiling and Installing User-Defined Functions</a></dt></dl></dd><dt>compliance</dt><dd><dl><dt>Y2K, <a href="introduction.html#year-2000-compliance">Year 2000 Compliance</a></dt></dl></dd><dt>compress</dt><dd><dl><dt>mysql option, <a href="client-side-scripts.html#mysql-command-options">Options</a></dt></dl></dd><dt>COMPRESS(), <a href="functions.html#string-functions">String Functions</a></dt><dt>compressed tables, <a href="storage-engines.html#compressed-format">Compressed Table Characteristics</a></dt><dt>CONCAT(), <a href="functions.html#string-functions">String Functions</a></dt><dt>CONCAT_WS(), <a href="functions.html#string-functions">String Functions</a></dt><dt>concurrent inserts, <a href="optimization.html#internal-locking">Locking Methods</a></dt><dt>Conditions, <a href="stored-procedures.html#declare-conditions">DECLARE Conditions</a></dt><dt>config-file</dt><dd><dl><dt>mysqld_multi option, <a href="database-administration.html#mysqld-multi">mysqld_multi — Program for Managing Multiple MySQL Servers</a></dt></dl></dd><dt>config.cache, <a href="installing.html#compilation-problems">Dealing with Problems Compiling MySQL</a></dt><dt>config.cache file, <a href="installing.html#compilation-problems">Dealing with Problems Compiling MySQL</a></dt><dt>configuration files, <a href="database-administration.html#access-denied">Causes of Access denied Errors</a></dt><dt>configuration options, <a href="installing.html#configure-options">Typical configure Options</a></dt><dt>configure</dt><dd><dl><dt>running after prior invocation, <a href="installing.html#compilation-problems">Dealing with Problems Compiling MySQL</a></dt></dl></dd><dt>configure option</dt><dd><dl><dt>--with-charset, <a href="installing.html#configure-options">Typical configure Options</a></dt><dt>--with-collation, <a href="installing.html#configure-options">Typical configure Options</a></dt><dt>--with-extra-charsets, <a href="installing.html#configure-options">Typical configure Options</a></dt><dt>--with-low-memory, <a href="installing.html#compilation-problems">Dealing with Problems Compiling MySQL</a></dt></dl></dd><dt>configure script, <a href="installing.html#configure-options">Typical configure Options</a></dt><dt>connecting</dt><dd><dl><dt>remotely with SSH, <a href="database-administration.html#windows-and-ssh">Connecting to MySQL Remotely from Windows with SSH</a></dt><dt>to the server, <a href="tutorial.html#connecting-disconnecting">Connecting to and Disconnecting from the Server</a>, <a href="database-administration.html#connecting">Connecting to the MySQL Server</a></dt><dt>verification, <a href="database-administration.html#connection-access">Access Control, Stage 1: Connection Verification</a></dt></dl></dd><dt>connection</dt><dd><dl><dt>aborted, <a href="problems.html#communication-errors">Communication Errors and Aborted Connections</a></dt></dl></dd><dt>CONNECTION_ID(), <a href="functions.html#information-functions">Information Functions</a></dt><dt>Connector/JDBC, <a href="connectors.html"> Connectors</a></dt><dt>Connector/ODBC, <a href="connectors.html"> Connectors</a>, <a href="connectors.html#odbc-connector">MySQL Connector/ODBC</a></dt><dd><dl><dt>reporting problems, <a href="connectors.html#myodbc-bug-report">How to Report MyODBC Problems or Bugs</a></dt></dl></dd><dt>Connectors</dt><dd><dl><dt>MySQL, <a href="connectors.html"> Connectors</a></dt></dl></dd><dt>connect_timeout variable, <a href="client-side-scripts.html#mysql-command-options">Options</a>, <a href="client-side-scripts.html#mysqladmin">mysqladmin — Client for Administering a MySQL Server</a></dt><dt>constant table, <a href="optimization.html#explain">EXPLAIN Syntax (Get Information About a SELECT)</a>, <a href="optimization.html#where-optimizations">How MySQL Optimizes WHERE Clauses</a></dt><dt>constraints, <a href="introduction.html#constraints">How MySQL Deals with Constraints</a></dt><dt>CONSTRAINTS</dt><dd><dl><dt>INFORMATION_SCHEMA table, <a href="information-schema.html#table-constraints-table">The INFORMATION_SCHEMA TABLE_CONSTRAINTS Table</a></dt></dl></dd><dt>Contains(), <a href="spatial-extensions-in-mysql.html#functions-that-test-spatial-relationships-between-geometries">Functions That Test Spatial Relationships Between Geometries</a></dt><dt>contributing companies</dt><dd><dl><dt>list of, <a href="credits.html#supporters">Supporters of MySQL</a></dt></dl></dd><dt>contributors</dt><dd><dl><dt>list of, <a href="credits.html#contributors">Contributors to MySQL</a></dt></dl></dd><dt>control access, <a href="database-administration.html#connection-access">Access Control, Stage 1: Connection Verification</a></dt><dt>control flow functions, <a href="functions.html#control-flow-functions">Control Flow Functions</a></dt><dt>CONV(), <a href="functions.html#string-functions">String Functions</a></dt><dt>conventions</dt><dd><dl><dt>typographical, <a href="introduction.html#manual-conventions">Conventions Used in This Manual</a></dt></dl></dd><dt>CONVERT, <a href="functions.html#cast-functions">Cast Functions and Operators</a></dt><dt>CONVERT TO, <a href="sql-syntax.html#alter-table">ALTER TABLE Syntax</a></dt><dt>CONVERT_TZ(), <a href="functions.html#date-and-time-functions">Date and Time Functions</a></dt><dt>ConvexHull(), <a href="spatial-extensions-in-mysql.html#spatial-operators">Spatial Operators</a></dt><dt>copying databases, <a href="installing.html#upgrading-to-arch">Copying MySQL Databases to Another Machine</a></dt><dt>copying tables, <a href="sql-syntax.html#create-table">CREATE TABLE Syntax</a></dt><dt>COS(), <a href="functions.html#mathematical-functions">Mathematical Functions</a></dt><dt>COT(), <a href="functions.html#mathematical-functions">Mathematical Functions</a></dt><dt>COUNT(), <a href="functions.html#group-by-functions">GROUP BY (Aggregate) Functions</a></dt><dt>COUNT(DISTINCT), <a href="functions.html#group-by-functions">GROUP BY (Aggregate) Functions</a></dt><dt>counting</dt><dd><dl><dt>table rows, <a href="tutorial.html#counting-rows">Counting Rows</a></dt></dl></dd><dt>crash, <a href="porting.html#debugging-server">Debugging a MySQL Server</a></dt><dd><dl><dt>recovery, <a href="database-administration.html#crash-recovery">Using myisamchk for Crash Recovery</a></dt><dt>repeated, <a href="problems.html#crashing">What to Do If MySQL Keeps Crashing</a></dt></dl></dd><dt>crash-me, <a href="optimization.html#mysql-benchmarks">The MySQL Benchmark Suite</a></dt><dt>crash-me program, <a href="optimization.html#portability">Designing Applications for Portability</a>, <a href="optimization.html#mysql-benchmarks">The MySQL Benchmark Suite</a></dt><dt>CRC32(), <a href="functions.html#mathematical-functions">Mathematical Functions</a></dt><dt>CREATE DATABASE, <a href="sql-syntax.html#create-database">CREATE DATABASE Syntax</a></dt><dt>CREATE FUNCTION, <a href="stored-procedures.html#create-procedure">CREATE PROCEDURE and CREATE FUNCTION</a>, <a href="extending-mysql.html#create-function">CREATE FUNCTION/DROP FUNCTION Syntax</a></dt><dt>CREATE INDEX, <a href="sql-syntax.html#create-index">CREATE INDEX Syntax</a></dt><dt>CREATE PROCEDURE, <a href="stored-procedures.html#create-procedure">CREATE PROCEDURE and CREATE FUNCTION</a></dt><dt>CREATE SCHEMA, <a href="sql-syntax.html#create-database">CREATE DATABASE Syntax</a></dt><dt>CREATE TABLE, <a href="sql-syntax.html#create-table">CREATE TABLE Syntax</a></dt><dt>CREATE USER, <a href="sql-syntax.html#create-user">CREATE USER Syntax</a></dt><dt>CREATE VIEW, <a href="views.html#create-view">CREATE VIEW Syntax</a></dt><dt>creating</dt><dd><dl><dt>bug reports, <a href="introduction.html#bug-reports">How to Report Bugs or Problems</a></dt><dt>database, <a href="sql-syntax.html#create-database">CREATE DATABASE Syntax</a></dt><dt>databases, <a href="tutorial.html#database-use">Creating and Using a Database</a></dt><dt>default startup options, <a href="using-mysql-programs.html#option-files">Using Option Files</a></dt><dt>schema, <a href="sql-syntax.html#create-database">CREATE DATABASE Syntax</a></dt><dt>tables, <a href="tutorial.html#creating-tables">Creating a Table</a></dt></dl></dd><dt>creating user accounts, <a href="sql-syntax.html#create-user">CREATE USER Syntax</a></dt><dt>CROSS JOIN, <a href="sql-syntax.html#join">JOIN Syntax</a></dt><dt>Crosses(), <a href="spatial-extensions-in-mysql.html#functions-that-test-spatial-relationships-between-geometries">Functions That Test Spatial Relationships Between Geometries</a></dt><dt>CR_SERVER_GONE_ERROR, <a href="problems.html#gone-away">MySQL server has gone away</a></dt><dt>CR_SERVER_LOST_ERROR, <a href="problems.html#gone-away">MySQL server has gone away</a></dt><dt>CSV storage engine, <a href="storage-engines.html">Storage Engines and Table Types</a>, <a href="storage-engines.html#csv-storage-engine">The CSV Storage Engine</a></dt><dt>CSV table type, <a href="storage-engines.html">Storage Engines and Table Types</a>, <a href="storage-engines.html#csv-storage-engine">The CSV Storage Engine</a></dt><dt>CURDATE(), <a href="functions.html#date-and-time-functions">Date and Time Functions</a></dt><dt>CURRENT_DATE, <a href="functions.html#date-and-time-functions">Date and Time Functions</a></dt><dt>CURRENT_TIME, <a href="functions.html#date-and-time-functions">Date and Time Functions</a></dt><dt>CURRENT_TIMESTAMP, <a href="functions.html#date-and-time-functions">Date and Time Functions</a></dt><dt>CURRENT_USER(), <a href="functions.html#information-functions">Information Functions</a></dt><dt>Cursors, <a href="stored-procedures.html#cursors">Cursors</a></dt><dt>CURTIME(), <a href="functions.html#date-and-time-functions">Date and Time Functions</a></dt><dt>customer support</dt><dd><dl><dt>mailing address, <a href="introduction.html#bug-reports">How to Report Bugs or Problems</a></dt></dl></dd><dt>customers</dt><dd><dl><dt>of MySQL, <a href="optimization.html#internal-use">What We Have Used MySQL For</a></dt></dl></dd><dt>CXX environment variable, <a href="installing.html#configure-options">Typical configure Options</a>, <a href="installing.html#compilation-problems">Dealing with Problems Compiling MySQL</a>, <a href="environment-variables.html">Environment Variables</a></dt><dt>CXXFLAGS environment variable, <a href="installing.html#configure-options">Typical configure Options</a>, <a href="installing.html#compilation-problems">Dealing with Problems Compiling MySQL</a>, <a href="environment-variables.html">Environment Variables</a></dt></dl></div><div class="indexdiv"><h3>D</h3><dl><dt>data</dt><dd><dl><dt>character sets, <a href="database-administration.html#character-sets">The Character Set Used for Data and Sorting</a></dt><dt>loading into tables, <a href="tutorial.html#loading-tables">Loading Data into a Table</a></dt><dt>retrieving, <a href="tutorial.html#retrieving-data">Retrieving Information from a Table</a></dt><dt>size, <a href="optimization.html#data-size">Make Your Data as Small as Possible</a></dt></dl></dd><dt>data type</dt><dd><dl><dt>BIGINT, <a href="column-types.html#numeric-type-overview">Overview of Numeric Types</a></dt><dt>BINARY, <a href="column-types.html#string-type-overview">Overview of String Types</a>, <a href="column-types.html#binary-varbinary">The BINARY and VARBINARY Types</a></dt><dt>BIT, <a href="column-types.html#numeric-type-overview">Overview of Numeric Types</a></dt><dt>BLOB, <a href="column-types.html#string-type-overview">Overview of String Types</a>, <a href="column-types.html#blob">The BLOB and TEXT Types</a></dt><dt>BOOL, <a href="column-types.html#numeric-type-overview">Overview of Numeric Types</a>, <a href="column-types.html#other-vendor-column-types">Using Column Types from Other Database Engines</a></dt><dt>BOOLEAN, <a href="column-types.html#numeric-type-overview">Overview of Numeric Types</a>, <a href="column-types.html#other-vendor-column-types">Using Column Types from Other Database Engines</a></dt><dt>CHAR, <a href="column-types.html#string-type-overview">Overview of String Types</a>, <a href="column-types.html#string-types">String Types</a></dt><dt>CHAR VARYING, <a href="column-types.html#string-type-overview">Overview of String Types</a></dt><dt>CHARACTER, <a href="column-types.html#string-type-overview">Overview of String Types</a></dt><dt>CHARACTER VARYING, <a href="column-types.html#string-type-overview">Overview of String Types</a></dt><dt>DATE, <a href="column-types.html#date-and-time-type-overview">Overview of Date and Time Types</a>, <a href="column-types.html#datetime">The DATETIME, DATE, and TIMESTAMP Types</a></dt><dt>DATETIME, <a href="column-types.html#date-and-time-type-overview">Overview of Date and Time Types</a>, <a href="column-types.html#datetime">The DATETIME, DATE, and TIMESTAMP Types</a></dt><dt>DEC, <a href="column-types.html#numeric-type-overview">Overview of Numeric Types</a></dt><dt>DECIMAL, <a href="column-types.html#numeric-type-overview">Overview of Numeric Types</a>, <a href="precision-math.html">Precision Math</a></dt><dt>DOUBLE, <a href="column-types.html#numeric-type-overview">Overview of Numeric Types</a></dt><dt>DOUBLE PRECISION, <a href="column-types.html#numeric-type-overview">Overview of Numeric Types</a></dt><dt>ENUM, <a href="column-types.html#string-type-overview">Overview of String Types</a>, <a href="column-types.html#enum">The ENUM Type</a></dt><dt>FIXED, <a href="column-types.html#numeric-type-overview">Overview of Numeric Types</a></dt><dt>FLOAT, <a href="column-types.html#numeric-type-overview">Overview of Numeric Types</a></dt><dt>GEOMETRY, <a href="spatial-extensions-in-mysql.html#mysql-spatial-datatypes">MySQL Spatial Data Types</a></dt><dt>GEOMETRYCOLLECTION, <a href="spatial-extensions-in-mysql.html#mysql-spatial-datatypes">MySQL Spatial Data Types</a></dt><dt>INT, <a href="column-types.html#numeric-type-overview">Overview of Numeric Types</a></dt><dt>INTEGER, <a href="column-types.html#numeric-type-overview">Overview of Numeric Types</a></dt><dt>LINESTRING, <a href="spatial-extensions-in-mysql.html#mysql-spatial-datatypes">MySQL Spatial Data Types</a></dt><dt>LONG, <a href="column-types.html#blob">The BLOB and TEXT Types</a></dt><dt>LONGBLOB, <a href="column-types.html#string-type-overview">Overview of String Types</a></dt><dt>LONGTEXT, <a href="column-types.html#string-type-overview">Overview of String Types</a></dt><dt>MEDIUMBLOB, <a href="column-types.html#string-type-overview">Overview of String Types</a></dt><dt>MEDIUMINT, <a href="column-types.html#numeric-type-overview">Overview of Numeric Types</a></dt><dt>MEDIUMTEXT, <a href="column-types.html#string-type-overview">Overview of String Types</a></dt><dt>MULTILINESTRING, <a href="spatial-extensions-in-mysql.html#mysql-spatial-datatypes">MySQL Spatial Data Types</a></dt><dt>MULTIPOINT, <a href="spatial-extensions-in-mysql.html#mysql-spatial-datatypes">MySQL Spatial Data Types</a></dt><dt>MULTIPOLYGON, <a href="spatial-extensions-in-mysql.html#mysql-spatial-datatypes">MySQL Spatial Data Types</a></dt><dt>NATIONAL CHAR, <a href="column-types.html#string-type-overview">Overview of String Types</a></dt><dt>NCHAR, <a href="column-types.html#string-type-overview">Overview of String Types</a></dt><dt>NUMERIC, <a href="column-types.html#numeric-type-overview">Overview of Numeric Types</a></dt><dt>POINT, <a href="spatial-extensions-in-mysql.html#mysql-spatial-datatypes">MySQL Spatial Data Types</a></dt><dt>POLYGON, <a href="spatial-extensions-in-mysql.html#mysql-spatial-datatypes">MySQL Spatial Data Types</a></dt><dt>REAL, <a href="column-types.html#numeric-type-overview">Overview of Numeric Types</a></dt><dt>SET, <a href="column-types.html#string-type-overview">Overview of String Types</a>, <a href="column-types.html#set">The SET Type</a></dt><dt>SMALLINT, <a href="column-types.html#numeric-type-overview">Overview of Numeric Types</a></dt><dt>TEXT, <a href="column-types.html#string-type-overview">Overview of String Types</a>, <a href="column-types.html#blob">The BLOB and TEXT Types</a></dt><dt>TIME, <a href="column-types.html#date-and-time-type-overview">Overview of Date and Time Types</a>, <a href="column-types.html#time">The TIME Type</a></dt><dt>TIMESTAMP, <a href="column-types.html#date-and-time-type-overview">Overview of Date and Time Types</a>, <a href="column-types.html#datetime">The DATETIME, DATE, and TIMESTAMP Types</a></dt><dt>TINYBLOB, <a href="column-types.html#string-type-overview">Overview of String Types</a></dt><dt>TINYINT, <a href="column-types.html#numeric-type-overview">Overview of Numeric Types</a></dt><dt>TINYTEXT, <a href="column-types.html#string-type-overview">Overview of String Types</a></dt><dt>VARBINARY, <a href="column-types.html#string-type-overview">Overview of String Types</a>, <a href="column-types.html#binary-varbinary">The BINARY and VARBINARY Types</a></dt><dt>VARCHAR, <a href="column-types.html#string-type-overview">Overview of String Types</a>, <a href="column-types.html#string-types">String Types</a></dt><dt>VARCHARACTER, <a href="column-types.html#string-type-overview">Overview of String Types</a></dt><dt>YEAR, <a href="column-types.html#date-and-time-type-overview">Overview of Date and Time Types</a>, <a href="column-types.html#year">The YEAR Type</a></dt></dl></dd><dt>data types, <a href="column-types.html">Column Types</a></dt><dd><dl><dt>C API, <a href="apis.html#c">MySQL C API</a></dt><dt>overview, <a href="column-types.html#column-type-overview">Column Type Overview</a></dt></dl></dd><dt>database</dt><dd><dl><dt>altering, <a href="sql-syntax.html#alter-database">ALTER DATABASE Syntax</a></dt><dt>creating, <a href="sql-syntax.html#create-database">CREATE DATABASE Syntax</a></dt><dt>deleting, <a href="sql-syntax.html#drop-database">DROP DATABASE Syntax</a></dt><dt>mysql option, <a href="client-side-scripts.html#mysql-command-options">Options</a></dt></dl></dd><dt>database design, <a href="optimization.html#design">Design Choices</a></dt><dt>Database information</dt><dd><dl><dt>obtaining, <a href="sql-syntax.html#show">SHOW Syntax</a></dt></dl></dd><dt>database metadata, <a href="information-schema.html">The INFORMATION_SCHEMA Information Database</a></dt><dt>database names</dt><dd><dl><dt>case sensitivity, <a href="language-structure.html#name-case-sensitivity">Identifier Case Sensitivity</a></dt><dt>case-sensitivity, <a href="introduction.html#extensions-to-ansi">MySQL Extensions to Standard SQL</a></dt></dl></dd><dt>DATABASE(), <a href="functions.html#information-functions">Information Functions</a></dt><dt>databases</dt><dd><dl><dt>backups, <a href="database-administration.html#backup">Database Backups</a></dt><dt>copying, <a href="installing.html#upgrading-to-arch">Copying MySQL Databases to Another Machine</a></dt><dt>creating, <a href="tutorial.html#database-use">Creating and Using a Database</a></dt><dt>defined, <a href="introduction.html#what-is">Overview of the MySQL Database Management System</a></dt><dt>information about, <a href="tutorial.html#getting-information">Getting Information About Databases and Tables</a></dt><dt>names, <a href="language-structure.html#legal-names">Database, Table, Index, Column, and Alias Names</a></dt><dt>replicating, <a href="replication.html">Replication in MySQL</a></dt><dt>selecting, <a href="tutorial.html#creating-database">Creating and Selecting a Database</a></dt><dt>symbolic links, <a href="optimization.html#symbolic-links-to-databases">Using Symbolic Links for Databases on Unix</a></dt><dt>using, <a href="tutorial.html#database-use">Creating and Using a Database</a></dt></dl></dd><dt>DataJunction, <a href="connectors.html#programs-known-to-work-with-myodbc">Programs Known to Work With MyODBC</a></dt><dt>DATE, <a href="problems.html#using-date">Problems Using DATE Columns</a></dt><dt>date and time functions, <a href="functions.html#date-and-time-functions">Date and Time Functions</a></dt><dt>Date and Time types, <a href="column-types.html#date-and-time-types">Date and Time Types</a></dt><dt>date calculations, <a href="tutorial.html#date-calculations">Date Calculations</a></dt><dt>DATE columns</dt><dd><dl><dt>problems, <a href="problems.html#using-date">Problems Using DATE Columns</a></dt></dl></dd><dt>DATE data type, <a href="column-types.html#date-and-time-type-overview">Overview of Date and Time Types</a>, <a href="column-types.html#datetime">The DATETIME, DATE, and TIMESTAMP Types</a></dt><dt>date functions</dt><dd><dl><dt>Y2K compliance, <a href="introduction.html#year-2000-compliance">Year 2000 Compliance</a></dt></dl></dd><dt>date types, <a href="column-types.html#storage-requirements">Column Type Storage Requirements</a></dt><dd><dl><dt>Y2K issues, <a href="column-types.html#y2k-issues">Y2K Issues and Date Types</a></dt></dl></dd><dt>date values</dt><dd><dl><dt>problems, <a href="column-types.html#datetime">The DATETIME, DATE, and TIMESTAMP Types</a></dt></dl></dd><dt>DATE(), <a href="functions.html#date-and-time-functions">Date and Time Functions</a></dt><dt>DATEDIFF(), <a href="functions.html#date-and-time-functions">Date and Time Functions</a></dt><dt>DATETIME data type, <a href="column-types.html#date-and-time-type-overview">Overview of Date and Time Types</a>, <a href="column-types.html#datetime">The DATETIME, DATE, and TIMESTAMP Types</a></dt><dt>DATE_ADD(), <a href="functions.html#date-and-time-functions">Date and Time Functions</a></dt><dt>DATE_FORMAT(), <a href="functions.html#date-and-time-functions">Date and Time Functions</a></dt><dt>DATE_SUB(), <a href="functions.html#date-and-time-functions">Date and Time Functions</a></dt><dt>DAY(), <a href="functions.html#date-and-time-functions">Date and Time Functions</a></dt><dt>DAYNAME(), <a href="functions.html#date-and-time-functions">Date and Time Functions</a></dt><dt>DAYOFMONTH(), <a href="functions.html#date-and-time-functions">Date and Time Functions</a></dt><dt>DAYOFWEEK(), <a href="functions.html#date-and-time-functions">Date and Time Functions</a></dt><dt>DAYOFYEAR(), <a href="functions.html#date-and-time-functions">Date and Time Functions</a></dt><dt>db table</dt><dd><dl><dt>sorting, <a href="database-administration.html#request-access">Access Control, Stage 2: Request Verification</a></dt></dl></dd><dt>DB2 SQL mode, <a href="database-administration.html#server-sql-mode">The Server SQL Mode</a></dt><dt>DBI interface, <a href="apis.html#perl">MySQL Perl API</a></dt><dt>DBI->quote, <a href="language-structure.html#string-syntax">Strings</a></dt><dt>DBI->trace, <a href="porting.html#using-gdb-on-mysqld">Debugging mysqld under gdb</a></dt><dt>DBI/DBD interface, <a href="apis.html#perl">MySQL Perl API</a></dt><dt>DBI_TRACE environment variable, <a href="porting.html#using-gdb-on-mysqld">Debugging mysqld under gdb</a>, <a href="environment-variables.html">Environment Variables</a></dt><dt>DBI_USER environment variable, <a href="environment-variables.html">Environment Variables</a></dt><dt>DBUG package, <a href="porting.html#the-dbug-package">The DBUG Package</a></dt><dt>DEALLOCATE PREPARE, <a href="sql-syntax.html#sqlps">SQL Syntax for Prepared Statements</a></dt><dt>debug</dt><dd><dl><dt>mysql option, <a href="client-side-scripts.html#mysql-command-options">Options</a></dt></dl></dd><dt>debug-info</dt><dd><dl><dt>mysql option, <a href="client-side-scripts.html#mysql-command-options">Options</a></dt></dl></dd><dt>debugging</dt><dd><dl><dt>client, <a href="porting.html#debugging-client">Debugging a MySQL Client</a></dt><dt>server, <a href="porting.html#debugging-server">Debugging a MySQL Server</a></dt></dl></dd><dt>DEC data type, <a href="column-types.html#numeric-type-overview">Overview of Numeric Types</a></dt><dt>decimal arithmetic, <a href="precision-math.html">Precision Math</a></dt><dt>DECIMAL data type, <a href="column-types.html#numeric-type-overview">Overview of Numeric Types</a>, <a href="precision-math.html">Precision Math</a></dt><dt>decimal point, <a href="column-types.html">Column Types</a></dt><dt>DECLARE, <a href="stored-procedures.html#declare">DECLARE Statement</a></dt><dt>DECODE(), <a href="functions.html#encryption-functions">Encryption Functions</a></dt><dt>decode_bits myisamchk variable, <a href="database-administration.html#myisamchk-general-options">General Options for myisamchk</a></dt><dt>DEFAULT</dt><dd><dl><dt>constraint, <a href="introduction.html#constraint-invalid-data">Constraints on Invalid Data</a></dt></dl></dd><dt>default</dt><dd><dl><dt>privileges, <a href="installing.html#default-privileges">Securing the Initial MySQL Accounts</a></dt></dl></dd><dt>default hostname, <a href="database-administration.html#connecting">Connecting to the MySQL Server</a></dt><dt>default installation location, <a href="installing.html#installation-layouts">Installation Layouts</a></dt><dt>default options, <a href="using-mysql-programs.html#option-files">Using Option Files</a></dt><dt>DEFAULT value clause, <a href="sql-syntax.html#create-table">CREATE TABLE Syntax</a></dt><dt>default values, <a href="optimization.html#design-limitations">MySQL Design Limitations and Tradeoffs</a>, <a href="sql-syntax.html#create-table">CREATE TABLE Syntax</a>, <a href="sql-syntax.html#insert">INSERT Syntax</a></dt><dd><dl><dt>BLOB and TEXT columns, <a href="column-types.html#blob">The BLOB and TEXT Types</a></dt><dt>implicit, <a href="sql-syntax.html#create-table">CREATE TABLE Syntax</a></dt><dt>suppression, <a href="introduction.html#constraint-invalid-data">Constraints on Invalid Data</a></dt></dl></dd><dt>DEFAULT(), <a href="functions.html#miscellaneous-functions">Miscellaneous Functions</a></dt><dt>default-character-set</dt><dd><dl><dt>mysql option, <a href="client-side-scripts.html#mysql-command-options">Options</a></dt></dl></dd><dt>defaults</dt><dd><dl><dt>embedded, <a href="apis.html#libmysqld-options">Options with the Embedded Server</a></dt></dl></dd><dt>DEGREES(), <a href="functions.html#mathematical-functions">Mathematical Functions</a></dt><dt>DELAYED, <a href="sql-syntax.html#insert-delayed">INSERT DELAYED Syntax</a></dt><dt>delayed_insert_limit, <a href="sql-syntax.html#insert-delayed">INSERT DELAYED Syntax</a></dt><dt>DELETE, <a href="sql-syntax.html#delete">DELETE Syntax</a></dt><dt>deleting</dt><dd><dl><dt>database, <a href="sql-syntax.html#drop-database">DROP DATABASE Syntax</a></dt><dt>foreign key, <a href="sql-syntax.html#alter-table">ALTER TABLE Syntax</a>, <a href="storage-engines.html#innodb-foreign-key-constraints">FOREIGN KEY Constraints</a></dt><dt>function, <a href="extending-mysql.html#create-function">CREATE FUNCTION/DROP FUNCTION Syntax</a></dt><dt>index, <a href="sql-syntax.html#alter-table">ALTER TABLE Syntax</a>, <a href="sql-syntax.html#drop-index">DROP INDEX Syntax</a></dt><dt>primary key, <a href="sql-syntax.html#alter-table">ALTER TABLE Syntax</a></dt><dt>rows, <a href="problems.html#deleting-from-related-tables">Deleting Rows from Related Tables</a></dt><dt>schema, <a href="sql-syntax.html#drop-database">DROP DATABASE Syntax</a></dt><dt>table, <a href="sql-syntax.html#drop-table">DROP TABLE Syntax</a></dt><dt>user, <a href="database-administration.html#removing-users">Removing User Accounts from MySQL</a>, <a href="sql-syntax.html#drop-user">DROP USER Syntax</a></dt><dt>users, <a href="database-administration.html#removing-users">Removing User Accounts from MySQL</a>, <a href="sql-syntax.html#drop-user">DROP USER Syntax</a></dt></dl></dd><dt>deletion</dt><dd><dl><dt>mysql.sock, <a href="problems.html#problems-with-mysql-sock">How to Protect or Change the MySQL Socket File /tmp/mysql.sock</a></dt></dl></dd><dt>Delphi program, <a href="connectors.html#programs-known-to-work-with-myodbc">Programs Known to Work With MyODBC</a></dt><dt>derived tables, <a href="sql-syntax.html#unnamed-views">Subqueries in the FROM clause</a></dt><dt>DESC, <a href="sql-syntax.html#describe">DESCRIBE Syntax (Get Information About Columns)</a></dt><dt>DESCRIBE, <a href="tutorial.html#getting-information">Getting Information About Databases and Tables</a>, <a href="sql-syntax.html#describe">DESCRIBE Syntax (Get Information About Columns)</a></dt><dt>design</dt><dd><dl><dt>choices, <a href="optimization.html#design">Design Choices</a></dt><dt>issues, <a href="problems.html#bugs">Known Issues in MySQL</a></dt><dt>limitations, <a href="optimization.html#design-limitations">MySQL Design Limitations and Tradeoffs</a></dt></dl></dd><dt>DES_DECRYPT(), <a href="functions.html#encryption-functions">Encryption Functions</a></dt><dt>DES_ENCRYPT(), <a href="functions.html#encryption-functions">Encryption Functions</a></dt><dt>developers</dt><dd><dl><dt>list of, <a href="credits.html">Credits</a></dt></dl></dd><dt>development source tree, <a href="installing.html#installing-source-tree">Installing from the Development Source Tree</a></dt><dt>Difference(), <a href="spatial-extensions-in-mysql.html#spatial-operators">Spatial Operators</a></dt><dt>digits, <a href="column-types.html">Column Types</a></dt><dt>Dimension(), <a href="spatial-extensions-in-mysql.html#general-geometry-property-functions">General Geometry Functions</a></dt><dt>directory structure</dt><dd><dl><dt>default, <a href="installing.html#installation-layouts">Installation Layouts</a></dt></dl></dd><dt>DISCARD TABLESPACE, <a href="sql-syntax.html#alter-table">ALTER TABLE Syntax</a>, <a href="storage-engines.html#multiple-tablespaces">Using Per-Table Tablespaces</a></dt><dt>disconnecting</dt><dd><dl><dt>from the server, <a href="tutorial.html#connecting-disconnecting">Connecting to and Disconnecting from the Server</a></dt></dl></dd><dt>Disjoint(), <a href="spatial-extensions-in-mysql.html#functions-that-test-spatial-relationships-between-geometries">Functions That Test Spatial Relationships Between Geometries</a></dt><dt>disk full, <a href="problems.html#full-disk">How MySQL Handles a Full Disk</a></dt><dt>disk issues, <a href="optimization.html#disk-issues">Disk Issues</a></dt><dt>disks</dt><dd><dl><dt>splitting data across, <a href="optimization.html#windows-symbolic-links">Using Symbolic Links for Databases on Windows</a></dt></dl></dd><dt>display size, <a href="column-types.html">Column Types</a></dt><dt>display triggers, <a href="sql-syntax.html#show-triggers">SHOW TRIGGERS Syntax</a></dt><dt>display width, <a href="column-types.html">Column Types</a></dt><dt>displaying</dt><dd><dl><dt>information</dt><dd><dl><dt>Cardinality, <a href="sql-syntax.html#show-index">SHOW INDEX Syntax</a></dt><dt>Collation, <a href="sql-syntax.html#show-index">SHOW INDEX Syntax</a></dt><dt>SHOW, <a href="sql-syntax.html#show">SHOW Syntax</a>, <a href="sql-syntax.html#show-columns">SHOW COLUMNS Syntax</a>, <a href="sql-syntax.html#show-index">SHOW INDEX Syntax</a>, <a href="sql-syntax.html#show-open-tables">SHOW OPEN TABLES Syntax</a>, <a href="sql-syntax.html#show-tables">SHOW TABLES Syntax</a></dt></dl></dd><dt>table status, <a href="sql-syntax.html#show-table-status">SHOW TABLE STATUS Syntax</a></dt></dl></dd><dt>Distance(), <a href="spatial-extensions-in-mysql.html#functions-that-test-spatial-relationships-between-geometries">Functions That Test Spatial Relationships Between Geometries</a></dt><dt>DISTINCT, <a href="tutorial.html#selecting-columns">Selecting Particular Columns</a>, <a href="optimization.html#distinct-optimization">How MySQL Optimizes DISTINCT</a>, <a href="functions.html#group-by-functions">GROUP BY (Aggregate) Functions</a>, <a href="sql-syntax.html#select">SELECT Syntax</a></dt><dt>DISTINCTROW, <a href="sql-syntax.html#select">SELECT Syntax</a></dt><dt>DIV, <a href="functions.html#arithmetic-functions">Arithmetic Operators</a></dt><dt>division (/), <a href="functions.html#arithmetic-functions">Arithmetic Operators</a></dt><dt>DNS, <a href="optimization.html#dns">How MySQL Uses DNS</a></dt><dt>DO, <a href="sql-syntax.html#do">DO Syntax</a></dt><dt>DocBook XML</dt><dd><dl><dt>documentation source format, <a href="introduction.html#manual-info">About This Manual</a></dt></dl></dd><dt>Documenters</dt><dd><dl><dt>list of, <a href="credits.html#documenters-translators">Documenters and translators</a></dt></dl></dd><dt>DOUBLE data type, <a href="column-types.html#numeric-type-overview">Overview of Numeric Types</a></dt><dt>DOUBLE PRECISION data type, <a href="column-types.html#numeric-type-overview">Overview of Numeric Types</a></dt><dt>double quote (\"), <a href="language-structure.html#string-syntax">Strings</a></dt><dt>downgrading, <a href="installing.html#downgrading">Downgrading MySQL</a></dt><dt>downloading, <a href="installing.html#getting-mysql">How to Get MySQL</a></dt><dt>DROP DATABASE, <a href="sql-syntax.html#drop-database">DROP DATABASE Syntax</a></dt><dt>DROP FOREIGN KEY, <a href="sql-syntax.html#alter-table">ALTER TABLE Syntax</a>, <a href="storage-engines.html#innodb-foreign-key-constraints">FOREIGN KEY Constraints</a></dt><dt>DROP FUNCTION, <a href="stored-procedures.html#drop-procedure">DROP PROCEDURE and DROP FUNCTION</a>, <a href="extending-mysql.html#create-function">CREATE FUNCTION/DROP FUNCTION Syntax</a></dt><dt>DROP INDEX, <a href="sql-syntax.html#alter-table">ALTER TABLE Syntax</a>, <a href="sql-syntax.html#drop-index">DROP INDEX Syntax</a></dt><dt>DROP PRIMARY KEY, <a href="sql-syntax.html#alter-table">ALTER TABLE Syntax</a></dt><dt>DROP PROCEDURE, <a href="stored-procedures.html#drop-procedure">DROP PROCEDURE and DROP FUNCTION</a></dt><dt>DROP SCHEMA, <a href="sql-syntax.html#drop-database">DROP DATABASE Syntax</a></dt><dt>DROP TABLE, <a href="sql-syntax.html#drop-table">DROP TABLE Syntax</a></dt><dt>DROP USER, <a href="sql-syntax.html#drop-user">DROP USER Syntax</a></dt><dt>DROP VIEW, <a href="views.html#drop-view">DROP VIEW Syntax</a></dt><dt>dropping</dt><dd><dl><dt>user, <a href="database-administration.html#removing-users">Removing User Accounts from MySQL</a>, <a href="sql-syntax.html#drop-user">DROP USER Syntax</a></dt></dl></dd><dt>DUAL, <a href="sql-syntax.html#select">SELECT Syntax</a></dt><dt>DUMPFILE, <a href="sql-syntax.html#select">SELECT Syntax</a></dt><dt>dynamic table characteristics, <a href="storage-engines.html#dynamic-format">Dynamic Table Characteristics</a></dt></dl></div><div class="indexdiv"><h3>E</h3><dl><dt>Eiffel Wrapper, <a href="apis.html#eiffel">MySQL Eiffel Wrapper</a></dt><dt>ELT(), <a href="functions.html#string-functions">String Functions</a></dt><dt>email lists, <a href="introduction.html#mailing-list">The MySQL Mailing Lists</a></dt><dt>embedded MySQL server library, <a href="apis.html#libmysqld">libmysqld, the Embedded MySQL Server Library</a></dt><dt>ENCODE(), <a href="functions.html#encryption-functions">Encryption Functions</a></dt><dt>ENCRYPT(), <a href="functions.html#encryption-functions">Encryption Functions</a></dt><dt>encryption functions, <a href="functions.html#encryption-functions">Encryption Functions</a></dt><dt>END, <a href="stored-procedures.html#begin-end">BEGIN ... END Compound Statement</a></dt><dt>EndPoint(), <a href="spatial-extensions-in-mysql.html#linestring-property-functions">LineString Functions</a></dt><dt>entering</dt><dd><dl><dt>queries, <a href="tutorial.html#entering-queries">Entering Queries</a></dt></dl></dd><dt>ENUM</dt><dd><dl><dt>size, <a href="column-types.html#storage-requirements">Column Type Storage Requirements</a></dt></dl></dd><dt>ENUM data type, <a href="column-types.html#string-type-overview">Overview of String Types</a>, <a href="column-types.html#enum">The ENUM Type</a></dt><dt>Envelope(), <a href="spatial-extensions-in-mysql.html#general-geometry-property-functions">General Geometry Functions</a></dt><dt>environment variable</dt><dd><dl><dt>CC, <a href="installing.html#configure-options">Typical configure Options</a>, <a href="installing.html#compilation-problems">Dealing with Problems Compiling MySQL</a></dt><dt>CFLAGS, <a href="installing.html#configure-options">Typical configure Options</a>, <a href="installing.html#compilation-problems">Dealing with Problems Compiling MySQL</a></dt><dt>CXX, <a href="installing.html#configure-options">Typical configure Options</a>, <a href="installing.html#compilation-problems">Dealing with Problems Compiling MySQL</a></dt><dt>CXXFLAGS, <a href="installing.html#configure-options">Typical configure Options</a>, <a href="installing.html#compilation-problems">Dealing with Problems Compiling MySQL</a></dt><dt>HOME, <a href="client-side-scripts.html#mysql-command-options">Options</a></dt><dt>LD_RUN_PATH, <a href="installing.html#source-notes-linux">Linux Source Distribution Notes</a>, <a href="installing.html#solaris">Solaris Notes</a></dt><dt>MYSQL_DEBUG, <a href="client-side-scripts.html#client-side-overview">Overview of the Client-Side Scripts and Utilities</a></dt><dt>MYSQL_HISTFILE, <a href="client-side-scripts.html#mysql-command-options">Options</a></dt><dt>MYSQL_HOST, <a href="database-administration.html#connecting">Connecting to the MySQL Server</a></dt><dt>MYSQL_PWD, <a href="database-administration.html#connecting">Connecting to the MySQL Server</a>, <a href="client-side-scripts.html#client-side-overview">Overview of the Client-Side Scripts and Utilities</a></dt><dt>MYSQL_TCP_PORT, <a href="database-administration.html#multiple-unix-servers">Running Multiple Servers on Unix</a>, <a href="database-administration.html#multiple-server-clients">Using Client Programs in a Multiple-Server Environment</a>, <a href="client-side-scripts.html#client-side-overview">Overview of the Client-Side Scripts and Utilities</a></dt><dt>MYSQL_UNIX_PORT, <a href="database-administration.html#multiple-unix-servers">Running Multiple Servers on Unix</a>, <a href="database-administration.html#multiple-server-clients">Using Client Programs in a Multiple-Server Environment</a>, <a href="client-side-scripts.html#client-side-overview">Overview of the Client-Side Scripts and Utilities</a></dt><dt>PATH, <a href="installing.html#installing-binary">Installing MySQL on Other Unix-Like Systems</a>, <a href="using-mysql-programs.html#invoking-programs">Invoking MySQL Programs</a></dt><dt>USER, <a href="database-administration.html#connecting">Connecting to the MySQL Server</a></dt></dl></dd><dt>Environment variable</dt><dd><dl><dt>CC, <a href="environment-variables.html">Environment Variables</a></dt><dt>CFLAGS, <a href="environment-variables.html">Environment Variables</a></dt><dt>CXX, <a href="installing.html#compilation-problems">Dealing with Problems Compiling MySQL</a>, <a href="environment-variables.html">Environment Variables</a></dt><dt>CXXFLAGS, <a href="environment-variables.html">Environment Variables</a></dt><dt>DBI_TRACE, <a href="porting.html#using-gdb-on-mysqld">Debugging mysqld under gdb</a>, <a href="environment-variables.html">Environment Variables</a></dt><dt>DBI_USER, <a href="environment-variables.html">Environment Variables</a></dt><dt>HOME, <a href="environment-variables.html">Environment Variables</a></dt><dt>LD_LIBRARY_PATH, <a href="installing.html#perl-support-problems">Problems Using the Perl DBI/DBD Interface</a></dt><dt>LD_RUN_PATH, <a href="installing.html#perl-support-problems">Problems Using the Perl DBI/DBD Interface</a>, <a href="environment-variables.html">Environment Variables</a></dt><dt>MYSQL_DEBUG, <a href="porting.html#debugging-client">Debugging a MySQL Client</a>, <a href="environment-variables.html">Environment Variables</a></dt><dt>MYSQL_HISTFILE, <a href="environment-variables.html">Environment Variables</a></dt><dt>MYSQL_HOST, <a href="environment-variables.html">Environment Variables</a></dt><dt>MYSQL_PS1, <a href="environment-variables.html">Environment Variables</a></dt><dt>MYSQL_PWD, <a href="environment-variables.html">Environment Variables</a></dt><dt>MYSQL_TCP_PORT, <a href="environment-variables.html">Environment Variables</a></dt><dt>MYSQL_UNIX_PORT, <a href="installing.html#mysql-install-db">Problems Running mysql_install_db</a>, <a href="environment-variables.html">Environment Variables</a></dt><dt>PATH, <a href="environment-variables.html">Environment Variables</a></dt><dt>TMPDIR, <a href="installing.html#mysql-install-db">Problems Running mysql_install_db</a>, <a href="environment-variables.html">Environment Variables</a></dt><dt>TZ, <a href="problems.html#timezone-problems">Time Zone Problems</a>, <a href="environment-variables.html">Environment Variables</a></dt><dt>UMASK, <a href="problems.html#file-permissions">Problems with File Permissions</a>, <a href="environment-variables.html">Environment Variables</a></dt><dt>UMASK_DIR, <a href="problems.html#file-permissions">Problems with File Permissions</a>, <a href="environment-variables.html">Environment Variables</a></dt><dt>USER, <a href="environment-variables.html">Environment Variables</a></dt></dl></dd><dt>Environment variables</dt><dd><dl><dt>CXX, <a href="installing.html#compilation-problems">Dealing with Problems Compiling MySQL</a></dt></dl></dd><dt>environment variables, <a href="using-mysql-programs.html#environment-variable-options">Using Environment Variables to Specify Options</a>, <a href="database-administration.html#access-denied">Causes of Access denied Errors</a>, <a href="client-side-scripts.html#client-side-overview">Overview of the Client-Side Scripts and Utilities</a></dt><dd><dl><dt>list of, <a href="environment-variables.html">Environment Variables</a></dt></dl></dd><dt>equal (=), <a href="functions.html#comparison-operators">Comparison Functions and Operators</a></dt><dt>Equals(), <a href="spatial-extensions-in-mysql.html#functions-that-test-spatial-relationships-between-geometries">Functions That Test Spatial Relationships Between Geometries</a></dt><dt>error messages</dt><dd><dl><dt>can't find file, <a href="problems.html#file-permissions">Problems with File Permissions</a></dt><dt>languages, <a href="database-administration.html#languages">Setting the Error Message Language</a></dt></dl></dd><dt>errors</dt><dd><dl><dt>access denied, <a href="problems.html#error-access-denied">Access denied</a></dt><dt>checking tables for, <a href="database-administration.html#check">How to Check MyISAM Tables for Errors</a></dt><dt>common, <a href="problems.html">Problems and Common Errors</a></dt><dt>directory checksum, <a href="installing.html#solaris">Solaris Notes</a></dt><dt>handling for UDFs, <a href="extending-mysql.html#udf-return-values">UDF Return Values and Error Handling</a></dt><dt>known, <a href="problems.html#bugs">Known Issues in MySQL</a></dt><dt>linking, <a href="problems.html#link-errors">Problems Linking to the MySQL Client Library</a></dt><dt>list of, <a href="problems.html#common-errors">Common Errors When Using MySQL Programs</a></dt><dt>reporting, <a href="introduction.html">General Information</a>, <a href="introduction.html#questions">MySQL Mailing Lists</a>, <a href="introduction.html#bug-reports">How to Report Bugs or Problems</a></dt></dl></dd><dt>ERROR_FOR_DIVISION_BY_ZERO SQL mode, <a href="database-administration.html#server-sql-mode">The Server SQL Mode</a></dt><dt>escape (\\), <a href="language-structure.html#string-syntax">Strings</a></dt><dt>escape characters, <a href="language-structure.html#literals">Literal Values</a></dt><dt>estimating</dt><dd><dl><dt>query performance, <a href="optimization.html#estimating-performance">Estimating Query Performance</a></dt></dl></dd><dt>exact-value literals, <a href="precision-math.html">Precision Math</a></dt><dt>example</dt><dd><dl><dt>mysqld_multi option, <a href="database-administration.html#mysqld-multi">mysqld_multi — Program for Managing Multiple MySQL Servers</a></dt></dl></dd><dt>EXAMPLE storage engine, <a href="storage-engines.html">Storage Engines and Table Types</a>, <a href="storage-engines.html#example-storage-engine">The EXAMPLE Storage Engine</a></dt><dt>EXAMPLE table type, <a href="storage-engines.html">Storage Engines and Table Types</a>, <a href="storage-engines.html#example-storage-engine">The EXAMPLE Storage Engine</a></dt><dt>examples</dt><dd><dl><dt>compressed tables, <a href="client-side-scripts.html#myisampack">myisampack — Generate Compressed, Read-Only MyISAM Tables</a></dt><dt>myisamchk output, <a href="database-administration.html#table-info">Getting Information About a Table</a></dt><dt>queries, <a href="tutorial.html#examples">Examples of Common Queries</a></dt></dl></dd><dt>Excel, <a href="connectors.html#programs-known-to-work-with-myodbc">Programs Known to Work With MyODBC</a></dt><dt>execute</dt><dd><dl><dt>mysql option, <a href="client-side-scripts.html#mysql-command-options">Options</a></dt></dl></dd><dt>EXECUTE, <a href="sql-syntax.html#sqlps">SQL Syntax for Prepared Statements</a></dt><dt>EXP(), <a href="functions.html#mathematical-functions">Mathematical Functions</a></dt><dt>EXPLAIN, <a href="optimization.html#explain">EXPLAIN Syntax (Get Information About a SELECT)</a></dt><dt>EXPORT_SET(), <a href="functions.html#string-functions">String Functions</a></dt><dt>expression aliases, <a href="functions.html#group-by-hidden-fields">GROUP BY with Hidden Fields</a>, <a href="sql-syntax.html#select">SELECT Syntax</a></dt><dt>expressions</dt><dd><dl><dt>extended, <a href="tutorial.html#pattern-matching">Pattern Matching</a></dt></dl></dd><dt>extensions</dt><dd><dl><dt>to standard SQL, <a href="introduction.html#compatibility">MySQL Standards Compliance</a></dt></dl></dd><dt>ExteriorRing(), <a href="spatial-extensions-in-mysql.html#polygon-property-functions">Polygon Functions</a></dt><dt>EXTRACT(), <a href="functions.html#date-and-time-functions">Date and Time Functions</a></dt><dt>extracting</dt><dd><dl><dt>dates, <a href="tutorial.html#date-calculations">Date Calculations</a></dt></dl></dd></dl></div><div class="indexdiv"><h3>F</h3><dl><dt>FALSE, <a href="language-structure.html#number-syntax">Numbers</a></dt><dd><dl><dt>testing for, <a href="functions.html#comparison-operators">Comparison Functions and Operators</a></dt></dl></dd><dt>fatal signal 11, <a href="installing.html#compilation-problems">Dealing with Problems Compiling MySQL</a></dt><dt>features of MySQL, <a href="introduction.html#features">The Main Features of MySQL</a></dt><dt>FEDERATED storage engine, <a href="storage-engines.html">Storage Engines and Table Types</a>, <a href="storage-engines.html#federated-storage-engine">The FEDERATED Storage Engine</a></dt><dt>FEDERATED table type, <a href="storage-engines.html">Storage Engines and Table Types</a>, <a href="storage-engines.html#federated-storage-engine">The FEDERATED Storage Engine</a></dt><dt>FETCH, <a href="stored-procedures.html#fetch">Cursor FETCH Statement</a></dt><dt>field</dt><dd><dl><dt>changing, <a href="sql-syntax.html#alter-table">ALTER TABLE Syntax</a></dt></dl></dd><dt>FIELD(), <a href="functions.html#string-functions">String Functions</a></dt><dt>FILE, <a href="functions.html#string-functions">String Functions</a></dt><dt>files</dt><dd><dl><dt>binary log, <a href="database-administration.html#binary-log">The Binary Log</a></dt><dt>config.cache, <a href="installing.html#compilation-problems">Dealing with Problems Compiling MySQL</a></dt><dt>error messages, <a href="database-administration.html#languages">Setting the Error Message Language</a></dt><dt>log, <a href="installing.html#configure-options">Typical configure Options</a>, <a href="database-administration.html#log-file-maintenance">Log File Maintenance</a></dt><dt>my.cnf, <a href="replication.html#replication-features">Replication Features and Known Problems</a></dt><dt>not found message, <a href="problems.html#file-permissions">Problems with File Permissions</a></dt><dt>permissions, <a href="problems.html#file-permissions">Problems with File Permissions</a></dt><dt>query log, <a href="database-administration.html#query-log">The General Query Log</a></dt><dt>repairing, <a href="database-administration.html#myisamchk-repair-options">Repair Options for myisamchk</a></dt><dt>script, <a href="tutorial.html#batch-mode">Using mysql in Batch Mode</a></dt><dt>size limits, <a href="introduction.html#table-size">How Big MySQL Tables Can Be</a></dt><dt>slow query log, <a href="database-administration.html#slow-query-log">The Slow Query Log</a></dt><dt>tmp, <a href="installing.html#mysql-install-db">Problems Running mysql_install_db</a></dt><dt>update log (obsolete), <a href="database-administration.html#binary-log">The Binary Log</a></dt></dl></dd><dt>filesort optimization, <a href="optimization.html#order-by-optimization">How MySQL Optimizes ORDER BY</a></dt><dt>FIND_IN_SET(), <a href="functions.html#string-functions">String Functions</a></dt><dt>FIXED data type, <a href="column-types.html#numeric-type-overview">Overview of Numeric Types</a></dt><dt>fixed-point arithmetic, <a href="precision-math.html">Precision Math</a></dt><dt>FLOAT data type, <a href="column-types.html#numeric-type-overview">Overview of Numeric Types</a></dt><dt>floating-point number, <a href="column-types.html#numeric-type-overview">Overview of Numeric Types</a></dt><dt>floats, <a href="language-structure.html#number-syntax">Numbers</a></dt><dt>FLOOR(), <a href="functions.html#mathematical-functions">Mathematical Functions</a></dt><dt>FLUSH, <a href="sql-syntax.html#flush">FLUSH Syntax</a></dt><dt>flush tables, <a href="client-side-scripts.html#mysqladmin">mysqladmin — Client for Administering a MySQL Server</a></dt><dt>FOR UPDATE, <a href="sql-syntax.html#select">SELECT Syntax</a></dt><dt>force</dt><dd><dl><dt>mysql option, <a href="client-side-scripts.html#mysql-command-options">Options</a></dt></dl></dd><dt>FORCE INDEX, <a href="sql-syntax.html#select">SELECT Syntax</a>, <a href="sql-syntax.html#join">JOIN Syntax</a>, <a href="problems.html#optimizer-issues">Optimizer-Related Issues</a></dt><dt>FORCE KEY, <a href="sql-syntax.html#select">SELECT Syntax</a>, <a href="sql-syntax.html#join">JOIN Syntax</a></dt><dt>foreign key</dt><dd><dl><dt>constraint, <a href="introduction.html#constraint-primary-key">PRIMARY KEY and UNIQUE Index Constraints</a></dt><dt>deleting, <a href="sql-syntax.html#alter-table">ALTER TABLE Syntax</a>, <a href="storage-engines.html#innodb-foreign-key-constraints">FOREIGN KEY Constraints</a></dt></dl></dd><dt>foreign keys, <a href="introduction.html#ansi-diff-foreign-keys">Foreign Keys</a>, <a href="tutorial.html#example-foreign-keys">Using Foreign Keys</a>, <a href="sql-syntax.html#alter-table">ALTER TABLE Syntax</a></dt><dt>FORMAT(), <a href="functions.html#miscellaneous-functions">Miscellaneous Functions</a></dt><dt>Forums, <a href="introduction.html#forums">MySQL Community Support at the MySQL Forums</a></dt><dt>FOUND_ROWS(), <a href="functions.html#information-functions">Information Functions</a></dt><dt>FreeBSD troubleshooting, <a href="installing.html#compilation-problems">Dealing with Problems Compiling MySQL</a></dt><dt>FROM, <a href="sql-syntax.html#select">SELECT Syntax</a></dt><dt>FROM_DAYS(), <a href="functions.html#date-and-time-functions">Date and Time Functions</a></dt><dt>FROM_UNIXTIME(), <a href="functions.html#date-and-time-functions">Date and Time Functions</a></dt><dt>ft_max_word_len myisamchk variable, <a href="database-administration.html#myisamchk-general-options">General Options for myisamchk</a></dt><dt>ft_min_word_len myisamchk variable, <a href="database-administration.html#myisamchk-general-options">General Options for myisamchk</a></dt><dt>ft_stopword_file myisamchk
variable, <a href="database-administration.html#myisamchk-general-options">General Options for myisamchk</a></dt><dt>full disk, <a href="problems.html#full-disk">How MySQL Handles a Full Disk</a></dt><dt>full-text search, <a href="functions.html#fulltext-search">Full-Text Search Functions</a></dt><dt>FULLTEXT, <a href="functions.html#fulltext-search">Full-Text Search Functions</a></dt><dt>fulltext</dt><dd><dl><dt>stopword list, <a href="functions.html#fulltext-fine-tuning">Fine-Tuning MySQL Full-Text Search</a></dt></dl></dd><dt>function</dt><dd><dl><dt>deleting, <a href="extending-mysql.html#create-function">CREATE FUNCTION/DROP FUNCTION Syntax</a></dt></dl></dd><dt>functions, <a href="functions.html">Functions and Operators</a></dt><dd><dl><dt>arithmetic, <a href="functions.html#bit-functions">Bit Functions</a></dt><dt>bit, <a href="functions.html#bit-functions">Bit Functions</a></dt><dt>C API, <a href="apis.html#c-api-function-overview">C API Function Overview</a></dt><dt>C Prepared statement API, <a href="apis.html#c-api-prepared-statement-function-overview">C API Prepared Statement Function Overview</a></dt><dt>cast, <a href="functions.html#cast-functions">Cast Functions and Operators</a></dt><dt>control flow, <a href="functions.html#control-flow-functions">Control Flow Functions</a></dt><dt>date and time, <a href="functions.html#date-and-time-functions">Date and Time Functions</a></dt><dt>encryption, <a href="functions.html#encryption-functions">Encryption Functions</a></dt><dt>GROUP BY, <a href="functions.html#group-by-functions">GROUP BY (Aggregate) Functions</a></dt><dt>grouping, <a href="functions.html#parentheses">Parentheses</a></dt><dt>information, <a href="functions.html#information-functions">Information Functions</a></dt><dt>mathematical, <a href="functions.html#mathematical-functions">Mathematical Functions</a></dt><dt>miscellaneous, <a href="functions.html#miscellaneous-functions">Miscellaneous Functions</a></dt><dt>native</dt><dd><dl><dt>adding, <a href="extending-mysql.html#adding-native-function">Adding a New Native Function</a></dt></dl></dd><dt>new, <a href="extending-mysql.html#adding-functions">Adding New Functions to MySQL</a></dt><dt>string, <a href="functions.html#string-functions">String Functions</a></dt><dt>string comparison, <a href="functions.html#string-comparison-functions">String Comparison Functions</a></dt><dt>user-defined, <a href="extending-mysql.html#adding-functions">Adding New Functions to MySQL</a></dt><dd><dl><dt>adding, <a href="extending-mysql.html#adding-udf">Adding a New User-Defined Function</a></dt></dl></dd></dl></dd><dt>Functions</dt><dd><dl><dt>user-defined, <a href="extending-mysql.html#create-function">CREATE FUNCTION/DROP FUNCTION Syntax</a></dt></dl></dd><dt>functions for SELECT and WHERE
clauses, <a href="functions.html">Functions and Operators</a></dt><dt>Future development of MySQL Cluster, <a href="ndbcluster.html#mysql-cluster-roadmap">MySQL Cluster Development Roadmap</a></dt></dl></div><div class="indexdiv"><h3>G</h3><dl><dt>gcc, <a href="installing.html#configure-options">Typical configure Options</a></dt><dt>gdb</dt><dd><dl><dt>using, <a href="porting.html#using-gdb-on-mysqld">Debugging mysqld under gdb</a></dt></dl></dd><dt>general information, <a href="introduction.html">General Information</a></dt><dt>General Public License, <a href="introduction.html#what-is">Overview of the MySQL Database Management System</a></dt><dt>geographic feature, <a href="spatial-extensions-in-mysql.html#gis-introduction">Introduction</a></dt><dt>GeomCollFromText(), <a href="spatial-extensions-in-mysql.html#gis-wkt-functions">Creating Geometry Values Using WKT Functions</a></dt><dt>GeomCollFromWKB(), <a href="spatial-extensions-in-mysql.html#gis-wkb-functions">Creating Geometry Values Using WKB Functions</a></dt><dt>geometry, <a href="spatial-extensions-in-mysql.html#gis-introduction">Introduction</a></dt><dt>GEOMETRY data type, <a href="spatial-extensions-in-mysql.html#mysql-spatial-datatypes">MySQL Spatial Data Types</a></dt><dt>GEOMETRYCOLLECTION data type, <a href="spatial-extensions-in-mysql.html#mysql-spatial-datatypes">MySQL Spatial Data Types</a></dt><dt>GeometryCollection(), <a href="spatial-extensions-in-mysql.html#gis-mysql-specific-functions">Creating Geometry Values Using MySQL-Specific Functions</a></dt><dt>GeometryCollectionFromText(), <a href="spatial-extensions-in-mysql.html#gis-wkt-functions">Creating Geometry Values Using WKT Functions</a></dt><dt>GeometryCollectionFromWKB(), <a href="spatial-extensions-in-mysql.html#gis-wkb-functions">Creating Geometry Values Using WKB Functions</a></dt><dt>GeometryFromText(), <a href="spatial-extensions-in-mysql.html#gis-wkt-functions">Creating Geometry Values Using WKT Functions</a></dt><dt>GeometryFromWKB(), <a href="spatial-extensions-in-mysql.html#gis-wkb-functions">Creating Geometry Values Using WKB Functions</a></dt><dt>GeometryN(), <a href="spatial-extensions-in-mysql.html#geometrycollection-property-functions">GeometryCollection Functions</a></dt><dt>GeometryType(), <a href="spatial-extensions-in-mysql.html#general-geometry-property-functions">General Geometry Functions</a></dt><dt>GeomFromText(), <a href="spatial-extensions-in-mysql.html#gis-wkt-functions">Creating Geometry Values Using WKT Functions</a>, <a href="spatial-extensions-in-mysql.html#functions-to-convert-geometries-between-formats">Geometry Format Conversion Functions</a></dt><dt>GeomFromWKB(), <a href="spatial-extensions-in-mysql.html#gis-wkb-functions">Creating Geometry Values Using WKB Functions</a>, <a href="spatial-extensions-in-mysql.html#functions-to-convert-geometries-between-formats">Geometry Format Conversion Functions</a></dt><dt>geospatial feature, <a href="spatial-extensions-in-mysql.html#gis-introduction">Introduction</a></dt><dt>getting MySQL, <a href="installing.html#getting-mysql">How to Get MySQL</a></dt><dt>GET_FORMAT(), <a href="functions.html#date-and-time-functions">Date and Time Functions</a></dt><dt>GET_LOCK(), <a href="functions.html#miscellaneous-functions">Miscellaneous Functions</a></dt><dt>GIS, <a href="spatial-extensions-in-mysql.html">Spatial Extensions in MySQL</a>, <a href="spatial-extensions-in-mysql.html#gis-introduction">Introduction</a></dt><dt>GLength(), <a href="spatial-extensions-in-mysql.html#linestring-property-functions">LineString Functions</a>, <a href="spatial-extensions-in-mysql.html#multilinestring-property-functions">MultiLineString Functions</a></dt><dt>global privileges, <a href="sql-syntax.html#grant">GRANT and REVOKE Syntax</a></dt><dt>goals of MySQL, <a href="introduction.html#what-is">Overview of the MySQL Database Management System</a></dt><dt>GPL</dt><dd><dl><dt>General Public License, <a href="gpl-license.html">GNU General Public License</a></dt><dt>GNU General Public License, <a href="gpl-license.html">GNU General Public License</a></dt><dt>MySQL FLOSS License Exception, <a href="mysql-floss-license-exception.html">MySQL FLOSS License Exception</a></dt></dl></dd><dt>GRANT, <a href="sql-syntax.html#grant">GRANT and REVOKE Syntax</a></dt><dt>GRANT statement, <a href="database-administration.html#adding-users">Adding New User Accounts to MySQL</a>, <a href="database-administration.html#secure-grant">SSL GRANT Options</a></dt><dt>grant tables, <a href="database-administration.html#request-access">Access Control, Stage 2: Request Verification</a></dt><dd><dl><dt>re-creating, <a href="installing.html#unix-post-installation">Unix Post-Installation Procedures</a></dt><dt>sorting, <a href="database-administration.html#connection-access">Access Control, Stage 1: Connection Verification</a>, <a href="database-administration.html#request-access">Access Control, Stage 2: Request Verification</a></dt><dt>upgrading, <a href="installing.html#upgrading-grant-tables">Upgrading the Grant Tables</a></dt></dl></dd><dt>granting</dt><dd><dl><dt>privileges, <a href="sql-syntax.html#grant">GRANT and REVOKE Syntax</a></dt></dl></dd><dt>GRANTS, <a href="sql-syntax.html#show-grants">SHOW GRANTS Syntax</a></dt><dt>greater than (>), <a href="functions.html#comparison-operators">Comparison Functions and Operators</a></dt><dt>greater than or equal (>=), <a href="functions.html#comparison-operators">Comparison Functions and Operators</a></dt><dt>GREATEST(), <a href="functions.html#comparison-operators">Comparison Functions and Operators</a></dt><dt>GROUP BY, <a href="optimization.html#group-by-optimization">How MySQL Optimizes GROUP BY</a></dt><dd><dl><dt>aliases in, <a href="functions.html#group-by-hidden-fields">GROUP BY with Hidden Fields</a></dt><dt>extensions to standard SQL, <a href="functions.html#group-by-hidden-fields">GROUP BY with Hidden Fields</a>, <a href="sql-syntax.html#select">SELECT Syntax</a></dt></dl></dd><dt>GROUP BY functions, <a href="functions.html#group-by-functions">GROUP BY (Aggregate) Functions</a></dt><dt>grouping</dt><dd><dl><dt>expressions, <a href="functions.html#parentheses">Parentheses</a></dt></dl></dd><dt>GROUP_CONCAT(), <a href="functions.html#group-by-functions">GROUP BY (Aggregate) Functions</a></dt></dl></div><div class="indexdiv"><h3>H</h3><dl><dt>HANDLER, <a href="sql-syntax.html#handler">HANDLER Syntax</a></dt><dt>Handlers, <a href="stored-procedures.html#declare-handlers">DECLARE Handlers</a></dt><dt>handling</dt><dd><dl><dt>errors, <a href="extending-mysql.html#udf-return-values">UDF Return Values and Error Handling</a></dt></dl></dd><dt>HAVING, <a href="sql-syntax.html#select">SELECT Syntax</a></dt><dt>HEAP storage engine, <a href="storage-engines.html">Storage Engines and Table Types</a>, <a href="storage-engines.html#memory-storage-engine">The MEMORY (HEAP) Storage Engine</a></dt><dt>HEAP table type, <a href="storage-engines.html">Storage Engines and Table Types</a>, <a href="storage-engines.html#memory-storage-engine">The MEMORY (HEAP) Storage Engine</a></dt><dt>help</dt><dd><dl><dt>mysql option, <a href="client-side-scripts.html#mysql-command-options">Options</a></dt><dt>mysqld_multi option, <a href="database-administration.html#mysqld-multi">mysqld_multi — Program for Managing Multiple MySQL Servers</a></dt></dl></dd><dt>HEX(), <a href="functions.html#string-functions">String Functions</a></dt><dt>hexadecimal values, <a href="language-structure.html#hexadecimal-values">Hexadecimal Values</a></dt><dt>HIGH_NOT_PRECEDENCE SQL mode, <a href="database-administration.html#server-sql-mode">The Server SQL Mode</a></dt><dt>HIGH_PRIORITY, <a href="sql-syntax.html#select">SELECT Syntax</a></dt><dt>hints, <a href="introduction.html#extensions-to-ansi">MySQL Extensions to Standard SQL</a>, <a href="sql-syntax.html#select">SELECT Syntax</a>, <a href="sql-syntax.html#join">JOIN Syntax</a></dt><dd><dl><dt>index, <a href="sql-syntax.html#select">SELECT Syntax</a>, <a href="sql-syntax.html#join">JOIN Syntax</a></dt></dl></dd><dt>history of MySQL, <a href="introduction.html#history">History of MySQL</a></dt><dt>HOME environment variable, <a href="client-side-scripts.html#mysql-command-options">Options</a>, <a href="environment-variables.html">Environment Variables</a></dt><dt>host</dt><dd><dl><dt>mysql option, <a href="client-side-scripts.html#mysql-command-options">Options</a></dt></dl></dd><dt>host table, <a href="database-administration.html#request-access">Access Control, Stage 2: Request Verification</a></dt><dd><dl><dt>sorting, <a href="database-administration.html#request-access">Access Control, Stage 2: Request Verification</a></dt></dl></dd><dt>host.frm</dt><dd><dl><dt>problems finding, <a href="installing.html#unix-post-installation">Unix Post-Installation Procedures</a></dt></dl></dd><dt>hostname</dt><dd><dl><dt>default, <a href="database-administration.html#connecting">Connecting to the MySQL Server</a></dt></dl></dd><dt>hostname caching, <a href="optimization.html#dns">How MySQL Uses DNS</a></dt><dt>HOUR(), <a href="functions.html#date-and-time-functions">Date and Time Functions</a></dt><dt>html</dt><dd><dl><dt>mysql option, <a href="client-side-scripts.html#mysql-command-options">Options</a></dt></dl></dd></dl></div><div class="indexdiv"><h3>I</h3><dl><dt>ID</dt><dd><dl><dt>unique, <a href="apis.html#getting-unique-id">How to Get the Unique ID for the Last Inserted Row</a></dt></dl></dd><dt>identifiers, <a href="language-structure.html#legal-names">Database, Table, Index, Column, and Alias Names</a></dt><dd><dl><dt>case sensitivity, <a href="language-structure.html#name-case-sensitivity">Identifier Case Sensitivity</a></dt><dt>quoting, <a href="language-structure.html#legal-names">Database, Table, Index, Column, and Alias Names</a></dt></dl></dd><dt>IF, <a href="stored-procedures.html#if-statement">IF Statement</a></dt><dt>IF(), <a href="functions.html#control-flow-functions">Control Flow Functions</a></dt><dt>IFNULL(), <a href="functions.html#control-flow-functions">Control Flow Functions</a></dt><dt>IGNORE INDEX, <a href="sql-syntax.html#select">SELECT Syntax</a>, <a href="sql-syntax.html#join">JOIN Syntax</a></dt><dt>IGNORE KEY, <a href="sql-syntax.html#select">SELECT Syntax</a>, <a href="sql-syntax.html#join">JOIN Syntax</a></dt><dt>ignore-space</dt><dd><dl><dt>mysql option, <a href="client-side-scripts.html#mysql-command-options">Options</a></dt></dl></dd><dt>IGNORE_SPACE SQL mode, <a href="database-administration.html#server-sql-mode">The Server SQL Mode</a></dt><dt>implicit default values, <a href="sql-syntax.html#create-table">CREATE TABLE Syntax</a></dt><dt>IMPORT TABLESPACE, <a href="sql-syntax.html#alter-table">ALTER TABLE Syntax</a>, <a href="storage-engines.html#multiple-tablespaces">Using Per-Table Tablespaces</a></dt><dt>IN, <a href="functions.html#comparison-operators">Comparison Functions and Operators</a></dt><dt>increasing</dt><dd><dl><dt>performance, <a href="replication.html#replication-faq">Replication FAQ</a></dt></dl></dd><dt>increasing with replication</dt><dd><dl><dt>speed, <a href="replication.html">Replication in MySQL</a></dt></dl></dd><dt>index</dt><dd><dl><dt>deleting, <a href="sql-syntax.html#alter-table">ALTER TABLE Syntax</a>, <a href="sql-syntax.html#drop-index">DROP INDEX Syntax</a></dt></dl></dd><dt>index hints, <a href="sql-syntax.html#select">SELECT Syntax</a>, <a href="sql-syntax.html#join">JOIN Syntax</a></dt><dt>indexes, <a href="sql-syntax.html#create-index">CREATE INDEX Syntax</a></dt><dd><dl><dt>and BLOB columns, <a href="optimization.html#indexes">Column Indexes</a>, <a href="sql-syntax.html#create-table">CREATE TABLE Syntax</a></dt><dt>and IS NULL, <a href="optimization.html#mysql-indexes">How MySQL Uses Indexes</a></dt><dt>and LIKE, <a href="optimization.html#mysql-indexes">How MySQL Uses Indexes</a></dt><dt>and NULL values, <a href="sql-syntax.html#create-table">CREATE TABLE Syntax</a></dt><dt>and TEXT columns, <a href="optimization.html#indexes">Column Indexes</a>, <a href="sql-syntax.html#create-table">CREATE TABLE Syntax</a></dt><dt>assigning to key cache, <a href="sql-syntax.html#cache-index">CACHE INDEX Syntax</a></dt><dt>block size, <a href="database-administration.html#server-system-variables">Server System Variables</a></dt><dt>columns, <a href="optimization.html#indexes">Column Indexes</a></dt><dt>leftmost prefix of, <a href="optimization.html#mysql-indexes">How MySQL Uses Indexes</a></dt><dt>multi-column, <a href="optimization.html#multiple-column-indexes">Multiple-Column Indexes</a></dt><dt>multiple-part, <a href="sql-syntax.html#create-index">CREATE INDEX Syntax</a></dt><dt>names, <a href="language-structure.html#legal-names">Database, Table, Index, Column, and Alias Names</a></dt><dt>use of, <a href="optimization.html#mysql-indexes">How MySQL Uses Indexes</a></dt></dl></dd><dt>INET_ATON(), <a href="functions.html#miscellaneous-functions">Miscellaneous Functions</a></dt><dt>INET_NTOA(), <a href="functions.html#miscellaneous-functions">Miscellaneous Functions</a></dt><dt>information functions, <a href="functions.html#information-functions">Information Functions</a></dt><dt>INFORMATION_SCHEMA, <a href="information-schema.html">The INFORMATION_SCHEMA Information Database</a>, <a href="information-schema.html#information-schema-tables">INFORMATION_SCHEMA Tables</a></dt><dt>INNER JOIN, <a href="sql-syntax.html#join">JOIN Syntax</a></dt><dt>InnoDB, <a href="storage-engines.html#innodb-overview">InnoDB Overview</a></dt><dd><dl><dt>Solaris 10 x86_64 issues, <a href="installing.html#solaris">Solaris Notes</a></dt></dl></dd><dt>InnoDB storage engine, <a href="storage-engines.html">Storage Engines and Table Types</a>, <a href="storage-engines.html#innodb">The InnoDB Storage Engine</a></dt><dt>InnoDB table type, <a href="storage-engines.html">Storage Engines and Table Types</a>, <a href="storage-engines.html#innodb">The InnoDB Storage Engine</a></dt><dt>InnoDB tables, <a href="introduction.html#ansi-diff-transactions">Transactions and Atomic Operations</a></dt><dt>INSERT, <a href="optimization.html#insert-speed">Speed of INSERT Statements</a>, <a href="sql-syntax.html#insert">INSERT Syntax</a></dt><dt>INSERT ... SELECT, <a href="sql-syntax.html#insert">INSERT Syntax</a></dt><dt>INSERT DELAYED, <a href="sql-syntax.html#insert-delayed">INSERT DELAYED Syntax</a></dt><dt>INSERT statement</dt><dd><dl><dt>grant privileges, <a href="database-administration.html#adding-users">Adding New User Accounts to MySQL</a></dt></dl></dd><dt>INSERT(), <a href="functions.html#string-functions">String Functions</a></dt><dt>inserting</dt><dd><dl><dt>speed of, <a href="optimization.html#insert-speed">Speed of INSERT Statements</a></dt></dl></dd><dt>installation layouts, <a href="installing.html#installation-layouts">Installation Layouts</a></dt><dt>installation overview, <a href="installing.html#installing-source">MySQL Installation Using a Source Distribution</a></dt><dt>installing</dt><dd><dl><dt>binary distribution, <a href="installing.html#installing-binary">Installing MySQL on Other Unix-Like Systems</a></dt><dt>Linux RPM packages, <a href="installing.html#linux-rpm">Installing MySQL on Linux</a></dt><dt>Mac OS X PKG packages, <a href="installing.html#mac-os-x-installation">Installing MySQL on Mac OS X</a></dt><dt>overview, <a href="installing.html">Installing MySQL</a></dt><dt>Perl, <a href="installing.html#perl-support">Perl Installation Notes</a></dt><dt>Perl on Windows, <a href="installing.html#activestate-perl">Installing ActiveState Perl on Windows</a></dt><dt>source distribution, <a href="installing.html#installing-source">MySQL Installation Using a Source Distribution</a></dt><dt>user-defined functions, <a href="extending-mysql.html#udf-compiling">Compiling and Installing User-Defined Functions</a></dt></dl></dd><dt>INSTR(), <a href="functions.html#string-functions">String Functions</a></dt><dt>INT data type, <a href="column-types.html#numeric-type-overview">Overview of Numeric Types</a></dt><dt>integer arithmetic, <a href="precision-math.html">Precision Math</a></dt><dt>INTEGER data type, <a href="column-types.html#numeric-type-overview">Overview of Numeric Types</a></dt><dt>integers, <a href="language-structure.html#number-syntax">Numbers</a></dt><dt>InteriorRingN(), <a href="spatial-extensions-in-mysql.html#polygon-property-functions">Polygon Functions</a></dt><dt>internal compiler errors, <a href="installing.html#compilation-problems">Dealing with Problems Compiling MySQL</a></dt><dt>internal locking, <a href="optimization.html#internal-locking">Locking Methods</a></dt><dt>internals, <a href="extending-mysql.html#mysql-internals">MySQL Internals</a></dt><dt>Internet Relay Chat, <a href="introduction.html#irc">MySQL Community Support on IRC (Internet Relay Chat)</a></dt><dt>Intersection(), <a href="spatial-extensions-in-mysql.html#spatial-operators">Spatial Operators</a></dt><dt>Intersects(), <a href="spatial-extensions-in-mysql.html#functions-that-test-spatial-relationships-between-geometries">Functions That Test Spatial Relationships Between Geometries</a></dt><dt>INTERVAL(), <a href="functions.html#comparison-operators">Comparison Functions and Operators</a></dt><dt>introducer</dt><dd><dl><dt>string literal, <a href="language-structure.html#string-syntax">Strings</a>, <a href="charset.html#charset-literal">Character String Literal Character Set and Collation</a></dt></dl></dd><dt>invalid data</dt><dd><dl><dt>constraint, <a href="introduction.html#constraint-invalid-data">Constraints on Invalid Data</a></dt></dl></dd><dt>IRC, <a href="introduction.html#irc">MySQL Community Support on IRC (Internet Relay Chat)</a></dt><dt>IS boolean_value, <a href="functions.html#comparison-operators">Comparison Functions and Operators</a></dt><dt>IS NOT boolean_value, <a href="functions.html#comparison-operators">Comparison Functions and Operators</a></dt><dt>IS NOT NULL, <a href="functions.html#comparison-operators">Comparison Functions and Operators</a></dt><dt>IS NULL, <a href="optimization.html#is-null-optimization">How MySQL Optimizes IS NULL</a>, <a href="functions.html#comparison-operators">Comparison Functions and Operators</a></dt><dd><dl><dt>and indexes, <a href="optimization.html#mysql-indexes">How MySQL Uses Indexes</a></dt></dl></dd><dt>ISAM storage engine, <a href="storage-engines.html">Storage Engines and Table Types</a></dt><dt>ISAM table type, <a href="storage-engines.html">Storage Engines and Table Types</a></dt><dt>IsClosed(), <a href="spatial-extensions-in-mysql.html#multilinestring-property-functions">MultiLineString Functions</a></dt><dt>IsEmpty(), <a href="spatial-extensions-in-mysql.html#general-geometry-property-functions">General Geometry Functions</a></dt><dt>ISNULL(), <a href="functions.html#comparison-operators">Comparison Functions and Operators</a></dt><dt>ISOLATION LEVEL, <a href="sql-syntax.html#set-transaction">SET TRANSACTION Syntax</a></dt><dt>IsRing(), <a href="spatial-extensions-in-mysql.html#linestring-property-functions">LineString Functions</a></dt><dt>IsSimple(), <a href="spatial-extensions-in-mysql.html#general-geometry-property-functions">General Geometry Functions</a></dt><dt>IS_FREE_LOCK(), <a href="functions.html#miscellaneous-functions">Miscellaneous Functions</a></dt><dt>IS_USED_LOCK(), <a href="functions.html#miscellaneous-functions">Miscellaneous Functions</a></dt><dt>ITERATE, <a href="stored-procedures.html#iterate-statement">ITERATE Statement</a></dt></dl></div><div class="indexdiv"><h3>J</h3><dl><dt>JOIN, <a href="sql-syntax.html#join">JOIN Syntax</a></dt></dl></div><div class="indexdiv"><h3>K</h3><dl><dt>Key cache</dt><dd><dl><dt>MyISAM, <a href="optimization.html#myisam-key-cache">The MyISAM Key Cache</a></dt></dl></dd><dt>key cache</dt><dd><dl><dt>assigning indexes to, <a href="sql-syntax.html#cache-index">CACHE INDEX Syntax</a></dt></dl></dd><dt>key space</dt><dd><dl><dt>MyISAM, <a href="storage-engines.html#key-space">Space Needed for Keys</a></dt></dl></dd><dt>keys, <a href="optimization.html#indexes">Column Indexes</a></dt><dd><dl><dt>foreign, <a href="introduction.html#ansi-diff-foreign-keys">Foreign Keys</a>, <a href="tutorial.html#example-foreign-keys">Using Foreign Keys</a></dt><dt>multi-column, <a href="optimization.html#multiple-column-indexes">Multiple-Column Indexes</a></dt><dt>searching on two, <a href="tutorial.html#searching-on-two-keys">Searching on Two Keys</a></dt></dl></dd><dt>keywords, <a href="language-structure.html#reserved-words">Treatment of Reserved Words in MySQL</a></dt><dt>key_buffer_size myisamchk variable, <a href="database-administration.html#myisamchk-general-options">General Options for myisamchk</a></dt><dt>KEY_COLUMN_USAGE</dt><dd><dl><dt>INFORMATION_SCHEMA table, <a href="information-schema.html#key-column-usage-table">The INFORMATION_SCHEMA KEY_COLUMN_USAGE Table</a></dt></dl></dd><dt>KILL, <a href="sql-syntax.html#kill">KILL Syntax</a></dt><dt>known errors, <a href="problems.html#bugs">Known Issues in MySQL</a></dt></dl></div><div class="indexdiv"><h3>L</h3><dl><dt>language support, <a href="database-administration.html#languages">Setting the Error Message Language</a></dt><dt>last row</dt><dd><dl><dt>unique ID, <a href="apis.html#getting-unique-id">How to Get the Unique ID for the Last Inserted Row</a></dt></dl></dd><dt>LAST_DAY(), <a href="functions.html#date-and-time-functions">Date and Time Functions</a></dt><dt>LAST_INSERT_ID(), <a href="introduction.html#ansi-diff-transactions">Transactions and Atomic Operations</a>, <a href="sql-syntax.html#insert">INSERT Syntax</a></dt><dt>LAST_INSERT_ID([expr]), <a href="functions.html#information-functions">Information Functions</a></dt><dt>layout of installation, <a href="installing.html#installation-layouts">Installation Layouts</a></dt><dt>LCASE(), <a href="functions.html#string-functions">String Functions</a></dt><dt>LD_LIBRARY_PATH environment variable, <a href="installing.html#perl-support-problems">Problems Using the Perl DBI/DBD Interface</a></dt><dt>LD_RUN_PATH environment variable, <a href="installing.html#source-notes-linux">Linux Source Distribution Notes</a>, <a href="installing.html#solaris">Solaris Notes</a>, <a href="installing.html#perl-support-problems">Problems Using the Perl DBI/DBD Interface</a>, <a href="environment-variables.html">Environment Variables</a></dt><dt>LEAST(), <a href="functions.html#comparison-operators">Comparison Functions and Operators</a></dt><dt>LEAVE, <a href="stored-procedures.html#leave-statement">LEAVE Statement</a></dt><dt>LEFT JOIN, <a href="optimization.html#left-join-optimization">How MySQL Optimizes LEFT JOIN and RIGHT JOIN</a>, <a href="sql-syntax.html#join">JOIN Syntax</a></dt><dt>LEFT OUTER JOIN, <a href="sql-syntax.html#join">JOIN Syntax</a></dt><dt>LEFT(), <a href="functions.html#string-functions">String Functions</a></dt><dt>leftmost prefix of indexes, <a href="optimization.html#mysql-indexes">How MySQL Uses Indexes</a></dt><dt>legal names, <a href="language-structure.html#legal-names">Database, Table, Index, Column, and Alias Names</a></dt><dt>LENGTH(), <a href="functions.html#string-functions">String Functions</a></dt><dt>less than (<), <a href="functions.html#comparison-operators">Comparison Functions and Operators</a></dt><dt>less than or equal (<=), <a href="functions.html#comparison-operators">Comparison Functions and Operators</a></dt><dt>libmysqld, <a href="apis.html#libmysqld">libmysqld, the Embedded MySQL Server Library</a></dt><dd><dl><dt>options, <a href="apis.html#libmysqld-options">Options with the Embedded Server</a></dt></dl></dd><dt>libraries</dt><dd><dl><dt>list of, <a href="credits.html#used-libraries">Libraries used by and included with MySQL</a></dt></dl></dd><dt>library</dt><dd><dl><dt>mysqlclient, <a href="apis.html">APIs and Libraries</a></dt><dt>mysqld, <a href="apis.html">APIs and Libraries</a></dt></dl></dd><dt>License, <a href="mysql-floss-license-exception.html">MySQL FLOSS License Exception</a></dt><dt>LIKE, <a href="functions.html#string-comparison-functions">String Comparison Functions</a></dt><dd><dl><dt>and indexes, <a href="optimization.html#mysql-indexes">How MySQL Uses Indexes</a></dt><dt>and wildcards, <a href="optimization.html#mysql-indexes">How MySQL Uses Indexes</a></dt></dl></dd><dt>LIMIT, <a href="optimization.html#limit-optimization">How MySQL Optimizes LIMIT</a>, <a href="functions.html#information-functions">Information Functions</a>, <a href="sql-syntax.html#select">SELECT Syntax</a></dt><dt>limitations</dt><dd><dl><dt>design, <a href="optimization.html#design-limitations">MySQL Design Limitations and Tradeoffs</a></dt><dt>MySQL Limitations, <a href="limits.html">Limits in MySQL</a></dt><dt>replication, <a href="replication.html#replication-features">Replication Features and Known Problems</a></dt></dl></dd><dt>limits</dt><dd><dl><dt>file-size, <a href="introduction.html#table-size">How Big MySQL Tables Can Be</a></dt><dt>MySQL Limits, limits in MySQL, <a href="limits.html">Limits in MySQL</a></dt></dl></dd><dt>linefeed (\n), <a href="language-structure.html#string-syntax">Strings</a></dt><dt>LineFromText(), <a href="spatial-extensions-in-mysql.html#gis-wkt-functions">Creating Geometry Values Using WKT Functions</a></dt><dt>LineFromWKB(), <a href="spatial-extensions-in-mysql.html#gis-wkb-functions">Creating Geometry Values Using WKB Functions</a></dt><dt>LINESTRING data type, <a href="spatial-extensions-in-mysql.html#mysql-spatial-datatypes">MySQL Spatial Data Types</a></dt><dt>LineString(), <a href="spatial-extensions-in-mysql.html#gis-mysql-specific-functions">Creating Geometry Values Using MySQL-Specific Functions</a></dt><dt>LineStringFromText(), <a href="spatial-extensions-in-mysql.html#gis-wkt-functions">Creating Geometry Values Using WKT Functions</a></dt><dt>LineStringFromWKB(), <a href="spatial-extensions-in-mysql.html#gis-wkb-functions">Creating Geometry Values Using WKB Functions</a></dt><dt>linking, <a href="apis.html#building-clients">Building Client Programs</a></dt><dd><dl><dt>errors, <a href="problems.html#link-errors">Problems Linking to the MySQL Client Library</a></dt><dt>problems, <a href="apis.html#c-api-linking-problems">Problems Linking with the C API</a></dt><dt>speed, <a href="optimization.html#compile-and-link-options">How Compiling and Linking Affects the Speed of MySQL</a></dt></dl></dd><dt>links</dt><dd><dl><dt>symbolic, <a href="optimization.html#symbolic-links">Using Symbolic Links</a></dt></dl></dd><dt>Linux</dt><dd><dl><dt>binary distribution, <a href="installing.html#binary-notes-linux">Linux Binary Distribution Notes</a></dt><dt>source distribution, <a href="installing.html#source-notes-linux">Linux Source Distribution Notes</a></dt></dl></dd><dt>literals, <a href="language-structure.html#literals">Literal Values</a></dt><dt>LN(), <a href="functions.html#mathematical-functions">Mathematical Functions</a></dt><dt>LOAD DATA FROM MASTER, <a href="sql-syntax.html#load-data-from-master">LOAD DATA FROM MASTER Syntax</a></dt><dt>LOAD DATA INFILE, <a href="sql-syntax.html#load-data">LOAD DATA INFILE Syntax</a>, <a href="problems.html#problems-with-null">Problems with NULL Values</a></dt><dt>LOAD TABLE FROM MASTER, <a href="sql-syntax.html#load-table-from-master">LOAD TABLE tbl_name FROM MASTER Syntax</a></dt><dt>loading</dt><dd><dl><dt>tables, <a href="tutorial.html#loading-tables">Loading Data into a Table</a></dt></dl></dd><dt>LOAD_FILE(), <a href="functions.html#string-functions">String Functions</a></dt><dt>local-infile</dt><dd><dl><dt>mysql option, <a href="client-side-scripts.html#mysql-command-options">Options</a></dt></dl></dd><dt>LOCALTIME, <a href="functions.html#date-and-time-functions">Date and Time Functions</a></dt><dt>LOCALTIMESTAMP, <a href="functions.html#date-and-time-functions">Date and Time Functions</a></dt><dt>LOCATE(), <a href="functions.html#string-functions">String Functions</a></dt><dt>LOCK IN SHARE MODE, <a href="sql-syntax.html#select">SELECT Syntax</a></dt><dt>LOCK TABLES, <a href="sql-syntax.html#lock-tables">LOCK TABLES and UNLOCK TABLES Syntax</a></dt><dt>locking, <a href="optimization.html#system">System Factors and Startup Parameter Tuning</a></dt><dd><dl><dt>page-level, <a href="optimization.html#internal-locking">Locking Methods</a></dt><dt>row-level, <a href="introduction.html#ansi-diff-transactions">Transactions and Atomic Operations</a>, <a href="optimization.html#internal-locking">Locking Methods</a></dt><dt>table-level, <a href="optimization.html#internal-locking">Locking Methods</a></dt></dl></dd><dt>locking methods, <a href="optimization.html#internal-locking">Locking Methods</a></dt><dt>log</dt><dd><dl><dt>changes, <a href="news.html">MySQL Change History</a></dt><dt>mysqld_multi option, <a href="database-administration.html#mysqld-multi">mysqld_multi — Program for Managing Multiple MySQL Servers</a></dt></dl></dd><dt>log files, <a href="installing.html#configure-options">Typical configure Options</a></dt><dd><dl><dt>maintaining, <a href="database-administration.html#log-file-maintenance">Log File Maintenance</a></dt><dt>names, <a href="database-administration.html#backup">Database Backups</a></dt></dl></dd><dt>Log files, <a href="database-administration.html#log-files">The MySQL Log Files</a></dt><dt>LOG(), <a href="functions.html#mathematical-functions">Mathematical Functions</a></dt><dt>LOG10(), <a href="functions.html#mathematical-functions">Mathematical Functions</a></dt><dt>LOG2(), <a href="functions.html#mathematical-functions">Mathematical Functions</a></dt><dt>logical operators, <a href="functions.html#logical-operators">Logical Operators</a></dt><dt>LONG data type, <a href="column-types.html#blob">The BLOB and TEXT Types</a></dt><dt>LONGBLOB data type, <a href="column-types.html#string-type-overview">Overview of String Types</a></dt><dt>LONGTEXT data type, <a href="column-types.html#string-type-overview">Overview of String Types</a></dt><dt>LOOP, <a href="stored-procedures.html#loop-statement">LOOP Statement</a></dt><dt>LOWER(), <a href="functions.html#string-functions">String Functions</a></dt><dt>LPAD(), <a href="functions.html#string-functions">String Functions</a></dt><dt>LTRIM(), <a href="functions.html#string-functions">String Functions</a></dt></dl></div><div class="indexdiv"><h3>M</h3><dl><dt>Mac OS X</dt><dd><dl><dt>installation, <a href="installing.html#mac-os-x-installation">Installing MySQL on Mac OS X</a></dt></dl></dd><dt>mailing address</dt><dd><dl><dt>for customer support, <a href="introduction.html#bug-reports">How to Report Bugs or Problems</a></dt></dl></dd><dt>mailing list address, <a href="introduction.html">General Information</a></dt><dt>mailing lists, <a href="introduction.html#mailing-list">The MySQL Mailing Lists</a></dt><dd><dl><dt>archive location, <a href="introduction.html#asking-questions">Asking Questions or Reporting Bugs</a></dt><dt>guidelines, <a href="introduction.html#answering-questions">Guidelines for Answering Questions on the Mailing List</a></dt></dl></dd><dt>main features of MySQL, <a href="introduction.html#features">The Main Features of MySQL</a></dt><dt>maintaining</dt><dd><dl><dt>log files, <a href="database-administration.html#log-file-maintenance">Log File Maintenance</a></dt><dt>tables, <a href="database-administration.html#maintenance-schedule">Setting Up a Table Maintenance Schedule</a></dt></dl></dd><dt>MAKEDATE(), <a href="functions.html#date-and-time-functions">Date and Time Functions</a></dt><dt>MAKETIME(), <a href="functions.html#date-and-time-functions">Date and Time Functions</a></dt><dt>make_binary_distribution, <a href="database-administration.html#server-side-overview">Overview of the Server-Side Scripts and Utilities</a></dt><dt>MAKE_SET(), <a href="functions.html#string-functions">String Functions</a></dt><dt>manual</dt><dd><dl><dt>available formats, <a href="introduction.html#manual-info">About This Manual</a></dt><dt>online location, <a href="introduction.html#manual-info">About This Manual</a></dt><dt>typographical conventions, <a href="introduction.html#manual-conventions">Conventions Used in This Manual</a></dt></dl></dd><dt>master/slave setup, <a href="replication.html#replication-implementation">Replication Implementation Overview</a></dt><dt>MASTER_POS_WAIT(), <a href="functions.html#miscellaneous-functions">Miscellaneous Functions</a>, <a href="sql-syntax.html#master-pos-wait">MASTER_POS_WAIT() Syntax</a></dt><dt>MATCH ... AGAINST(), <a href="functions.html#fulltext-search">Full-Text Search Functions</a></dt><dt>matching</dt><dd><dl><dt>patterns, <a href="tutorial.html#pattern-matching">Pattern Matching</a></dt></dl></dd><dt>math, <a href="precision-math.html">Precision Math</a></dt><dt>mathematical functions, <a href="functions.html#mathematical-functions">Mathematical Functions</a></dt><dt>MAX(), <a href="functions.html#group-by-functions">GROUP BY (Aggregate) Functions</a></dt><dt>MAX(DISTINCT), <a href="functions.html#group-by-functions">GROUP BY (Aggregate) Functions</a></dt><dt>MAXDB SQL mode, <a href="database-administration.html#server-sql-mode">The Server SQL Mode</a></dt><dt>maximum memory used, <a href="client-side-scripts.html#mysqladmin">mysqladmin — Client for Administering a MySQL Server</a></dt><dt>maximums</dt><dd><dl><dt>maximum tables per join, <a href="limits.html#joins-limits">Limits of Joins</a></dt></dl></dd><dt>max_allowed_packet variable, <a href="client-side-scripts.html#mysql-command-options">Options</a></dt><dt>MAX_CONNECTIONS_PER_HOUR, <a href="database-administration.html#user-resources">Limiting Account Resources</a></dt><dt>max_join_size variable, <a href="client-side-scripts.html#mysql-command-options">Options</a></dt><dt>MAX_QUERIES_PER_HOUR, <a href="database-administration.html#user-resources">Limiting Account Resources</a></dt><dt>MAX_UPDATES_PER_HOUR, <a href="database-administration.html#user-resources">Limiting Account Resources</a></dt><dt>MAX_USER_CONNECTIONS, <a href="database-administration.html#user-resources">Limiting Account Resources</a></dt><dt>MBR, <a href="spatial-extensions-in-mysql.html#relations-on-geometry-mbr">Relations on Geometry Minimal Bounding Rectangles (MBRs)</a></dt><dt>MBRContains(), <a href="spatial-extensions-in-mysql.html#relations-on-geometry-mbr">Relations on Geometry Minimal Bounding Rectangles (MBRs)</a></dt><dt>MBRDisjoint(), <a href="spatial-extensions-in-mysql.html#relations-on-geometry-mbr">Relations on Geometry Minimal Bounding Rectangles (MBRs)</a></dt><dt>MBREqual(), <a href="spatial-extensions-in-mysql.html#relations-on-geometry-mbr">Relations on Geometry Minimal Bounding Rectangles (MBRs)</a></dt><dt>MBRIntersects(), <a href="spatial-extensions-in-mysql.html#relations-on-geometry-mbr">Relations on Geometry Minimal Bounding Rectangles (MBRs)</a></dt><dt>MBROverlaps(), <a href="spatial-extensions-in-mysql.html#relations-on-geometry-mbr">Relations on Geometry Minimal Bounding Rectangles (MBRs)</a></dt><dt>MBRTouches(), <a href="spatial-extensions-in-mysql.html#relations-on-geometry-mbr">Relations on Geometry Minimal Bounding Rectangles (MBRs)</a></dt><dt>MBRWithin(), <a href="spatial-extensions-in-mysql.html#relations-on-geometry-mbr">Relations on Geometry Minimal Bounding Rectangles (MBRs)</a></dt><dt>MD5(), <a href="functions.html#encryption-functions">Encryption Functions</a></dt><dt>MEDIUMBLOB data type, <a href="column-types.html#string-type-overview">Overview of String Types</a></dt><dt>MEDIUMINT data type, <a href="column-types.html#numeric-type-overview">Overview of Numeric Types</a></dt><dt>MEDIUMTEXT data type, <a href="column-types.html#string-type-overview">Overview of String Types</a></dt><dt>MEMORY storage engine, <a href="storage-engines.html">Storage Engines and Table Types</a>, <a href="storage-engines.html#memory-storage-engine">The MEMORY (HEAP) Storage Engine</a></dt><dt>MEMORY table type, <a href="storage-engines.html">Storage Engines and Table Types</a>, <a href="storage-engines.html#memory-storage-engine">The MEMORY (HEAP) Storage Engine</a></dt><dt>memory usage</dt><dd><dl><dt>myisamchk, <a href="database-administration.html#myisamchk-memory">myisamchk Memory Usage</a></dt></dl></dd><dt>memory use, <a href="optimization.html#memory-use">How MySQL Uses Memory</a>, <a href="client-side-scripts.html#mysqladmin">mysqladmin — Client for Administering a MySQL Server</a></dt><dt>MERGE storage engine, <a href="storage-engines.html">Storage Engines and Table Types</a>, <a href="storage-engines.html#merge-storage-engine">The MERGE Storage Engine</a></dt><dt>MERGE table type, <a href="storage-engines.html">Storage Engines and Table Types</a>, <a href="storage-engines.html#merge-storage-engine">The MERGE Storage Engine</a></dt><dt>MERGE tables</dt><dd><dl><dt>defined, <a href="storage-engines.html#merge-storage-engine">The MERGE Storage Engine</a></dt></dl></dd><dt>messages</dt><dd><dl><dt>languages, <a href="database-administration.html#languages">Setting the Error Message Language</a></dt></dl></dd><dt>metadata</dt><dd><dl><dt>database, <a href="information-schema.html">The INFORMATION_SCHEMA Information Database</a></dt></dl></dd><dt>methods</dt><dd><dl><dt>locking, <a href="optimization.html#internal-locking">Locking Methods</a></dt></dl></dd><dt>MICROSECOND(), <a href="functions.html#date-and-time-functions">Date and Time Functions</a></dt><dt>MID(), <a href="functions.html#string-functions">String Functions</a></dt><dt>MIN(), <a href="functions.html#group-by-functions">GROUP BY (Aggregate) Functions</a></dt><dt>MIN(DISTINCT), <a href="functions.html#group-by-functions">GROUP BY (Aggregate) Functions</a></dt><dt>Minimum Bounding Rectangle, <a href="spatial-extensions-in-mysql.html#relations-on-geometry-mbr">Relations on Geometry Minimal Bounding Rectangles (MBRs)</a></dt><dt>minus</dt><dd><dl><dt>unary (-), <a href="functions.html#arithmetic-functions">Arithmetic Operators</a></dt></dl></dd><dt>MINUTE(), <a href="functions.html#date-and-time-functions">Date and Time Functions</a></dt><dt>mirror sites, <a href="installing.html#getting-mysql">How to Get MySQL</a></dt><dt>miscellaneous functions, <a href="functions.html#miscellaneous-functions">Miscellaneous Functions</a></dt><dt>MIT-pthreads, <a href="installing.html#mit-pthreads">MIT-pthreads Notes</a></dt><dt>MLineFromText(), <a href="spatial-extensions-in-mysql.html#gis-wkt-functions">Creating Geometry Values Using WKT Functions</a></dt><dt>MLineFromWKB(), <a href="spatial-extensions-in-mysql.html#gis-wkb-functions">Creating Geometry Values Using WKB Functions</a></dt><dt>MOD (modulo), <a href="functions.html#mathematical-functions">Mathematical Functions</a></dt><dt>MOD(), <a href="functions.html#mathematical-functions">Mathematical Functions</a></dt><dt>modes</dt><dd><dl><dt>batch, <a href="tutorial.html#batch-mode">Using mysql in Batch Mode</a></dt></dl></dd><dt>modules</dt><dd><dl><dt>list of, <a href="introduction.html#stability">MySQL Stability</a></dt></dl></dd><dt>modulo (%), <a href="functions.html#mathematical-functions">Mathematical Functions</a></dt><dt>modulo (MOD), <a href="functions.html#mathematical-functions">Mathematical Functions</a></dt><dt>monitor</dt><dd><dl><dt>terminal, <a href="tutorial.html">Tutorial</a></dt></dl></dd><dt>MONTH(), <a href="functions.html#date-and-time-functions">Date and Time Functions</a></dt><dt>MONTHNAME(), <a href="functions.html#date-and-time-functions">Date and Time Functions</a></dt><dt>MPointFromText(), <a href="spatial-extensions-in-mysql.html#gis-wkt-functions">Creating Geometry Values Using WKT Functions</a></dt><dt>MPointFromWKB(), <a href="spatial-extensions-in-mysql.html#gis-wkb-functions">Creating Geometry Values Using WKB Functions</a></dt><dt>MPolyFromText(), <a href="spatial-extensions-in-mysql.html#gis-wkt-functions">Creating Geometry Values Using WKT Functions</a></dt><dt>MPolyFromWKB(), <a href="spatial-extensions-in-mysql.html#gis-wkb-functions">Creating Geometry Values Using WKB Functions</a></dt><dt>mSQL compatibility, <a href="functions.html#string-comparison-functions">String Comparison Functions</a></dt><dt>MSSQL SQL mode, <a href="database-administration.html#server-sql-mode">The Server SQL Mode</a></dt><dt>multi-byte character sets, <a href="problems.html#cannot-initialize-character-set">Can't initialize character set</a></dt><dt>multi-byte characters, <a href="database-administration.html#multi-byte-characters">Multi-Byte Character Support</a></dt><dt>multi-column indexes, <a href="optimization.html#multiple-column-indexes">Multiple-Column Indexes</a></dt><dt>MULTILINESTRING data type, <a href="spatial-extensions-in-mysql.html#mysql-spatial-datatypes">MySQL Spatial Data Types</a></dt><dt>MultiLineString(), <a href="spatial-extensions-in-mysql.html#gis-mysql-specific-functions">Creating Geometry Values Using MySQL-Specific Functions</a></dt><dt>MultiLineStringFromText(), <a href="spatial-extensions-in-mysql.html#gis-wkt-functions">Creating Geometry Values Using WKT Functions</a></dt><dt>MultiLineStringFromWKB(), <a href="spatial-extensions-in-mysql.html#gis-wkb-functions">Creating Geometry Values Using WKB Functions</a></dt><dt>multiple servers, <a href="database-administration.html#multiple-servers">Running Multiple MySQL Servers on the Same Machine</a></dt><dt>multiple-part index, <a href="sql-syntax.html#create-index">CREATE INDEX Syntax</a></dt><dt>multiplication (*), <a href="functions.html#arithmetic-functions">Arithmetic Operators</a></dt><dt>MULTIPOINT data type, <a href="spatial-extensions-in-mysql.html#mysql-spatial-datatypes">MySQL Spatial Data Types</a></dt><dt>MultiPoint(), <a href="spatial-extensions-in-mysql.html#gis-mysql-specific-functions">Creating Geometry Values Using MySQL-Specific Functions</a></dt><dt>MultiPointFromText(), <a href="spatial-extensions-in-mysql.html#gis-wkt-functions">Creating Geometry Values Using WKT Functions</a></dt><dt>MultiPointFromWKB(), <a href="spatial-extensions-in-mysql.html#gis-wkb-functions">Creating Geometry Values Using WKB Functions</a></dt><dt>MULTIPOLYGON data type, <a href="spatial-extensions-in-mysql.html#mysql-spatial-datatypes">MySQL Spatial Data Types</a></dt><dt>MultiPolygon(), <a href="spatial-extensions-in-mysql.html#gis-mysql-specific-functions">Creating Geometry Values Using MySQL-Specific Functions</a></dt><dt>MultiPolygonFromText(), <a href="spatial-extensions-in-mysql.html#gis-wkt-functions">Creating Geometry Values Using WKT Functions</a></dt><dt>MultiPolygonFromWKB(), <a href="spatial-extensions-in-mysql.html#gis-wkb-functions">Creating Geometry Values Using WKB Functions</a></dt><dt>My</dt><dd><dl><dt>derivation, <a href="introduction.html#history">History of MySQL</a></dt></dl></dd><dt>my.cnf file, <a href="replication.html#replication-features">Replication Features and Known Problems</a></dt><dt>MyISAM</dt><dd><dl><dt>compressed tables, <a href="storage-engines.html#compressed-format">Compressed Table Characteristics</a></dt><dt>size, <a href="column-types.html#storage-requirements">Column Type Storage Requirements</a></dt></dl></dd><dt>MyISAM key cache, <a href="optimization.html#myisam-key-cache">The MyISAM Key Cache</a></dt><dt>MyISAM storage engine, <a href="storage-engines.html">Storage Engines and Table Types</a>, <a href="storage-engines.html#myisam-storage-engine">The MyISAM Storage Engine</a></dt><dt>MyISAM table type, <a href="storage-engines.html">Storage Engines and Table Types</a>, <a href="storage-engines.html#myisam-storage-engine">The MyISAM Storage Engine</a></dt><dt>myisamchk, <a href="installing.html#configure-options">Typical configure Options</a>, <a href="database-administration.html#server-side-overview">Overview of the Server-Side Scripts and Utilities</a></dt><dd><dl><dt>example output, <a href="database-administration.html#table-info">Getting Information About a Table</a></dt><dt>options, <a href="database-administration.html#myisamchk-general-options">General Options for myisamchk</a></dt></dl></dd><dt>myisampack, <a href="client-side-scripts.html#client-side-overview">Overview of the Client-Side Scripts and Utilities</a>, <a href="sql-syntax.html#silent-column-changes">Silent Column Specification Changes</a>, <a href="storage-engines.html#compressed-format">Compressed Table Characteristics</a></dt><dt>myisam_block_size myisamchk
variable, <a href="database-administration.html#myisamchk-general-options">General Options for myisamchk</a></dt><dt>MyODBC, <a href="connectors.html#odbc-connector">MySQL Connector/ODBC</a></dt><dd><dl><dt>reporting problems, <a href="connectors.html#myodbc-bug-report">How to Report MyODBC Problems or Bugs</a></dt></dl></dd><dt>MySQL</dt><dd><dl><dt>defined, <a href="introduction.html#what-is">Overview of the MySQL Database Management System</a></dt><dt>introduction, <a href="introduction.html#what-is">Overview of the MySQL Database Management System</a></dt><dt>pronunciation, <a href="introduction.html#what-is">Overview of the MySQL Database Management System</a></dt></dl></dd><dt>mysql, <a href="client-side-scripts.html#client-side-overview">Overview of the Client-Side Scripts and Utilities</a></dt><dt>MySQL AB</dt><dd><dl><dt>defined, <a href="introduction.html#what-is-mysql-ab">Overview of MySQL AB</a></dt></dl></dd><dt>MySQL binary distribution, <a href="installing.html#which-version">Choosing Which MySQL Distribution to Install</a></dt><dt>MYSQL C type, <a href="apis.html#c-api-datatypes">C API Data types</a></dt><dt>MySQL C type, <a href="apis.html#c-api-prepared-statement-datatypes">C API Prepared Statement Data types</a></dt><dt>MySQL Cluster in MySQL 5.0 and 5.1, <a href="ndbcluster.html#mysql-cluster-roadmap">MySQL Cluster Development Roadmap</a></dt><dt>mysql command-line options, <a href="client-side-scripts.html#mysql-command-options">Options</a></dt><dt>mysql commands</dt><dd><dl><dt>list of, <a href="client-side-scripts.html#mysql-commands">mysql Commands</a></dt></dl></dd><dt>MySQL Dolphin name, <a href="introduction.html#history">History of MySQL</a></dt><dt>MySQL history, <a href="introduction.html#history">History of MySQL</a></dt><dt>mysql history file, <a href="client-side-scripts.html#mysql-command-options">Options</a></dt><dt>MySQL mailing lists, <a href="introduction.html#questions">MySQL Mailing Lists</a></dt><dt>MySQL name, <a href="introduction.html#history">History of MySQL</a></dt><dt>mysql prompt command, <a href="client-side-scripts.html#mysql-commands">mysql Commands</a></dt><dt>MySQL source distribution, <a href="installing.html#which-version">Choosing Which MySQL Distribution to Install</a></dt><dt>mysql status command, <a href="client-side-scripts.html#mysql-commands">mysql Commands</a></dt><dt>MySQL storage engines, <a href="storage-engines.html">Storage Engines and Table Types</a></dt><dt>MySQL table types, <a href="storage-engines.html">Storage Engines and Table Types</a></dt><dt>MySQL version, <a href="installing.html#getting-mysql">How to Get MySQL</a></dt><dt>MySQL++, <a href="apis.html#cplusplus">MySQL C++ API</a></dt><dt>mysql.server, <a href="database-administration.html#server-side-overview">Overview of the Server-Side Scripts and Utilities</a></dt><dt>mysql.sock</dt><dd><dl><dt>changing location of, <a href="installing.html#configure-options">Typical configure Options</a></dt><dt>protection, <a href="problems.html#problems-with-mysql-sock">How to Protect or Change the MySQL Socket File /tmp/mysql.sock</a></dt></dl></dd><dt>MYSQL323 SQL mode, <a href="database-administration.html#server-sql-mode">The Server SQL Mode</a></dt><dt>MYSQL40 SQL mode, <a href="database-administration.html#server-sql-mode">The Server SQL Mode</a></dt><dt>mysqlaccess, <a href="client-side-scripts.html#client-side-overview">Overview of the Client-Side Scripts and Utilities</a></dt><dt>mysqladmin, <a href="client-side-scripts.html#client-side-overview">Overview of the Client-Side Scripts and Utilities</a>, <a href="sql-syntax.html#create-database">CREATE DATABASE Syntax</a>, <a href="sql-syntax.html#drop-database">DROP DATABASE Syntax</a>, <a href="sql-syntax.html#show-status">SHOW STATUS Syntax</a>, <a href="sql-syntax.html#show-variables">SHOW VARIABLES Syntax</a>, <a href="sql-syntax.html#flush">FLUSH Syntax</a>, <a href="sql-syntax.html#kill">KILL Syntax</a></dt><dd><dl><dt>mysqld_multi option, <a href="database-administration.html#mysqld-multi">mysqld_multi — Program for Managing Multiple MySQL Servers</a></dt></dl></dd><dt>mysqladmin command-line options, <a href="client-side-scripts.html#mysqladmin">mysqladmin — Client for Administering a MySQL Server</a></dt><dt>mysqlbinlog, <a href="client-side-scripts.html#client-side-overview">Overview of the Client-Side Scripts and Utilities</a></dt><dt>mysqlbug, <a href="database-administration.html#server-side-overview">Overview of the Server-Side Scripts and Utilities</a></dt><dt>mysqlbug script, <a href="introduction.html#bug-reports">How to Report Bugs or Problems</a></dt><dd><dl><dt>location, <a href="introduction.html">General Information</a></dt></dl></dd><dt>mysqlcheck, <a href="client-side-scripts.html#client-side-overview">Overview of the Client-Side Scripts and Utilities</a></dt><dt>mysqlclient library, <a href="apis.html">APIs and Libraries</a></dt><dt>mysqld, <a href="database-administration.html#server-side-overview">Overview of the Server-Side Scripts and Utilities</a></dt><dd><dl><dt>mysqld_multi option, <a href="database-administration.html#mysqld-multi">mysqld_multi — Program for Managing Multiple MySQL Servers</a></dt><dt>starting, <a href="problems.html#changing-mysql-user">How to Run MySQL as a Normal User</a></dt></dl></dd><dt>mysqld library, <a href="apis.html">APIs and Libraries</a></dt><dt>mysqld options, <a href="database-administration.html#server-options">mysqld Command-Line Options</a>, <a href="optimization.html#server-parameters">Tuning Server Parameters</a></dt><dt>mysqld server</dt><dd><dl><dt>buffer sizes, <a href="optimization.html#server-parameters">Tuning Server Parameters</a></dt></dl></dd><dt>mysqld-max, <a href="database-administration.html#server-side-overview">Overview of the Server-Side Scripts and Utilities</a>, <a href="database-administration.html#mysqld-max">The mysqld-max Extended MySQL Server</a></dt><dt>mysqldump, <a href="installing.html#upgrading-to-arch">Copying MySQL Databases to Another Machine</a>, <a href="client-side-scripts.html#client-side-overview">Overview of the Client-Side Scripts and Utilities</a></dt><dt>mysqld_multi, <a href="database-administration.html#server-side-overview">Overview of the Server-Side Scripts and Utilities</a></dt><dt>mysqld_safe, <a href="database-administration.html#server-side-overview">Overview of the Server-Side Scripts and Utilities</a></dt><dt>mysqlhotcopy, <a href="client-side-scripts.html#client-side-overview">Overview of the Client-Side Scripts and Utilities</a></dt><dt>mysqlimport, <a href="installing.html#upgrading-to-arch">Copying MySQL Databases to Another Machine</a>, <a href="client-side-scripts.html#client-side-overview">Overview of the Client-Side Scripts and Utilities</a>, <a href="sql-syntax.html#load-data">LOAD DATA INFILE Syntax</a></dt><dt>mysqlshow, <a href="client-side-scripts.html#client-side-overview">Overview of the Client-Side Scripts and Utilities</a></dt><dt>mysqltest</dt><dd><dl><dt>MySQL Test Suite, <a href="extending-mysql.html#mysql-test-suite">MySQL Test Suite</a></dt></dl></dd><dt>mysql_affected_rows(), <a href="apis.html#mysql-affected-rows">mysql_affected_rows()</a></dt><dt>mysql_autocommit()., <a href="apis.html#mysql-autocommit">mysql_autocommit()</a></dt><dt>MYSQL_BIND C type, <a href="apis.html#c-api-prepared-statement-datatypes">C API Prepared Statement Data types</a></dt><dt>mysql_change_user(), <a href="apis.html#mysql-change-user">mysql_change_user()</a></dt><dt>mysql_character_set_name(), <a href="apis.html#mysql-character-set-name">mysql_character_set_name()</a></dt><dt>mysql_close(), <a href="apis.html#mysql-close">mysql_close()</a></dt><dt>mysql_commit()., <a href="apis.html#mysql-commit">mysql_commit()</a></dt><dt>mysql_connect(), <a href="apis.html#mysql-connect">mysql_connect()</a></dt><dt>mysql_create_db(), <a href="apis.html#mysql-create-db">mysql_create_db()</a></dt><dt>mysql_data_seek(), <a href="apis.html#mysql-data-seek">mysql_data_seek()</a></dt><dt>MYSQL_DEBUG environment variable, <a href="client-side-scripts.html#client-side-overview">Overview of the Client-Side Scripts and Utilities</a>, <a href="porting.html#debugging-client">Debugging a MySQL Client</a>, <a href="environment-variables.html">Environment Variables</a></dt><dt>mysql_debug(), <a href="apis.html#mysql-debug">mysql_debug()</a></dt><dt>mysql_drop_db(), <a href="apis.html#mysql-drop-db">mysql_drop_db()</a></dt><dt>mysql_dump_debug_info(), <a href="apis.html#mysql-dump-debug-info">mysql_dump_debug_info()</a></dt><dt>mysql_eof(), <a href="apis.html#mysql-eof">mysql_eof()</a></dt><dt>mysql_errno(), <a href="apis.html#mysql-errno">mysql_errno()</a></dt><dt>mysql_error(), <a href="apis.html#mysql-error">mysql_error()</a></dt><dt>mysql_escape_string(), <a href="apis.html#mysql-escape-string">mysql_escape_string()</a></dt><dt>mysql_fetch_field(), <a href="apis.html#mysql-fetch-field">mysql_fetch_field()</a></dt><dt>mysql_fetch_fields(), <a href="apis.html#mysql-fetch-fields">mysql_fetch_fields()</a></dt><dt>mysql_fetch_field_direct(), <a href="apis.html#mysql-fetch-field-direct">mysql_fetch_field_direct()</a></dt><dt>mysql_fetch_lengths(), <a href="apis.html#mysql-fetch-lengths">mysql_fetch_lengths()</a></dt><dt>mysql_fetch_row(), <a href="apis.html#mysql-fetch-row">mysql_fetch_row()</a></dt><dt>MYSQL_FIELD C type, <a href="apis.html#c-api-datatypes">C API Data types</a></dt><dt>mysql_field_count(), <a href="apis.html#mysql-field-count">mysql_field_count()</a>, <a href="apis.html#mysql-num-fields">mysql_num_fields()</a></dt><dt>MYSQL_FIELD_OFFSET C type, <a href="apis.html#c-api-datatypes">C API Data types</a></dt><dt>mysql_field_seek(), <a href="apis.html#mysql-field-seek">mysql_field_seek()</a></dt><dt>mysql_field_tell(), <a href="apis.html#mysql-field-tell">mysql_field_tell()</a></dt><dt>mysql_fix_privilege_tables, <a href="database-administration.html#server-side-overview">Overview of the Server-Side Scripts and Utilities</a>, <a href="database-administration.html#access-denied">Causes of Access denied Errors</a></dt><dt>mysql_free_result(), <a href="apis.html#mysql-free-result">mysql_free_result()</a></dt><dt>mysql_get_character_set_info(), <a href="apis.html#mysql-get-character-set-info">mysql_get_character_set_info()</a></dt><dt>mysql_get_client_info(), <a href="apis.html#mysql-get-client-info">mysql_get_client_info()</a></dt><dt>mysql_get_client_version(), <a href="apis.html#mysql-get-client-version">mysql_get_client_version()</a></dt><dt>mysql_get_host_info(), <a href="apis.html#mysql-get-host-info">mysql_get_host_info()</a></dt><dt>mysql_get_proto_info(), <a href="apis.html#mysql-get-proto-info">mysql_get_proto_info()</a></dt><dt>mysql_get_server_info(), <a href="apis.html#mysql-get-server-info">mysql_get_server_info()</a></dt><dt>mysql_get_server_version(), <a href="apis.html#mysql-get-server-version">mysql_get_server_version()</a></dt><dt>mysql_hex_string(), <a href="apis.html#mysql-hex-string">mysql_hex_string()</a></dt><dt>MYSQL_HISTFILE environment variable, <a href="client-side-scripts.html#mysql-command-options">Options</a>, <a href="environment-variables.html">Environment Variables</a></dt><dt>MYSQL_HOST environment variable, <a href="database-administration.html#connecting">Connecting to the MySQL Server</a>, <a href="environment-variables.html">Environment Variables</a></dt><dt>mysql_info(), <a href="sql-syntax.html#alter-table">ALTER TABLE Syntax</a>, <a href="sql-syntax.html#insert">INSERT Syntax</a>, <a href="sql-syntax.html#load-data">LOAD DATA INFILE Syntax</a>, <a href="sql-syntax.html#update">UPDATE Syntax</a>, <a href="apis.html#mysql-info">mysql_info()</a></dt><dt>mysql_init(), <a href="apis.html#mysql-init">mysql_init()</a></dt><dt>mysql_insert_id(), <a href="introduction.html#ansi-diff-transactions">Transactions and Atomic Operations</a>, <a href="sql-syntax.html#insert">INSERT Syntax</a>, <a href="apis.html#mysql-insert-id">mysql_insert_id()</a></dt><dt>mysql_install_db, <a href="database-administration.html#server-side-overview">Overview of the Server-Side Scripts and Utilities</a></dt><dt>mysql_install_db script, <a href="installing.html#mysql-install-db">Problems Running mysql_install_db</a></dt><dt>mysql_kill(), <a href="apis.html#mysql-kill">mysql_kill()</a></dt><dt>mysql_library_end(), <a href="apis.html#mysql-library-end">mysql_library_end()</a></dt><dt>mysql_library_init(), <a href="apis.html#mysql-library-init">mysql_library_init()</a></dt><dt>mysql_list_dbs(), <a href="apis.html#mysql-list-dbs">mysql_list_dbs()</a></dt><dt>mysql_list_fields(), <a href="apis.html#mysql-list-fields">mysql_list_fields()</a></dt><dt>mysql_list_processes(), <a href="apis.html#mysql-list-processes">mysql_list_processes()</a></dt><dt>mysql_list_tables(), <a href="apis.html#mysql-list-tables">mysql_list_tables()</a></dt><dt>mysql_more_results()., <a href="apis.html#mysql-more-results">mysql_more_results()</a></dt><dt>mysql_next_result()., <a href="apis.html#mysql-next-result">mysql_next_result()</a></dt><dt>mysql_num_fields(), <a href="apis.html#mysql-num-fields">mysql_num_fields()</a></dt><dt>mysql_num_rows(), <a href="apis.html#mysql-num-rows">mysql_num_rows()</a></dt><dt>mysql_options(), <a href="apis.html#mysql-options">mysql_options()</a></dt><dt>mysql_ping(), <a href="apis.html#mysql-ping">mysql_ping()</a></dt><dt>MYSQL_PS1 environment variable, <a href="environment-variables.html">Environment Variables</a></dt><dt>MYSQL_PWD environment variable, <a href="database-administration.html#connecting">Connecting to the MySQL Server</a>, <a href="client-side-scripts.html#client-side-overview">Overview of the Client-Side Scripts and Utilities</a>, <a href="environment-variables.html">Environment Variables</a></dt><dt>mysql_query(), <a href="apis.html#mysql-query">mysql_query()</a>, <a href="apis.html#c-api-problems">Common questions and problems when using the C API</a></dt><dt>mysql_real_connect(), <a href="apis.html#mysql-real-connect">mysql_real_connect()</a></dt><dt>mysql_real_escape_string(), <a href="language-structure.html#string-syntax">Strings</a>, <a href="apis.html#mysql-real-escape-string">mysql_real_escape_string()</a></dt><dt>mysql_real_query(), <a href="apis.html#mysql-real-query">mysql_real_query()</a></dt><dt>mysql_refresh(), <a href="apis.html#mysql-refresh">mysql_refresh()</a></dt><dt>mysql_reload(), <a href="apis.html#mysql-reload">mysql_reload()</a></dt><dt>MYSQL_RES C type, <a href="apis.html#c-api-datatypes">C API Data types</a></dt><dt>mysql_rollback()., <a href="apis.html#mysql-rollback">mysql_rollback()</a></dt><dt>MYSQL_ROW C type, <a href="apis.html#c-api-datatypes">C API Data types</a></dt><dt>mysql_row_seek(), <a href="apis.html#mysql-row-seek">mysql_row_seek()</a></dt><dt>mysql_row_tell(), <a href="apis.html#mysql-row-tell">mysql_row_tell()</a></dt><dt>mysql_select_db(), <a href="apis.html#mysql-select-db">mysql_select_db()</a></dt><dt>mysql_server_end(), <a href="apis.html#mysql-server-end">mysql_server_end()</a></dt><dt>mysql_server_init(), <a href="apis.html#mysql-server-init">mysql_server_init()</a></dt><dt>mysql_set_character_set(), <a href="apis.html#mysql-set-character-set">mysql_set_character_set()</a></dt><dt>mysql_set_server_option(), <a href="apis.html#mysql-set-server-option">mysql_set_server_option()</a></dt><dt>mysql_shutdown(), <a href="apis.html#mysql-shutdown">mysql_shutdown()</a></dt><dt>mysql_sqlstate(), <a href="apis.html#mysql-sqlstate">mysql_sqlstate()</a></dt><dt>mysql_ssl_set(), <a href="apis.html#mysql-ssl-set">mysql_ssl_set()</a></dt><dt>mysql_stat(), <a href="apis.html#mysql-stat">mysql_stat()</a></dt><dt>MYSQL_STMT C type, <a href="apis.html#c-api-prepared-statement-datatypes">C API Prepared Statement Data types</a></dt><dt>mysql_stmt_affected_rows(), <a href="apis.html#mysql-stmt-affected-rows">mysql_stmt_affected_rows()</a></dt><dt>mysql_stmt_attr_get(), <a href="apis.html#mysql-stmt-attr-get">mysql_stmt_attr_get()</a></dt><dt>mysql_stmt_attr_set(), <a href="apis.html#mysql-stmt-attr-set">mysql_stmt_attr_set()</a></dt><dt>mysql_stmt_bind_param(), <a href="apis.html#mysql-stmt-bind-param">mysql_stmt_bind_param()</a></dt><dt>mysql_stmt_bind_result(), <a href="apis.html#mysql-stmt-bind-result">mysql_stmt_bind_result()</a></dt><dt>mysql_stmt_close(), <a href="apis.html#mysql-stmt-close">mysql_stmt_close()</a></dt><dt>mysql_stmt_data_seek(), <a href="apis.html#mysql-stmt-data-seek">mysql_stmt_data_seek()</a></dt><dt>mysql_stmt_errno(), <a href="apis.html#mysql-stmt-errno">mysql_stmt_errno()</a></dt><dt>mysql_stmt_error()., <a href="apis.html#mysql-stmt-error">mysql_stmt_error()</a></dt><dt>mysql_stmt_execute(), <a href="apis.html#mysql-stmt-execute">mysql_stmt_execute()</a></dt><dt>mysql_stmt_fetch(), <a href="apis.html#mysql-stmt-fetch">mysql_stmt_fetch()</a></dt><dt>mysql_stmt_fetch_column(), <a href="apis.html#mysql-stmt-fetch-column">mysql_stmt_fetch_column()</a></dt><dt>mysql_stmt_field_count(), <a href="apis.html#mysql-stmt-field-count">mysql_stmt_field_count()</a></dt><dt>mysql_stmt_free_result(), <a href="apis.html#mysql-stmt-free-result">mysql_stmt_free_result()</a></dt><dt>mysql_stmt_init(), <a href="apis.html#mysql-stmt-init">mysql_stmt_init()</a></dt><dt>mysql_stmt_insert_id(), <a href="apis.html#mysql-stmt-insert-id">mysql_stmt_insert_id()</a></dt><dt>mysql_stmt_num_rows(), <a href="apis.html#mysql-stmt-num-rows">mysql_stmt_num_rows()</a></dt><dt>mysql_stmt_param_count(), <a href="apis.html#mysql-stmt-param-count">mysql_stmt_param_count()</a></dt><dt>mysql_stmt_param_metadata(), <a href="apis.html#mysql-stmt-param-metadata">mysql_stmt_param_metadata()</a></dt><dt>mysql_stmt_prepare(), <a href="apis.html#mysql-stmt-prepare">mysql_stmt_prepare()</a></dt><dt>mysql_stmt_reset(), <a href="apis.html#mysql-stmt-reset">mysql_stmt_reset()</a></dt><dt>mysql_stmt_result_metadata., <a href="apis.html#mysql-stmt-result-metadata">mysql_stmt_result_metadata()</a></dt><dt>mysql_stmt_row_seek(), <a href="apis.html#mysql-stmt-row-seek">mysql_stmt_row_seek()</a></dt><dt>mysql_stmt_row_tell(), <a href="apis.html#mysql-stmt-row-tell">mysql_stmt_row_tell()</a></dt><dt>mysql_stmt_send_long_data()., <a href="apis.html#mysql-stmt-send-long-data">mysql_stmt_send_long_data()</a></dt><dt>mysql_stmt_sqlstate(), <a href="apis.html#mysql-stmt-sqlstate">mysql_stmt_sqlstate()</a></dt><dt>mysql_stmt_store_result(), <a href="apis.html#mysql-stmt-store-result">mysql_stmt_store_result()</a></dt><dt>mysql_store_result(), <a href="apis.html#mysql-store-result">mysql_store_result()</a>, <a href="apis.html#c-api-problems">Common questions and problems when using the C API</a></dt><dt>MYSQL_TCP_PORT environment variable, <a href="database-administration.html#multiple-unix-servers">Running Multiple Servers on Unix</a>, <a href="database-administration.html#multiple-server-clients">Using Client Programs in a Multiple-Server Environment</a>, <a href="client-side-scripts.html#client-side-overview">Overview of the Client-Side Scripts and Utilities</a>, <a href="environment-variables.html">Environment Variables</a></dt><dt>mysql_thread_end(), <a href="apis.html#mysql-thread-end">mysql_thread_end()</a></dt><dt>mysql_thread_id(), <a href="apis.html#mysql-thread-id">mysql_thread_id()</a></dt><dt>mysql_thread_init(), <a href="apis.html#mysql-thread-init">mysql_thread_init()</a></dt><dt>mysql_thread_safe(), <a href="apis.html#mysql-thread-safe">mysql_thread_safe()</a></dt><dt>MYSQL_UNIX_PORT environment variable, <a href="installing.html#mysql-install-db">Problems Running mysql_install_db</a>, <a href="database-administration.html#multiple-unix-servers">Running Multiple Servers on Unix</a>, <a href="database-administration.html#multiple-server-clients">Using Client Programs in a Multiple-Server Environment</a>, <a href="client-side-scripts.html#client-side-overview">Overview of the Client-Side Scripts and Utilities</a>, <a href="environment-variables.html">Environment Variables</a></dt><dt>mysql_use_result(), <a href="apis.html#mysql-use-result">mysql_use_result()</a></dt><dt>mysql_warning_count()., <a href="apis.html#mysql-warning-count">mysql_warning_count()</a></dt><dt>my_init(), <a href="apis.html#my-init">my_init()</a></dt><dt>my_ulonglong C type, <a href="apis.html#c-api-datatypes">C API Data types</a></dt><dt>my_ulonglong values</dt><dd><dl><dt>printing, <a href="apis.html#c-api-datatypes">C API Data types</a></dt></dl></dd></dl></div><div class="indexdiv"><h3>N</h3><dl><dt>named pipes, <a href="installing.html#windows-select-server">Selecting a MySQL Server type</a>, <a href="installing.html#windows-testing">Testing The MySQL Installation</a></dt><dt>named-commands</dt><dd><dl><dt>mysql option, <a href="client-side-scripts.html#mysql-command-options">Options</a></dt></dl></dd><dt>names, <a href="language-structure.html#legal-names">Database, Table, Index, Column, and Alias Names</a></dt><dd><dl><dt>case sensitivity, <a href="language-structure.html#name-case-sensitivity">Identifier Case Sensitivity</a></dt><dt>variables, <a href="language-structure.html#variables">User Variables</a></dt></dl></dd><dt>NAME_CONST(), <a href="functions.html#miscellaneous-functions">Miscellaneous Functions</a></dt><dt>naming</dt><dd><dl><dt>releases of MySQL, <a href="installing.html#choosing-version">Choosing Which Version of MySQL to Install</a></dt></dl></dd><dt>NATIONAL CHAR data type, <a href="column-types.html#string-type-overview">Overview of String Types</a></dt><dt>native functions</dt><dd><dl><dt>adding, <a href="extending-mysql.html#adding-native-function">Adding a New Native Function</a></dt></dl></dd><dt>native thread support, <a href="installing.html#which-os">Operating Systems Supported by MySQL</a></dt><dt>NATURAL LEFT JOIN, <a href="sql-syntax.html#join">JOIN Syntax</a></dt><dt>NATURAL LEFT OUTER JOIN, <a href="sql-syntax.html#join">JOIN Syntax</a></dt><dt>NATURAL RIGHT JOIN, <a href="sql-syntax.html#join">JOIN Syntax</a></dt><dt>NATURAL RIGHT OUTER JOIN, <a href="sql-syntax.html#join">JOIN Syntax</a></dt><dt>NCHAR data type, <a href="column-types.html#string-type-overview">Overview of String Types</a></dt><dt>negative values, <a href="language-structure.html#number-syntax">Numbers</a></dt><dt>nested queries, <a href="sql-syntax.html#subqueries">Subquery Syntax</a></dt><dt>net etiquette, <a href="introduction.html#asking-questions">Asking Questions or Reporting Bugs</a>, <a href="introduction.html#answering-questions">Guidelines for Answering Questions on the Mailing List</a></dt><dt>netmask notation</dt><dd><dl><dt>in mysql.user table, <a href="database-administration.html#connection-access">Access Control, Stage 1: Connection Verification</a></dt></dl></dd><dt>NetWare, <a href="installing.html#netware-installation">Installing MySQL on NetWare</a></dt><dt>net_buffer_length variable, <a href="client-side-scripts.html#mysql-command-options">Options</a></dt><dt>New features in MySQL Cluster, <a href="ndbcluster.html#mysql-cluster-roadmap">MySQL Cluster Development Roadmap</a></dt><dt>new procedures</dt><dd><dl><dt>adding, <a href="extending-mysql.html#adding-procedures">Adding New Procedures to MySQL</a></dt></dl></dd><dt>new users</dt><dd><dl><dt>adding, <a href="installing.html#installing-binary">Installing MySQL on Other Unix-Like Systems</a>, <a href="installing.html#quick-install">Source Installation Overview</a></dt></dl></dd><dt>newline (\n), <a href="language-structure.html#string-syntax">Strings</a></dt><dt>no matching rows, <a href="problems.html#no-matching-rows">Solving Problems with No Matching Rows</a></dt><dt>no-auto-rehash</dt><dd><dl><dt>mysql option, <a href="client-side-scripts.html#mysql-command-options">Options</a></dt></dl></dd><dt>no-beep</dt><dd><dl><dt>mysql option, <a href="client-side-scripts.html#mysql-command-options">Options</a></dt></dl></dd><dt>no-log</dt><dd><dl><dt>mysqld_multi option, <a href="database-administration.html#mysqld-multi">mysqld_multi — Program for Managing Multiple MySQL Servers</a></dt></dl></dd><dt>no-named-commands</dt><dd><dl><dt>mysql option, <a href="client-side-scripts.html#mysql-command-options">Options</a></dt></dl></dd><dt>no-pager</dt><dd><dl><dt>mysql option, <a href="client-side-scripts.html#mysql-command-options">Options</a></dt></dl></dd><dt>no-tee</dt><dd><dl><dt>mysql option, <a href="client-side-scripts.html#mysql-command-options">Options</a></dt></dl></dd><dt>non-delimited strings, <a href="column-types.html#datetime">The DATETIME, DATE, and TIMESTAMP Types</a></dt><dt>Non-transactional tables, <a href="problems.html#non-transactional-tables">Rollback Failure for Non-Transactional Tables</a></dt><dt>NOT</dt><dd><dl><dt>logical, <a href="functions.html#logical-operators">Logical Operators</a></dt></dl></dd><dt>NOT BETWEEN, <a href="functions.html#comparison-operators">Comparison Functions and Operators</a></dt><dt>not equal (!=), <a href="functions.html#comparison-operators">Comparison Functions and Operators</a></dt><dt>not equal (<>), <a href="functions.html#comparison-operators">Comparison Functions and Operators</a></dt><dt>NOT IN, <a href="functions.html#comparison-operators">Comparison Functions and Operators</a></dt><dt>NOT LIKE, <a href="functions.html#string-comparison-functions">String Comparison Functions</a></dt><dt>NOT NULL</dt><dd><dl><dt>constraint, <a href="introduction.html#constraint-invalid-data">Constraints on Invalid Data</a></dt></dl></dd><dt>NOT REGEXP, <a href="functions.html#string-comparison-functions">String Comparison Functions</a></dt><dt>Novell NetWare, <a href="installing.html#netware-installation">Installing MySQL on NetWare</a></dt><dt>NOW(), <a href="functions.html#date-and-time-functions">Date and Time Functions</a></dt><dt>NO_AUTO_CREATE_USER SQL mode, <a href="database-administration.html#server-sql-mode">The Server SQL Mode</a></dt><dt>NO_AUTO_VALUE_ON_ZERO SQL mode, <a href="database-administration.html#server-sql-mode">The Server SQL Mode</a></dt><dt>NO_BACKSLASH_ESCAPES SQL mode, <a href="database-administration.html#server-sql-mode">The Server SQL Mode</a></dt><dt>NO_DIR_IN_CREATE SQL mode, <a href="database-administration.html#server-sql-mode">The Server SQL Mode</a></dt><dt>NO_FIELD_OPTIONS SQL mode, <a href="database-administration.html#server-sql-mode">The Server SQL Mode</a></dt><dt>NO_KEY_OPTIONS SQL mode, <a href="database-administration.html#server-sql-mode">The Server SQL Mode</a></dt><dt>NO_TABLE_OPTIONS SQL mode, <a href="database-administration.html#server-sql-mode">The Server SQL Mode</a></dt><dt>NO_UNSIGNED_SUBTRACTION SQL mode, <a href="database-administration.html#server-sql-mode">The Server SQL Mode</a></dt><dt>NO_ZERO_DATE SQL mode, <a href="database-administration.html#server-sql-mode">The Server SQL Mode</a></dt><dt>NO_ZERO_IN_DATE SQL mode, <a href="database-administration.html#server-sql-mode">The Server SQL Mode</a></dt><dt>NUL, <a href="language-structure.html#string-syntax">Strings</a></dt><dt>NULL, <a href="tutorial.html#working-with-null">Working with NULL Values</a>, <a href="problems.html#problems-with-null">Problems with NULL Values</a></dt><dd><dl><dt>testing for null, <a href="functions.html#comparison-operators">Comparison Functions and Operators</a>, <a href="functions.html#control-flow-functions">Control Flow Functions</a></dt></dl></dd><dt>NULL value, <a href="tutorial.html#working-with-null">Working with NULL Values</a>, <a href="language-structure.html#null-values">NULL Values</a></dt><dt>NULL values</dt><dd><dl><dt>and AUTO_INCREMENT columns, <a href="problems.html#problems-with-null">Problems with NULL Values</a></dt><dt>and indexes, <a href="sql-syntax.html#create-table">CREATE TABLE Syntax</a></dt><dt>and TIMESTAMP columns, <a href="problems.html#problems-with-null">Problems with NULL Values</a></dt><dt>vs. empty values, <a href="problems.html#problems-with-null">Problems with NULL Values</a></dt></dl></dd><dt>NULLIF(), <a href="functions.html#control-flow-functions">Control Flow Functions</a></dt><dt>numbers, <a href="language-structure.html#number-syntax">Numbers</a></dt><dt>NUMERIC data type, <a href="column-types.html#numeric-type-overview">Overview of Numeric Types</a></dt><dt>numeric types, <a href="column-types.html#storage-requirements">Column Type Storage Requirements</a></dt><dt>NumGeometries(), <a href="spatial-extensions-in-mysql.html#geometrycollection-property-functions">GeometryCollection Functions</a></dt><dt>NumInteriorRings(), <a href="spatial-extensions-in-mysql.html#polygon-property-functions">Polygon Functions</a></dt><dt>NumPoints(), <a href="spatial-extensions-in-mysql.html#linestring-property-functions">LineString Functions</a></dt></dl></div><div class="indexdiv"><h3>O</h3><dl><dt>OCT(), <a href="functions.html#string-functions">String Functions</a></dt><dt>OCTET_LENGTH(), <a href="functions.html#string-functions">String Functions</a></dt><dt>ODBC, <a href="connectors.html#odbc-connector">MySQL Connector/ODBC</a></dt><dt>ODBC compatibility, <a href="language-structure.html#identifier-qualifiers">Identifier Qualifiers</a>, <a href="column-types.html#numeric-type-overview">Overview of Numeric Types</a>, <a href="functions.html#comparison-operators">Comparison Functions and Operators</a>, <a href="sql-syntax.html#create-table">CREATE TABLE Syntax</a>, <a href="sql-syntax.html#join">JOIN Syntax</a></dt><dt>odbcadmin program, <a href="connectors.html#programs-known-to-work-with-myodbc">Programs Known to Work With MyODBC</a></dt><dt>OLAP, <a href="functions.html#group-by-modifiers">GROUP BY Modifiers</a></dt><dt>OLD_PASSWORD(), <a href="functions.html#encryption-functions">Encryption Functions</a></dt><dt>ON DUPLICATE KEY, <a href="sql-syntax.html#insert">INSERT Syntax</a></dt><dt>one-database</dt><dd><dl><dt>mysql option, <a href="client-side-scripts.html#mysql-command-options">Options</a></dt></dl></dd><dt>online location of manual, <a href="introduction.html#manual-info">About This Manual</a></dt><dt>ONLY_FULL_GROUP_BY SQL mode, <a href="database-administration.html#server-sql-mode">The Server SQL Mode</a></dt><dt>OPEN, <a href="stored-procedures.html#open">Cursor OPEN Statement</a></dt><dt>Open Source</dt><dd><dl><dt>defined, <a href="introduction.html#what-is">Overview of the MySQL Database Management System</a></dt></dl></dd><dt>open tables, <a href="optimization.html#open-tables">How MySQL Counts Open Tables</a>, <a href="client-side-scripts.html#mysqladmin">mysqladmin — Client for Administering a MySQL Server</a></dt><dt>OpenGIS, <a href="spatial-extensions-in-mysql.html#gis-introduction">Introduction</a></dt><dt>opening</dt><dd><dl><dt>tables, <a href="optimization.html#table-cache">How MySQL Opens and Closes Tables</a></dt></dl></dd><dt>opens, <a href="client-side-scripts.html#mysqladmin">mysqladmin — Client for Administering a MySQL Server</a></dt><dt>OpenSSL, <a href="database-administration.html#secure-connections">Using Secure Connections</a>, <a href="database-administration.html#secure-using-yassl">Using yaSSL</a></dt><dt>open_files_limit variable, <a href="client-side-scripts.html#mysqlbinlog">mysqlbinlog — Utility for Processing Binary Log Files</a></dt><dt>operating systems</dt><dd><dl><dt>file-size limits, <a href="introduction.html#table-size">How Big MySQL Tables Can Be</a></dt><dt>supported, <a href="installing.html#which-os">Operating Systems Supported by MySQL</a></dt><dt>Windows versus Unix, <a href="installing.html#windows-vs-unix">MySQL on Windows Compared to MySQL on Unix</a></dt></dl></dd><dt>operations</dt><dd><dl><dt>arithmetic, <a href="functions.html#arithmetic-functions">Arithmetic Operators</a></dt></dl></dd><dt>operators, <a href="functions.html">Functions and Operators</a></dt><dd><dl><dt>cast, <a href="functions.html#arithmetic-functions">Arithmetic Operators</a>, <a href="functions.html#cast-functions">Cast Functions and Operators</a></dt><dt>logical, <a href="functions.html#logical-operators">Logical Operators</a></dt></dl></dd><dt>optimization</dt><dd><dl><dt>tips, <a href="optimization.html#tips">Other Optimization Tips</a></dt></dl></dd><dt>optimizations, <a href="optimization.html#where-optimizations">How MySQL Optimizes WHERE Clauses</a>, <a href="optimization.html#index-merge-optimization">Index Merge Optimization</a></dt><dt>OPTIMIZE TABLE, <a href="sql-syntax.html#optimize-table">OPTIMIZE TABLE Syntax</a></dt><dt>optimizer</dt><dd><dl><dt>controlling, <a href="optimization.html#controlling-optimizer">Controlling Query Optimizer Performance</a></dt></dl></dd><dt>optimizing</dt><dd><dl><dt>DISTINCT, <a href="optimization.html#distinct-optimization">How MySQL Optimizes DISTINCT</a></dt><dt>filesort, <a href="optimization.html#order-by-optimization">How MySQL Optimizes ORDER BY</a></dt><dt>GROUP BY, <a href="optimization.html#group-by-optimization">How MySQL Optimizes GROUP BY</a></dt><dt>LEFT JOIN, <a href="optimization.html#left-join-optimization">How MySQL Optimizes LEFT JOIN and RIGHT JOIN</a></dt><dt>LIMIT, <a href="optimization.html#limit-optimization">How MySQL Optimizes LIMIT</a></dt><dt>tables, <a href="database-administration.html#table-optimization">Table Optimization</a></dt></dl></dd><dt>option files, <a href="using-mysql-programs.html#option-files">Using Option Files</a>, <a href="database-administration.html#access-denied">Causes of Access denied Errors</a></dt><dt>options</dt><dd><dl><dt>command-line, <a href="database-administration.html#server-options">mysqld Command-Line Options</a></dt><dd><dl><dt>mysql, <a href="client-side-scripts.html#mysql-command-options">Options</a></dt><dt>mysqladmin, <a href="client-side-scripts.html#mysqladmin">mysqladmin — Client for Administering a MySQL Server</a></dt></dl></dd><dt>configure, <a href="installing.html#configure-options">Typical configure Options</a></dt><dt>embedded server, <a href="apis.html#libmysqld-options">Options with the Embedded Server</a></dt><dt>libmysqld, <a href="apis.html#libmysqld-options">Options with the Embedded Server</a></dt><dt>myisamchk, <a href="database-administration.html#myisamchk-general-options">General Options for myisamchk</a></dt><dt>provided by MySQL, <a href="tutorial.html">Tutorial</a></dt><dt>replication, <a href="replication.html#replication-features">Replication Features and Known Problems</a></dt></dl></dd><dt>OR, <a href="tutorial.html#searching-on-two-keys">Searching on Two Keys</a>, <a href="optimization.html#index-merge-optimization">Index Merge Optimization</a></dt><dd><dl><dt>bitwise, <a href="functions.html#bit-functions">Bit Functions</a></dt><dt>logical, <a href="functions.html#logical-operators">Logical Operators</a></dt></dl></dd><dt>OR Index Merge optimization, <a href="optimization.html#index-merge-optimization">Index Merge Optimization</a></dt><dt>Oracle compatibility, <a href="introduction.html#extensions-to-ansi">MySQL Extensions to Standard SQL</a>, <a href="functions.html#group-by-functions">GROUP BY (Aggregate) Functions</a>, <a href="sql-syntax.html#describe">DESCRIBE Syntax (Get Information About Columns)</a></dt><dt>ORACLE SQL mode, <a href="database-administration.html#server-sql-mode">The Server SQL Mode</a></dt><dt>ORD(), <a href="functions.html#string-functions">String Functions</a></dt><dt>ORDER BY, <a href="tutorial.html#sorting-rows">Sorting Rows</a>, <a href="sql-syntax.html#alter-table">ALTER TABLE Syntax</a>, <a href="sql-syntax.html#select">SELECT Syntax</a></dt><dd><dl><dt>aliases in, <a href="functions.html#group-by-hidden-fields">GROUP BY with Hidden Fields</a></dt></dl></dd><dt>OUTFILE, <a href="sql-syntax.html#select">SELECT Syntax</a></dt><dt>Overlaps(), <a href="spatial-extensions-in-mysql.html#functions-that-test-spatial-relationships-between-geometries">Functions That Test Spatial Relationships Between Geometries</a></dt><dt>overview, <a href="introduction.html">General Information</a></dt></dl></div><div class="indexdiv"><h3>P</h3><dl><dt>packages</dt><dd><dl><dt>list of, <a href="credits.html#packages">Packages that support MySQL</a></dt></dl></dd><dt>page-level locking, <a href="optimization.html#internal-locking">Locking Methods</a></dt><dt>pager</dt><dd><dl><dt>mysql option, <a href="client-side-scripts.html#mysql-command-options">Options</a></dt></dl></dd><dt>parameters</dt><dd><dl><dt>server, <a href="optimization.html#server-parameters">Tuning Server Parameters</a></dt></dl></dd><dt>parentheses ( and ), <a href="functions.html#parentheses">Parentheses</a></dt><dt>password</dt><dd><dl><dt>mysql option, <a href="client-side-scripts.html#mysql-command-options">Options</a></dt><dt>mysqld_multi option, <a href="database-administration.html#mysqld-multi">mysqld_multi — Program for Managing Multiple MySQL Servers</a></dt><dt>root user, <a href="installing.html#default-privileges">Securing the Initial MySQL Accounts</a></dt></dl></dd><dt>password encryption</dt><dd><dl><dt>reversibility of, <a href="functions.html#encryption-functions">Encryption Functions</a></dt></dl></dd><dt>PASSWORD(), <a href="database-administration.html#connection-access">Access Control, Stage 1: Connection Verification</a>, <a href="database-administration.html#passwords">Assigning Account Passwords</a>, <a href="functions.html#encryption-functions">Encryption Functions</a>, <a href="problems.html#ignoring-user">Ignoring user</a></dt><dt>passwords</dt><dd><dl><dt>for users, <a href="database-administration.html#user-names">MySQL Usernames and Passwords</a></dt><dt>forgotten, <a href="problems.html#resetting-permissions">How to Reset the Root Password</a></dt><dt>lost, <a href="problems.html#resetting-permissions">How to Reset the Root Password</a></dt><dt>resetting, <a href="problems.html#resetting-permissions">How to Reset the Root Password</a></dt><dt>security, <a href="database-administration.html#what-privileges">What the Privilege System Does</a></dt><dt>setting, <a href="database-administration.html#passwords">Assigning Account Passwords</a>, <a href="sql-syntax.html#grant">GRANT and REVOKE Syntax</a>, <a href="sql-syntax.html#set-password">SET PASSWORD Syntax</a></dt></dl></dd><dt>PATH environment variable, <a href="installing.html#installing-binary">Installing MySQL on Other Unix-Like Systems</a>, <a href="using-mysql-programs.html#invoking-programs">Invoking MySQL Programs</a>, <a href="environment-variables.html">Environment Variables</a></dt><dt>pattern matching, <a href="tutorial.html#pattern-matching">Pattern Matching</a></dt><dt>performance</dt><dd><dl><dt>benchmarks, <a href="optimization.html#custom-benchmarks">Using Your Own Benchmarks</a></dt><dt>disk issues, <a href="optimization.html#disk-issues">Disk Issues</a></dt><dt>estimating, <a href="optimization.html#estimating-performance">Estimating Query Performance</a></dt><dt>improving, <a href="replication.html#replication-faq">Replication FAQ</a>, <a href="optimization.html#data-size">Make Your Data as Small as Possible</a></dt></dl></dd><dt>PERIOD_ADD(), <a href="functions.html#date-and-time-functions">Date and Time Functions</a></dt><dt>PERIOD_DIFF(), <a href="functions.html#date-and-time-functions">Date and Time Functions</a></dt><dt>Perl</dt><dd><dl><dt>installing, <a href="installing.html#perl-support">Perl Installation Notes</a></dt><dt>installing on Windows, <a href="installing.html#activestate-perl">Installing ActiveState Perl on Windows</a></dt></dl></dd><dt>Perl API, <a href="apis.html#perl">MySQL Perl API</a></dt><dt>Perl DBI/DBD</dt><dd><dl><dt>installation problems, <a href="installing.html#perl-support-problems">Problems Using the Perl DBI/DBD Interface</a></dt></dl></dd><dt>permission checks</dt><dd><dl><dt>effect on speed, <a href="optimization.html#query-speed">Optimizing SELECT Statements and Other Queries</a></dt></dl></dd><dt>perror, <a href="client-side-scripts.html#client-side-overview">Overview of the Client-Side Scripts and Utilities</a></dt><dt>PHP API, <a href="apis.html#php">MySQL PHP API</a></dt><dt>PI(), <a href="functions.html#mathematical-functions">Mathematical Functions</a></dt><dt>PIPES_AS_CONCAT SQL mode, <a href="database-administration.html#server-sql-mode">The Server SQL Mode</a></dt><dt>POINT data type, <a href="spatial-extensions-in-mysql.html#mysql-spatial-datatypes">MySQL Spatial Data Types</a></dt><dt>point in time recovery, <a href="database-administration.html#point-in-time-recovery">Point-in-Time Recovery</a></dt><dt>Point(), <a href="spatial-extensions-in-mysql.html#gis-mysql-specific-functions">Creating Geometry Values Using MySQL-Specific Functions</a></dt><dt>PointFromText(), <a href="spatial-extensions-in-mysql.html#gis-wkt-functions">Creating Geometry Values Using WKT Functions</a></dt><dt>PointFromWKB(), <a href="spatial-extensions-in-mysql.html#gis-wkb-functions">Creating Geometry Values Using WKB Functions</a></dt><dt>PointN(), <a href="spatial-extensions-in-mysql.html#linestring-property-functions">LineString Functions</a></dt><dt>PointOnSurface(), <a href="spatial-extensions-in-mysql.html#multipolygon-property-functions">MultiPolygon Functions</a></dt><dt>PolyFromText(), <a href="spatial-extensions-in-mysql.html#gis-wkt-functions">Creating Geometry Values Using WKT Functions</a></dt><dt>PolyFromWKB(), <a href="spatial-extensions-in-mysql.html#gis-wkb-functions">Creating Geometry Values Using WKB Functions</a></dt><dt>POLYGON data type, <a href="spatial-extensions-in-mysql.html#mysql-spatial-datatypes">MySQL Spatial Data Types</a></dt><dt>Polygon(), <a href="spatial-extensions-in-mysql.html#gis-mysql-specific-functions">Creating Geometry Values Using MySQL-Specific Functions</a></dt><dt>PolygonFromText(), <a href="spatial-extensions-in-mysql.html#gis-wkt-functions">Creating Geometry Values Using WKT Functions</a></dt><dt>PolygonFromWKB(), <a href="spatial-extensions-in-mysql.html#gis-wkb-functions">Creating Geometry Values Using WKB Functions</a></dt><dt>port</dt><dd><dl><dt>mysql option, <a href="client-side-scripts.html#mysql-command-options">Options</a></dt></dl></dd><dt>portability, <a href="optimization.html#portability">Designing Applications for Portability</a></dt><dd><dl><dt>types, <a href="column-types.html#other-vendor-column-types">Using Column Types from Other Database Engines</a></dt></dl></dd><dt>porting</dt><dd><dl><dt>to other systems, <a href="porting.html">Porting to Other Systems</a></dt></dl></dd><dt>POSITION(), <a href="functions.html#string-functions">String Functions</a></dt><dt>post-install</dt><dd><dl><dt>multiple servers, <a href="database-administration.html#multiple-servers">Running Multiple MySQL Servers on the Same Machine</a></dt></dl></dd><dt>post-installation</dt><dd><dl><dt>setup and testing, <a href="installing.html#post-installation">Post-Installation Setup and Testing</a></dt></dl></dd><dt>PostgreSQL compatibility, <a href="introduction.html#extensions-to-ansi">MySQL Extensions to Standard SQL</a></dt><dt>POSTGRESQL SQL mode, <a href="database-administration.html#server-sql-mode">The Server SQL Mode</a></dt><dt>POW(), <a href="functions.html#mathematical-functions">Mathematical Functions</a></dt><dt>POWER(), <a href="functions.html#mathematical-functions">Mathematical Functions</a></dt><dt>precision</dt><dd><dl><dt>arithmetic, <a href="precision-math.html">Precision Math</a></dt></dl></dd><dt>precision math, <a href="precision-math.html">Precision Math</a></dt><dt>PREPARE, <a href="sql-syntax.html#sqlps">SQL Syntax for Prepared Statements</a></dt><dd><dl><dt>XA transactions, <a href="sql-syntax.html#xa-statements">XA Transaction SQL Syntax</a></dt></dl></dd><dt>PRIMARY KEY, <a href="sql-syntax.html#alter-table">ALTER TABLE Syntax</a>, <a href="sql-syntax.html#create-table">CREATE TABLE Syntax</a></dt><dd><dl><dt>constraint, <a href="introduction.html#constraint-primary-key">PRIMARY KEY and UNIQUE Index Constraints</a></dt></dl></dd><dt>primary key</dt><dd><dl><dt>deleting, <a href="sql-syntax.html#alter-table">ALTER TABLE Syntax</a></dt></dl></dd><dt>privilege</dt><dd><dl><dt>changes, <a href="database-administration.html#request-access">Access Control, Stage 2: Request Verification</a></dt></dl></dd><dt>privilege information</dt><dd><dl><dt>location, <a href="database-administration.html#privileges-provided">Privileges Provided by MySQL</a></dt></dl></dd><dt>privilege system, <a href="database-administration.html#what-privileges">What the Privilege System Does</a></dt><dd><dl><dt>described, <a href="database-administration.html#privileges">How the Privilege System Works</a></dt></dl></dd><dt>privileges</dt><dd><dl><dt>access, <a href="database-administration.html#privilege-system">The MySQL Access Privilege System</a></dt><dt>adding, <a href="database-administration.html#adding-users">Adding New User Accounts to MySQL</a></dt><dt>default, <a href="installing.html#default-privileges">Securing the Initial MySQL Accounts</a></dt><dt>deleting, <a href="database-administration.html#removing-users">Removing User Accounts from MySQL</a>, <a href="sql-syntax.html#drop-user">DROP USER Syntax</a></dt><dt>display, <a href="sql-syntax.html#show-grants">SHOW GRANTS Syntax</a></dt><dt>dropping, <a href="database-administration.html#removing-users">Removing User Accounts from MySQL</a>, <a href="sql-syntax.html#drop-user">DROP USER Syntax</a></dt><dt>granting, <a href="sql-syntax.html#grant">GRANT and REVOKE Syntax</a></dt><dt>revoking, <a href="sql-syntax.html#grant">GRANT and REVOKE Syntax</a></dt></dl></dd><dt>problems</dt><dd><dl><dt>access denied errors, <a href="problems.html#error-access-denied">Access denied</a></dt><dt>common errors, <a href="problems.html">Problems and Common Errors</a></dt><dt>compiling, <a href="installing.html#compilation-problems">Dealing with Problems Compiling MySQL</a></dt><dt>DATE columns, <a href="problems.html#using-date">Problems Using DATE Columns</a></dt><dt>date values, <a href="column-types.html#datetime">The DATETIME, DATE, and TIMESTAMP Types</a></dt><dt>installing on IBM-AIX, <a href="installing.html#ibm-aix">IBM-AIX notes</a></dt><dt>installing on Solaris, <a href="installing.html#solaris">Solaris Notes</a></dt><dt>installing Perl, <a href="installing.html#perl-support-problems">Problems Using the Perl DBI/DBD Interface</a></dt><dt>linking, <a href="problems.html#link-errors">Problems Linking to the MySQL Client Library</a></dt><dt>ODBC, <a href="connectors.html#myodbc-bug-report">How to Report MyODBC Problems or Bugs</a></dt><dt>reporting, <a href="introduction.html#bug-reports">How to Report Bugs or Problems</a></dt><dt>starting the server, <a href="installing.html#starting-server">Starting and Troubleshooting the MySQL Server</a></dt><dt>table locking, <a href="optimization.html#table-locking">Table Locking Issues</a></dt><dt>time zone, <a href="problems.html#timezone-problems">Time Zone Problems</a></dt></dl></dd><dt>PROCEDURE, <a href="sql-syntax.html#select">SELECT Syntax</a></dt><dt>procedures</dt><dd><dl><dt>adding, <a href="extending-mysql.html#adding-procedures">Adding New Procedures to MySQL</a></dt><dt>stored, <a href="introduction.html#ansi-diff-triggers">Stored Procedures and Triggers</a>, <a href="stored-procedures.html">Stored Procedures and Functions</a></dt></dl></dd><dt>process support, <a href="installing.html#which-os">Operating Systems Supported by MySQL</a></dt><dt>processes</dt><dd><dl><dt>display, <a href="sql-syntax.html#show-processlist">SHOW PROCESSLIST Syntax</a></dt></dl></dd><dt>processing</dt><dd><dl><dt>arguments, <a href="extending-mysql.html#udf-arguments">UDF Argument Processing</a></dt></dl></dd><dt>PROCESSLIST, <a href="sql-syntax.html#show-processlist">SHOW PROCESSLIST Syntax</a></dt><dt>program variables</dt><dd><dl><dt>setting, <a href="using-mysql-programs.html#program-variables">Using Options to Set Program Variables</a></dt></dl></dd><dt>programs</dt><dd><dl><dt>client, <a href="apis.html#building-clients">Building Client Programs</a></dt><dt>crash-me, <a href="optimization.html#portability">Designing Applications for Portability</a></dt><dt>list of, <a href="database-administration.html#server-side-overview">Overview of the Server-Side Scripts and Utilities</a></dt></dl></dd><dt>prompt</dt><dd><dl><dt>mysql option, <a href="client-side-scripts.html#mysql-command-options">Options</a></dt></dl></dd><dt>prompts</dt><dd><dl><dt>meanings, <a href="tutorial.html#entering-queries">Entering Queries</a></dt></dl></dd><dt>pronunciation</dt><dd><dl><dt>MySQL, <a href="introduction.html#what-is">Overview of the MySQL Database Management System</a></dt></dl></dd><dt>protocol</dt><dd><dl><dt>mysql option, <a href="client-side-scripts.html#mysql-command-options">Options</a></dt></dl></dd><dt>PURGE MASTER LOGS, <a href="sql-syntax.html#purge-master-logs">PURGE MASTER LOGS Syntax</a></dt><dt>Python API, <a href="apis.html#python">MySQL Python API</a></dt></dl></div><div class="indexdiv"><h3>Q</h3><dl><dt>QUARTER(), <a href="functions.html#date-and-time-functions">Date and Time Functions</a></dt><dt>queries</dt><dd><dl><dt>entering, <a href="tutorial.html#entering-queries">Entering Queries</a></dt><dt>estimating performance, <a href="optimization.html#estimating-performance">Estimating Query Performance</a></dt><dt>examples, <a href="tutorial.html#examples">Examples of Common Queries</a></dt><dt>speed of, <a href="optimization.html#query-speed">Optimizing SELECT Statements and Other Queries</a></dt><dt>Twin Studies project, <a href="tutorial.html#twin">Queries from the Twin Project</a></dt></dl></dd><dt>Query Cache, <a href="database-administration.html#query-cache">The MySQL Query Cache</a></dt><dt>query log, <a href="database-administration.html#query-log">The General Query Log</a></dt><dt>questions, <a href="client-side-scripts.html#mysqladmin">mysqladmin — Client for Administering a MySQL Server</a></dt><dd><dl><dt>answering, <a href="introduction.html#answering-questions">Guidelines for Answering Questions on the Mailing List</a></dt></dl></dd><dt>quick</dt><dd><dl><dt>mysql option, <a href="client-side-scripts.html#mysql-command-options">Options</a></dt></dl></dd><dt>QUOTE(), <a href="functions.html#string-functions">String Functions</a></dt><dt>quotes</dt><dd><dl><dt>in strings, <a href="language-structure.html#string-syntax">Strings</a></dt></dl></dd><dt>quoting, <a href="language-structure.html#string-syntax">Strings</a></dt><dt>quoting binary data, <a href="language-structure.html#string-syntax">Strings</a></dt><dt>quoting of identifiers, <a href="language-structure.html#legal-names">Database, Table, Index, Column, and Alias Names</a></dt></dl></div><div class="indexdiv"><h3>R</h3><dl><dt>RADIANS(), <a href="functions.html#mathematical-functions">Mathematical Functions</a></dt><dt>RAND(), <a href="functions.html#mathematical-functions">Mathematical Functions</a></dt><dt>raw</dt><dd><dl><dt>mysql option, <a href="client-side-scripts.html#mysql-command-options">Options</a></dt></dl></dd><dt>re-creating</dt><dd><dl><dt>grant tables, <a href="installing.html#unix-post-installation">Unix Post-Installation Procedures</a></dt></dl></dd><dt>read_buffer_size myisamchk
variable, <a href="database-administration.html#myisamchk-general-options">General Options for myisamchk</a></dt><dt>REAL data type, <a href="column-types.html#numeric-type-overview">Overview of Numeric Types</a></dt><dt>REAL_AS_FLOAT SQL mode, <a href="database-administration.html#server-sql-mode">The Server SQL Mode</a></dt><dt>reconfiguring, <a href="installing.html#compilation-problems">Dealing with Problems Compiling MySQL</a></dt><dt>reconnect</dt><dd><dl><dt>mysql option, <a href="client-side-scripts.html#mysql-command-options">Options</a></dt></dl></dd><dt>RECOVER</dt><dd><dl><dt>XA transactions, <a href="sql-syntax.html#xa-statements">XA Transaction SQL Syntax</a></dt></dl></dd><dt>recovery</dt><dd><dl><dt>from crash, <a href="database-administration.html#crash-recovery">Using myisamchk for Crash Recovery</a></dt><dt>point in time, <a href="database-administration.html#point-in-time-recovery">Point-in-Time Recovery</a></dt></dl></dd><dt>reducing</dt><dd><dl><dt>data size, <a href="optimization.html#data-size">Make Your Data as Small as Possible</a></dt></dl></dd><dt>references, <a href="sql-syntax.html#alter-table">ALTER TABLE Syntax</a></dt><dt>ref_or_null, <a href="optimization.html#is-null-optimization">How MySQL Optimizes IS NULL</a></dt><dt>regex, <a href="regexp.html">MySQL Regular Expressions</a></dt><dt>REGEXP, <a href="functions.html#string-comparison-functions">String Comparison Functions</a></dt><dt>regular expression syntax</dt><dd><dl><dt>described, <a href="regexp.html">MySQL Regular Expressions</a></dt></dl></dd><dt>Related(), <a href="spatial-extensions-in-mysql.html#functions-that-test-spatial-relationships-between-geometries">Functions That Test Spatial Relationships Between Geometries</a></dt><dt>relational databases</dt><dd><dl><dt>defined, <a href="introduction.html#what-is">Overview of the MySQL Database Management System</a></dt></dl></dd><dt>release numbers, <a href="installing.html#which-version">Choosing Which MySQL Distribution to Install</a></dt><dt>RELEASE SAVEPOINT, <a href="sql-syntax.html#savepoints">SAVEPOINT and ROLLBACK TO SAVEPOINT Syntax</a></dt><dt>releases</dt><dd><dl><dt>naming scheme, <a href="installing.html#choosing-version">Choosing Which Version of MySQL to Install</a></dt><dt>testing, <a href="installing.html#choosing-version">Choosing Which Version of MySQL to Install</a></dt><dt>updating, <a href="installing.html#many-versions">How and When Updates Are Released</a></dt></dl></dd><dt>RELEASE_LOCK(), <a href="functions.html#miscellaneous-functions">Miscellaneous Functions</a></dt><dt>RENAME TABLE, <a href="sql-syntax.html#rename-table">RENAME TABLE Syntax</a></dt><dt>RENAME USER, <a href="sql-syntax.html#rename-user">RENAME USER Syntax</a></dt><dt>renaming user accounts, <a href="sql-syntax.html#rename-user">RENAME USER Syntax</a></dt><dt>reordering</dt><dd><dl><dt>columns, <a href="problems.html#change-column-order">How to Change the Order of Columns in a Table</a></dt></dl></dd><dt>repair options</dt><dd><dl><dt>myisamchk, <a href="database-administration.html#myisamchk-repair-options">Repair Options for myisamchk</a></dt></dl></dd><dt>REPAIR TABLE, <a href="sql-syntax.html#repair-table">REPAIR TABLE Syntax</a></dt><dt>repairing</dt><dd><dl><dt>tables, <a href="database-administration.html#repair">How to Repair Tables</a></dt></dl></dd><dt>REPEAT, <a href="stored-procedures.html#repeat-statement">REPEAT Statement</a></dt><dt>REPEAT(), <a href="functions.html#string-functions">String Functions</a></dt><dt>replace, <a href="client-side-scripts.html#client-side-overview">Overview of the Client-Side Scripts and Utilities</a></dt><dt>REPLACE, <a href="sql-syntax.html#replace">REPLACE Syntax</a></dt><dt>REPLACE ... SELECT, <a href="sql-syntax.html#insert">INSERT Syntax</a></dt><dt>REPLACE(), <a href="functions.html#string-functions">String Functions</a></dt><dt>replication, <a href="replication.html">Replication in MySQL</a></dt><dt>replication limitations, <a href="replication.html#replication-features">Replication Features and Known Problems</a></dt><dt>replication masters</dt><dd><dl><dt>commands, <a href="sql-syntax.html#replication-master-sql">SQL Statements for Controlling Master Servers</a></dt></dl></dd><dt>replication options, <a href="replication.html#replication-features">Replication Features and Known Problems</a></dt><dt>replication slaves</dt><dd><dl><dt>commands, <a href="sql-syntax.html#replication-slave-sql">SQL Statements for Controlling Slave Servers</a></dt></dl></dd><dt>reporting</dt><dd><dl><dt>bugs, <a href="introduction.html#bug-reports">How to Report Bugs or Problems</a></dt><dt>Connector/ODBC problems, <a href="connectors.html#myodbc-bug-report">How to Report MyODBC Problems or Bugs</a></dt><dt>errors, <a href="introduction.html">General Information</a>, <a href="introduction.html#questions">MySQL Mailing Lists</a></dt><dt>MyODBC problems, <a href="connectors.html#myodbc-bug-report">How to Report MyODBC Problems or Bugs</a></dt></dl></dd><dt>REQUIRE GRANT option, <a href="database-administration.html#secure-grant">SSL GRANT Options</a>, <a href="sql-syntax.html#grant">GRANT and REVOKE Syntax</a></dt><dt>reserved words</dt><dd><dl><dt>exceptions, <a href="language-structure.html#reserved-words">Treatment of Reserved Words in MySQL</a></dt></dl></dd><dt>RESET MASTER, <a href="sql-syntax.html#reset-master">RESET MASTER Syntax</a></dt><dt>RESET SLAVE, <a href="sql-syntax.html#reset-slave">RESET SLAVE Syntax</a></dt><dt>restarting</dt><dd><dl><dt>the server, <a href="installing.html#unix-post-installation">Unix Post-Installation Procedures</a></dt></dl></dd><dt>RESTORE TABLE, <a href="sql-syntax.html#restore-table">RESTORE TABLE Syntax</a></dt><dt>restrictions</dt><dd><dl><dt>server-side cursors, <a href="restrictions.html#cursor-restrictions">Restrictions on Server-Side Cursors</a></dt><dt>stored routines, <a href="restrictions.html#routine-restrictions">Restrictions on Stored Routines and Triggers</a></dt><dt>subqueries, <a href="restrictions.html#subquery-restrictions">Restrictions on Subqueries</a></dt><dt>triggers, <a href="restrictions.html#routine-restrictions">Restrictions on Stored Routines and Triggers</a></dt><dt>views, <a href="restrictions.html#view-restrictions">Restrictions on Views</a></dt></dl></dd><dt>retrieving</dt><dd><dl><dt>data from tables, <a href="tutorial.html#retrieving-data">Retrieving Information from a Table</a></dt></dl></dd><dt>return (\r), <a href="language-structure.html#string-syntax">Strings</a></dt><dt>return values</dt><dd><dl><dt>UDFs, <a href="extending-mysql.html#udf-return-values">UDF Return Values and Error Handling</a></dt></dl></dd><dt>REVERSE(), <a href="functions.html#string-functions">String Functions</a></dt><dt>REVOKE, <a href="sql-syntax.html#grant">GRANT and REVOKE Syntax</a></dt><dt>revoking</dt><dd><dl><dt>privileges, <a href="sql-syntax.html#grant">GRANT and REVOKE Syntax</a></dt></dl></dd><dt>RIGHT JOIN, <a href="sql-syntax.html#join">JOIN Syntax</a></dt><dt>RIGHT OUTER JOIN, <a href="sql-syntax.html#join">JOIN Syntax</a></dt><dt>RIGHT(), <a href="functions.html#string-functions">String Functions</a></dt><dt>RLIKE, <a href="functions.html#string-comparison-functions">String Comparison Functions</a></dt><dt>ROLLBACK, <a href="introduction.html#ansi-diff-transactions">Transactions and Atomic Operations</a>, <a href="sql-syntax.html#commit">START TRANSACTION, COMMIT, and ROLLBACK Syntax</a></dt><dd><dl><dt>XA transactions, <a href="sql-syntax.html#xa-statements">XA Transaction SQL Syntax</a></dt></dl></dd><dt>ROLLBACK TO SAVEPOINT, <a href="sql-syntax.html#savepoints">SAVEPOINT and ROLLBACK TO SAVEPOINT Syntax</a></dt><dt>ROLLUP, <a href="functions.html#group-by-modifiers">GROUP BY Modifiers</a></dt><dt>root password, <a href="installing.html#default-privileges">Securing the Initial MySQL Accounts</a></dt><dt>root user</dt><dd><dl><dt>password resetting, <a href="problems.html#resetting-permissions">How to Reset the Root Password</a></dt></dl></dd><dt>ROUND(), <a href="functions.html#mathematical-functions">Mathematical Functions</a></dt><dt>rounding, <a href="precision-math.html">Precision Math</a></dt><dt>rounding errors, <a href="column-types.html#numeric-type-overview">Overview of Numeric Types</a></dt><dt>ROUTINES</dt><dd><dl><dt>INFORMATION_SCHEMA table, <a href="information-schema.html#routines-table">The INFORMATION_SCHEMA ROUTINES Table</a></dt></dl></dd><dt>row-level locking, <a href="optimization.html#internal-locking">Locking Methods</a></dt><dt>rows</dt><dd><dl><dt>counting, <a href="tutorial.html#counting-rows">Counting Rows</a></dt><dt>deleting, <a href="problems.html#deleting-from-related-tables">Deleting Rows from Related Tables</a></dt><dt>locking, <a href="introduction.html#ansi-diff-transactions">Transactions and Atomic Operations</a></dt><dt>matching problems, <a href="problems.html#no-matching-rows">Solving Problems with No Matching Rows</a></dt><dt>selecting, <a href="tutorial.html#selecting-rows">Selecting Particular Rows</a></dt><dt>sorting, <a href="tutorial.html#sorting-rows">Sorting Rows</a></dt></dl></dd><dt>ROW_COUNT(), <a href="functions.html#information-functions">Information Functions</a></dt><dt>RPAD(), <a href="functions.html#string-functions">String Functions</a></dt><dt>RPM file, <a href="installing.html#linux-rpm">Installing MySQL on Linux</a></dt><dt>RPM Package Manager, <a href="installing.html#linux-rpm">Installing MySQL on Linux</a></dt><dt>RTRIM(), <a href="functions.html#string-functions">String Functions</a></dt><dt>RTS-threads, <a href="porting.html#rts-threads">Comments about RTS Threads</a></dt><dt>running</dt><dd><dl><dt>ANSI mode, <a href="introduction.html#ansi-mode">Running MySQL in ANSI Mode</a></dt><dt>batch mode, <a href="tutorial.html#batch-mode">Using mysql in Batch Mode</a></dt><dt>multiple servers, <a href="database-administration.html#multiple-servers">Running Multiple MySQL Servers on the Same Machine</a></dt><dt>queries, <a href="tutorial.html#entering-queries">Entering Queries</a></dt></dl></dd><dt>running configure after prior invocation, <a href="installing.html#compilation-problems">Dealing with Problems Compiling MySQL</a></dt></dl></div><div class="indexdiv"><h3>S</h3><dl><dt>safe-updates</dt><dd><dl><dt>mysql option, <a href="client-side-scripts.html#mysql-command-options">Options</a></dt></dl></dd><dt>safe-updates option, <a href="client-side-scripts.html#safe-updates">Using the --safe-updates Option</a></dt><dt>Sakila, <a href="introduction.html#history">History of MySQL</a></dt><dt>SAVEPOINT, <a href="sql-syntax.html#savepoints">SAVEPOINT and ROLLBACK TO SAVEPOINT Syntax</a></dt><dt>scale</dt><dd><dl><dt>arithmetic, <a href="precision-math.html">Precision Math</a></dt></dl></dd><dt>schema</dt><dd><dl><dt>altering, <a href="sql-syntax.html#alter-database">ALTER DATABASE Syntax</a></dt><dt>creating, <a href="sql-syntax.html#create-database">CREATE DATABASE Syntax</a></dt><dt>deleting, <a href="sql-syntax.html#drop-database">DROP DATABASE Syntax</a></dt></dl></dd><dt>SCHEMA(), <a href="functions.html#information-functions">Information Functions</a></dt><dt>SCHEMATA</dt><dd><dl><dt>INFORMATION_SCHEMA table, <a href="information-schema.html#schemata-table">The INFORMATION_SCHEMA SCHEMATA Table</a></dt></dl></dd><dt>SCHEMA_PRIVILEGES</dt><dd><dl><dt>INFORMATION_SCHEMA table, <a href="information-schema.html#schema-privileges-table">The INFORMATION_SCHEMA SCHEMA_PRIVILEGES Table</a></dt></dl></dd><dt>script files, <a href="tutorial.html#batch-mode">Using mysql in Batch Mode</a></dt><dt>scripts</dt><dd><dl><dt>mysqlbug, <a href="introduction.html#bug-reports">How to Report Bugs or Problems</a></dt><dt>mysql_install_db, <a href="installing.html#mysql-install-db">Problems Running mysql_install_db</a></dt></dl></dd><dt>searching</dt><dd><dl><dt>and case sensitivity, <a href="problems.html#case-sensitivity">Case Sensitivity in Searches</a></dt><dt>full-text, <a href="functions.html#fulltext-search">Full-Text Search Functions</a></dt><dt>MySQL Web pages, <a href="introduction.html#asking-questions">Asking Questions or Reporting Bugs</a></dt><dt>two keys, <a href="tutorial.html#searching-on-two-keys">Searching on Two Keys</a></dt></dl></dd><dt>SECOND(), <a href="functions.html#date-and-time-functions">Date and Time Functions</a></dt><dt>secure-auth</dt><dd><dl><dt>mysql option, <a href="client-side-scripts.html#mysql-command-options">Options</a></dt></dl></dd><dt>security</dt><dd><dl><dt>against attackers, <a href="database-administration.html#security-against-attack">Making MySQL Secure Against Attackers</a></dt></dl></dd><dt>security system, <a href="database-administration.html#privilege-system">The MySQL Access Privilege System</a></dt><dt>SEC_TO_TIME(), <a href="functions.html#date-and-time-functions">Date and Time Functions</a></dt><dt>SELECT</dt><dd><dl><dt>LIMIT, <a href="sql-syntax.html#select">SELECT Syntax</a></dt><dt>optimizing, <a href="optimization.html#explain">EXPLAIN Syntax (Get Information About a SELECT)</a></dt><dt>Query Cache, <a href="database-administration.html#query-cache">The MySQL Query Cache</a></dt></dl></dd><dt>SELECT INTO, <a href="stored-procedures.html#select-into-statement">SELECT ... INTO Statement</a></dt><dt>SELECT INTO TABLE, <a href="introduction.html#ansi-diff-select-into-table">SELECT INTO TABLE</a></dt><dt>SELECT speed, <a href="optimization.html#select-speed">Speed of SELECT Queries</a></dt><dt>selecting</dt><dd><dl><dt>databases, <a href="tutorial.html#creating-database">Creating and Selecting a Database</a></dt></dl></dd><dt>select_limit variable, <a href="client-side-scripts.html#mysql-command-options">Options</a></dt><dt>SEQUENCE, <a href="tutorial.html#example-auto-increment">Using AUTO_INCREMENT</a></dt><dt>sequence emulation, <a href="functions.html#information-functions">Information Functions</a></dt><dt>sequences, <a href="tutorial.html#example-auto-increment">Using AUTO_INCREMENT</a></dt><dt>server</dt><dd><dl><dt>connecting, <a href="tutorial.html#connecting-disconnecting">Connecting to and Disconnecting from the Server</a>, <a href="database-administration.html#connecting">Connecting to the MySQL Server</a></dt><dt>debugging, <a href="porting.html#debugging-server">Debugging a MySQL Server</a></dt><dt>disconnecting, <a href="tutorial.html#connecting-disconnecting">Connecting to and Disconnecting from the Server</a></dt><dt>restart, <a href="installing.html#unix-post-installation">Unix Post-Installation Procedures</a></dt><dt>shutdown, <a href="installing.html#unix-post-installation">Unix Post-Installation Procedures</a></dt><dt>starting, <a href="installing.html#unix-post-installation">Unix Post-Installation Procedures</a></dt><dt>starting and stopping, <a href="installing.html#automatic-start">Starting and Stopping MySQL Automatically</a></dt><dt>starting problems, <a href="installing.html#starting-server">Starting and Troubleshooting the MySQL Server</a></dt></dl></dd><dt>server variables, <a href="database-administration.html#server-system-variables">Server System Variables</a>, <a href="language-structure.html#system-variables">System Variables</a>, <a href="sql-syntax.html#show-variables">SHOW VARIABLES Syntax</a></dt><dt>server-side cursor restrictions, <a href="restrictions.html#cursor-restrictions">Restrictions on Server-Side Cursors</a></dt><dt>servers</dt><dd><dl><dt>multiple, <a href="database-administration.html#multiple-servers">Running Multiple MySQL Servers on the Same Machine</a></dt></dl></dd><dt>SESSION_USER(), <a href="functions.html#information-functions">Information Functions</a></dt><dt>SET, <a href="sql-syntax.html#set-option">SET Syntax</a>, <a href="stored-procedures.html#set-statement">Variable SET Statement</a></dt><dd><dl><dt>size, <a href="column-types.html#storage-requirements">Column Type Storage Requirements</a></dt></dl></dd><dt>SET data type, <a href="column-types.html#string-type-overview">Overview of String Types</a>, <a href="column-types.html#set">The SET Type</a></dt><dt>SET GLOBAL SQL_SLAVE_SKIP_COUNTER, <a href="sql-syntax.html#set-global-sql-slave-skip-counter">SET GLOBAL SQL_SLAVE_SKIP_COUNTER Syntax</a></dt><dt>SET OPTION, <a href="sql-syntax.html#set-option">SET Syntax</a></dt><dt>SET PASSWORD, <a href="sql-syntax.html#set-password">SET PASSWORD Syntax</a></dt><dt>SET PASSWORD statement, <a href="database-administration.html#passwords">Assigning Account Passwords</a></dt><dt>SET SQL_LOG_BIN, <a href="sql-syntax.html#set-sql-log-bin">SET SQL_LOG_BIN Syntax</a></dt><dt>SET TRANSACTION, <a href="sql-syntax.html#set-transaction">SET TRANSACTION Syntax</a></dt><dt>setting</dt><dd><dl><dt>passwords, <a href="database-administration.html#passwords">Assigning Account Passwords</a></dt></dl></dd><dt>setting passwords, <a href="sql-syntax.html#set-password">SET PASSWORD Syntax</a></dt><dt>setting program variables, <a href="using-mysql-programs.html#program-variables">Using Options to Set Program Variables</a></dt><dt>setup</dt><dd><dl><dt>post-installation, <a href="installing.html#post-installation">Post-Installation Setup and Testing</a></dt></dl></dd><dt>SHA(), <a href="functions.html#encryption-functions">Encryption Functions</a></dt><dt>SHA1(), <a href="functions.html#encryption-functions">Encryption Functions</a></dt><dt>shell syntax, <a href="introduction.html#manual-conventions">Conventions Used in This Manual</a></dt><dt>SHOW BINARY LOGS, <a href="sql-syntax.html#show-master-logs">SHOW MASTER LOGS Syntax</a></dt><dt>SHOW BINLOG EVENTS, <a href="sql-syntax.html#show">SHOW Syntax</a>, <a href="sql-syntax.html#show-binlog-events">SHOW BINLOG EVENTS Syntax</a></dt><dt>SHOW CHARACTER SET, <a href="sql-syntax.html#show-character-set">SHOW CHARACTER SET Syntax</a></dt><dt>SHOW COLLATION, <a href="sql-syntax.html#show-collation">SHOW COLLATION Syntax</a></dt><dt>SHOW COLUMNS, <a href="sql-syntax.html#show">SHOW Syntax</a>, <a href="sql-syntax.html#show-columns">SHOW COLUMNS Syntax</a></dt><dt>SHOW CREATE DATABASE, <a href="sql-syntax.html#show">SHOW Syntax</a>, <a href="sql-syntax.html#show-create-database">SHOW CREATE DATABASE Syntax</a></dt><dt>SHOW CREATE FUNCTION, <a href="stored-procedures.html#show-create-procedure">SHOW CREATE PROCEDURE and SHOW CREATE FUNCTION</a></dt><dt>SHOW CREATE PROCEDURE, <a href="stored-procedures.html#show-create-procedure">SHOW CREATE PROCEDURE and SHOW CREATE FUNCTION</a></dt><dt>SHOW CREATE SCHEMA, <a href="sql-syntax.html#show">SHOW Syntax</a>, <a href="sql-syntax.html#show-create-database">SHOW CREATE DATABASE Syntax</a></dt><dt>SHOW CREATE TABLE, <a href="sql-syntax.html#show">SHOW Syntax</a>, <a href="sql-syntax.html#show-create-table">SHOW CREATE TABLE Syntax</a></dt><dt>SHOW CREATE VIEW, <a href="views.html#show-create-view">SHOW CREATE VIEW Syntax</a></dt><dt>SHOW DATABASES, <a href="sql-syntax.html#show">SHOW Syntax</a>, <a href="sql-syntax.html#show-databases">SHOW DATABASES Syntax</a></dt><dt>SHOW ENGINE, <a href="sql-syntax.html#show">SHOW Syntax</a>, <a href="sql-syntax.html#show-engine">SHOW ENGINE Syntax</a></dt><dt>SHOW ENGINES, <a href="sql-syntax.html#show">SHOW Syntax</a>, <a href="sql-syntax.html#show-engines">SHOW ENGINES Syntax</a></dt><dt>SHOW ERRORS, <a href="sql-syntax.html#show">SHOW Syntax</a>, <a href="sql-syntax.html#show-errors">SHOW ERRORS Syntax</a></dt><dt>SHOW extensions, <a href="information-schema.html#extended-show">Extensions to SHOW Statements</a></dt><dt>SHOW FIELDS, <a href="sql-syntax.html#show">SHOW Syntax</a></dt><dt>SHOW FUNCTION STATUS, <a href="stored-procedures.html#show-procedure-status">SHOW PROCEDURE STATUS and SHOW FUNCTION STATUS</a></dt><dt>SHOW GRANTS, <a href="sql-syntax.html#show">SHOW Syntax</a>, <a href="sql-syntax.html#show-grants">SHOW GRANTS Syntax</a></dt><dt>SHOW INDEX, <a href="sql-syntax.html#show">SHOW Syntax</a>, <a href="sql-syntax.html#show-index">SHOW INDEX Syntax</a></dt><dt>SHOW INNODB STATUS, <a href="sql-syntax.html#show">SHOW Syntax</a></dt><dt>SHOW KEYS, <a href="sql-syntax.html#show">SHOW Syntax</a>, <a href="sql-syntax.html#show-index">SHOW INDEX Syntax</a></dt><dt>SHOW MASTER LOGS, <a href="sql-syntax.html#show">SHOW Syntax</a>, <a href="sql-syntax.html#show-master-logs">SHOW MASTER LOGS Syntax</a></dt><dt>SHOW MASTER STATUS, <a href="sql-syntax.html#show">SHOW Syntax</a>, <a href="sql-syntax.html#show-master-status">SHOW MASTER STATUS Syntax</a></dt><dt>SHOW OPEN TABLES, <a href="sql-syntax.html#show">SHOW Syntax</a>, <a href="sql-syntax.html#show-open-tables">SHOW OPEN TABLES Syntax</a></dt><dt>SHOW PRIVILEGES, <a href="sql-syntax.html#show">SHOW Syntax</a>, <a href="sql-syntax.html#show-privileges">SHOW PRIVILEGES Syntax</a></dt><dt>SHOW PROCEDURE STATUS, <a href="stored-procedures.html#show-procedure-status">SHOW PROCEDURE STATUS and SHOW FUNCTION STATUS</a></dt><dt>SHOW PROCESSLIST, <a href="sql-syntax.html#show">SHOW Syntax</a>, <a href="sql-syntax.html#show-processlist">SHOW PROCESSLIST Syntax</a></dt><dt>SHOW SCHEMAS, <a href="sql-syntax.html#show">SHOW Syntax</a>, <a href="sql-syntax.html#show-databases">SHOW DATABASES Syntax</a></dt><dt>SHOW SLAVE HOSTS, <a href="sql-syntax.html#show">SHOW Syntax</a>, <a href="sql-syntax.html#show-slave-hosts">SHOW SLAVE HOSTS Syntax</a></dt><dt>SHOW SLAVE STATUS, <a href="sql-syntax.html#show">SHOW Syntax</a>, <a href="sql-syntax.html#show-slave-status">SHOW SLAVE STATUS Syntax</a></dt><dt>SHOW STATUS, <a href="sql-syntax.html#show">SHOW Syntax</a></dt><dt>SHOW STORAGE ENGINES, <a href="sql-syntax.html#show-engines">SHOW ENGINES Syntax</a></dt><dt>SHOW TABLE STATUS, <a href="sql-syntax.html#show">SHOW Syntax</a></dt><dt>SHOW TABLE TYPES, <a href="sql-syntax.html#show">SHOW Syntax</a>, <a href="sql-syntax.html#show-engines">SHOW ENGINES Syntax</a></dt><dt>SHOW TABLES, <a href="sql-syntax.html#show">SHOW Syntax</a>, <a href="sql-syntax.html#show-tables">SHOW TABLES Syntax</a></dt><dt>SHOW TRIGGERS, <a href="sql-syntax.html#show">SHOW Syntax</a>, <a href="sql-syntax.html#show-triggers">SHOW TRIGGERS Syntax</a></dt><dt>SHOW VARIABLES, <a href="sql-syntax.html#show">SHOW Syntax</a></dt><dt>SHOW WARNINGS, <a href="sql-syntax.html#show">SHOW Syntax</a>, <a href="sql-syntax.html#show-warnings">SHOW WARNINGS Syntax</a></dt><dt>SHOW with WHERE, <a href="information-schema.html">The INFORMATION_SCHEMA Information Database</a>, <a href="information-schema.html#extended-show">Extensions to SHOW Statements</a></dt><dt>show-warnings</dt><dd><dl><dt>mysql option, <a href="client-side-scripts.html#mysql-command-options">Options</a></dt></dl></dd><dt>shutdown_timeout variable, <a href="client-side-scripts.html#mysqladmin">mysqladmin — Client for Administering a MySQL Server</a></dt><dt>shutting down</dt><dd><dl><dt>the server, <a href="installing.html#unix-post-installation">Unix Post-Installation Procedures</a></dt></dl></dd><dt>sigint-ignore</dt><dd><dl><dt>mysql option, <a href="client-side-scripts.html#mysql-command-options">Options</a></dt></dl></dd><dt>SIGN(), <a href="functions.html#mathematical-functions">Mathematical Functions</a></dt><dt>silent</dt><dd><dl><dt>mysql option, <a href="client-side-scripts.html#mysql-command-options">Options</a></dt><dt>mysqld_multi option, <a href="database-administration.html#mysqld-multi">mysqld_multi — Program for Managing Multiple MySQL Servers</a></dt></dl></dd><dt>silent column changes, <a href="sql-syntax.html#silent-column-changes">Silent Column Specification Changes</a></dt><dt>SIN(), <a href="functions.html#mathematical-functions">Mathematical Functions</a></dt><dt>single quote (\'), <a href="language-structure.html#string-syntax">Strings</a></dt><dt>size of tables, <a href="introduction.html#table-size">How Big MySQL Tables Can Be</a></dt><dt>sizes</dt><dd><dl><dt>display, <a href="column-types.html">Column Types</a></dt></dl></dd><dt>skip-column-names</dt><dd><dl><dt>mysql option, <a href="client-side-scripts.html#mysql-command-options">Options</a></dt></dl></dd><dt>skip-line-numbers</dt><dd><dl><dt>mysql option, <a href="client-side-scripts.html#mysql-command-options">Options</a></dt></dl></dd><dt>SLEEP(), <a href="functions.html#miscellaneous-functions">Miscellaneous Functions</a></dt><dt>slow queries, <a href="client-side-scripts.html#mysqladmin">mysqladmin — Client for Administering a MySQL Server</a></dt><dt>slow query log, <a href="database-administration.html#slow-query-log">The Slow Query Log</a></dt><dt>SMALLINT data type, <a href="column-types.html#numeric-type-overview">Overview of Numeric Types</a></dt><dt>socket</dt><dd><dl><dt>mysql option, <a href="client-side-scripts.html#mysql-command-options">Options</a></dt></dl></dd><dt>socket location</dt><dd><dl><dt>changing, <a href="installing.html#configure-options">Typical configure Options</a></dt></dl></dd><dt>Solaris installation problems, <a href="installing.html#solaris">Solaris Notes</a></dt><dt>Solaris troubleshooting, <a href="installing.html#compilation-problems">Dealing with Problems Compiling MySQL</a></dt><dt>Solaris x86_64 issues, <a href="storage-engines.html#innodb-tuning">InnoDB Performance Tuning Tips</a></dt><dt>sorting</dt><dd><dl><dt>character sets, <a href="database-administration.html#character-sets">The Character Set Used for Data and Sorting</a></dt><dt>data, <a href="tutorial.html#sorting-rows">Sorting Rows</a></dt><dt>grant tables, <a href="database-administration.html#connection-access">Access Control, Stage 1: Connection Verification</a>, <a href="database-administration.html#request-access">Access Control, Stage 2: Request Verification</a></dt><dt>table rows, <a href="tutorial.html#sorting-rows">Sorting Rows</a></dt></dl></dd><dt>sort_buffer_size myisamchk
variable, <a href="database-administration.html#myisamchk-general-options">General Options for myisamchk</a></dt><dt>sort_key_blocks myisamchk variable, <a href="database-administration.html#myisamchk-general-options">General Options for myisamchk</a></dt><dt>SOUNDEX(), <a href="functions.html#string-functions">String Functions</a></dt><dt>SOUNDS LIKE, <a href="functions.html#string-functions">String Functions</a></dt><dt>source distribution</dt><dd><dl><dt>installing, <a href="installing.html#installing-source">MySQL Installation Using a Source Distribution</a></dt></dl></dd><dt>source distributions</dt><dd><dl><dt>on Linux, <a href="installing.html#source-notes-linux">Linux Source Distribution Notes</a></dt></dl></dd><dt>SPACE(), <a href="functions.html#string-functions">String Functions</a></dt><dt>Spatial Extensions in MySQL, <a href="spatial-extensions-in-mysql.html#gis-introduction">Introduction</a></dt><dt>speed</dt><dd><dl><dt>compiling, <a href="optimization.html#compile-and-link-options">How Compiling and Linking Affects the Speed of MySQL</a></dt><dt>increasing with replication, <a href="replication.html">Replication in MySQL</a></dt><dt>inserting, <a href="optimization.html#insert-speed">Speed of INSERT Statements</a></dt><dt>linking, <a href="optimization.html#compile-and-link-options">How Compiling and Linking Affects the Speed of MySQL</a></dt><dt>of queries, <a href="optimization.html#query-speed">Optimizing SELECT Statements and Other Queries</a>, <a href="optimization.html#select-speed">Speed of SELECT Queries</a></dt></dl></dd><dt>SQL</dt><dd><dl><dt>defined, <a href="introduction.html#what-is">Overview of the MySQL Database Management System</a></dt></dl></dd><dt>SQL commands</dt><dd><dl><dt>replication masters, <a href="sql-syntax.html#replication-master-sql">SQL Statements for Controlling Master Servers</a></dt><dt>replication slaves, <a href="sql-syntax.html#replication-slave-sql">SQL Statements for Controlling Slave Servers</a></dt></dl></dd><dt>SQL-92</dt><dd><dl><dt>extensions to, <a href="introduction.html#compatibility">MySQL Standards Compliance</a></dt></dl></dd><dt>SQL_BIG_RESULT, <a href="sql-syntax.html#select">SELECT Syntax</a></dt><dt>SQL_BUFFER_RESULT, <a href="sql-syntax.html#select">SELECT Syntax</a></dt><dt>SQL_CACHE, <a href="database-administration.html#query-cache-in-select">Query Cache SELECT Options</a>, <a href="sql-syntax.html#select">SELECT Syntax</a></dt><dt>SQL_CALC_FOUND_ROWS, <a href="sql-syntax.html#select">SELECT Syntax</a></dt><dt>SQL_NO_CACHE, <a href="database-administration.html#query-cache-in-select">Query Cache SELECT Options</a>, <a href="sql-syntax.html#select">SELECT Syntax</a></dt><dt>SQL_SMALL_RESULT, <a href="sql-syntax.html#select">SELECT Syntax</a></dt><dt>sql_yacc.cc problems, <a href="installing.html#compilation-problems">Dealing with Problems Compiling MySQL</a></dt><dt>SQRT(), <a href="functions.html#mathematical-functions">Mathematical Functions</a></dt><dt>square brackets, <a href="column-types.html">Column Types</a></dt><dt>SRID(), <a href="spatial-extensions-in-mysql.html#general-geometry-property-functions">General Geometry Functions</a></dt><dt>SSH, <a href="database-administration.html#windows-and-ssh">Connecting to MySQL Remotely from Windows with SSH</a></dt><dt>SSL and X509 Basics, <a href="database-administration.html#secure-connections">Using Secure Connections</a></dt><dt>SSL command-line options, <a href="database-administration.html#ssl-options">SSL Command-Line Options</a></dt><dt>SSL related options, <a href="database-administration.html#secure-grant">SSL GRANT Options</a>, <a href="sql-syntax.html#grant">GRANT and REVOKE Syntax</a></dt><dt>stability, <a href="introduction.html#stability">MySQL Stability</a></dt><dt>standard SQL</dt><dd><dl><dt>extensions to, <a href="introduction.html#compatibility">MySQL Standards Compliance</a></dt></dl></dd><dt>Standard SQL</dt><dd><dl><dt>differences from, <a href="sql-syntax.html#grant">GRANT and REVOKE Syntax</a></dt></dl></dd><dt>standards compatibility, <a href="introduction.html#compatibility">MySQL Standards Compliance</a></dt><dt>START</dt><dd><dl><dt>XA transactions, <a href="sql-syntax.html#xa-statements">XA Transaction SQL Syntax</a></dt></dl></dd><dt>START SLAVE, <a href="sql-syntax.html#start-slave">START SLAVE Syntax</a></dt><dt>START TRANSACTION, <a href="sql-syntax.html#commit">START TRANSACTION, COMMIT, and ROLLBACK Syntax</a></dt><dt>starting</dt><dd><dl><dt>comments, <a href="introduction.html#ansi-diff-comments">'--' as the Start of a Comment</a></dt><dt>mysqld, <a href="problems.html#changing-mysql-user">How to Run MySQL as a Normal User</a></dt><dt>the server, <a href="installing.html#unix-post-installation">Unix Post-Installation Procedures</a></dt><dt>the server automatically, <a href="installing.html#automatic-start">Starting and Stopping MySQL Automatically</a></dt></dl></dd><dt>Starting many servers, <a href="database-administration.html#multiple-servers">Running Multiple MySQL Servers on the Same Machine</a></dt><dt>StartPoint(), <a href="spatial-extensions-in-mysql.html#linestring-property-functions">LineString Functions</a></dt><dt>startup options</dt><dd><dl><dt>default, <a href="using-mysql-programs.html#option-files">Using Option Files</a></dt></dl></dd><dt>startup parameters, <a href="optimization.html#server-parameters">Tuning Server Parameters</a></dt><dd><dl><dt>mysql, <a href="client-side-scripts.html#mysql-command-options">Options</a></dt><dt>mysqladmin, <a href="client-side-scripts.html#mysqladmin">mysqladmin — Client for Administering a MySQL Server</a></dt><dt>tuning, <a href="optimization.html#system">System Factors and Startup Parameter Tuning</a></dt></dl></dd><dt>statements</dt><dd><dl><dt>GRANT, <a href="database-administration.html#adding-users">Adding New User Accounts to MySQL</a></dt><dt>INSERT, <a href="database-administration.html#adding-users">Adding New User Accounts to MySQL</a></dt></dl></dd><dt>statically</dt><dd><dl><dt>compiling, <a href="installing.html#configure-options">Typical configure Options</a></dt></dl></dd><dt>STATISTICS</dt><dd><dl><dt>INFORMATION_SCHEMA table, <a href="information-schema.html#statistics-table">The INFORMATION_SCHEMA STATISTICS Table</a></dt></dl></dd><dt>stats_method myisamchk variable, <a href="database-administration.html#myisamchk-general-options">General Options for myisamchk</a></dt><dt>status</dt><dd><dl><dt>tables, <a href="sql-syntax.html#show-table-status">SHOW TABLE STATUS Syntax</a></dt></dl></dd><dt>status command</dt><dd><dl><dt>results, <a href="client-side-scripts.html#mysqladmin">mysqladmin — Client for Administering a MySQL Server</a></dt></dl></dd><dt>status variables, <a href="database-administration.html#server-status-variables">Server Status Variables</a>, <a href="sql-syntax.html#show-status">SHOW STATUS Syntax</a></dt><dt>STD(), <a href="functions.html#group-by-functions">GROUP BY (Aggregate) Functions</a></dt><dt>STDDEV(), <a href="functions.html#group-by-functions">GROUP BY (Aggregate) Functions</a></dt><dt>STDDEV_POP(), <a href="functions.html#group-by-functions">GROUP BY (Aggregate) Functions</a></dt><dt>STDDEV_SAMP(), <a href="functions.html#group-by-functions">GROUP BY (Aggregate) Functions</a></dt><dt>STOP SLAVE, <a href="sql-syntax.html#stop-slave">STOP SLAVE Syntax</a></dt><dt>stopping</dt><dd><dl><dt>the server, <a href="installing.html#automatic-start">Starting and Stopping MySQL Automatically</a></dt></dl></dd><dt>stopword list</dt><dd><dl><dt>user-defined, <a href="functions.html#fulltext-fine-tuning">Fine-Tuning MySQL Full-Text Search</a></dt></dl></dd><dt>storage engine</dt><dd><dl><dt>ARCHIVE, <a href="storage-engines.html#archive-storage-engine">The ARCHIVE Storage Engine</a></dt></dl></dd><dt>storage engines</dt><dd><dl><dt>choosing, <a href="storage-engines.html">Storage Engines and Table Types</a></dt></dl></dd><dt>storage of data, <a href="optimization.html#design">Design Choices</a></dt><dt>storage requirements</dt><dd><dl><dt>column type, <a href="column-types.html#storage-requirements">Column Type Storage Requirements</a></dt></dl></dd><dt>storage space</dt><dd><dl><dt>minimising, <a href="optimization.html#data-size">Make Your Data as Small as Possible</a></dt></dl></dd><dt>stored procedures, <a href="stored-procedures.html">Stored Procedures and Functions</a></dt><dt>stored procedures and triggers</dt><dd><dl><dt>defined, <a href="introduction.html#ansi-diff-triggers">Stored Procedures and Triggers</a></dt></dl></dd><dt>stored routine restrictions, <a href="restrictions.html#routine-restrictions">Restrictions on Stored Routines and Triggers</a></dt><dt>STRAIGHT_JOIN, <a href="sql-syntax.html#select">SELECT Syntax</a>, <a href="sql-syntax.html#join">JOIN Syntax</a></dt><dt>STRCMP(), <a href="functions.html#string-comparison-functions">String Comparison Functions</a></dt><dt>STRICT SQL mode, <a href="database-administration.html#server-sql-mode">The Server SQL Mode</a></dt><dt>STRICT_ALL_TABLES SQL mode, <a href="database-administration.html#server-sql-mode">The Server SQL Mode</a></dt><dt>STRICT_TRANS_TABLES SQL mode, <a href="database-administration.html#server-sql-mode">The Server SQL Mode</a></dt><dt>string collating, <a href="database-administration.html#string-collating">String Collating Support</a></dt><dt>string comparison functions, <a href="functions.html#string-comparison-functions">String Comparison Functions</a></dt><dt>string comparisons</dt><dd><dl><dt>case sensitivity, <a href="functions.html#string-comparison-functions">String Comparison Functions</a></dt></dl></dd><dt>string functions, <a href="functions.html#string-functions">String Functions</a></dt><dt>string literal introducer, <a href="language-structure.html#string-syntax">Strings</a>, <a href="charset.html#charset-literal">Character String Literal Character Set and Collation</a></dt><dt>string types, <a href="column-types.html#string-types">String Types</a></dt><dt>strings</dt><dd><dl><dt>defined, <a href="language-structure.html#literals">Literal Values</a></dt><dt>escaping characters, <a href="language-structure.html#literals">Literal Values</a></dt><dt>non-delimited, <a href="column-types.html#datetime">The DATETIME, DATE, and TIMESTAMP Types</a></dt></dl></dd><dt>striping</dt><dd><dl><dt>defined, <a href="optimization.html#disk-issues">Disk Issues</a></dt></dl></dd><dt>STR_TO_DATE(), <a href="functions.html#date-and-time-functions">Date and Time Functions</a></dt><dt>SUBDATE(), <a href="functions.html#date-and-time-functions">Date and Time Functions</a></dt><dt>subqueries, <a href="sql-syntax.html#subqueries">Subquery Syntax</a></dt><dt>subquery, <a href="sql-syntax.html#subqueries">Subquery Syntax</a></dt><dt>subquery restrictions, <a href="restrictions.html#subquery-restrictions">Restrictions on Subqueries</a></dt><dt>subselects, <a href="sql-syntax.html#subqueries">Subquery Syntax</a></dt><dt>SUBSTR(), <a href="functions.html#string-functions">String Functions</a></dt><dt>SUBSTRING(), <a href="functions.html#string-functions">String Functions</a></dt><dt>SUBSTRING_INDEX(), <a href="functions.html#string-functions">String Functions</a></dt><dt>SUBTIME(), <a href="functions.html#date-and-time-functions">Date and Time Functions</a></dt><dt>subtraction (-), <a href="functions.html#arithmetic-functions">Arithmetic Operators</a></dt><dt>SUM(), <a href="functions.html#group-by-functions">GROUP BY (Aggregate) Functions</a></dt><dt>SUM(DISTINCT), <a href="functions.html#group-by-functions">GROUP BY (Aggregate) Functions</a></dt><dt>superuser, <a href="installing.html#default-privileges">Securing the Initial MySQL Accounts</a></dt><dt>support</dt><dd><dl><dt>for operating systems, <a href="installing.html#which-os">Operating Systems Supported by MySQL</a></dt><dt>mailing address, <a href="introduction.html#bug-reports">How to Report Bugs or Problems</a></dt></dl></dd><dt>suppression</dt><dd><dl><dt>default values, <a href="introduction.html#constraint-invalid-data">Constraints on Invalid Data</a></dt></dl></dd><dt>Sybase compatibility, <a href="sql-syntax.html#use">USE Syntax</a></dt><dt>symbolic links, <a href="optimization.html#symbolic-links">Using Symbolic Links</a>, <a href="optimization.html#windows-symbolic-links">Using Symbolic Links for Databases on Windows</a></dt><dt>SymDifference(), <a href="spatial-extensions-in-mysql.html#spatial-operators">Spatial Operators</a></dt><dt>syntax</dt><dd><dl><dt>regular expression, <a href="regexp.html">MySQL Regular Expressions</a></dt></dl></dd><dt>SYSDATE(), <a href="functions.html#date-and-time-functions">Date and Time Functions</a></dt><dt>system</dt><dd><dl><dt>privilege, <a href="database-administration.html#what-privileges">What the Privilege System Does</a></dt><dt>security, <a href="database-administration.html#security">General Security Issues</a></dt></dl></dd><dt>system optimization, <a href="optimization.html#system">System Factors and Startup Parameter Tuning</a></dt><dt>system table, <a href="optimization.html#explain">EXPLAIN Syntax (Get Information About a SELECT)</a></dt><dt>system variables, <a href="database-administration.html#server-system-variables">Server System Variables</a>, <a href="language-structure.html#system-variables">System Variables</a>, <a href="sql-syntax.html#show-variables">SHOW VARIABLES Syntax</a></dt><dt>SYSTEM_USER(), <a href="functions.html#information-functions">Information Functions</a></dt></dl></div><div class="indexdiv"><h3>T</h3><dl><dt>tab (\t), <a href="language-structure.html#string-syntax">Strings</a></dt><dt>table</dt><dd><dl><dt>changing, <a href="sql-syntax.html#alter-table">ALTER TABLE Syntax</a>, <a href="problems.html#alter-table-problems">Problems with ALTER TABLE</a></dt><dt>deleting, <a href="sql-syntax.html#drop-table">DROP TABLE Syntax</a></dt><dt>mysql option, <a href="client-side-scripts.html#mysql-command-options">Options</a></dt></dl></dd><dt>table aliases, <a href="sql-syntax.html#select">SELECT Syntax</a></dt><dt>table cache, <a href="optimization.html#table-cache">How MySQL Opens and Closes Tables</a></dt><dt>table is full, <a href="sql-syntax.html#set-option">SET Syntax</a>, <a href="problems.html#full-table">The table is full</a></dt><dt>table names</dt><dd><dl><dt>case sensitivity, <a href="language-structure.html#name-case-sensitivity">Identifier Case Sensitivity</a></dt><dt>case-sensitivity, <a href="introduction.html#extensions-to-ansi">MySQL Extensions to Standard SQL</a></dt></dl></dd><dt>Table scans</dt><dd><dl><dt>avoiding, <a href="optimization.html#how-to-avoid-table-scan">How to Avoid Table Scans</a></dt></dl></dd><dt>table types</dt><dd><dl><dt>choosing, <a href="storage-engines.html">Storage Engines and Table Types</a></dt></dl></dd><dt>table-level locking, <a href="optimization.html#internal-locking">Locking Methods</a></dt><dt>tables</dt><dd><dl><dt>ARCHIVE, <a href="storage-engines.html#archive-storage-engine">The ARCHIVE Storage Engine</a></dt><dt>BDB, <a href="storage-engines.html#bdb-storage-engine">The BDB (BerkeleyDB) Storage Engine</a></dt><dt>Berkeley DB, <a href="storage-engines.html#bdb-storage-engine">The BDB (BerkeleyDB) Storage Engine</a></dt><dt>BLACKHOLE, <a href="storage-engines.html#blackhole-storage-engine">The BLACKHOLE Storage Engine</a></dt><dt>changing column order, <a href="problems.html#change-column-order">How to Change the Order of Columns in a Table</a></dt><dt>checking, <a href="database-administration.html#myisamchk-check-options">Check Options for myisamchk</a></dt><dt>closing, <a href="optimization.html#table-cache">How MySQL Opens and Closes Tables</a></dt><dt>compressed format, <a href="storage-engines.html#compressed-format">Compressed Table Characteristics</a></dt><dt>constant, <a href="optimization.html#explain">EXPLAIN Syntax (Get Information About a SELECT)</a>, <a href="optimization.html#where-optimizations">How MySQL Optimizes WHERE Clauses</a></dt><dt>copying, <a href="sql-syntax.html#create-table">CREATE TABLE Syntax</a></dt><dt>counting rows, <a href="tutorial.html#counting-rows">Counting Rows</a></dt><dt>creating, <a href="tutorial.html#creating-tables">Creating a Table</a></dt><dt>CSV, <a href="storage-engines.html#csv-storage-engine">The CSV Storage Engine</a></dt><dt>defragment, <a href="database-administration.html#maintenance-schedule">Setting Up a Table Maintenance Schedule</a>, <a href="storage-engines.html#dynamic-format">Dynamic Table Characteristics</a></dt><dt>defragmenting, <a href="sql-syntax.html#optimize-table">OPTIMIZE TABLE Syntax</a></dt><dt>deleting rows, <a href="problems.html#deleting-from-related-tables">Deleting Rows from Related Tables</a></dt><dt>displaying status, <a href="sql-syntax.html#show-table-status">SHOW TABLE STATUS Syntax</a></dt><dt>dynamic, <a href="storage-engines.html#dynamic-format">Dynamic Table Characteristics</a></dt><dt>error checking, <a href="database-administration.html#check">How to Check MyISAM Tables for Errors</a></dt><dt>EXAMPLE, <a href="storage-engines.html#example-storage-engine">The EXAMPLE Storage Engine</a></dt><dt>FEDERATED, <a href="storage-engines.html#federated-storage-engine">The FEDERATED Storage Engine</a></dt><dt>flush, <a href="client-side-scripts.html#mysqladmin">mysqladmin — Client for Administering a MySQL Server</a></dt><dt>fragmentation, <a href="sql-syntax.html#optimize-table">OPTIMIZE TABLE Syntax</a></dt><dt>grant, <a href="database-administration.html#request-access">Access Control, Stage 2: Request Verification</a></dt><dt>HEAP, <a href="storage-engines.html#memory-storage-engine">The MEMORY (HEAP) Storage Engine</a></dt><dt>host, <a href="database-administration.html#request-access">Access Control, Stage 2: Request Verification</a></dt><dt>improving performance, <a href="optimization.html#data-size">Make Your Data as Small as Possible</a></dt><dt>information, <a href="database-administration.html#table-info">Getting Information About a Table</a></dt><dt>information about, <a href="tutorial.html#getting-information">Getting Information About Databases and Tables</a></dt><dt>InnoDB, <a href="storage-engines.html#innodb">The InnoDB Storage Engine</a></dt><dt>loading data, <a href="tutorial.html#loading-tables">Loading Data into a Table</a></dt><dt>maintenance regimen, <a href="database-administration.html#maintenance-schedule">Setting Up a Table Maintenance Schedule</a></dt><dt>maximum size, <a href="introduction.html#table-size">How Big MySQL Tables Can Be</a></dt><dt>MEMORY, <a href="storage-engines.html#memory-storage-engine">The MEMORY (HEAP) Storage Engine</a></dt><dt>MERGE, <a href="storage-engines.html#merge-storage-engine">The MERGE Storage Engine</a></dt><dt>merging, <a href="storage-engines.html#merge-storage-engine">The MERGE Storage Engine</a></dt><dt>multiple, <a href="tutorial.html#multiple-tables">Using More Than one Table</a></dt><dt>MyISAM, <a href="storage-engines.html#myisam-storage-engine">The MyISAM Storage Engine</a></dt><dt>names, <a href="language-structure.html#legal-names">Database, Table, Index, Column, and Alias Names</a></dt><dt>open, <a href="optimization.html#open-tables">How MySQL Counts Open Tables</a></dt><dt>opening, <a href="optimization.html#table-cache">How MySQL Opens and Closes Tables</a></dt><dt>optimizing, <a href="database-administration.html#table-optimization">Table Optimization</a></dt><dt>partitioning, <a href="storage-engines.html#merge-storage-engine">The MERGE Storage Engine</a></dt><dt>repairing, <a href="database-administration.html#repair">How to Repair Tables</a></dt><dt>retrieving data, <a href="tutorial.html#retrieving-data">Retrieving Information from a Table</a></dt><dt>selecting columns, <a href="tutorial.html#selecting-columns">Selecting Particular Columns</a></dt><dt>selecting rows, <a href="tutorial.html#selecting-rows">Selecting Particular Rows</a></dt><dt>sorting rows, <a href="tutorial.html#sorting-rows">Sorting Rows</a></dt><dt>symbolic links, <a href="optimization.html#symbolic-links-to-tables">Using Symbolic Links for Tables on Unix</a></dt><dt>system, <a href="optimization.html#explain">EXPLAIN Syntax (Get Information About a SELECT)</a></dt><dt>too many, <a href="optimization.html#creating-many-tables">Drawbacks to Creating Many Tables in the Same Database</a></dt><dt>unique ID for last row, <a href="apis.html#getting-unique-id">How to Get the Unique ID for the Last Inserted Row</a></dt><dt>updating, <a href="introduction.html#ansi-diff-transactions">Transactions and Atomic Operations</a></dt></dl></dd><dt>TABLES</dt><dd><dl><dt>INFORMATION_SCHEMA table, <a href="information-schema.html#tables-table">The INFORMATION_SCHEMA TABLES Table</a></dt></dl></dd><dt>table_cache, <a href="optimization.html#table-cache">How MySQL Opens and Closes Tables</a></dt><dt>TABLE_PRIVILEGES</dt><dd><dl><dt>INFORMATION_SCHEMA table, <a href="information-schema.html#table-privileges-table">The INFORMATION_SCHEMA TABLE_PRIVILEGES Table</a></dt></dl></dd><dt>TAN(), <a href="functions.html#mathematical-functions">Mathematical Functions</a></dt><dt>tar</dt><dd><dl><dt>problems on Solaris, <a href="installing.html#solaris">Solaris Notes</a></dt></dl></dd><dt>Tcl API, <a href="apis.html#tcl">MySQL Tcl API</a></dt><dt>tcp-ip</dt><dd><dl><dt>mysqld_multi option, <a href="database-administration.html#mysqld-multi">mysqld_multi — Program for Managing Multiple MySQL Servers</a></dt></dl></dd><dt>TCP/IP, <a href="installing.html#windows-select-server">Selecting a MySQL Server type</a>, <a href="installing.html#windows-testing">Testing The MySQL Installation</a></dt><dt>technical support</dt><dd><dl><dt>mailing address, <a href="introduction.html#bug-reports">How to Report Bugs or Problems</a></dt></dl></dd><dt>tee</dt><dd><dl><dt>mysql option, <a href="client-side-scripts.html#mysql-command-options">Options</a></dt></dl></dd><dt>temporary file</dt><dd><dl><dt>write access, <a href="installing.html#mysql-install-db">Problems Running mysql_install_db</a></dt></dl></dd><dt>temporary tables</dt><dd><dl><dt>problems, <a href="problems.html#temporary-table-problems">TEMPORARY TABLE Problems</a></dt></dl></dd><dt>terminal monitor</dt><dd><dl><dt>defined, <a href="tutorial.html">Tutorial</a></dt></dl></dd><dt>testing</dt><dd><dl><dt>connection to the server, <a href="database-administration.html#connection-access">Access Control, Stage 1: Connection Verification</a></dt><dt>installation, <a href="installing.html#unix-post-installation">Unix Post-Installation Procedures</a></dt><dt>of MySQL releases, <a href="installing.html#choosing-version">Choosing Which Version of MySQL to Install</a></dt><dt>post-installation, <a href="installing.html#post-installation">Post-Installation Setup and Testing</a></dt></dl></dd><dt>testing mysqld</dt><dd><dl><dt>mysqltest, <a href="extending-mysql.html#mysql-test-suite">MySQL Test Suite</a></dt></dl></dd><dt>TEXT</dt><dd><dl><dt>size, <a href="column-types.html#storage-requirements">Column Type Storage Requirements</a></dt></dl></dd><dt>TEXT columns</dt><dd><dl><dt>default values, <a href="column-types.html#blob">The BLOB and TEXT Types</a></dt><dt>indexing, <a href="optimization.html#indexes">Column Indexes</a>, <a href="sql-syntax.html#create-table">CREATE TABLE Syntax</a></dt></dl></dd><dt>TEXT data type, <a href="column-types.html#string-type-overview">Overview of String Types</a>, <a href="column-types.html#blob">The BLOB and TEXT Types</a></dt><dt>thread packages</dt><dd><dl><dt>differences between, <a href="porting.html#thread-packages">Differences Between Thread Packages</a></dt></dl></dd><dt>thread support, <a href="installing.html#which-os">Operating Systems Supported by MySQL</a></dt><dd><dl><dt>non-native, <a href="installing.html#mit-pthreads">MIT-pthreads Notes</a></dt></dl></dd><dt>threaded clients, <a href="apis.html#threaded-clients">How to Make a Threaded Client</a></dt><dt>threads, <a href="client-side-scripts.html#mysqladmin">mysqladmin — Client for Administering a MySQL Server</a>, <a href="sql-syntax.html#show-processlist">SHOW PROCESSLIST Syntax</a>, <a href="extending-mysql.html#mysql-internals">MySQL Internals</a></dt><dd><dl><dt>display, <a href="sql-syntax.html#show-processlist">SHOW PROCESSLIST Syntax</a></dt><dt>RTS, <a href="porting.html#rts-threads">Comments about RTS Threads</a></dt></dl></dd><dt>TIME data type, <a href="column-types.html#date-and-time-type-overview">Overview of Date and Time Types</a>, <a href="column-types.html#time">The TIME Type</a></dt><dt>time types, <a href="column-types.html#storage-requirements">Column Type Storage Requirements</a></dt><dt>time zone problems, <a href="problems.html#timezone-problems">Time Zone Problems</a></dt><dt>TIME(), <a href="functions.html#date-and-time-functions">Date and Time Functions</a></dt><dt>TIMEDIFF(), <a href="functions.html#date-and-time-functions">Date and Time Functions</a></dt><dt>timeout, <a href="database-administration.html#server-system-variables">Server System Variables</a>, <a href="functions.html#miscellaneous-functions">Miscellaneous Functions</a>, <a href="sql-syntax.html#insert-delayed">INSERT DELAYED Syntax</a></dt><dd><dl><dt>connect_timeout variable, <a href="client-side-scripts.html#mysql-command-options">Options</a>, <a href="client-side-scripts.html#mysqladmin">mysqladmin — Client for Administering a MySQL Server</a></dt><dt>shutdown_timeout variable, <a href="client-side-scripts.html#mysqladmin">mysqladmin — Client for Administering a MySQL Server</a></dt></dl></dd><dt>TIMESTAMP</dt><dd><dl><dt>and NULL values, <a href="problems.html#problems-with-null">Problems with NULL Values</a></dt></dl></dd><dt>TIMESTAMP data type, <a href="column-types.html#date-and-time-type-overview">Overview of Date and Time Types</a>, <a href="column-types.html#datetime">The DATETIME, DATE, and TIMESTAMP Types</a></dt><dt>TIMESTAMP(), <a href="functions.html#date-and-time-functions">Date and Time Functions</a></dt><dt>TIMESTAMPADD(), <a href="functions.html#date-and-time-functions">Date and Time Functions</a></dt><dt>TIMESTAMPDIFF(), <a href="functions.html#date-and-time-functions">Date and Time Functions</a></dt><dt>TIME_FORMAT(), <a href="functions.html#date-and-time-functions">Date and Time Functions</a></dt><dt>TIME_TO_SEC(), <a href="functions.html#date-and-time-functions">Date and Time Functions</a></dt><dt>TINYBLOB data type, <a href="column-types.html#string-type-overview">Overview of String Types</a></dt><dt>TINYINT data type, <a href="column-types.html#numeric-type-overview">Overview of Numeric Types</a></dt><dt>TINYTEXT data type, <a href="column-types.html#string-type-overview">Overview of String Types</a></dt><dt>tips</dt><dd><dl><dt>optimization, <a href="optimization.html#tips">Other Optimization Tips</a></dt></dl></dd><dt>TMPDIR environment variable, <a href="installing.html#mysql-install-db">Problems Running mysql_install_db</a>, <a href="environment-variables.html">Environment Variables</a></dt><dt>TODO</dt><dd><dl><dt>embedded server, <a href="apis.html#libmysqld-todo">Things left to do in Embedded Server (TODO)</a></dt><dt>symlinks, <a href="optimization.html#symbolic-links-to-tables">Using Symbolic Links for Tables on Unix</a></dt></dl></dd><dt>tools</dt><dd><dl><dt>list of, <a href="credits.html#tools-used-to-create-mysql">Tools that were used to create MySQL</a></dt></dl></dd><dt>Touches(), <a href="spatial-extensions-in-mysql.html#functions-that-test-spatial-relationships-between-geometries">Functions That Test Spatial Relationships Between Geometries</a></dt><dt>TO_DAYS(), <a href="functions.html#date-and-time-functions">Date and Time Functions</a></dt><dt>trace DBI method, <a href="porting.html#using-gdb-on-mysqld">Debugging mysqld under gdb</a></dt><dt>TRADITIONAL SQL mode, <a href="database-administration.html#server-sql-mode">The Server SQL Mode</a></dt><dt>transaction-safe tables, <a href="introduction.html#ansi-diff-transactions">Transactions and Atomic Operations</a>, <a href="storage-engines.html#innodb-overview">InnoDB Overview</a></dt><dt>transactions</dt><dd><dl><dt>support, <a href="introduction.html#ansi-diff-transactions">Transactions and Atomic Operations</a>, <a href="storage-engines.html#innodb-overview">InnoDB Overview</a></dt></dl></dd><dt>Translators</dt><dd><dl><dt>list of, <a href="credits.html#documenters-translators">Documenters and translators</a></dt></dl></dd><dt>trigger restrictions, <a href="restrictions.html#routine-restrictions">Restrictions on Stored Routines and Triggers</a></dt><dt>triggers, <a href="introduction.html#ansi-diff-triggers">Stored Procedures and Triggers</a>, <a href="sql-syntax.html#show-triggers">SHOW TRIGGERS Syntax</a>, <a href="triggers.html">Triggers</a></dt><dt>TRIGGERS</dt><dd><dl><dt>INFORMATION_SCHEMA table, <a href="information-schema.html#triggers-table">The INFORMATION_SCHEMA TRIGGERS Table</a></dt></dl></dd><dt>TRIM(), <a href="functions.html#string-functions">String Functions</a></dt><dt>troubleshooting</dt><dd><dl><dt>FreeBSD, <a href="installing.html#compilation-problems">Dealing with Problems Compiling MySQL</a></dt><dt>Solaris, <a href="installing.html#compilation-problems">Dealing with Problems Compiling MySQL</a></dt></dl></dd><dt>TRUE, <a href="language-structure.html#number-syntax">Numbers</a></dt><dd><dl><dt>testing for, <a href="functions.html#comparison-operators">Comparison Functions and Operators</a></dt></dl></dd><dt>TRUNCATE, <a href="sql-syntax.html#truncate">TRUNCATE Syntax</a></dt><dt>TRUNCATE(), <a href="functions.html#mathematical-functions">Mathematical Functions</a></dt><dt>tutorial, <a href="tutorial.html">Tutorial</a></dt><dt>Twin Studies</dt><dd><dl><dt>queries, <a href="tutorial.html#twin">Queries from the Twin Project</a></dt></dl></dd><dt>type conversions, <a href="functions.html#comparison-operators">Comparison Functions and Operators</a></dt><dt>types</dt><dd><dl><dt>columns, <a href="column-types.html">Column Types</a>, <a href="column-types.html#choosing-types">Choosing the Right Type for a Column</a></dt><dt>data, <a href="column-types.html">Column Types</a></dt><dt>date, <a href="column-types.html#storage-requirements">Column Type Storage Requirements</a></dt><dt>Date and Time, <a href="column-types.html#date-and-time-types">Date and Time Types</a></dt><dt>numeric, <a href="column-types.html#storage-requirements">Column Type Storage Requirements</a></dt><dt>of tables, <a href="storage-engines.html">Storage Engines and Table Types</a></dt><dt>portability, <a href="column-types.html#other-vendor-column-types">Using Column Types from Other Database Engines</a></dt><dt>strings, <a href="column-types.html#string-types">String Types</a></dt><dt>time, <a href="column-types.html#storage-requirements">Column Type Storage Requirements</a></dt></dl></dd><dt>typographical conventions, <a href="introduction.html#manual-conventions">Conventions Used in This Manual</a></dt><dt>TZ environment variable, <a href="problems.html#timezone-problems">Time Zone Problems</a>, <a href="environment-variables.html">Environment Variables</a></dt></dl></div><div class="indexdiv"><h3>U</h3><dl><dt>UCASE(), <a href="functions.html#string-functions">String Functions</a></dt><dt>UCS-2, <a href="charset.html">Character Set Support</a></dt><dt>UDFs, <a href="extending-mysql.html#create-function">CREATE FUNCTION/DROP FUNCTION Syntax</a></dt><dd><dl><dt>compiling, <a href="extending-mysql.html#udf-compiling">Compiling and Installing User-Defined Functions</a></dt><dt>defined, <a href="extending-mysql.html#adding-functions">Adding New Functions to MySQL</a></dt><dt>return values, <a href="extending-mysql.html#udf-return-values">UDF Return Values and Error Handling</a></dt></dl></dd><dt>ulimit, <a href="problems.html#not-enough-file-handles">File Not Found</a></dt><dt>UMASK environment variable, <a href="problems.html#file-permissions">Problems with File Permissions</a>, <a href="environment-variables.html">Environment Variables</a></dt><dt>UMASK_DIR environment variable, <a href="problems.html#file-permissions">Problems with File Permissions</a>, <a href="environment-variables.html">Environment Variables</a></dt><dt>unary minus (-), <a href="functions.html#arithmetic-functions">Arithmetic Operators</a></dt><dt>unbuffered</dt><dd><dl><dt>mysql option, <a href="client-side-scripts.html#mysql-command-options">Options</a></dt></dl></dd><dt>UNCOMPRESS(), <a href="functions.html#string-functions">String Functions</a></dt><dt>UNCOMPRESSED_LENGTH(), <a href="functions.html#string-functions">String Functions</a></dt><dt>UNHEX(), <a href="functions.html#string-functions">String Functions</a></dt><dt>Unicode, <a href="charset.html">Character Set Support</a></dt><dt>Unicode Collation Algorithm, <a href="charset.html#charset-unicode-sets">Unicode Character Sets</a></dt><dt>UNION, <a href="tutorial.html#searching-on-two-keys">Searching on Two Keys</a>, <a href="sql-syntax.html#union">UNION Syntax</a></dt><dt>Union(), <a href="spatial-extensions-in-mysql.html#spatial-operators">Spatial Operators</a></dt><dt>UNIQUE, <a href="sql-syntax.html#alter-table">ALTER TABLE Syntax</a></dt><dd><dl><dt>constraint, <a href="introduction.html#constraint-primary-key">PRIMARY KEY and UNIQUE Index Constraints</a></dt></dl></dd><dt>unique ID, <a href="apis.html#getting-unique-id">How to Get the Unique ID for the Last Inserted Row</a></dt><dt>UNIX_TIMESTAMP(), <a href="functions.html#date-and-time-functions">Date and Time Functions</a></dt><dt>UNKNOWN</dt><dd><dl><dt>testing for, <a href="functions.html#comparison-operators">Comparison Functions and Operators</a></dt></dl></dd><dt>unloading</dt><dd><dl><dt>tables, <a href="tutorial.html#retrieving-data">Retrieving Information from a Table</a></dt></dl></dd><dt>UNLOCK TABLES, <a href="sql-syntax.html#lock-tables">LOCK TABLES and UNLOCK TABLES Syntax</a></dt><dt>unnamed views, <a href="sql-syntax.html#unnamed-views">Subqueries in the FROM clause</a></dt><dt>UNTIL, <a href="stored-procedures.html#repeat-statement">REPEAT Statement</a></dt><dt>UPDATE, <a href="sql-syntax.html#update">UPDATE Syntax</a></dt><dt>updating</dt><dd><dl><dt>releases of MySQL, <a href="installing.html#many-versions">How and When Updates Are Released</a></dt><dt>tables, <a href="introduction.html#ansi-diff-transactions">Transactions and Atomic Operations</a></dt></dl></dd><dt>upgrading, <a href="installing.html#upgrade">Upgrading MySQL</a></dt><dd><dl><dt>different architecture, <a href="installing.html#upgrading-to-arch">Copying MySQL Databases to Another Machine</a></dt><dt>grant tables, <a href="installing.html#upgrading-grant-tables">Upgrading the Grant Tables</a></dt><dt>to 5.0, <a href="installing.html#upgrading-from-4-1">Upgrading from Version 4.1 to 5.0</a></dt></dl></dd><dt>upgrading tables</dt><dd><dl><dt>ISAM, <a href="installing.html#upgrading-from-4-1">Upgrading from Version 4.1 to 5.0</a></dt></dl></dd><dt>UPPER(), <a href="functions.html#string-functions">String Functions</a></dt><dt>uptime, <a href="client-side-scripts.html#mysqladmin">mysqladmin — Client for Administering a MySQL Server</a></dt><dt>URLs for downloading MySQL, <a href="installing.html#getting-mysql">How to Get MySQL</a></dt><dt>USE, <a href="sql-syntax.html#use">USE Syntax</a></dt><dt>USE INDEX, <a href="sql-syntax.html#select">SELECT Syntax</a>, <a href="sql-syntax.html#join">JOIN Syntax</a></dt><dt>USE KEY, <a href="sql-syntax.html#select">SELECT Syntax</a>, <a href="sql-syntax.html#join">JOIN Syntax</a></dt><dt>user</dt><dd><dl><dt>mysql option, <a href="client-side-scripts.html#mysql-command-options">Options</a></dt><dt>mysqld_multi option, <a href="database-administration.html#mysqld-multi">mysqld_multi — Program for Managing Multiple MySQL Servers</a></dt></dl></dd><dt>user accounts</dt><dd><dl><dt>creating, <a href="sql-syntax.html#create-user">CREATE USER Syntax</a></dt><dt>renaming, <a href="sql-syntax.html#rename-user">RENAME USER Syntax</a></dt></dl></dd><dt>USER environment variable, <a href="database-administration.html#connecting">Connecting to the MySQL Server</a>, <a href="environment-variables.html">Environment Variables</a></dt><dt>user privileges</dt><dd><dl><dt>adding, <a href="database-administration.html#adding-users">Adding New User Accounts to MySQL</a></dt><dt>deleting, <a href="database-administration.html#removing-users">Removing User Accounts from MySQL</a>, <a href="sql-syntax.html#drop-user">DROP USER Syntax</a></dt><dt>dropping, <a href="database-administration.html#removing-users">Removing User Accounts from MySQL</a>, <a href="sql-syntax.html#drop-user">DROP USER Syntax</a></dt></dl></dd><dt>user table</dt><dd><dl><dt>sorting, <a href="database-administration.html#connection-access">Access Control, Stage 1: Connection Verification</a></dt></dl></dd><dt>user variables, <a href="language-structure.html#variables">User Variables</a></dt><dt>USER(), <a href="functions.html#information-functions">Information Functions</a></dt><dt>user-defined functions</dt><dd><dl><dt>adding, <a href="extending-mysql.html#adding-functions">Adding New Functions to MySQL</a>, <a href="extending-mysql.html#adding-udf">Adding a New User-Defined Function</a></dt></dl></dd><dt>User-defined functions, <a href="extending-mysql.html#create-function">CREATE FUNCTION/DROP FUNCTION Syntax</a></dt><dt>usernames</dt><dd><dl><dt>and passwords, <a href="database-administration.html#user-names">MySQL Usernames and Passwords</a></dt></dl></dd><dt>users</dt><dd><dl><dt>adding, <a href="installing.html#installing-binary">Installing MySQL on Other Unix-Like Systems</a>, <a href="installing.html#quick-install">Source Installation Overview</a></dt><dt>deleting, <a href="database-administration.html#removing-users">Removing User Accounts from MySQL</a>, <a href="sql-syntax.html#drop-user">DROP USER Syntax</a></dt><dt>root, <a href="installing.html#default-privileges">Securing the Initial MySQL Accounts</a></dt></dl></dd><dt>USER_PRIVILEGES</dt><dd><dl><dt>INFORMATION_SCHEMA table, <a href="information-schema.html#user-privileges-table">The INFORMATION_SCHEMA USER_PRIVILEGES Table</a></dt></dl></dd><dt>uses</dt><dd><dl><dt>of MySQL, <a href="optimization.html#internal-use">What We Have Used MySQL For</a></dt></dl></dd><dt>using multiple disks to start data, <a href="optimization.html#windows-symbolic-links">Using Symbolic Links for Databases on Windows</a></dt><dt>UTC_DATE(), <a href="functions.html#date-and-time-functions">Date and Time Functions</a></dt><dt>UTC_TIME(), <a href="functions.html#date-and-time-functions">Date and Time Functions</a></dt><dt>UTC_TIMESTAMP(), <a href="functions.html#date-and-time-functions">Date and Time Functions</a></dt><dt>UTF-8, <a href="charset.html">Character Set Support</a></dt><dt>UTF8, <a href="charset.html">Character Set Support</a></dt><dt>UUID(), <a href="functions.html#miscellaneous-functions">Miscellaneous Functions</a></dt></dl></div><div class="indexdiv"><h3>V</h3><dl><dt>valid numbers</dt><dd><dl><dt>examples, <a href="language-structure.html#number-syntax">Numbers</a></dt></dl></dd><dt>VALUES(), <a href="functions.html#miscellaneous-functions">Miscellaneous Functions</a></dt><dt>VARBINARY data type, <a href="column-types.html#string-type-overview">Overview of String Types</a>, <a href="column-types.html#binary-varbinary">The BINARY and VARBINARY Types</a></dt><dt>VARCHAR</dt><dd><dl><dt>size, <a href="column-types.html#storage-requirements">Column Type Storage Requirements</a></dt></dl></dd><dt>VARCHAR data type, <a href="column-types.html#string-type-overview">Overview of String Types</a>, <a href="column-types.html#string-types">String Types</a></dt><dt>VARCHARACTER data type, <a href="column-types.html#string-type-overview">Overview of String Types</a></dt><dt>variables</dt><dd><dl><dt>mysqld, <a href="optimization.html#server-parameters">Tuning Server Parameters</a></dt><dt>server, <a href="database-administration.html#server-system-variables">Server System Variables</a>, <a href="sql-syntax.html#show-variables">SHOW VARIABLES Syntax</a></dt><dt>status, <a href="database-administration.html#server-status-variables">Server Status Variables</a>, <a href="sql-syntax.html#show-status">SHOW STATUS Syntax</a></dt><dt>system, <a href="database-administration.html#server-system-variables">Server System Variables</a>, <a href="sql-syntax.html#show-variables">SHOW VARIABLES Syntax</a></dt><dt>System, <a href="language-structure.html#system-variables">System Variables</a></dt><dt>user, <a href="language-structure.html#variables">User Variables</a></dt><dt>values, <a href="database-administration.html#server-system-variables">Server System Variables</a></dt></dl></dd><dt>VARIANCE(), <a href="functions.html#group-by-functions">GROUP BY (Aggregate) Functions</a></dt><dt>VAR_POP(), <a href="functions.html#group-by-functions">GROUP BY (Aggregate) Functions</a></dt><dt>VAR_SAMP(), <a href="functions.html#group-by-functions">GROUP BY (Aggregate) Functions</a></dt><dt>verbose</dt><dd><dl><dt>mysql option, <a href="client-side-scripts.html#mysql-command-options">Options</a></dt><dt>mysqld_multi option, <a href="database-administration.html#mysqld-multi">mysqld_multi — Program for Managing Multiple MySQL Servers</a></dt></dl></dd><dt>version</dt><dd><dl><dt>choosing, <a href="installing.html#which-version">Choosing Which MySQL Distribution to Install</a></dt><dt>latest, <a href="installing.html#getting-mysql">How to Get MySQL</a></dt><dt>mysql option, <a href="client-side-scripts.html#mysql-command-options">Options</a></dt><dt>mysqld_multi option, <a href="database-administration.html#mysqld-multi">mysqld_multi — Program for Managing Multiple MySQL Servers</a></dt></dl></dd><dt>VERSION(), <a href="functions.html#information-functions">Information Functions</a></dt><dt>vertical</dt><dd><dl><dt>mysql option, <a href="client-side-scripts.html#mysql-command-options">Options</a></dt></dl></dd><dt>view restrictions, <a href="restrictions.html#view-restrictions">Restrictions on Views</a></dt><dt>views, <a href="introduction.html#ansi-diff-views">Views</a>, <a href="views.html">Views</a>, <a href="views.html#create-view">CREATE VIEW Syntax</a></dt><dd><dl><dt>updatable, <a href="introduction.html#ansi-diff-views">Views</a>, <a href="views.html#create-view">CREATE VIEW Syntax</a></dt></dl></dd><dt>VIEWS</dt><dd><dl><dt>INFORMATION_SCHEMA table, <a href="information-schema.html#views-table">The INFORMATION_SCHEMA VIEWS Table</a></dt></dl></dd><dt>virtual memory</dt><dd><dl><dt>problems while compiling, <a href="installing.html#compilation-problems">Dealing with Problems Compiling MySQL</a></dt></dl></dd><dt>Visual Basic, <a href="connectors.html#programs-known-to-work-with-myodbc">Programs Known to Work With MyODBC</a></dt></dl></div><div class="indexdiv"><h3>W</h3><dl><dt>wait</dt><dd><dl><dt>mysql option, <a href="client-side-scripts.html#mysql-command-options">Options</a></dt></dl></dd><dt>WEEK(), <a href="functions.html#date-and-time-functions">Date and Time Functions</a></dt><dt>WEEKDAY(), <a href="functions.html#date-and-time-functions">Date and Time Functions</a></dt><dt>WEEKOFYEAR(), <a href="functions.html#date-and-time-functions">Date and Time Functions</a></dt><dt>Well-Known Binary format, <a href="spatial-extensions-in-mysql.html#gis-wkb-format">Well-Known Binary (WKB) Format</a></dt><dt>Well-Known Text format, <a href="spatial-extensions-in-mysql.html#gis-wkt-format">Well-Known Text (WKT) Format</a></dt><dt>What is an X509/Certificate?, <a href="database-administration.html#secure-basics">Basic SSL Concepts</a></dt><dt>What is encryption, <a href="database-administration.html#secure-basics">Basic SSL Concepts</a></dt><dt>WHERE, <a href="optimization.html#where-optimizations">How MySQL Optimizes WHERE Clauses</a></dt><dd><dl><dt>with SHOW, <a href="information-schema.html">The INFORMATION_SCHEMA Information Database</a>, <a href="information-schema.html#extended-show">Extensions to SHOW Statements</a></dt></dl></dd><dt>WHILE, <a href="stored-procedures.html#while-statement">WHILE Statement</a></dt><dt>widths</dt><dd><dl><dt>display, <a href="column-types.html">Column Types</a></dt></dl></dd><dt>Wildcard character (%), <a href="language-structure.html#string-syntax">Strings</a></dt><dt>Wildcard character (_), <a href="language-structure.html#string-syntax">Strings</a></dt><dt>wildcards</dt><dd><dl><dt>and LIKE, <a href="optimization.html#mysql-indexes">How MySQL Uses Indexes</a></dt><dt>in mysql.columns_priv table, <a href="database-administration.html#request-access">Access Control, Stage 2: Request Verification</a></dt><dt>in mysql.db table, <a href="database-administration.html#request-access">Access Control, Stage 2: Request Verification</a></dt><dt>in mysql.host table, <a href="database-administration.html#request-access">Access Control, Stage 2: Request Verification</a></dt><dt>in mysql.tables_priv table, <a href="database-administration.html#request-access">Access Control, Stage 2: Request Verification</a></dt><dt>in mysql.user table, <a href="database-administration.html#connection-access">Access Control, Stage 1: Connection Verification</a></dt></dl></dd><dt>Windows, <a href="connectors.html#odbc-connector">MySQL Connector/ODBC</a></dt><dd><dl><dt>compiling on, <a href="installing.html#windows-client-compiling">Compiling MySQL Clients on Windows</a></dt><dt>open issues, <a href="installing.html#windows-vs-unix">MySQL on Windows Compared to MySQL on Unix</a></dt><dt>upgrading, <a href="installing.html#windows-upgrading">Upgrading MySQL on Windows</a></dt><dt>versus Unix, <a href="installing.html#windows-vs-unix">MySQL on Windows Compared to MySQL on Unix</a></dt></dl></dd><dt>with-big-tables option, <a href="installing.html#configure-options">Typical configure Options</a></dt><dt>Within(), <a href="spatial-extensions-in-mysql.html#functions-that-test-spatial-relationships-between-geometries">Functions That Test Spatial Relationships Between Geometries</a></dt><dt>without-server option, <a href="installing.html#configure-options">Typical configure Options</a></dt><dt>WKB format, <a href="spatial-extensions-in-mysql.html#gis-wkb-format">Well-Known Binary (WKB) Format</a></dt><dt>WKT format, <a href="spatial-extensions-in-mysql.html#gis-wkt-format">Well-Known Text (WKT) Format</a></dt><dt>Word program, <a href="connectors.html#programs-known-to-work-with-myodbc">Programs Known to Work With MyODBC</a></dt><dt>wrappers</dt><dd><dl><dt>Eiffel, <a href="apis.html#eiffel">MySQL Eiffel Wrapper</a></dt></dl></dd><dt>write access</dt><dd><dl><dt>tmp, <a href="installing.html#mysql-install-db">Problems Running mysql_install_db</a></dt></dl></dd><dt>write_buffer_size myisamchk
variable, <a href="database-administration.html#myisamchk-general-options">General Options for myisamchk</a></dt></dl></div><div class="indexdiv"><h3>X</h3><dl><dt>X(), <a href="spatial-extensions-in-mysql.html#point-property-functions">Point Functions</a></dt><dt>XA BEGIN, <a href="sql-syntax.html#xa-statements">XA Transaction SQL Syntax</a></dt><dt>XA COMMIT, <a href="sql-syntax.html#xa-statements">XA Transaction SQL Syntax</a></dt><dt>XA PREPARE, <a href="sql-syntax.html#xa-statements">XA Transaction SQL Syntax</a></dt><dt>XA RECOVER, <a href="sql-syntax.html#xa-statements">XA Transaction SQL Syntax</a></dt><dt>XA ROLLBACK, <a href="sql-syntax.html#xa-statements">XA Transaction SQL Syntax</a></dt><dt>XA START, <a href="sql-syntax.html#xa-statements">XA Transaction SQL Syntax</a></dt><dt>XA transactions, <a href="sql-syntax.html#xa">XA Transactions</a></dt><dd><dl><dt>transaction identifiers, <a href="sql-syntax.html#xa-statements">XA Transaction SQL Syntax</a></dt></dl></dd><dt>xid</dt><dd><dl><dt>XA transaction identifier, <a href="sql-syntax.html#xa-statements">XA Transaction SQL Syntax</a></dt></dl></dd><dt>xml</dt><dd><dl><dt>mysql option, <a href="client-side-scripts.html#mysql-command-options">Options</a></dt></dl></dd><dt>XOR</dt><dd><dl><dt>bitwise, <a href="functions.html#bit-functions">Bit Functions</a></dt><dt>logical, <a href="functions.html#logical-operators">Logical Operators</a></dt></dl></dd></dl></div><div class="indexdiv"><h3>Y</h3><dl><dt>Y(), <a href="spatial-extensions-in-mysql.html#point-property-functions">Point Functions</a></dt><dt>Year 2000 compliance, <a href="introduction.html#year-2000-compliance">Year 2000 Compliance</a></dt><dt>Year 2000 issues, <a href="column-types.html#y2k-issues">Y2K Issues and Date Types</a></dt><dt>YEAR data type, <a href="column-types.html#date-and-time-type-overview">Overview of Date and Time Types</a>, <a href="column-types.html#year">The YEAR Type</a></dt><dt>YEAR(), <a href="functions.html#date-and-time-functions">Date and Time Functions</a></dt><dt>YEARWEEK(), <a href="functions.html#date-and-time-functions">Date and Time Functions</a></dt></dl></div></div></div><div class="navfooter"><hr><table width="100%" summary="Navigation footer"><tr><td width="40%" align="left"><a accesskey="p" href="mysql-floss-license-exception.html">Prev</a> </td><td width="20%" align="center"> </td><td width="40%" align="right"> </td></tr><tr><td width="40%" align="left" valign="top">Appendix K. MySQL FLOSS License Exception </td><td width="20%" align="center"><a accesskey="h" href="index.html">Home</a></td><td width="40%" align="right" valign="top"> </td></tr></table></div></body></html>
