Index

Index
Prev

Symbols

! (logical NOT), Logical Operators
!= (not equal), Comparison Functions and Operators
", Database, Table, Index, Column, and Alias Names
% (modulo), Mathematical Functions
% (wildcard character), Strings
& (bitwise AND), Bit Functions
&& (logical AND), Logical Operators
() (parentheses), Parentheses
(Control-Z) \Z, Strings
* (multiplication), Arithmetic Operators
+ (addition), Arithmetic Operators
- (subtraction), Arithmetic Operators
- (unary minus), Arithmetic Operators
--password option, Keeping Your Password Secure
-p option, Keeping Your Password Secure
.my.cnf file, Using Option Files, Connecting to the MySQL Server, Causes of Access denied Errors, Keeping Your Password Secure, Using Client Programs in a Multiple-Server Environment
.mysql_history file, mysql Options
.pid (process ID) file, Setting Up a Table Maintenance Schedule
/ (division), Arithmetic Operators
/etc/passwd, Making MySQL Secure Against Attackers, SELECT Syntax
< (less than), Comparison Functions and Operators
<<, Calculating Visits Per Day
<< (left shift), Bit Functions
<= (less than or equal), Comparison Functions and Operators
<=> (equal to), Comparison Functions and Operators
<> (not equal), Comparison Functions and Operators
= (equal), Comparison Functions and Operators
> (greater than), Comparison Functions and Operators
>= (greater than or equal), Comparison Functions and Operators
>> (right shift), Bit Functions
\" (double quote), Strings
\' (single quote), Strings
\0 (ASCII 0), Strings
\b (backspace), Strings
\n (linefeed), Strings
\n (newline), Strings
\r (carriage return), Strings
\t (tab), Strings
\Z (Control-Z) ASCII 26, Strings
\\ (escape), Strings
^ (bitwise XOR), Bit Functions
_ (wildcard character), Strings
`, Database, Table, Index, Column, and Alias Names
| (bitwise OR), Bit Functions
|| (logical OR), Logical Operators
~, Bit Functions

A

aborted clients, Communication Errors and Aborted Connections

aborted connection, Communication Errors and Aborted Connections

ABS(), Mathematical Functions

access control, Access Control, Stage 1: Connection Verification

access denied errors, Access denied

access privileges, The MySQL Access Privilege System

Access program, Programs Known to Work With MyODBC

account privileges

adding, Adding New User Accounts to MySQL

accounts

anonymous user, Securing the Initial MySQL Accounts
root, Securing the Initial MySQL Accounts

ACID, Transactions and Atomic Operations, InnoDB Overview

ACLs, The MySQL Access Privilege System

ACOS(), Mathematical Functions

ActiveState Perl, Installing ActiveState Perl on Windows

ADDDATE(), Date and Time Functions

adding

character sets, Adding a New Character Set
native functions, Adding a New Native Function
new account privileges, Adding New User Accounts to MySQL
new functions, Adding New Functions to MySQL
new user privileges, Adding New User Accounts to MySQL
new users, Installing MySQL on Other Unix-Like Systems, Source Installation Overview
procedures, Adding New Procedures to MySQL
user-defined functions, Adding a New User-Defined Function

addition (+), Arithmetic Operators

ADDTIME(), Date and Time Functions

ADO program, Programs Known to Work With MyODBC

AES_DECRYPT(), Encryption Functions

AES_ENCRYPT(), Encryption Functions

age

calculating, Date Calculations

alias, Problems with Column Aliases

alias names

case sensitivity, Identifier Case Sensitivity

aliases

for expressions, GROUP BY with Hidden Fields
for tables, SELECT Syntax
in GROUP BY clauses, GROUP BY with Hidden Fields
in ORDER BY clauses, GROUP BY with Hidden Fields
names, Database, Table, Index, Column, and Alias Names
on expressions, SELECT Syntax

ALL, SELECT Syntax

ALLOW_INVALID_DATES SQL mode, The Server SQL Mode

ALTER COLUMN, ALTER TABLE Syntax

ALTER DATABASE, ALTER DATABASE Syntax

ALTER FUNCTION, ALTER PROCEDURE and ALTER FUNCTION

ALTER PROCEDURE, ALTER PROCEDURE and ALTER FUNCTION

ALTER SCHEMA, ALTER DATABASE Syntax

ALTER TABLE, ALTER TABLE Syntax, Problems with ALTER TABLE

ALTER VIEW, ALTER VIEW Syntax

altering

database, ALTER DATABASE Syntax
schema, ALTER DATABASE Syntax

ANALYZE TABLE, ANALYZE TABLE Syntax

AND

bitwise, Bit Functions
logical, Logical Operators

anonymous user, Securing the Initial MySQL Accounts, Access Control, Stage 1: Connection Verification, Access Control, Stage 2: Request Verification

ANSI mode

running, Running MySQL in ANSI Mode

ANSI SQL mode, The Server SQL Mode

ANSI_QUOTES SQL mode, The Server SQL Mode

answering questions

etiquette, Guidelines for Using the Mailing Lists

Apache, Using MySQL with Apache

API's

list of, Packages that support MySQL

APIs, APIs and Libraries

Perl, MySQL Perl API

approximate-value literals, Precision Math

ARCHIVE storage engine, Storage Engines and Table Types, The ARCHIVE Storage Engine

ARCHIVE table type, Storage Engines and Table Types, The ARCHIVE Storage Engine

Area(), Polygon Functions, MultiPolygon Functions

argument processing, UDF Argument Processing

arithmetic expressions, Arithmetic Operators

arithmetic functions, Bit Functions

AS, SELECT Syntax, JOIN Syntax

AsBinary(), Geometry Format Conversion Functions

ASCII(), String Functions

ASIN(), Mathematical Functions

AsText(), Geometry Format Conversion Functions

ATAN(), Mathematical Functions

ATAN2(), Mathematical Functions

attackers

security against, Making MySQL Secure Against Attackers

AUTO-INCREMENT

ODBC, How to Get the Value of an AUTO_INCREMENT Column in ODBC

AUTO_INCREMENT, Using AUTO_INCREMENT

and NULL values, Problems with NULL Values

AVG(), GROUP BY (Aggregate) Functions

AVG(DISTINCT), GROUP BY (Aggregate) Functions

B

backslash

escape character, Literal Values

backspace (\b), Strings

BACKUP TABLE, BACKUP TABLE Syntax

backups, Database Backups

database, BACKUP TABLE Syntax

batch

mysql option, mysql Options

batch mode, Using mysql in Batch Mode

BDB storage engine, Storage Engines and Table Types, The BDB (BerkeleyDB) Storage Engine

BDB table type, Storage Engines and Table Types, The BDB (BerkeleyDB) Storage Engine

BDB tables, Transactions and Atomic Operations

BdMPolyFromText(), Creating Geometry Values Using WKT Functions

BdMPolyFromWKB(), Creating Geometry Values Using WKB Functions

BdPolyFromText(), Creating Geometry Values Using WKT Functions

BdPolyFromWKB(), Creating Geometry Values Using WKB Functions

BEGIN, START TRANSACTION, COMMIT, and ROLLBACK Syntax, BEGIN … END Compound Statement

XA transactions, XA Transaction SQL Syntax

benchmark suite, The MySQL Benchmark Suite

BENCHMARK(), Information Functions

benchmarks, Using Your Own Benchmarks

BerkeleyDB storage engine, Storage Engines and Table Types, The BDB (BerkeleyDB) Storage Engine

BerkeleyDB table type, Storage Engines and Table Types, The BDB (BerkeleyDB) Storage Engine

BETWEEN ... AND, Comparison Functions and Operators

Big5 Chinese character encoding, Case Sensitivity in Searches

BIGINT data type, Overview of Numeric Types

BIN(), String Functions

BINARY, Cast Functions and Operators

BINARY data type, Overview of String Types, The BINARY and VARBINARY Types

binary distributions, MySQL Binaries Compiled by MySQL AB

installing, Installing MySQL on Other Unix-Like Systems
on Linux, Linux Binary Distribution Notes

binary log, The Binary Log

BIT data type, Overview of Numeric Types

BitKeeper tree, Installing from the Development Source Tree

BIT_AND(), GROUP BY (Aggregate) Functions

BIT_COUNT, Calculating Visits Per Day

BIT_COUNT(), Bit Functions

bit_functions

example, Calculating Visits Per Day

BIT_LENGTH(), String Functions

BIT_OR, Calculating Visits Per Day

BIT_OR(), GROUP BY (Aggregate) Functions

BIT_XOR(), GROUP BY (Aggregate) Functions

BLACKHOLE storage engine, Storage Engines and Table Types, The BLACKHOLE Storage Engine

BLACKHOLE table type, Storage Engines and Table Types, The BLACKHOLE Storage Engine

BLOB

inserting binary data, Strings
size, Data Type Storage Requirements

BLOB columns

default values, The BLOB and TEXT Types
indexing, Column Indexes, CREATE TABLE Syntax

BLOB data type, Overview of String Types, The BLOB and TEXT Types

BOOL data type, Overview of Numeric Types

BOOLEAN data type, Overview of Numeric Types

Borland Builder 4 program, Programs Known to Work With MyODBC

Borland C++ compiler, Borland C++

Boundary(), General Geometry Functions

brackets

square, Data Types

buffer sizes

client, APIs and Libraries
mysqld server, Tuning Server Parameters

Buffer(), Spatial Operators

bug reports

criteria for, How to Report Bugs or Problems

bugs

known, Known Issues in MySQL
reporting, How to Report Bugs or Problems

bugs database, How to Report Bugs or Problems

bugs.mysql.com, How to Report Bugs or Problems

building

client programs, Building Client Programs

C

C API

data types, MySQL C API
functions, C API Function Overview
linking problems, Problems Linking with the C API

C Prepared statement API

functions, C API Prepared Statement Function Overview

C++ APIs, MySQL C++ API

C++ Builder, Programs Known to Work With MyODBC

C++ compiler

gcc, Typical configure Options

C++ compiler cannot create executables, Dealing with Problems Compiling MySQL

C:\my.cnf file, Using Client Programs in a Multiple-Server Environment

CACHE INDEX, CACHE INDEX Syntax

caches

clearing, FLUSH Syntax

calculating

dates, Date Calculations

calendar, What Calendar Is Used By MySQL?

CALL, CALL Statement

calling sequences for aggregate functions

UDF, UDF Calling Sequences for Aggregate Functions

calling sequences for simple functions

UDF, UDF Calling Sequences for Simple Functions

can't create/write to file, Can't create/write to file

carriage return (\r), Strings

CASE, Control Flow Functions, CASE Statement

case sensitivity

in identifiers, Identifier Case Sensitivity
in names, Identifier Case Sensitivity
in searches, Case Sensitivity in Searches
in string comparisons, String Comparison Functions

case-sensitivity

in access checking, How the Privilege System Works
of database names, MySQL Extensions to Standard SQL
of table names, MySQL Extensions to Standard SQL

CAST, Cast Functions and Operators

cast functions, Cast Functions and Operators

cast operators, Cast Functions and Operators

casts, Comparison Functions and Operators, Cast Functions and Operators

CC environment variable, Typical configure Options, Dealing with Problems Compiling MySQL, Environment Variables

cc1plus problems, Dealing with Problems Compiling MySQL

CEILING(), Mathematical Functions

Centroid(), MultiPolygon Functions

CFLAGS environment variable, Typical configure Options, Dealing with Problems Compiling MySQL, Environment Variables

CHANGE MASTER TO, CHANGE MASTER TO Syntax

ChangeLog, MySQL Change History

changes

log, MySQL Change History
MySQL 5.1, Changes in release 5.1.x (Development)

changes to privileges, Access Control, Stage 2: Request Verification

changing

column, ALTER TABLE Syntax
column order, How to Change the Order of Columns in a Table
field, ALTER TABLE Syntax
table, ALTER TABLE Syntax, Problems with ALTER TABLE

changing socket location, Typical configure Options, Starting and Stopping MySQL Automatically, How to Protect or Change the MySQL Socket File /tmp/mysql.sock

CHAR data type, Overview of String Types, String Types

CHAR VARYING data type, Overview of String Types

CHAR(), String Functions

CHARACTER data type, Overview of String Types

character sets, Typical configure Options, The Character Set Used for Data and Sorting

adding, Adding a New Character Set

Character sets, Character Set Support

CHARACTER VARYING data type, Overview of String Types

character-sets-dir

mysql option, mysql Options

characters

multi-byte, Multi-Byte Character Support

CHARACTER_LENGTH(), String Functions

CHARACTER_SETS

INFORMATION_SCHEMA table, The INFORMATION_SCHEMA CHARACTER_SETS Table

CHARSET(), Information Functions

CHAR_LENGTH(), String Functions

check options

myisamchk, Check Options for myisamchk

CHECK TABLE, CHECK TABLE Syntax

checking

tables for errors, How to Check MyISAM Tables for Errors

checksum errors, Solaris Notes

CHECKSUM TABLE, CHECKSUM TABLE Syntax

Chinese, Case Sensitivity in Searches

choosing

a MySQL version, Choosing Which MySQL Distribution to Install

choosing types, Choosing the Right Type for a Column

clearing

caches, FLUSH Syntax

client programs

building, Building Client Programs

client tools, APIs and Libraries

clients

debugging, Debugging a MySQL Client
threaded, How to Make a Threaded Client

CLOSE, Cursor CLOSE Statement

closing

tables, How MySQL Opens and Closes Tables

COALESCE(), Comparison Functions and Operators

COERCIBILITY(), Information Functions

ColdFusion program, Programs Known to Work With MyODBC

collating

strings, String Collating Support

COLLATION(), Information Functions

COLLATIONS

INFORMATION_SCHEMA table, The INFORMATION_SCHEMA COLLATIONS Table

COLLATION_CHARACTER_SET_APPLICABILITY

INFORMATION_SCHEMA table, The INFORMATION_SCHEMA COLLATION_CHARACTER_SET_APPLICABILITY Table

column

changing, ALTER TABLE Syntax

column comments, CREATE TABLE Syntax

column names

case sensitivity, Identifier Case Sensitivity

columns

changing, How to Change the Order of Columns in a Table
indexes, Column Indexes
names, Database, Table, Index, Column, and Alias Names
other types, Using Data Types from Other Database Engines
selecting, Selecting Particular Columns
storage requirements, Data Type Storage Requirements
types, Data Types

COLUMNS

INFORMATION_SCHEMA table, The INFORMATION_SCHEMA COLUMNS Table

COLUMN_PRIVILEGES

INFORMATION_SCHEMA table, The INFORMATION_SCHEMA COLUMN_PRIVILEGES Table

command syntax, Conventions Used in This Manual

command-line history

mysql, mysql Options

command-line options

mysql, mysql Options
mysqladmin, mysqladmin — Client for Administering a MySQL Server
mysqld, mysqld Command-Line Options

commands

for binary distribution, Installing MySQL on Other Unix-Like Systems
replication masters, SQL Statements for Controlling Master Servers
replication slaves, SQL Statements for Controlling Slave Servers

commands out of sync, Commands out of sync

Comment syntax, Comment Syntax

comments

adding, Comment Syntax
starting, '--' as the Start of a Comment

COMMIT, Transactions and Atomic Operations, START TRANSACTION, COMMIT, and ROLLBACK Syntax

XA transactions, XA Transaction SQL Syntax

comparison operators, Comparison Functions and Operators

compatibility

between MySQL versions, Upgrading from MySQL 5.0
with mSQL, String Comparison Functions
with ODBC, Identifier Qualifiers, Overview of Numeric Types, Comparison Functions and Operators, CREATE TABLE Syntax, JOIN Syntax
with Oracle, MySQL Extensions to Standard SQL, GROUP BY (Aggregate) Functions, DESCRIBE Syntax (Get Information About Columns)
with PostgreSQL, MySQL Extensions to Standard SQL
with standard SQL, MySQL Standards Compliance
with Sybase, USE Syntax

compiler

C++ gcc, Typical configure Options

compiling

on Windows, Compiling MySQL Clients on Windows
optimizing, System Factors and Startup Parameter Tuning
problems, Dealing with Problems Compiling MySQL
speed, How Compiling and Linking Affects the Speed of MySQL
statically, Typical configure Options
user-defined functions, Compiling and Installing User-Defined Functions

compliance

Y2K, Year 2000 Compliance

composite subpartitioning, Subpartitioning

compress

mysql option, mysql Options

COMPRESS(), String Functions

compressed tables, Compressed Table Characteristics

CONCAT(), String Functions

CONCAT_WS(), String Functions

concurrent inserts, Speed of INSERT Statements, Locking Methods

Conditions, DECLARE Conditions

config-file

mysqld_multi option, mysqld_multi — Program for Managing Multiple MySQL Servers

config.cache, Dealing with Problems Compiling MySQL

config.cache file, Dealing with Problems Compiling MySQL

configuration files, Causes of Access denied Errors

configuration options, Typical configure Options

configure

running after prior invocation, Dealing with Problems Compiling MySQL

configure option

--with-charset, Typical configure Options
--with-collation, Typical configure Options
--with-extra-charsets, Typical configure Options
--with-low-memory, Dealing with Problems Compiling MySQL

configure script, Typical configure Options

connecting

remotely with SSH, Connecting to MySQL Remotely from Windows with SSH
to the server, Connecting to and Disconnecting from the Server, Connecting to the MySQL Server
verification, Access Control, Stage 1: Connection Verification

connection

aborted, Communication Errors and Aborted Connections

CONNECTION_ID(), Information Functions

Connector/JDBC, Connectors

Connector/ODBC, Connectors, MySQL Connector/ODBC

reporting problems, How to Report MyODBC Problems or Bugs

Connectors

MySQL, Connectors

connect_timeout variable, mysql Options, mysqladmin — Client for Administering a MySQL Server

constant table, Optimizing Queries with EXPLAIN, WHERE Clause Optimization

constraints, How MySQL Deals with Constraints

CONSTRAINTS

INFORMATION_SCHEMA table, The INFORMATION_SCHEMA TABLE_CONSTRAINTS Table

Contains(), Functions That Test Spatial Relationships Between Geometries

contributing companies

list of, Supporters of MySQL

contributors

list of, Contributors to MySQL

control access, Access Control, Stage 1: Connection Verification

control flow functions, Control Flow Functions

CONV(), String Functions

conventions

typographical, Conventions Used in This Manual

CONVERT, Cast Functions and Operators

CONVERT TO, ALTER TABLE Syntax

CONVERT_TZ(), Date and Time Functions

ConvexHull(), Spatial Operators

copying databases, Copying MySQL Databases to Another Machine

copying tables, CREATE TABLE Syntax

COS(), Mathematical Functions

COT(), Mathematical Functions

COUNT(), GROUP BY (Aggregate) Functions

COUNT(DISTINCT), GROUP BY (Aggregate) Functions

counting

table rows, Counting Rows

crash, Debugging a MySQL Server

recovery, Using myisamchk for Crash Recovery
repeated, What to Do If MySQL Keeps Crashing

crash-me, The MySQL Benchmark Suite

crash-me program, Designing Applications for Portability, The MySQL Benchmark Suite

CRC32(), Mathematical Functions

CREATE DATABASE, CREATE DATABASE Syntax

CREATE FUNCTION, CREATE PROCEDURE and CREATE FUNCTION, CREATE FUNCTION Syntax

CREATE INDEX, CREATE INDEX Syntax

CREATE PROCEDURE, CREATE PROCEDURE and CREATE FUNCTION

CREATE SCHEMA, CREATE DATABASE Syntax

CREATE TABLE, CREATE TABLE Syntax

CREATE TRIGGER, CREATE TRIGGER Syntax

CREATE USER, CREATE USER Syntax

CREATE VIEW, CREATE VIEW Syntax

creating

bug reports, How to Report Bugs or Problems
database, CREATE DATABASE Syntax
databases, Creating and Using a Database
default startup options, Using Option Files
function, CREATE FUNCTION Syntax
schema, CREATE DATABASE Syntax
tables, Creating a Table

creating user accounts, CREATE USER Syntax

CROSS JOIN, JOIN Syntax

Crosses(), Functions That Test Spatial Relationships Between Geometries

CR_SERVER_GONE_ERROR, MySQL server has gone away

CR_SERVER_LOST_ERROR, MySQL server has gone away

CSV storage engine, Storage Engines and Table Types, The CSV Storage Engine

CSV table type, Storage Engines and Table Types, The CSV Storage Engine

CURDATE(), Date and Time Functions

CURRENT_DATE, Date and Time Functions

CURRENT_TIME, Date and Time Functions

CURRENT_TIMESTAMP, Date and Time Functions

CURRENT_USER(), Information Functions

Cursors, Cursors

CURTIME(), Date and Time Functions

customers

of MySQL, What We Have Used MySQL For

CXX environment variable, Typical configure Options, Dealing with Problems Compiling MySQL, Environment Variables

CXXFLAGS environment variable, Typical configure Options, Dealing with Problems Compiling MySQL, Environment Variables

D

data

character sets, The Character Set Used for Data and Sorting
loading into tables, Loading Data into a Table
retrieving, Retrieving Information from a Table
size, Make Your Data as Small as Possible

data type

BIGINT, Overview of Numeric Types
BINARY, Overview of String Types, The BINARY and VARBINARY Types
BIT, Overview of Numeric Types
BLOB, Overview of String Types, The BLOB and TEXT Types
BOOL, Overview of Numeric Types, Using Data Types from Other Database Engines
BOOLEAN, Overview of Numeric Types, Using Data Types from Other Database Engines
CHAR, Overview of String Types, String Types
CHAR VARYING, Overview of String Types
CHARACTER, Overview of String Types
CHARACTER VARYING, Overview of String Types
DATE, Overview of Date and Time Types, The DATETIME, DATE, and TIMESTAMP Types
DATETIME, Overview of Date and Time Types, The DATETIME, DATE, and TIMESTAMP Types
DEC, Overview of Numeric Types
DECIMAL, Overview of Numeric Types, Precision Math
DOUBLE, Overview of Numeric Types
DOUBLE PRECISION, Overview of Numeric Types
ENUM, Overview of String Types, The ENUM Type
FIXED, Overview of Numeric Types
FLOAT, Overview of Numeric Types
GEOMETRY, MySQL Spatial Data Types
GEOMETRYCOLLECTION, MySQL Spatial Data Types
INT, Overview of Numeric Types
INTEGER, Overview of Numeric Types
LINESTRING, MySQL Spatial Data Types
LONG, The BLOB and TEXT Types
LONGBLOB, Overview of String Types
LONGTEXT, Overview of String Types
MEDIUMBLOB, Overview of String Types
MEDIUMINT, Overview of Numeric Types
MEDIUMTEXT, Overview of String Types
MULTILINESTRING, MySQL Spatial Data Types
MULTIPOINT, MySQL Spatial Data Types
MULTIPOLYGON, MySQL Spatial Data Types
NATIONAL CHAR, Overview of String Types
NCHAR, Overview of String Types
NUMERIC, Overview of Numeric Types
POINT, MySQL Spatial Data Types
POLYGON, MySQL Spatial Data Types
REAL, Overview of Numeric Types
SET, Overview of String Types, The SET Type
SMALLINT, Overview of Numeric Types
TEXT, Overview of String Types, The BLOB and TEXT Types
TIME, Overview of Date and Time Types, The TIME Type
TIMESTAMP, Overview of Date and Time Types, The DATETIME, DATE, and TIMESTAMP Types
TINYBLOB, Overview of String Types
TINYINT, Overview of Numeric Types
TINYTEXT, Overview of String Types
VARBINARY, Overview of String Types, The BINARY and VARBINARY Types
VARCHAR, Overview of String Types, String Types
VARCHARACTER, Overview of String Types
YEAR, Overview of Date and Time Types, The YEAR Type

data types, Data Types

C API, MySQL C API
overview, Data Type Overview

database

altering, ALTER DATABASE Syntax
creating, CREATE DATABASE Syntax
deleting, DROP DATABASE Syntax
mysql option, mysql Options

database design, Design Choices

Database information

obtaining, SHOW Syntax

database metadata, The INFORMATION_SCHEMA Database

database names

case sensitivity, Identifier Case Sensitivity
case-sensitivity, MySQL Extensions to Standard SQL

DATABASE(), Information Functions

databases

backups, Database Backups
copying, Copying MySQL Databases to Another Machine
creating, Creating and Using a Database
defined, Overview of the MySQL Database Management System
information about, Getting Information About Databases and Tables
names, Database, Table, Index, Column, and Alias Names
replicating, Replication in MySQL
selecting, Creating and Selecting a Database
symbolic links, Using Symbolic Links for Databases on Unix
using, Creating and Using a Database

DataJunction, Programs Known to Work With MyODBC

DATE, Problems Using DATE Columns

date and time functions, Date and Time Functions

Date and Time types, Date and Time Types

date calculations, Date Calculations

DATE columns

problems, Problems Using DATE Columns

DATE data type, Overview of Date and Time Types, The DATETIME, DATE, and TIMESTAMP Types

date functions

Y2K compliance, Year 2000 Compliance

date types, Data Type Storage Requirements

Y2K issues, Y2K Issues and Date Types

date values

problems, The DATETIME, DATE, and TIMESTAMP Types

DATE(), Date and Time Functions

DATEDIFF(), Date and Time Functions

DATETIME data type, Overview of Date and Time Types, The DATETIME, DATE, and TIMESTAMP Types

DATE_ADD(), Date and Time Functions

DATE_FORMAT(), Date and Time Functions

DATE_SUB(), Date and Time Functions

DAY(), Date and Time Functions

DAYNAME(), Date and Time Functions

DAYOFMONTH(), Date and Time Functions

DAYOFWEEK(), Date and Time Functions

DAYOFYEAR(), Date and Time Functions

db table

sorting, Access Control, Stage 2: Request Verification

DB2 SQL mode, The Server SQL Mode

DBI interface, MySQL Perl API

DBI->quote, Strings

DBI->trace, Debugging mysqld under gdb

DBI/DBD interface, MySQL Perl API

DBI_TRACE environment variable, Debugging mysqld under gdb, Environment Variables

DBI_USER environment variable, Environment Variables

DBUG package, The DBUG Package

DEALLOCATE PREPARE, SQL Syntax for Prepared Statements

debug

mysql option, mysql Options

debug-info

mysql option, mysql Options

debugging

client, Debugging a MySQL Client
server, Debugging a MySQL Server

DEC data type, Overview of Numeric Types

decimal arithmetic, Precision Math

DECIMAL data type, Overview of Numeric Types, Precision Math

decimal point, Data Types

DECLARE, DECLARE Statement

DECODE(), Encryption Functions

decode_bits myisamchk variable, General Options for myisamchk

DEFAULT

constraint, Constraints on Invalid Data

default

privileges, Securing the Initial MySQL Accounts

default hostname, Connecting to the MySQL Server

default installation location, Installation Layouts

default options, Using Option Files

DEFAULT value clause, CREATE TABLE Syntax

default values, MySQL Design Limitations and Tradeoffs, CREATE TABLE Syntax, INSERT Syntax

BLOB and TEXT columns, The BLOB and TEXT Types
implicit, CREATE TABLE Syntax
suppression, Constraints on Invalid Data

DEFAULT(), Miscellaneous Functions

default-character-set

mysql option, mysql Options

defaults

embedded, Options with the Embedded Server

DEGREES(), Mathematical Functions

DELAYED, INSERT DELAYED Syntax

delayed_insert_limit, INSERT DELAYED Syntax

DELETE, DELETE Syntax

deleting

database, DROP DATABASE Syntax
foreign key, ALTER TABLE Syntax, FOREIGN KEY Constraints
function, DROP FUNCTION Syntax
index, ALTER TABLE Syntax, DROP INDEX Syntax
primary key, ALTER TABLE Syntax
rows, Deleting Rows from Related Tables
schema, DROP DATABASE Syntax
table, DROP TABLE Syntax
user, Removing User Accounts from MySQL, DROP USER Syntax
users, Removing User Accounts from MySQL, DROP USER Syntax

deletion

mysql.sock, How to Protect or Change the MySQL Socket File /tmp/mysql.sock

Delphi program, Programs Known to Work With MyODBC

derived tables, Subqueries in the FROM clause

DESC, DESCRIBE Syntax (Get Information About Columns)

DESCRIBE, Getting Information About Databases and Tables, DESCRIBE Syntax (Get Information About Columns)

design

choices, Design Choices
issues, Known Issues in MySQL
limitations, MySQL Design Limitations and Tradeoffs

DES_DECRYPT(), Encryption Functions

DES_ENCRYPT(), Encryption Functions

developers

list of, Credits

development source tree, Installing from the Development Source Tree

Difference(), Spatial Operators

digits, Data Types

Dimension(), General Geometry Functions

directory structure

default, Installation Layouts

DISCARD TABLESPACE, ALTER TABLE Syntax, Using Per-Table Tablespaces

disconnecting

from the server, Connecting to and Disconnecting from the Server

Disjoint(), Functions That Test Spatial Relationships Between Geometries

disk full, How MySQL Handles a Full Disk

disk issues, Disk Issues

disks

splitting data across, Using Symbolic Links for Databases on Windows

display size, Data Types

display triggers, SHOW TRIGGERS Syntax

display width, Data Types

displaying

information

Cardinality, SHOW INDEX Syntax
Collation, SHOW INDEX Syntax
SHOW, SHOW Syntax, SHOW COLUMNS Syntax, SHOW INDEX Syntax, SHOW OPEN TABLES Syntax, SHOW TABLES Syntax

table status, SHOW TABLE STATUS Syntax

Distance(), Functions That Test Spatial Relationships Between Geometries

DISTINCT, Selecting Particular Columns, DISTINCT Optimization, GROUP BY (Aggregate) Functions, SELECT Syntax

DISTINCTROW, SELECT Syntax

DIV, Arithmetic Operators

division (/), Arithmetic Operators

DNS, How MySQL Uses DNS

DO, DO Syntax

DocBook XML

documentation source format, About This Manual

Documenters

list of, Documenters and translators

DOUBLE data type, Overview of Numeric Types

DOUBLE PRECISION data type, Overview of Numeric Types

double quote (\"), Strings

downgrading, Downgrading MySQL

downloading, How to Get MySQL

DROP DATABASE, DROP DATABASE Syntax

DROP FOREIGN KEY, ALTER TABLE Syntax, FOREIGN KEY Constraints

DROP FUNCTION, DROP PROCEDURE and DROP FUNCTION, DROP FUNCTION Syntax

DROP INDEX, ALTER TABLE Syntax, DROP INDEX Syntax

DROP PRIMARY KEY, ALTER TABLE Syntax

DROP PROCEDURE, DROP PROCEDURE and DROP FUNCTION

DROP SCHEMA, DROP DATABASE Syntax

DROP TABLE, DROP TABLE Syntax

DROP TRIGGER, DROP TRIGGER Syntax

DROP USER, DROP USER Syntax

DROP VIEW, DROP VIEW Syntax

dropping

user, Removing User Accounts from MySQL, DROP USER Syntax

DUAL, SELECT Syntax

DUMPFILE, SELECT Syntax

dynamic table characteristics, Dynamic Table Characteristics

E

Eiffel Wrapper, MySQL Eiffel Wrapper

ELT(), String Functions

email lists, MySQL Mailing Lists

embedded MySQL server library, libmysqld, the Embedded MySQL Server Library

ENCODE(), Encryption Functions

ENCRYPT(), Encryption Functions

encryption functions, Encryption Functions

END, BEGIN … END Compound Statement

EndPoint(), LineString Functions

entering

queries, Entering Queries

ENUM

size, Data Type Storage Requirements

ENUM data type, Overview of String Types, The ENUM Type

Envelope(), General Geometry Functions

environment variable

CC, Typical configure Options, Dealing with Problems Compiling MySQL
CFLAGS, Typical configure Options, Dealing with Problems Compiling MySQL
CXX, Typical configure Options, Dealing with Problems Compiling MySQL
CXXFLAGS, Typical configure Options, Dealing with Problems Compiling MySQL
HOME, mysql Options
LD_RUN_PATH, Linux Source Distribution Notes, Solaris Notes
MYSQL_DEBUG, Overview of Client and Utility Programs
MYSQL_HISTFILE, mysql Options
MYSQL_HOST, Connecting to the MySQL Server
MYSQL_PWD, Connecting to the MySQL Server, Overview of Client and Utility Programs
MYSQL_TCP_PORT, Running Multiple Servers on Unix, Using Client Programs in a Multiple-Server Environment, Overview of Client and Utility Programs
MYSQL_UNIX_PORT, Running Multiple Servers on Unix, Using Client Programs in a Multiple-Server Environment, Overview of Client and Utility Programs
PATH, Installing MySQL on Other Unix-Like Systems, Invoking MySQL Programs
USER, Connecting to the MySQL Server

Environment variable

CC, Environment Variables
CFLAGS, Environment Variables
CXX, Dealing with Problems Compiling MySQL, Environment Variables
CXXFLAGS, Environment Variables
DBI_TRACE, Debugging mysqld under gdb, Environment Variables
DBI_USER, Environment Variables
HOME, Environment Variables
LD_LIBRARY_PATH, Problems Using the Perl DBI/DBD Interface
LD_RUN_PATH, Problems Using the Perl DBI/DBD Interface, Environment Variables
MYSQL_DEBUG, Debugging a MySQL Client, Environment Variables
MYSQL_HISTFILE, Environment Variables
MYSQL_HOME, Environment Variables
MYSQL_HOST, Environment Variables
MYSQL_PS1, Environment Variables
MYSQL_PWD, Environment Variables
MYSQL_TCP_PORT, Environment Variables
MYSQL_UNIX_PORT, Problems Running mysql_install_db, Environment Variables
PATH, Environment Variables
TMPDIR, Problems Running mysql_install_db, Environment Variables
TZ, Time Zone Problems, Environment Variables
UMASK, Problems with File Permissions, Environment Variables
UMASK_DIR, Problems with File Permissions, Environment Variables
USER, Environment Variables

Environment variables

CXX, Dealing with Problems Compiling MySQL

environment variables, Using Environment Variables to Specify Options, Causes of Access denied Errors, Overview of Client and Utility Programs

list of, Environment Variables

equal (=), Comparison Functions and Operators

Equals(), Functions That Test Spatial Relationships Between Geometries

error messages

can't find file, Problems with File Permissions
languages, Setting the Error Message Language

errors

access denied, Access denied
checking tables for, How to Check MyISAM Tables for Errors
common, Problems and Common Errors
directory checksum, Solaris Notes
handling for UDFs, UDF Return Values and Error Handling
known, Known Issues in MySQL
linking, Problems Linking to the MySQL Client Library
list of, Common Errors When Using MySQL Programs
reporting, General Information, How to Report Bugs or Problems

ERROR_FOR_DIVISION_BY_ZERO SQL mode, The Server SQL Mode

escape (\\), Strings

escape characters, Literal Values

estimating

query performance, Estimating Query Performance

exact-value literals, Precision Math

example

mysqld_multi option, mysqld_multi — Program for Managing Multiple MySQL Servers

EXAMPLE storage engine, Storage Engines and Table Types, The EXAMPLE Storage Engine

EXAMPLE table type, Storage Engines and Table Types, The EXAMPLE Storage Engine

examples

compressed tables, myisampack — Generate Compressed, Read-Only MyISAM Tables
myisamchk output, Getting Information About a Table
queries, Examples of Common Queries

Excel, Programs Known to Work With MyODBC

execute

mysql option, mysql Options

EXECUTE, SQL Syntax for Prepared Statements

EXP(), Mathematical Functions

EXPLAIN, Optimizing Queries with EXPLAIN

EXPORT_SET(), String Functions

expression aliases, GROUP BY with Hidden Fields, SELECT Syntax

expressions

extended, Pattern Matching

extensions

to standard SQL, MySQL Standards Compliance

ExteriorRing(), Polygon Functions

EXTRACT(), Date and Time Functions

extracting

dates, Date Calculations

ExtractValue(), XML Functions

F

FALSE, Numbers, Boolean Values

testing for, Comparison Functions and Operators

fatal signal 11, Dealing with Problems Compiling MySQL

features of MySQL, The Main Features of MySQL

FEDERATED storage engine, Storage Engines and Table Types, The FEDERATED Storage Engine

FEDERATED table type, Storage Engines and Table Types, The FEDERATED Storage Engine

FETCH, Cursor FETCH Statement

field

changing, ALTER TABLE Syntax

FIELD(), String Functions

FILE, String Functions

files

binary log, The Binary Log
config.cache, Dealing with Problems Compiling MySQL
error messages, Setting the Error Message Language
log, Typical configure Options, Log File Maintenance
my.cnf, Replication Features and Known Problems
not found message, Problems with File Permissions
permissions, Problems with File Permissions
query log, The General Query Log
repairing, Repair Options for myisamchk
script, Using mysql in Batch Mode
size limits, How Large MySQL Tables Can Be
slow query log, The Slow Query Log
tmp, Problems Running mysql_install_db
update log (obsolete), The Binary Log

filesort optimization, ORDER BY Optimization

FIND_IN_SET(), String Functions

FIXED data type, Overview of Numeric Types

fixed-point arithmetic, Precision Math

FLOAT data type, Overview of Numeric Types

floating-point number, Overview of Numeric Types

floats, Numbers

FLOOR(), Mathematical Functions

FLUSH, FLUSH Syntax

flush tables, mysqladmin — Client for Administering a MySQL Server

FOR UPDATE, SELECT Syntax

force

mysql option, mysql Options

FORCE INDEX, SELECT Syntax, JOIN Syntax, Optimizer-Related Issues

FORCE KEY, SELECT Syntax, JOIN Syntax

foreign key

constraint, PRIMARY KEY and UNIQUE Index Constraints
deleting, ALTER TABLE Syntax, FOREIGN KEY Constraints

foreign keys, Foreign Keys, Using Foreign Keys, ALTER TABLE Syntax

FORMAT(), Miscellaneous Functions

Forums, MySQL Community Support at the MySQL Forums

FOUND_ROWS(), Information Functions

FreeBSD troubleshooting, Dealing with Problems Compiling MySQL

FROM, SELECT Syntax

FROM_DAYS(), Date and Time Functions

FROM_UNIXTIME(), Date and Time Functions

ft_max_word_len myisamchk variable, General Options for myisamchk

ft_min_word_len myisamchk variable, General Options for myisamchk

ft_stopword_file myisamchk variable, General Options for myisamchk

full disk, How MySQL Handles a Full Disk

full-text search, Full-Text Search Functions

FULLTEXT, Full-Text Search Functions

fulltext

stopword list, Fine-Tuning MySQL Full-Text Search

function

creating, CREATE FUNCTION Syntax
deleting, DROP FUNCTION Syntax

functions, Functions and Operators

arithmetic, Bit Functions

bit, Bit Functions

C API, C API Function Overview

C Prepared statement API, C API Prepared Statement Function Overview

cast, Cast Functions and Operators

control flow, Control Flow Functions

date and time, Date and Time Functions

encryption, Encryption Functions

GROUP BY, GROUP BY (Aggregate) Functions

grouping, Parentheses

information, Information Functions

mathematical, Mathematical Functions

miscellaneous, Miscellaneous Functions

native

adding, Adding a New Native Function

new, Adding New Functions to MySQL

string, String Functions

string comparison, String Comparison Functions

user-defined, Adding New Functions to MySQL

adding, Adding a New User-Defined Function

Functions

user-defined, CREATE FUNCTION Syntax, DROP FUNCTION Syntax

functions for SELECT and WHERE clauses, Functions and Operators

Future development of MySQL Cluster, MySQL Cluster Development Roadmap

G

gcc, Typical configure Options

gdb

using, Debugging mysqld under gdb

general information, General Information

General Public License, Overview of the MySQL Database Management System

geographic feature, Introduction to MySQL Spatial Support

GeomCollFromText(), Creating Geometry Values Using WKT Functions

GeomCollFromWKB(), Creating Geometry Values Using WKB Functions

geometry, Introduction to MySQL Spatial Support

GEOMETRY data type, MySQL Spatial Data Types

GEOMETRYCOLLECTION data type, MySQL Spatial Data Types

GeometryCollection(), Creating Geometry Values Using MySQL-Specific Functions

GeometryCollectionFromText(), Creating Geometry Values Using WKT Functions

GeometryCollectionFromWKB(), Creating Geometry Values Using WKB Functions

GeometryFromText(), Creating Geometry Values Using WKT Functions

GeometryFromWKB(), Creating Geometry Values Using WKB Functions

GeometryN(), GeometryCollection Functions

GeometryType(), General Geometry Functions

GeomFromText(), Creating Geometry Values Using WKT Functions, Geometry Format Conversion Functions

GeomFromWKB(), Creating Geometry Values Using WKB Functions, Geometry Format Conversion Functions

geospatial feature, Introduction to MySQL Spatial Support

getting MySQL, How to Get MySQL

GET_FORMAT(), Date and Time Functions

GET_LOCK(), Miscellaneous Functions

GIS, Spatial Extensions in MySQL, Introduction to MySQL Spatial Support

GLength(), LineString Functions, MultiLineString Functions

global privileges, GRANT and REVOKE Syntax

goals of MySQL, Overview of the MySQL Database Management System

GPL

General Public License, GNU General Public License
GNU General Public License, GNU General Public License
MySQL FLOSS License Exception, MySQL FLOSS License Exception

GRANT, GRANT and REVOKE Syntax

GRANT statement, Adding New User Accounts to MySQL, SSL GRANT Options

grant tables, Access Control, Stage 2: Request Verification

re-creating, Problems Running mysql_install_db
sorting, Access Control, Stage 1: Connection Verification, Access Control, Stage 2: Request Verification
upgrading, Upgrading the Grant Tables

granting

privileges, GRANT and REVOKE Syntax

GRANTS, SHOW GRANTS Syntax

greater than (>), Comparison Functions and Operators

greater than or equal (>=), Comparison Functions and Operators

GREATEST(), Comparison Functions and Operators

GROUP BY, GROUP BY Optimization

aliases in, GROUP BY with Hidden Fields
extensions to standard SQL, GROUP BY with Hidden Fields, SELECT Syntax

GROUP BY functions, GROUP BY (Aggregate) Functions

grouping

expressions, Parentheses

GROUP_CONCAT(), GROUP BY (Aggregate) Functions

H

HANDLER, HANDLER Syntax

Handlers, DECLARE Handlers

handling

errors, UDF Return Values and Error Handling

hash partitioning, HASH Partitioning

hash partitions, managing, Management of HASH and KEY Partitions

hash partitions, splitting and merging, Management of HASH and KEY Partitions

HAVING, SELECT Syntax

HEAP storage engine, Storage Engines and Table Types, The MEMORY (HEAP) Storage Engine

HEAP table type, Storage Engines and Table Types, The MEMORY (HEAP) Storage Engine

help

mysql option, mysql Options
mysqld_multi option, mysqld_multi — Program for Managing Multiple MySQL Servers

HEX(), String Functions

hexadecimal values, Hexadecimal Values

HIGH_NOT_PRECEDENCE SQL mode, The Server SQL Mode

HIGH_PRIORITY, SELECT Syntax

hints, MySQL Extensions to Standard SQL, SELECT Syntax, JOIN Syntax

index, SELECT Syntax, JOIN Syntax

history of MySQL, History of MySQL

HOME environment variable, mysql Options, Environment Variables

host

mysql option, mysql Options

host table, Access Control, Stage 2: Request Verification

sorting, Access Control, Stage 2: Request Verification

host.frm

problems finding, Unix Post-Installation Procedures

hostname

default, Connecting to the MySQL Server

hostname caching, How MySQL Uses DNS

HOUR(), Date and Time Functions

html

mysql option, mysql Options

I

ID

unique, How to Get the Unique ID for the Last Inserted Row

identifiers, Database, Table, Index, Column, and Alias Names

case sensitivity, Identifier Case Sensitivity
quoting, Database, Table, Index, Column, and Alias Names

IF, IF Statement

IF(), Control Flow Functions

IFNULL(), Control Flow Functions

IGNORE INDEX, SELECT Syntax, JOIN Syntax

IGNORE KEY, SELECT Syntax, JOIN Syntax

ignore-space

mysql option, mysql Options

IGNORE_SPACE SQL mode, The Server SQL Mode

implicit default values, CREATE TABLE Syntax

IMPORT TABLESPACE, ALTER TABLE Syntax, Using Per-Table Tablespaces

IN, Comparison Functions and Operators

increasing

performance, Replication FAQ

increasing with replication

speed, Replication in MySQL

index

deleting, ALTER TABLE Syntax, DROP INDEX Syntax

index hints, SELECT Syntax, JOIN Syntax

indexes, CREATE INDEX Syntax

and BLOB columns, Column Indexes, CREATE TABLE Syntax
and IS NULL, How MySQL Uses Indexes
and LIKE, How MySQL Uses Indexes
and NULL values, CREATE TABLE Syntax
and TEXT columns, Column Indexes, CREATE TABLE Syntax
assigning to key cache, CACHE INDEX Syntax
block size, Server System Variables
columns, Column Indexes
leftmost prefix of, How MySQL Uses Indexes
multi-column, Multiple-Column Indexes
multiple-part, CREATE INDEX Syntax
names, Database, Table, Index, Column, and Alias Names
use of, How MySQL Uses Indexes

INET_ATON(), Miscellaneous Functions

INET_NTOA(), Miscellaneous Functions

information about partitions, obtaining, Obtaining Information About Partitions

information functions, Information Functions

INFORMATION_SCHEMA, The INFORMATION_SCHEMA Database, INFORMATION_SCHEMA Tables

INNER JOIN, JOIN Syntax

InnoDB, InnoDB Overview

Solaris 10 x86_64 issues, Solaris Notes

InnoDB storage engine, Storage Engines and Table Types, The InnoDB Storage Engine

InnoDB table type, Storage Engines and Table Types, The InnoDB Storage Engine

InnoDB tables, Transactions and Atomic Operations

INSERT, Speed of INSERT Statements, INSERT Syntax

INSERT ... SELECT, INSERT Syntax

INSERT DELAYED, INSERT DELAYED Syntax

INSERT statement

grant privileges, Adding New User Accounts to MySQL

INSERT(), String Functions

inserting

speed of, Speed of INSERT Statements

inserts

concurrent, Speed of INSERT Statements, Locking Methods

INSTALL PLUGIN, INSTALL PLUGIN Syntax

installation layouts, Installation Layouts

installation overview, MySQL Installation Using a Source Distribution

installing

binary distribution, Installing MySQL on Other Unix-Like Systems
Linux RPM packages, Installing MySQL on Linux
Mac OS X PKG packages, Installing MySQL on Mac OS X
overview, Installing MySQL
Perl, Perl Installation Notes
Perl on Windows, Installing ActiveState Perl on Windows
source distribution, MySQL Installation Using a Source Distribution
user-defined functions, Compiling and Installing User-Defined Functions

installing plugins, INSTALL PLUGIN Syntax

INSTR(), String Functions

INT data type, Overview of Numeric Types

integer arithmetic, Precision Math

INTEGER data type, Overview of Numeric Types

integers, Numbers

InteriorRingN(), Polygon Functions

internal compiler errors, Dealing with Problems Compiling MySQL

internal locking, Locking Methods

internals, MySQL Internals

Internet Relay Chat, MySQL Community Support on Internet Relay Chat (IRC)

Intersection(), Spatial Operators

Intersects(), Functions That Test Spatial Relationships Between Geometries

INTERVAL(), Comparison Functions and Operators

introducer

string literal, Strings, Character String Literal Character Set and Collation

invalid data

constraint, Constraints on Invalid Data

IRC, MySQL Community Support on Internet Relay Chat (IRC)

IS boolean_value, Comparison Functions and Operators

IS NOT boolean_value, Comparison Functions and Operators

IS NOT NULL, Comparison Functions and Operators

IS NULL, IS NULL Optimization, Comparison Functions and Operators

and indexes, How MySQL Uses Indexes

ISAM storage engine, Storage Engines and Table Types

ISAM table type, Storage Engines and Table Types

IsClosed(), MultiLineString Functions

IsEmpty(), General Geometry Functions

ISNULL(), Comparison Functions and Operators

ISOLATION LEVEL, SET TRANSACTION Syntax

IsRing(), LineString Functions

IsSimple(), General Geometry Functions

IS_FREE_LOCK(), Miscellaneous Functions

IS_USED_LOCK(), Miscellaneous Functions

ITERATE, ITERATE Statement

J

JOIN, JOIN Syntax

K

Key cache

MyISAM, The MyISAM Key Cache

key cache

assigning indexes to, CACHE INDEX Syntax

key partitioning, KEY Partitioning

key partitions, managing, Management of HASH and KEY Partitions

key partitions, splitting and merging, Management of HASH and KEY Partitions

key space

MyISAM, Space Needed for Keys

keys, Column Indexes

foreign, Foreign Keys, Using Foreign Keys
multi-column, Multiple-Column Indexes
searching on two, Searching on Two Keys

keywords, Treatment of Reserved Words in MySQL

key_buffer_size myisamchk variable, General Options for myisamchk

KEY_COLUMN_USAGE

INFORMATION_SCHEMA table, The INFORMATION_SCHEMA KEY_COLUMN_USAGE Table

KILL, KILL Syntax

known errors, Known Issues in MySQL

L

language support, Setting the Error Message Language

last row

unique ID, How to Get the Unique ID for the Last Inserted Row

LAST_DAY(), Date and Time Functions

LAST_INSERT_ID(), Transactions and Atomic Operations, INSERT Syntax

LAST_INSERT_ID([expr]), Information Functions

layout of installation, Installation Layouts

LCASE(), String Functions

LD_LIBRARY_PATH environment variable, Problems Using the Perl DBI/DBD Interface

LD_RUN_PATH environment variable, Linux Source Distribution Notes, Solaris Notes, Problems Using the Perl DBI/DBD Interface, Environment Variables

LEAST(), Comparison Functions and Operators

LEAVE, LEAVE Statement

LEFT JOIN, LEFT JOIN and RIGHT JOIN Optimization, JOIN Syntax

LEFT OUTER JOIN, JOIN Syntax

LEFT(), String Functions

leftmost prefix of indexes, How MySQL Uses Indexes

legal names, Database, Table, Index, Column, and Alias Names

LENGTH(), String Functions

less than (<), Comparison Functions and Operators

less than or equal (<=), Comparison Functions and Operators

libmysqld, libmysqld, the Embedded MySQL Server Library

options, Options with the Embedded Server

libraries

list of, Libraries used by and included with MySQL

library

mysqlclient, APIs and Libraries
mysqld, APIs and Libraries

License, MySQL FLOSS License Exception

LIKE, String Comparison Functions

and indexes, How MySQL Uses Indexes
and wildcards, How MySQL Uses Indexes

LIMIT, LIMIT Optimization, Information Functions, SELECT Syntax

limitations

design, MySQL Design Limitations and Tradeoffs
MySQL Limitations, Limits in MySQL
replication, Replication Features and Known Problems

limits

file-size, How Large MySQL Tables Can Be
MySQL Limits, limits in MySQL, Limits in MySQL

linear hash partitioning, LINEAR HASH Partitioning

linear key partitioning, KEY Partitioning

linefeed (\n), Strings

LineFromText(), Creating Geometry Values Using WKT Functions

LineFromWKB(), Creating Geometry Values Using WKB Functions

LINESTRING data type, MySQL Spatial Data Types

LineString(), Creating Geometry Values Using MySQL-Specific Functions

LineStringFromText(), Creating Geometry Values Using WKT Functions

LineStringFromWKB(), Creating Geometry Values Using WKB Functions

linking, Building Client Programs

errors, Problems Linking to the MySQL Client Library
problems, Problems Linking with the C API
speed, How Compiling and Linking Affects the Speed of MySQL

links

symbolic, Using Symbolic Links

Linux

binary distribution, Linux Binary Distribution Notes
source distribution, Linux Source Distribution Notes

list partitioning, LIST Partitioning

list partitions, adding and dropping, Management of RANGE and LIST Partitions

list partitions, managing, Management of RANGE and LIST Partitions

literals, Literal Values

LN(), Mathematical Functions

LOAD DATA FROM MASTER, LOAD DATA FROM MASTER Syntax

LOAD DATA INFILE, LOAD DATA INFILE Syntax, Problems with NULL Values

LOAD TABLE FROM MASTER, LOAD TABLE tbl_name FROM MASTER Syntax

loading

tables, Loading Data into a Table

LOAD_FILE(), String Functions

local-infile

mysql option, mysql Options

LOCALTIME, Date and Time Functions

LOCALTIMESTAMP, Date and Time Functions

LOCATE(), String Functions

LOCK IN SHARE MODE, SELECT Syntax

LOCK TABLES, LOCK TABLES and UNLOCK TABLES Syntax

locking, System Factors and Startup Parameter Tuning

page-level, Locking Methods
row-level, Transactions and Atomic Operations, Locking Methods
table-level, Locking Methods

locking methods, Locking Methods

log

changes, MySQL Change History
mysqld_multi option, mysqld_multi — Program for Managing Multiple MySQL Servers

log files, Typical configure Options

maintaining, Log File Maintenance
names, Database Backups

Log files, The MySQL Log Files

LOG(), Mathematical Functions

LOG10(), Mathematical Functions

LOG2(), Mathematical Functions

logical operators, Logical Operators

LONG data type, The BLOB and TEXT Types

LONGBLOB data type, Overview of String Types

LONGTEXT data type, Overview of String Types

LOOP, LOOP Statement

LOWER(), String Functions

LPAD(), String Functions

LTRIM(), String Functions

M

Mac OS X

installation, Installing MySQL on Mac OS X

mailing list address, General Information

mailing lists, MySQL Mailing Lists

archive location, MySQL Mailing Lists
guidelines, Guidelines for Using the Mailing Lists

main features of MySQL, The Main Features of MySQL

maintaining

log files, Log File Maintenance
tables, Setting Up a Table Maintenance Schedule

MAKEDATE(), Date and Time Functions

MAKETIME(), Date and Time Functions

make_binary_distribution, Overview of the Server-Side Scripts and Utilities

MAKE_SET(), String Functions

manual

available formats, About This Manual
online location, About This Manual
typographical conventions, Conventions Used in This Manual

master/slave setup, Replication Implementation Overview

MASTER_POS_WAIT(), Miscellaneous Functions, MASTER_POS_WAIT() Syntax

MATCH ... AGAINST(), Full-Text Search Functions

matching

patterns, Pattern Matching

math, Precision Math

mathematical functions, Mathematical Functions

MAX(), GROUP BY (Aggregate) Functions

MAX(DISTINCT), GROUP BY (Aggregate) Functions

MAXDB SQL mode, The Server SQL Mode

maximum memory used, mysqladmin — Client for Administering a MySQL Server

maximums

maximum tables per join, Limits of Joins

max_allowed_packet variable, mysql Options

MAX_CONNECTIONS_PER_HOUR, Limiting Account Resources

max_join_size variable, mysql Options

MAX_QUERIES_PER_HOUR, Limiting Account Resources

MAX_UPDATES_PER_HOUR, Limiting Account Resources

MAX_USER_CONNECTIONS, Limiting Account Resources

MBR, Relations on Geometry Minimal Bounding Rectangles (MBRs)

MBRContains(), Relations on Geometry Minimal Bounding Rectangles (MBRs)

MBRDisjoint(), Relations on Geometry Minimal Bounding Rectangles (MBRs)

MBREqual(), Relations on Geometry Minimal Bounding Rectangles (MBRs)

MBRIntersects(), Relations on Geometry Minimal Bounding Rectangles (MBRs)

MBROverlaps(), Relations on Geometry Minimal Bounding Rectangles (MBRs)

MBRTouches(), Relations on Geometry Minimal Bounding Rectangles (MBRs)

MBRWithin(), Relations on Geometry Minimal Bounding Rectangles (MBRs)

MD5(), Encryption Functions

MEDIUMBLOB data type, Overview of String Types

MEDIUMINT data type, Overview of Numeric Types

MEDIUMTEXT data type, Overview of String Types

MEMORY storage engine, Storage Engines and Table Types, The MEMORY (HEAP) Storage Engine

MEMORY table type, Storage Engines and Table Types, The MEMORY (HEAP) Storage Engine

memory usage

myisamchk, myisamchk Memory Usage

memory use, How MySQL Uses Memory, mysqladmin — Client for Administering a MySQL Server

MERGE storage engine, Storage Engines and Table Types, The MERGE Storage Engine

MERGE table type, Storage Engines and Table Types, The MERGE Storage Engine

MERGE tables

defined, The MERGE Storage Engine

messages

languages, Setting the Error Message Language

metadata

database, The INFORMATION_SCHEMA Database

methods

locking, Locking Methods

MICROSECOND(), Date and Time Functions

MID(), String Functions

MIN(), GROUP BY (Aggregate) Functions

MIN(DISTINCT), GROUP BY (Aggregate) Functions

Minimum Bounding Rectangle, Relations on Geometry Minimal Bounding Rectangles (MBRs)

minus

unary (-), Arithmetic Operators

MINUTE(), Date and Time Functions

mirror sites, How to Get MySQL

miscellaneous functions, Miscellaneous Functions

MIT-pthreads, MIT-pthreads Notes

MLineFromText(), Creating Geometry Values Using WKT Functions

MLineFromWKB(), Creating Geometry Values Using WKB Functions

MOD (modulo), Mathematical Functions

MOD(), Mathematical Functions

modes

batch, Using mysql in Batch Mode

modules

list of, MySQL Stability

modulo (%), Mathematical Functions

modulo (MOD), Mathematical Functions

monitor

terminal, Tutorial

MONTH(), Date and Time Functions

MONTHNAME(), Date and Time Functions

MPointFromText(), Creating Geometry Values Using WKT Functions

MPointFromWKB(), Creating Geometry Values Using WKB Functions

MPolyFromText(), Creating Geometry Values Using WKT Functions

MPolyFromWKB(), Creating Geometry Values Using WKB Functions

mSQL compatibility, String Comparison Functions

MSSQL SQL mode, The Server SQL Mode

multi-byte character sets, Can't initialize character set

multi-byte characters, Multi-Byte Character Support

multi-column indexes, Multiple-Column Indexes

MULTILINESTRING data type, MySQL Spatial Data Types

MultiLineString(), Creating Geometry Values Using MySQL-Specific Functions

MultiLineStringFromText(), Creating Geometry Values Using WKT Functions

MultiLineStringFromWKB(), Creating Geometry Values Using WKB Functions

multiple servers, Running Multiple MySQL Servers on the Same Machine

multiple-part index, CREATE INDEX Syntax

multiplication (*), Arithmetic Operators

MULTIPOINT data type, MySQL Spatial Data Types

MultiPoint(), Creating Geometry Values Using MySQL-Specific Functions

MultiPointFromText(), Creating Geometry Values Using WKT Functions

MultiPointFromWKB(), Creating Geometry Values Using WKB Functions

MULTIPOLYGON data type, MySQL Spatial Data Types

MultiPolygon(), Creating Geometry Values Using MySQL-Specific Functions

MultiPolygonFromText(), Creating Geometry Values Using WKT Functions

MultiPolygonFromWKB(), Creating Geometry Values Using WKB Functions

My

derivation, History of MySQL

my.cnf file, Replication Features and Known Problems

MyISAM

compressed tables, Compressed Table Characteristics
size, Data Type Storage Requirements

MyISAM key cache, The MyISAM Key Cache

MyISAM storage engine, Storage Engines and Table Types, The MyISAM Storage Engine

MyISAM table type, Storage Engines and Table Types, The MyISAM Storage Engine

myisamchk, Typical configure Options, Overview of the Server-Side Scripts and Utilities

example output, Getting Information About a Table
options, General Options for myisamchk

myisamlog, Overview of Client and Utility Programs

myisampack, Overview of Client and Utility Programs, Compressed Table Characteristics

myisam_block_size myisamchk variable, General Options for myisamchk

MyODBC, MySQL Connector/ODBC

reporting problems, How to Report MyODBC Problems or Bugs

MySQL

defined, Overview of the MySQL Database Management System
introduction, Overview of the MySQL Database Management System
pronunciation, Overview of the MySQL Database Management System

mysql, Overview of Client and Utility Programs

MySQL AB

defined, Overview of MySQL AB

MySQL binary distribution, Choosing Which MySQL Distribution to Install

MYSQL C type, C API Data types

MySQL C type, C API Prepared Statement Data types

MySQL Cluster in MySQL 5.0 and 5.1, MySQL Cluster Development Roadmap

mysql command-line options, mysql Options

mysql commands

list of, mysql Commands

MySQL Dolphin name, History of MySQL

MySQL history, History of MySQL

mysql history file, mysql Options

MySQL mailing lists, MySQL Mailing Lists

MySQL name, History of MySQL

mysql prompt command, mysql Commands

MySQL source distribution, Choosing Which MySQL Distribution to Install

mysql status command, mysql Commands

MySQL storage engines, Storage Engines and Table Types

MySQL table types, Storage Engines and Table Types

MySQL version, How to Get MySQL

MySQL++, MySQL C++ API

mysql.server, Overview of the Server-Side Scripts and Utilities

mysql.sock

changing location of, Typical configure Options
protection, How to Protect or Change the MySQL Socket File /tmp/mysql.sock

MYSQL323 SQL mode, The Server SQL Mode

MYSQL40 SQL mode, The Server SQL Mode

mysqlaccess, Overview of Client and Utility Programs

mysqladmin, Overview of Client and Utility Programs, CREATE DATABASE Syntax, DROP DATABASE Syntax, SHOW STATUS Syntax, SHOW VARIABLES Syntax, FLUSH Syntax, KILL Syntax

mysqld_multi option, mysqld_multi — Program for Managing Multiple MySQL Servers

mysqladmin command-line options, mysqladmin — Client for Administering a MySQL Server

mysqlbinlog, Overview of Client and Utility Programs

mysqlbug, Overview of the Server-Side Scripts and Utilities

mysqlbug script, How to Report Bugs or Problems

mysqlcheck, Overview of Client and Utility Programs

mysqlclient library, APIs and Libraries

mysqld, Overview of the Server-Side Scripts and Utilities

command-line options, mysqld Command-Line Options
mysqld_multi option, mysqld_multi — Program for Managing Multiple MySQL Servers
starting, How to Run MySQL as a Normal User

mysqld library, APIs and Libraries

mysqld options, Tuning Server Parameters

mysqld server

buffer sizes, Tuning Server Parameters

mysqld-max, Overview of the Server-Side Scripts and Utilities, The mysqld-max Extended MySQL Server

mysqldump, Copying MySQL Databases to Another Machine, Overview of Client and Utility Programs

mysqld_multi, Overview of the Server-Side Scripts and Utilities

mysqld_safe, Overview of the Server-Side Scripts and Utilities

mysqlhotcopy, Overview of Client and Utility Programs

mysqlimport, Copying MySQL Databases to Another Machine, Overview of Client and Utility Programs, LOAD DATA INFILE Syntax

mysqlshow, Overview of Client and Utility Programs

mysqlslap, Overview of Client and Utility Programs

mysqltest

MySQL Test Suite, MySQL Test Suite

mysql_affected_rows(), mysql_affected_rows()

mysql_autocommit()., mysql_autocommit()

MYSQL_BIND C type, C API Prepared Statement Data types

mysql_change_user(), mysql_change_user()

mysql_character_set_name(), mysql_character_set_name()

mysql_close(), mysql_close()

mysql_commit()., mysql_commit()

mysql_connect(), mysql_connect()

mysql_create_db(), mysql_create_db()

mysql_data_seek(), mysql_data_seek()

MYSQL_DEBUG environment variable, Overview of Client and Utility Programs, Debugging a MySQL Client, Environment Variables

mysql_debug(), mysql_debug()

mysql_drop_db(), mysql_drop_db()

mysql_dump_debug_info(), mysql_dump_debug_info()

mysql_eof(), mysql_eof()

mysql_errno(), mysql_errno()

mysql_error(), mysql_error()

mysql_escape_string(), mysql_escape_string()

mysql_fetch_field(), mysql_fetch_field()

mysql_fetch_fields(), mysql_fetch_fields()

mysql_fetch_field_direct(), mysql_fetch_field_direct()

mysql_fetch_lengths(), mysql_fetch_lengths()

mysql_fetch_row(), mysql_fetch_row()

MYSQL_FIELD C type, C API Data types

mysql_field_count(), mysql_field_count(), mysql_num_fields()

MYSQL_FIELD_OFFSET C type, C API Data types

mysql_field_seek(), mysql_field_seek()

mysql_field_tell(), mysql_field_tell()

mysql_fix_privilege_tables, Overview of the Server-Side Scripts and Utilities, Causes of Access denied Errors

mysql_free_result(), mysql_free_result()

mysql_get_character_set_info(), mysql_get_character_set_info()

mysql_get_client_info(), mysql_get_client_info()

mysql_get_client_version(), mysql_get_client_version()

mysql_get_host_info(), mysql_get_host_info()

mysql_get_proto_info(), mysql_get_proto_info()

mysql_get_server_info(), mysql_get_server_info()

mysql_get_server_version(), mysql_get_server_version()

mysql_hex_string(), mysql_hex_string()

MYSQL_HISTFILE environment variable, mysql Options, Environment Variables

MYSQL_HOME environment variable, Environment Variables

MYSQL_HOST environment variable, Connecting to the MySQL Server, Environment Variables

mysql_info(), ALTER TABLE Syntax, INSERT Syntax, LOAD DATA INFILE Syntax, UPDATE Syntax, mysql_info()

mysql_init(), mysql_init()

mysql_insert_id(), Transactions and Atomic Operations, INSERT Syntax, mysql_insert_id()

mysql_install_db, Overview of the Server-Side Scripts and Utilities

mysql_install_db script, Problems Running mysql_install_db

mysql_kill(), mysql_kill()

mysql_library_end(), mysql_library_end()

mysql_library_init(), mysql_library_init()

mysql_list_dbs(), mysql_list_dbs()

mysql_list_fields(), mysql_list_fields()

mysql_list_processes(), mysql_list_processes()

mysql_list_tables(), mysql_list_tables()

mysql_more_results()., mysql_more_results()

mysql_next_result()., mysql_next_result()

mysql_num_fields(), mysql_num_fields()

mysql_num_rows(), mysql_num_rows()

mysql_options(), mysql_options()

mysql_ping(), mysql_ping()

MYSQL_PS1 environment variable, Environment Variables

MYSQL_PWD environment variable, Connecting to the MySQL Server, Overview of Client and Utility Programs, Environment Variables

mysql_query(), mysql_query(), Common questions and problems when using the C API

mysql_real_connect(), mysql_real_connect()

mysql_real_escape_string(), Strings, mysql_real_escape_string()

mysql_real_query(), mysql_real_query()

mysql_refresh(), mysql_refresh()

mysql_reload(), mysql_reload()

MYSQL_RES C type, C API Data types

mysql_rollback()., mysql_rollback()

MYSQL_ROW C type, C API Data types

mysql_row_seek(), mysql_row_seek()

mysql_row_tell(), mysql_row_tell()

mysql_select_db(), mysql_select_db()

mysql_server_end(), mysql_server_end()

mysql_server_init(), mysql_server_init()

mysql_set_character_set(), mysql_set_character_set()

mysql_set_server_option(), mysql_set_server_option()

mysql_shutdown(), mysql_shutdown()

mysql_sqlstate(), mysql_sqlstate()

mysql_ssl_set(), mysql_ssl_set()

mysql_stat(), mysql_stat()

MYSQL_STMT C type, C API Prepared Statement Data types

mysql_stmt_affected_rows(), mysql_stmt_affected_rows()

mysql_stmt_attr_get(), mysql_stmt_attr_get()

mysql_stmt_attr_set(), mysql_stmt_attr_set()

mysql_stmt_bind_param(), mysql_stmt_bind_param()

mysql_stmt_bind_result(), mysql_stmt_bind_result()

mysql_stmt_close(), mysql_stmt_close()

mysql_stmt_data_seek(), mysql_stmt_data_seek()

mysql_stmt_errno(), mysql_stmt_errno()

mysql_stmt_error()., mysql_stmt_error()

mysql_stmt_execute(), mysql_stmt_execute()

mysql_stmt_fetch(), mysql_stmt_fetch()

mysql_stmt_fetch_column(), mysql_stmt_fetch_column()

mysql_stmt_field_count(), mysql_stmt_field_count()

mysql_stmt_free_result(), mysql_stmt_free_result()

mysql_stmt_init(), mysql_stmt_init()

mysql_stmt_insert_id(), mysql_stmt_insert_id()

mysql_stmt_num_rows(), mysql_stmt_num_rows()

mysql_stmt_param_count(), mysql_stmt_param_count()

mysql_stmt_param_metadata(), mysql_stmt_param_metadata()

mysql_stmt_prepare(), mysql_stmt_prepare()

mysql_stmt_reset(), mysql_stmt_reset()

mysql_stmt_result_metadata., mysql_stmt_result_metadata()

mysql_stmt_row_seek(), mysql_stmt_row_seek()

mysql_stmt_row_tell(), mysql_stmt_row_tell()

mysql_stmt_send_long_data()., mysql_stmt_send_long_data()

mysql_stmt_sqlstate(), mysql_stmt_sqlstate()

mysql_stmt_store_result(), mysql_stmt_store_result()

mysql_store_result(), mysql_store_result(), Common questions and problems when using the C API

MYSQL_TCP_PORT environment variable, Running Multiple Servers on Unix, Using Client Programs in a Multiple-Server Environment, Overview of Client and Utility Programs, Environment Variables

mysql_thread_end(), mysql_thread_end()

mysql_thread_id(), mysql_thread_id()

mysql_thread_init(), mysql_thread_init()

mysql_thread_safe(), mysql_thread_safe()

MYSQL_UNIX_PORT environment variable, Problems Running mysql_install_db, Running Multiple Servers on Unix, Using Client Programs in a Multiple-Server Environment, Overview of Client and Utility Programs, Environment Variables

mysql_use_result(), mysql_use_result()

mysql_warning_count()., mysql_warning_count()

mysql_zap, Overview of Client and Utility Programs

my_init(), my_init()

my_ulonglong C type, C API Data types

my_ulonglong values

printing, C API Data types

N

named pipes, Selecting a MySQL Server type, Testing The MySQL Installation

named-commands

mysql option, mysql Options

names, Database, Table, Index, Column, and Alias Names

case sensitivity, Identifier Case Sensitivity
variables, User-Defined Variables

NAME_CONST(), Miscellaneous Functions

naming

releases of MySQL, Choosing Which Version of MySQL to Install

NATIONAL CHAR data type, Overview of String Types

native functions

adding, Adding a New Native Function

native thread support, Operating Systems Supported by MySQL

NATURAL LEFT JOIN, JOIN Syntax

NATURAL LEFT OUTER JOIN, JOIN Syntax

NATURAL RIGHT JOIN, JOIN Syntax

NATURAL RIGHT OUTER JOIN, JOIN Syntax

NCHAR data type, Overview of String Types

negative values, Numbers

nested queries, Subquery Syntax

net etiquette, Guidelines for Using the Mailing Lists

netmask notation

in mysql.user table, Access Control, Stage 1: Connection Verification

NetWare, Installing MySQL on NetWare

net_buffer_length variable, mysql Options

New features in MySQL Cluster, MySQL Cluster Development Roadmap

new procedures

adding, Adding New Procedures to MySQL

new users

adding, Installing MySQL on Other Unix-Like Systems, Source Installation Overview

newline (\n), Strings

no matching rows, Solving Problems with No Matching Rows

no-auto-rehash

mysql option, mysql Options

no-beep

mysql option, mysql Options

no-log

mysqld_multi option, mysqld_multi — Program for Managing Multiple MySQL Servers

no-named-commands

mysql option, mysql Options

no-pager

mysql option, mysql Options

no-tee

mysql option, mysql Options

non-delimited strings, The DATETIME, DATE, and TIMESTAMP Types

Non-transactional tables, Rollback Failure for Non-Transactional Tables

NOT

logical, Logical Operators

NOT BETWEEN, Comparison Functions and Operators

not equal (!=), Comparison Functions and Operators

not equal (<>), Comparison Functions and Operators

NOT IN, Comparison Functions and Operators

NOT LIKE, String Comparison Functions

NOT NULL

constraint, Constraints on Invalid Data

NOT REGEXP, String Comparison Functions

Novell NetWare, Installing MySQL on NetWare

NOW(), Date and Time Functions

NO_AUTO_CREATE_USER SQL mode, The Server SQL Mode

NO_AUTO_VALUE_ON_ZERO SQL mode, The Server SQL Mode

NO_BACKSLASH_ESCAPES SQL mode, The Server SQL Mode

NO_DIR_IN_CREATE SQL mode, The Server SQL Mode

NO_FIELD_OPTIONS SQL mode, The Server SQL Mode

NO_KEY_OPTIONS SQL mode, The Server SQL Mode

NO_TABLE_OPTIONS SQL mode, The Server SQL Mode

NO_UNSIGNED_SUBTRACTION SQL mode, The Server SQL Mode

NO_ZERO_DATE SQL mode, The Server SQL Mode

NO_ZERO_IN_DATE SQL mode, The Server SQL Mode

NUL, Strings

NULL, Working with NULL Values, Problems with NULL Values

ORDER BY, ORDER BY Optimization
testing for null, Comparison Functions and Operators, Control Flow Functions

NULL value, Working with NULL Values, NULL Values

NULL values

and AUTO_INCREMENT columns, Problems with NULL Values
and indexes, CREATE TABLE Syntax
and TIMESTAMP columns, Problems with NULL Values
vs. empty values, Problems with NULL Values

NULLIF(), Control Flow Functions

numbers, Numbers

NUMERIC data type, Overview of Numeric Types

numeric types, Data Type Storage Requirements

NumGeometries(), GeometryCollection Functions

NumInteriorRings(), Polygon Functions

NumPoints(), LineString Functions

O

OCT(), String Functions

OCTET_LENGTH(), String Functions

ODBC, MySQL Connector/ODBC

ODBC compatibility, Identifier Qualifiers, Overview of Numeric Types, Comparison Functions and Operators, CREATE TABLE Syntax, JOIN Syntax

odbcadmin program, Programs Known to Work With MyODBC

OLAP, GROUP BY Modifiers

OLD_PASSWORD(), Encryption Functions

ON DUPLICATE KEY, INSERT Syntax

one-database

mysql option, mysql Options

online location of manual, About This Manual

ONLY_FULL_GROUP_BY SQL mode, The Server SQL Mode

OPEN, Cursor OPEN Statement

Open Source

defined, Overview of the MySQL Database Management System

open tables, How MySQL Opens and Closes Tables, mysqladmin — Client for Administering a MySQL Server

OpenGIS, Introduction to MySQL Spatial Support

opening

tables, How MySQL Opens and Closes Tables

opens, mysqladmin — Client for Administering a MySQL Server

OpenSSL, Using Secure Connections

open_files_limit variable, mysqlbinlog — Utility for Processing Binary Log Files

operating systems

file-size limits, How Large MySQL Tables Can Be
supported, Operating Systems Supported by MySQL
Windows versus Unix, MySQL on Windows Compared to MySQL on Unix

operations

arithmetic, Arithmetic Operators

operators, Functions and Operators

cast, Arithmetic Operators, Cast Functions and Operators
logical, Logical Operators

optimization

tips, Other Optimization Tips

optimizations, WHERE Clause Optimization, Index Merge Optimization

OPTIMIZE TABLE, OPTIMIZE TABLE Syntax

optimizer

controlling, Controlling Query Optimizer Performance

optimizing

DISTINCT, DISTINCT Optimization
filesort, ORDER BY Optimization
GROUP BY, GROUP BY Optimization
LEFT JOIN, LEFT JOIN and RIGHT JOIN Optimization
LIMIT, LIMIT Optimization
tables, Table Optimization

option files, Using Option Files, Causes of Access denied Errors

options

command-line

mysql, mysql Options
mysqladmin, mysqladmin — Client for Administering a MySQL Server

configure, Typical configure Options

embedded server, Options with the Embedded Server

libmysqld, Options with the Embedded Server

myisamchk, General Options for myisamchk

provided by MySQL, Tutorial

replication, Replication Features and Known Problems

OR, Searching on Two Keys, Index Merge Optimization

bitwise, Bit Functions
logical, Logical Operators

OR Index Merge optimization, Index Merge Optimization

Oracle compatibility, MySQL Extensions to Standard SQL, GROUP BY (Aggregate) Functions, DESCRIBE Syntax (Get Information About Columns)

ORACLE SQL mode, The Server SQL Mode

ORD(), String Functions

ORDER BY, Sorting Rows, ALTER TABLE Syntax, SELECT Syntax

aliases in, GROUP BY with Hidden Fields
NULL, ORDER BY Optimization

OUTFILE, SELECT Syntax

Overlaps(), Functions That Test Spatial Relationships Between Geometries

overview, General Information

P

packages

list of, Packages that support MySQL

page-level locking, Locking Methods

pager

mysql option, mysql Options

parameters

server, Tuning Server Parameters

parentheses ( and ), Parentheses

PARTITION, Partitioning

partition management, Partition Management

partitioning, Partitioning

partitioning by hash, HASH Partitioning

partitioning by key, KEY Partitioning

partitioning by linear hash, LINEAR HASH Partitioning

partitioning by linear key, KEY Partitioning

partitioning by list, LIST Partitioning

partitioning by range, RANGE Partitioning

partitioning concepts, Overview of Partitioning in MySQL

partitioning information commands, Obtaining Information About Partitions

partitioning support, Overview of Partitioning in MySQL

partitioning types, Partition Types

partitioning, advantages, Overview of Partitioning in MySQL

partitioning, enabling, Overview of Partitioning in MySQL

partitions, adding and dropping, Partition Management

partitions, analyzing, Maintenance of Partitions

partitions, checking, Maintenance of Partitions

partitions, managing, Partition Management

partitions, modifying, Partition Management

partitions, optimizing, Maintenance of Partitions

partitions, repairing, Maintenance of Partitions

partitions, splitting and merging, Partition Management

password

mysql option, mysql Options
mysqld_multi option, mysqld_multi — Program for Managing Multiple MySQL Servers
root user, Securing the Initial MySQL Accounts

password encryption

reversibility of, Encryption Functions

PASSWORD(), Access Control, Stage 1: Connection Verification, Assigning Account Passwords, Encryption Functions, Ignoring user

passwords

for users, MySQL Usernames and Passwords
forgotten, How to Reset the Root Password
lost, How to Reset the Root Password
resetting, How to Reset the Root Password
security, What the Privilege System Does
setting, Assigning Account Passwords, GRANT and REVOKE Syntax, SET PASSWORD Syntax

PATH environment variable, Installing MySQL on Other Unix-Like Systems, Invoking MySQL Programs, Environment Variables

pattern matching, Pattern Matching

performance

benchmarks, Using Your Own Benchmarks
disk issues, Disk Issues
estimating, Estimating Query Performance
improving, Replication FAQ, Make Your Data as Small as Possible

PERIOD_ADD(), Date and Time Functions

PERIOD_DIFF(), Date and Time Functions

Perl

installing, Perl Installation Notes
installing on Windows, Installing ActiveState Perl on Windows

Perl API, MySQL Perl API

Perl DBI/DBD

installation problems, Problems Using the Perl DBI/DBD Interface

permission checks

effect on speed, Optimizing SELECT and Other Statements

perror, Overview of Client and Utility Programs

PHP API, MySQL PHP API

PI(), Mathematical Functions

PIPES_AS_CONCAT SQL mode, The Server SQL Mode

plugin API, The MySQL Plugin Interface

plugins

adding, The MySQL Plugin Interface
installing, INSTALL PLUGIN Syntax
uninstalling, UNINSTALL PLUGIN Syntax

POINT data type, MySQL Spatial Data Types

point in time recovery, Point-in-Time Recovery

Point(), Creating Geometry Values Using MySQL-Specific Functions

PointFromText(), Creating Geometry Values Using WKT Functions

PointFromWKB(), Creating Geometry Values Using WKB Functions

PointN(), LineString Functions

PointOnSurface(), MultiPolygon Functions

PolyFromText(), Creating Geometry Values Using WKT Functions

PolyFromWKB(), Creating Geometry Values Using WKB Functions

POLYGON data type, MySQL Spatial Data Types

Polygon(), Creating Geometry Values Using MySQL-Specific Functions

PolygonFromText(), Creating Geometry Values Using WKT Functions

PolygonFromWKB(), Creating Geometry Values Using WKB Functions

port

mysql option, mysql Options

portability, Designing Applications for Portability

types, Using Data Types from Other Database Engines

porting

to other systems, Porting to Other Systems

POSITION(), String Functions

post-install

multiple servers, Running Multiple MySQL Servers on the Same Machine

post-installation

setup and testing, Post-Installation Setup and Testing

PostgreSQL compatibility, MySQL Extensions to Standard SQL

POSTGRESQL SQL mode, The Server SQL Mode

POW(), Mathematical Functions

POWER(), Mathematical Functions

precision

arithmetic, Precision Math

precision math, Precision Math

PREPARE, SQL Syntax for Prepared Statements

XA transactions, XA Transaction SQL Syntax

PRIMARY KEY, ALTER TABLE Syntax, CREATE TABLE Syntax

constraint, PRIMARY KEY and UNIQUE Index Constraints

primary key

deleting, ALTER TABLE Syntax

privilege

changes, Access Control, Stage 2: Request Verification

privilege information

location, Privileges Provided by MySQL

privilege system, What the Privilege System Does

described, How the Privilege System Works

privileges

access, The MySQL Access Privilege System
adding, Adding New User Accounts to MySQL
default, Securing the Initial MySQL Accounts
deleting, Removing User Accounts from MySQL, DROP USER Syntax
display, SHOW GRANTS Syntax
dropping, Removing User Accounts from MySQL, DROP USER Syntax
granting, GRANT and REVOKE Syntax
revoking, GRANT and REVOKE Syntax

problems

access denied errors, Access denied
common errors, Problems and Common Errors
compiling, Dealing with Problems Compiling MySQL
DATE columns, Problems Using DATE Columns
date values, The DATETIME, DATE, and TIMESTAMP Types
installing on IBM-AIX, IBM-AIX notes
installing on Solaris, Solaris Notes
installing Perl, Problems Using the Perl DBI/DBD Interface
linking, Problems Linking to the MySQL Client Library
ODBC, How to Report MyODBC Problems or Bugs
reporting, How to Report Bugs or Problems
starting the server, Starting and Troubleshooting the MySQL Server
table locking, Table Locking Issues
time zone, Time Zone Problems

PROCEDURE, SELECT Syntax

procedures

adding, Adding New Procedures to MySQL
stored, Stored Routines and Triggers, Stored Procedures and Functions

process support, Operating Systems Supported by MySQL

processes

display, SHOW PROCESSLIST Syntax

processing

arguments, UDF Argument Processing

PROCESSLIST, SHOW PROCESSLIST Syntax

program variables

setting, Using Options to Set Program Variables

programs

client, Building Client Programs
crash-me, Designing Applications for Portability
list of, Overview of the Server-Side Scripts and Utilities

prompt

mysql option, mysql Options

prompts

meanings, Entering Queries

pronunciation

MySQL, Overview of the MySQL Database Management System

protocol

mysql option, mysql Options

PURGE MASTER LOGS, PURGE MASTER LOGS Syntax

Python API, MySQL Python API

Q

QUARTER(), Date and Time Functions

queries

entering, Entering Queries
estimating performance, Estimating Query Performance
examples, Examples of Common Queries
speed of, Optimizing SELECT and Other Statements
Twin Studies project, Queries from the Twin Project

Query Cache, The MySQL Query Cache

query log, The General Query Log

questions, mysqladmin — Client for Administering a MySQL Server

answering, Guidelines for Using the Mailing Lists

quick

mysql option, mysql Options

QUOTE(), String Functions

quotes

in strings, Strings

quoting, Strings

quoting binary data, Strings

quoting of identifiers, Database, Table, Index, Column, and Alias Names

R

RADIANS(), Mathematical Functions

RAND(), Mathematical Functions

range partitioning, RANGE Partitioning

range partitions, adding and dropping, Management of RANGE and LIST Partitions

range partitions, managing, Management of RANGE and LIST Partitions

raw

mysql option, mysql Options

re-creating

grant tables, Problems Running mysql_install_db

read_buffer_size myisamchk variable, General Options for myisamchk

REAL data type, Overview of Numeric Types

REAL_AS_FLOAT SQL mode, The Server SQL Mode

reconfiguring, Dealing with Problems Compiling MySQL

reconnect

mysql option, mysql Options

RECOVER

XA transactions, XA Transaction SQL Syntax

recovery

from crash, Using myisamchk for Crash Recovery
point in time, Point-in-Time Recovery

reducing

data size, Make Your Data as Small as Possible

references, ALTER TABLE Syntax

ref_or_null, IS NULL Optimization

regex, MySQL Regular Expressions

REGEXP, String Comparison Functions

regular expression syntax

described, MySQL Regular Expressions

relational databases

defined, Overview of the MySQL Database Management System

release numbers, Choosing Which MySQL Distribution to Install

RELEASE SAVEPOINT, SAVEPOINT and ROLLBACK TO SAVEPOINT Syntax

releases

naming scheme, Choosing Which Version of MySQL to Install
testing, Choosing Which Version of MySQL to Install
updating, How and When Updates Are Released

RELEASE_LOCK(), Miscellaneous Functions

RENAME TABLE, RENAME TABLE Syntax

RENAME USER, RENAME USER Syntax

renaming user accounts, RENAME USER Syntax

reordering

columns, How to Change the Order of Columns in a Table

repair options

myisamchk, Repair Options for myisamchk

REPAIR TABLE, REPAIR TABLE Syntax

repairing

tables, How to Repair Tables

REPEAT, REPEAT Statement

REPEAT(), String Functions

replace, Overview of Client and Utility Programs

REPLACE, REPLACE Syntax

REPLACE ... SELECT, INSERT Syntax

REPLACE(), String Functions

replication, Replication in MySQL

replication limitations, Replication Features and Known Problems

replication masters

commands, SQL Statements for Controlling Master Servers

replication options, Replication Features and Known Problems

replication slaves

commands, SQL Statements for Controlling Slave Servers

reporting

bugs, How to Report Bugs or Problems
Connector/ODBC problems, How to Report MyODBC Problems or Bugs
errors, General Information, How to Report Bugs or Problems
MyODBC problems, How to Report MyODBC Problems or Bugs

REQUIRE GRANT option, SSL GRANT Options, GRANT and REVOKE Syntax

reserved words

exceptions, Treatment of Reserved Words in MySQL

RESET MASTER, RESET MASTER Syntax

RESET SLAVE, RESET SLAVE Syntax

restarting

the server, Unix Post-Installation Procedures

RESTORE TABLE, RESTORE TABLE Syntax

restrictions

server-side cursors, Restrictions on Server-Side Cursors
stored routines, Restrictions on Stored Routines and Triggers
subqueries, Restrictions on Subqueries
triggers, Restrictions on Stored Routines and Triggers
views, Restrictions on Views

retrieving

data from tables, Retrieving Information from a Table

return (\r), Strings

return values

UDFs, UDF Return Values and Error Handling

REVERSE(), String Functions

REVOKE, GRANT and REVOKE Syntax

revoking

privileges, GRANT and REVOKE Syntax

RIGHT JOIN, JOIN Syntax

RIGHT OUTER JOIN, JOIN Syntax

RIGHT(), String Functions

RLIKE, String Comparison Functions

ROLLBACK, Transactions and Atomic Operations, START TRANSACTION, COMMIT, and ROLLBACK Syntax

XA transactions, XA Transaction SQL Syntax

ROLLBACK TO SAVEPOINT, SAVEPOINT and ROLLBACK TO SAVEPOINT Syntax

ROLLUP, GROUP BY Modifiers

root password, Securing the Initial MySQL Accounts

root user

password resetting, How to Reset the Root Password

ROUND(), Mathematical Functions

rounding, Precision Math

rounding errors, Overview of Numeric Types

ROUTINES

INFORMATION_SCHEMA table, The INFORMATION_SCHEMA ROUTINES Table

row-level locking, Locking Methods

rows

counting, Counting Rows
deleting, Deleting Rows from Related Tables
locking, Transactions and Atomic Operations
matching problems, Solving Problems with No Matching Rows
selecting, Selecting Particular Rows
sorting, Sorting Rows

ROW_COUNT(), Information Functions

RPAD(), String Functions

RPM file, Installing MySQL on Linux

RPM Package Manager, Installing MySQL on Linux

RTRIM(), String Functions

RTS-threads, Comments about RTS Threads

running

ANSI mode, Running MySQL in ANSI Mode
batch mode, Using mysql in Batch Mode
multiple servers, Running Multiple MySQL Servers on the Same Machine
queries, Entering Queries

running configure after prior invocation, Dealing with Problems Compiling MySQL

S

safe-updates

mysql option, mysql Options

safe-updates option, Using the --safe-updates Option

Sakila, History of MySQL

SAVEPOINT, SAVEPOINT and ROLLBACK TO SAVEPOINT Syntax

scale

arithmetic, Precision Math

schema

altering, ALTER DATABASE Syntax
creating, CREATE DATABASE Syntax
deleting, DROP DATABASE Syntax

SCHEMA(), Information Functions

SCHEMATA

INFORMATION_SCHEMA table, The INFORMATION_SCHEMA SCHEMATA Table

SCHEMA_PRIVILEGES

INFORMATION_SCHEMA table, The INFORMATION_SCHEMA SCHEMA_PRIVILEGES Table

script files, Using mysql in Batch Mode

scripts

mysqlbug, How to Report Bugs or Problems
mysql_install_db, Problems Running mysql_install_db

searching

and case sensitivity, Case Sensitivity in Searches
full-text, Full-Text Search Functions
MySQL Web pages, How to Report Bugs or Problems
two keys, Searching on Two Keys

SECOND(), Date and Time Functions

secure-auth

mysql option, mysql Options

security

against attackers, Making MySQL Secure Against Attackers

security system, The MySQL Access Privilege System

SEC_TO_TIME(), Date and Time Functions

SELECT

LIMIT, SELECT Syntax
optimizing, Optimizing Queries with EXPLAIN
Query Cache, The MySQL Query Cache

SELECT INTO, SELECT … INTO Statement

SELECT INTO TABLE, SELECT INTO TABLE

SELECT speed, Speed of SELECT Queries

selecting

databases, Creating and Selecting a Database

select_limit variable, mysql Options

SEQUENCE, Using AUTO_INCREMENT

sequence emulation, Information Functions

sequences, Using AUTO_INCREMENT

server

connecting, Connecting to and Disconnecting from the Server, Connecting to the MySQL Server
debugging, Debugging a MySQL Server
disconnecting, Connecting to and Disconnecting from the Server
restart, Unix Post-Installation Procedures
shutdown, Unix Post-Installation Procedures
starting, Unix Post-Installation Procedures
starting and stopping, Starting and Stopping MySQL Automatically
starting problems, Starting and Troubleshooting the MySQL Server

server variables, Server System Variables, System Variables, SHOW VARIABLES Syntax

server-side cursor restrictions, Restrictions on Server-Side Cursors

servers

multiple, Running Multiple MySQL Servers on the Same Machine

SESSION_USER(), Information Functions

SET, SET Syntax, Variable SET Statement

AUTOCOMMIT, SET Syntax
BIG_TABLES, SET Syntax
CHARACTER SET, Connection Character Sets and Collations, SET Syntax
FOREIGN_KEY_CHECKS, SET Syntax
IDENTITY, SET Syntax
INSERT_ID, SET Syntax
LAST_INSERT_ID, SET Syntax
NAMES, Connection Character Sets and Collations, SET Syntax
ONE_SHOT, SET Syntax
size, Data Type Storage Requirements
SQL_AUTO_IS_NULL, SET Syntax
SQL_BIG_SELECTS, SET Syntax
SQL_BUFFER_SELECT, SET Syntax
SQL_LOG_BIN, SET Syntax
SQL_LOG_OFF, SET Syntax
SQL_LOG_UPDATE, SET Syntax
SQL_NOTES, SET Syntax
SQL_QUOTE_SHOW_CREATE, SET Syntax
SQL_SAFE_UPDATES, SET Syntax
SQL_SELECT_LIMIT, SET Syntax
SQL_WARNINGS, SET Syntax
TIMESTAMP, SET Syntax
UNIQUE_CHECKS, SET Syntax

SET data type, Overview of String Types, The SET Type

SET GLOBAL SQL_SLAVE_SKIP_COUNTER, SET GLOBAL SQL_SLAVE_SKIP_COUNTER Syntax

SET OPTION, SET Syntax

SET PASSWORD, SET PASSWORD Syntax

SET PASSWORD statement, Assigning Account Passwords

SET SQL_LOG_BIN, SET SQL_LOG_BIN Syntax

SET TRANSACTION, SET TRANSACTION Syntax

setting

passwords, Assigning Account Passwords

setting passwords, SET PASSWORD Syntax

setting program variables, Using Options to Set Program Variables

setup

post-installation, Post-Installation Setup and Testing

SHA(), Encryption Functions

SHA1(), Encryption Functions

shell syntax, Conventions Used in This Manual

SHOW BINARY LOGS, SHOW MASTER LOGS Syntax

SHOW BINLOG EVENTS, SHOW Syntax, SHOW BINLOG EVENTS Syntax

SHOW CHARACTER SET, SHOW CHARACTER SET Syntax

SHOW COLLATION, SHOW COLLATION Syntax

SHOW COLUMNS, SHOW Syntax, SHOW COLUMNS Syntax

SHOW CREATE DATABASE, SHOW Syntax, SHOW CREATE DATABASE Syntax

SHOW CREATE FUNCTION, SHOW CREATE PROCEDURE and SHOW CREATE FUNCTION

SHOW CREATE PROCEDURE, SHOW CREATE PROCEDURE and SHOW CREATE FUNCTION

SHOW CREATE SCHEMA, SHOW Syntax, SHOW CREATE DATABASE Syntax

SHOW CREATE TABLE, SHOW Syntax, SHOW CREATE TABLE Syntax

SHOW CREATE VIEW, SHOW CREATE VIEW Syntax

SHOW DATABASES, SHOW Syntax, SHOW DATABASES Syntax

SHOW ENGINE, SHOW Syntax, SHOW ENGINE Syntax

SHOW ENGINES, SHOW Syntax, SHOW ENGINES Syntax

SHOW ERRORS, SHOW Syntax, SHOW ERRORS Syntax

SHOW extensions, Extensions to SHOW Statements

SHOW FIELDS, SHOW Syntax

SHOW FUNCTION STATUS, SHOW PROCEDURE STATUS and SHOW FUNCTION STATUS

SHOW GRANTS, SHOW Syntax, SHOW GRANTS Syntax

SHOW INDEX, SHOW Syntax, SHOW INDEX Syntax

SHOW INNODB STATUS, SHOW Syntax

SHOW KEYS, SHOW Syntax, SHOW INDEX Syntax

SHOW MASTER LOGS, SHOW Syntax, SHOW MASTER LOGS Syntax

SHOW MASTER STATUS, SHOW Syntax, SHOW MASTER STATUS Syntax

SHOW OPEN TABLES, SHOW Syntax, SHOW OPEN TABLES Syntax

SHOW PRIVILEGES, SHOW Syntax, SHOW PRIVILEGES Syntax

SHOW PROCEDURE STATUS, SHOW PROCEDURE STATUS and SHOW FUNCTION STATUS

SHOW PROCESSLIST, SHOW Syntax, SHOW PROCESSLIST Syntax

SHOW SCHEMAS, SHOW Syntax, SHOW DATABASES Syntax

SHOW SLAVE HOSTS, SHOW Syntax, SHOW SLAVE HOSTS Syntax

SHOW SLAVE STATUS, SHOW Syntax, SHOW SLAVE STATUS Syntax

SHOW STATUS, SHOW Syntax

SHOW STORAGE ENGINES, SHOW ENGINES Syntax

SHOW TABLE STATUS, SHOW Syntax

SHOW TABLE TYPES, SHOW Syntax, SHOW ENGINES Syntax

SHOW TABLES, SHOW Syntax, SHOW TABLES Syntax

SHOW TRIGGERS, SHOW Syntax, SHOW TRIGGERS Syntax

SHOW VARIABLES, SHOW Syntax

SHOW WARNINGS, SHOW Syntax, SHOW WARNINGS Syntax

SHOW with WHERE, The INFORMATION_SCHEMA Database, Extensions to SHOW Statements

show-warnings

mysql option, mysql Options

shutdown_timeout variable, mysqladmin — Client for Administering a MySQL Server

shutting down

the server, Unix Post-Installation Procedures

sigint-ignore

mysql option, mysql Options

SIGN(), Mathematical Functions

silent

mysql option, mysql Options
mysqld_multi option, mysqld_multi — Program for Managing Multiple MySQL Servers

silent column changes, Silent Column Specification Changes

SIN(), Mathematical Functions

single quote (\'), Strings

size of tables, How Large MySQL Tables Can Be

sizes

display, Data Types

skip-column-names

mysql option, mysql Options

skip-line-numbers

mysql option, mysql Options

SLEEP(), Miscellaneous Functions

slow queries, mysqladmin — Client for Administering a MySQL Server

slow query log, The Slow Query Log

SMALLINT data type, Overview of Numeric Types

socket

mysql option, mysql Options

socket location

changing, Typical configure Options

Solaris installation problems, Solaris Notes

Solaris troubleshooting, Dealing with Problems Compiling MySQL

Solaris x86_64 issues, InnoDB Performance Tuning Tips

sorting

character sets, The Character Set Used for Data and Sorting
data, Sorting Rows
grant tables, Access Control, Stage 1: Connection Verification, Access Control, Stage 2: Request Verification
table rows, Sorting Rows

sort_buffer_size myisamchk variable, General Options for myisamchk

sort_key_blocks myisamchk variable, General Options for myisamchk

SOUNDEX(), String Functions

SOUNDS LIKE, String Functions

source distribution

installing, MySQL Installation Using a Source Distribution

source distributions

on Linux, Linux Source Distribution Notes

SPACE(), String Functions

Spatial Extensions in MySQL, Introduction to MySQL Spatial Support

speed

compiling, How Compiling and Linking Affects the Speed of MySQL
increasing with replication, Replication in MySQL
inserting, Speed of INSERT Statements
linking, How Compiling and Linking Affects the Speed of MySQL
of queries, Optimizing SELECT and Other Statements, Speed of SELECT Queries

SQL

defined, Overview of the MySQL Database Management System

SQL commands

replication masters, SQL Statements for Controlling Master Servers
replication slaves, SQL Statements for Controlling Slave Servers

SQL-92

extensions to, MySQL Standards Compliance

SQL_BIG_RESULT, SELECT Syntax

SQL_BUFFER_RESULT, SELECT Syntax

SQL_CACHE, Query Cache SELECT Options, SELECT Syntax

SQL_CALC_FOUND_ROWS, SELECT Syntax

SQL_NO_CACHE, Query Cache SELECT Options, SELECT Syntax

SQL_SMALL_RESULT, SELECT Syntax

sql_yacc.cc problems, Dealing with Problems Compiling MySQL

SQRT(), Mathematical Functions

square brackets, Data Types

SRID(), General Geometry Functions

SSH, Connecting to MySQL Remotely from Windows with SSH

SSL, Using yaSSL

SSL and X509 Basics, Using Secure Connections

SSL command-line options, SSL Command-Line Options

SSL related options, SSL GRANT Options, GRANT and REVOKE Syntax

stability, MySQL Stability

Standard SQL

differences from, MySQL Differences from Standard SQL, GRANT and REVOKE Syntax
extensions to, MySQL Standards Compliance, MySQL Extensions to Standard SQL

standards compatibility, MySQL Standards Compliance

START

XA transactions, XA Transaction SQL Syntax

START SLAVE, START SLAVE Syntax

START TRANSACTION, START TRANSACTION, COMMIT, and ROLLBACK Syntax

starting

comments, '--' as the Start of a Comment
mysqld, How to Run MySQL as a Normal User
the server, Unix Post-Installation Procedures
the server automatically, Starting and Stopping MySQL Automatically

Starting many servers, Running Multiple MySQL Servers on the Same Machine

StartPoint(), LineString Functions

startup options

default, Using Option Files

startup parameters, Tuning Server Parameters

mysql, mysql Options
mysqladmin, mysqladmin — Client for Administering a MySQL Server
tuning, System Factors and Startup Parameter Tuning

statements

GRANT, Adding New User Accounts to MySQL
INSERT, Adding New User Accounts to MySQL

statically

compiling, Typical configure Options

STATISTICS

INFORMATION_SCHEMA table, The INFORMATION_SCHEMA STATISTICS Table

stats_method myisamchk variable, General Options for myisamchk

status

tables, SHOW TABLE STATUS Syntax

status command

results, mysqladmin — Client for Administering a MySQL Server

status variables, Server Status Variables, SHOW STATUS Syntax

STD(), GROUP BY (Aggregate) Functions

STDDEV(), GROUP BY (Aggregate) Functions

STDDEV_POP(), GROUP BY (Aggregate) Functions

STDDEV_SAMP(), GROUP BY (Aggregate) Functions

STOP SLAVE, STOP SLAVE Syntax

stopping

the server, Starting and Stopping MySQL Automatically

stopword list

user-defined, Fine-Tuning MySQL Full-Text Search

storage engine

ARCHIVE, The ARCHIVE Storage Engine

storage engines

choosing, Storage Engines and Table Types

storage of data, Design Choices

storage requirements

data type, Data Type Storage Requirements

storage space

minimizing, Make Your Data as Small as Possible

stored procedures, Stored Procedures and Functions

stored procedures and triggers

defined, Stored Routines and Triggers

stored routine restrictions, Restrictions on Stored Routines and Triggers

STRAIGHT_JOIN, SELECT Syntax, JOIN Syntax

STRCMP(), String Comparison Functions

STRICT SQL mode, The Server SQL Mode

STRICT_ALL_TABLES SQL mode, The Server SQL Mode

STRICT_TRANS_TABLES SQL mode, The Server SQL Mode

string collating, String Collating Support

string comparison functions, String Comparison Functions

string comparisons

case sensitivity, String Comparison Functions

string functions, String Functions

string literal introducer, Strings, Character String Literal Character Set and Collation

string types, String Types

strings

defined, Literal Values
escaping characters, Literal Values
non-delimited, The DATETIME, DATE, and TIMESTAMP Types

striping

defined, Disk Issues

STR_TO_DATE(), Date and Time Functions

SUBDATE(), Date and Time Functions

subpartitioning, Subpartitioning

subpartitions, Subpartitioning

subqueries, Subquery Syntax

subquery, Subquery Syntax

subquery restrictions, Restrictions on Subqueries

subselects, Subquery Syntax

SUBSTR(), String Functions

SUBSTRING(), String Functions

SUBSTRING_INDEX(), String Functions

SUBTIME(), Date and Time Functions

subtraction (-), Arithmetic Operators

SUM(), GROUP BY (Aggregate) Functions

SUM(DISTINCT), GROUP BY (Aggregate) Functions

superuser, Securing the Initial MySQL Accounts

support

for operating systems, Operating Systems Supported by MySQL

suppression

default values, Constraints on Invalid Data

Sybase compatibility, USE Syntax

symbolic links, Using Symbolic Links, Using Symbolic Links for Databases on Windows

SymDifference(), Spatial Operators

syntax

regular expression, MySQL Regular Expressions

SYSDATE(), Date and Time Functions

system

privilege, What the Privilege System Does
security, General Security Issues

system optimization, System Factors and Startup Parameter Tuning

system table, Optimizing Queries with EXPLAIN

system variables, Server System Variables, System Variables, SHOW VARIABLES Syntax

SYSTEM_USER(), Information Functions

T

tab (\t), Strings

table

changing, ALTER TABLE Syntax, Problems with ALTER TABLE
deleting, DROP TABLE Syntax
mysql option, mysql Options

table aliases, SELECT Syntax

table cache, How MySQL Opens and Closes Tables

table is full, SET Syntax, The table is full

table names

case sensitivity, Identifier Case Sensitivity
case-sensitivity, MySQL Extensions to Standard SQL

Table scans

avoiding, How to Avoid Table Scans

table types

choosing, Storage Engines and Table Types

table-level locking, Locking Methods

tables

ARCHIVE, The ARCHIVE Storage Engine
BDB, The BDB (BerkeleyDB) Storage Engine
Berkeley DB, The BDB (BerkeleyDB) Storage Engine
BLACKHOLE, The BLACKHOLE Storage Engine
changing column order, How to Change the Order of Columns in a Table
checking, Check Options for myisamchk
closing, How MySQL Opens and Closes Tables
compressed format, Compressed Table Characteristics
constant, Optimizing Queries with EXPLAIN, WHERE Clause Optimization
copying, CREATE TABLE Syntax
counting rows, Counting Rows
creating, Creating a Table
CSV, The CSV Storage Engine
defragment, Setting Up a Table Maintenance Schedule, Dynamic Table Characteristics
defragmenting, OPTIMIZE TABLE Syntax
deleting rows, Deleting Rows from Related Tables
displaying status, SHOW TABLE STATUS Syntax
dynamic, Dynamic Table Characteristics
error checking, How to Check MyISAM Tables for Errors
EXAMPLE, The EXAMPLE Storage Engine
FEDERATED, The FEDERATED Storage Engine
flush, mysqladmin — Client for Administering a MySQL Server
fragmentation, OPTIMIZE TABLE Syntax
grant, Access Control, Stage 2: Request Verification
HEAP, The MEMORY (HEAP) Storage Engine
host, Access Control, Stage 2: Request Verification
improving performance, Make Your Data as Small as Possible
information, Getting Information About a Table
information about, Getting Information About Databases and Tables
InnoDB, The InnoDB Storage Engine
loading data, Loading Data into a Table
maintenance regimen, Setting Up a Table Maintenance Schedule
maximum size, How Large MySQL Tables Can Be
MEMORY, The MEMORY (HEAP) Storage Engine
MERGE, The MERGE Storage Engine
merging, The MERGE Storage Engine
multiple, Using More Than one Table
MyISAM, The MyISAM Storage Engine
names, Database, Table, Index, Column, and Alias Names
open, How MySQL Opens and Closes Tables
opening, How MySQL Opens and Closes Tables
optimizing, Table Optimization
partitioning, The MERGE Storage Engine
repairing, How to Repair Tables
retrieving data, Retrieving Information from a Table
selecting columns, Selecting Particular Columns
selecting rows, Selecting Particular Rows
sorting rows, Sorting Rows
symbolic links, Using Symbolic Links for Tables on Unix
system, Optimizing Queries with EXPLAIN
too many, Drawbacks to Creating Many Tables in the Same Database
unique ID for last row, How to Get the Unique ID for the Last Inserted Row
updating, Transactions and Atomic Operations

TABLES

INFORMATION_SCHEMA table, The INFORMATION_SCHEMA TABLES Table

table_open_cache, How MySQL Opens and Closes Tables

TABLE_PRIVILEGES

INFORMATION_SCHEMA table, The INFORMATION_SCHEMA TABLE_PRIVILEGES Table

TAN(), Mathematical Functions

tar

problems on Solaris, Solaris Notes

Tcl API, MySQL Tcl API

tcp-ip

mysqld_multi option, mysqld_multi — Program for Managing Multiple MySQL Servers

TCP/IP, Selecting a MySQL Server type, Testing The MySQL Installation

tee

mysql option, mysql Options

temporary file

write access, Problems Running mysql_install_db

temporary tables

problems, TEMPORARY TABLE Problems

terminal monitor

defined, Tutorial

testing

connection to the server, Access Control, Stage 1: Connection Verification
installation, Unix Post-Installation Procedures
of MySQL releases, Choosing Which Version of MySQL to Install
post-installation, Post-Installation Setup and Testing

testing mysqld

mysqltest, MySQL Test Suite

TEXT

size, Data Type Storage Requirements

TEXT columns

default values, The BLOB and TEXT Types
indexing, Column Indexes, CREATE TABLE Syntax

TEXT data type, Overview of String Types, The BLOB and TEXT Types

thread packages

differences between, Differences Between Thread Packages

thread support, Operating Systems Supported by MySQL

non-native, MIT-pthreads Notes

threaded clients, How to Make a Threaded Client

threads, mysqladmin — Client for Administering a MySQL Server, SHOW PROCESSLIST Syntax, MySQL Internals

display, SHOW PROCESSLIST Syntax
RTS, Comments about RTS Threads

TIME data type, Overview of Date and Time Types, The TIME Type

time types, Data Type Storage Requirements

time zone problems, Time Zone Problems

TIME(), Date and Time Functions

TIMEDIFF(), Date and Time Functions

timeout, Server System Variables, Miscellaneous Functions, INSERT DELAYED Syntax

connect_timeout variable, mysql Options, mysqladmin — Client for Administering a MySQL Server
shutdown_timeout variable, mysqladmin — Client for Administering a MySQL Server

TIMESTAMP

and NULL values, Problems with NULL Values

TIMESTAMP data type, Overview of Date and Time Types, The DATETIME, DATE, and TIMESTAMP Types

TIMESTAMP(), Date and Time Functions

TIMESTAMPADD(), Date and Time Functions

TIMESTAMPDIFF(), Date and Time Functions

TIME_FORMAT(), Date and Time Functions

TIME_TO_SEC(), Date and Time Functions

TINYBLOB data type, Overview of String Types

TINYINT data type, Overview of Numeric Types

TINYTEXT data type, Overview of String Types

tips

optimization, Other Optimization Tips

TMPDIR environment variable, Problems Running mysql_install_db, Environment Variables

TODO

embedded server, Things left to do in Embedded Server (TODO)
symlinks, Using Symbolic Links for Tables on Unix

tools

list of, Tools that were used to create MySQL

Touches(), Functions That Test Spatial Relationships Between Geometries

TO_DAYS(), Date and Time Functions

trace DBI method, Debugging mysqld under gdb

TRADITIONAL SQL mode, The Server SQL Mode

transaction-safe tables, Transactions and Atomic Operations, InnoDB Overview

transactions

support, Transactions and Atomic Operations, InnoDB Overview

Translators

list of, Documenters and translators

trigger restrictions, Restrictions on Stored Routines and Triggers

trigger, creating, CREATE TRIGGER Syntax

trigger, dropping, DROP TRIGGER Syntax

triggers, Stored Routines and Triggers, SHOW TRIGGERS Syntax, Triggers

TRIGGERS

INFORMATION_SCHEMA table, The INFORMATION_SCHEMA TRIGGERS Table

TRIM(), String Functions

troubleshooting

FreeBSD, Dealing with Problems Compiling MySQL
Solaris, Dealing with Problems Compiling MySQL

TRUE, Numbers, Boolean Values

testing for, Comparison Functions and Operators

TRUNCATE, TRUNCATE Syntax

TRUNCATE(), Mathematical Functions

tutorial, Tutorial

Twin Studies

queries, Queries from the Twin Project

type conversions, Comparison Functions and Operators

types

columns, Data Types, Choosing the Right Type for a Column
data, Data Types
date, Data Type Storage Requirements
Date and Time, Date and Time Types
numeric, Data Type Storage Requirements
of tables, Storage Engines and Table Types
portability, Using Data Types from Other Database Engines
strings, String Types
time, Data Type Storage Requirements

typographical conventions, Conventions Used in This Manual

TZ environment variable, Time Zone Problems, Environment Variables

U

UCASE(), String Functions

UCS-2, Character Set Support

UDFs, CREATE FUNCTION Syntax, DROP FUNCTION Syntax

compiling, Compiling and Installing User-Defined Functions
defined, Adding New Functions to MySQL
return values, UDF Return Values and Error Handling

ulimit, File Not Found

UMASK environment variable, Problems with File Permissions, Environment Variables

UMASK_DIR environment variable, Problems with File Permissions, Environment Variables

unary minus (-), Arithmetic Operators

unbuffered

mysql option, mysql Options

UNCOMPRESS(), String Functions

UNCOMPRESSED_LENGTH(), String Functions

UNHEX(), String Functions

Unicode, Character Set Support

Unicode Collation Algorithm, Unicode Character Sets

UNINSTALL PLUGIN, UNINSTALL PLUGIN Syntax

uninstalling plugins, UNINSTALL PLUGIN Syntax

UNION, Searching on Two Keys, UNION Syntax

Union(), Spatial Operators

UNIQUE, ALTER TABLE Syntax

constraint, PRIMARY KEY and UNIQUE Index Constraints

unique ID, How to Get the Unique ID for the Last Inserted Row

UNIX_TIMESTAMP(), Date and Time Functions

UNKNOWN

testing for, Comparison Functions and Operators

unloading

tables, Retrieving Information from a Table

UNLOCK TABLES, LOCK TABLES and UNLOCK TABLES Syntax

unnamed views, Subqueries in the FROM clause

UNTIL, REPEAT Statement

UPDATE, UPDATE Syntax

UpdateXML(), XML Functions

updating

releases of MySQL, How and When Updates Are Released
tables, Transactions and Atomic Operations

upgrading, Upgrading MySQL

different architecture, Copying MySQL Databases to Another Machine
grant tables, Upgrading the Grant Tables
to 5.1, Upgrading from MySQL 5.0

UPPER(), String Functions

uptime, mysqladmin — Client for Administering a MySQL Server

URLs for downloading MySQL, How to Get MySQL

USE, USE Syntax

USE INDEX, SELECT Syntax, JOIN Syntax

USE KEY, SELECT Syntax, JOIN Syntax

user

mysql option, mysql Options
mysqld_multi option, mysqld_multi — Program for Managing Multiple MySQL Servers

user accounts

creating, CREATE USER Syntax
renaming, RENAME USER Syntax

USER environment variable, Connecting to the MySQL Server, Environment Variables

user privileges

adding, Adding New User Accounts to MySQL
deleting, Removing User Accounts from MySQL, DROP USER Syntax
dropping, Removing User Accounts from MySQL, DROP USER Syntax

user table

sorting, Access Control, Stage 1: Connection Verification

user variables, User-Defined Variables

USER(), Information Functions

user-defined functions

adding, Adding New Functions to MySQL, Adding a New User-Defined Function

User-defined functions, CREATE FUNCTION Syntax, DROP FUNCTION Syntax

usernames

and passwords, MySQL Usernames and Passwords

users

adding, Installing MySQL on Other Unix-Like Systems, Source Installation Overview
deleting, Removing User Accounts from MySQL, DROP USER Syntax
root, Securing the Initial MySQL Accounts

USER_PRIVILEGES

INFORMATION_SCHEMA table, The INFORMATION_SCHEMA USER_PRIVILEGES Table

uses

of MySQL, What We Have Used MySQL For

using multiple disks to start data, Using Symbolic Links for Databases on Windows

UTC_DATE(), Date and Time Functions

UTC_TIME(), Date and Time Functions

UTC_TIMESTAMP(), Date and Time Functions

UTF-8, Character Set Support

UUID(), Miscellaneous Functions

V

valid numbers

examples, Numbers

VALUES(), Miscellaneous Functions

VARBINARY data type, Overview of String Types, The BINARY and VARBINARY Types

VARCHAR

size, Data Type Storage Requirements

VARCHAR data type, Overview of String Types, String Types

VARCHARACTER data type, Overview of String Types

variables

mysqld, Tuning Server Parameters
server, Server System Variables, SHOW VARIABLES Syntax
status, Server Status Variables, SHOW STATUS Syntax
system, Server System Variables, SHOW VARIABLES Syntax
System, System Variables
user, User-Defined Variables
values, Server System Variables

VARIANCE(), GROUP BY (Aggregate) Functions

VAR_POP(), GROUP BY (Aggregate) Functions

VAR_SAMP(), GROUP BY (Aggregate) Functions

verbose

mysql option, mysql Options
mysqld_multi option, mysqld_multi — Program for Managing Multiple MySQL Servers

version

choosing, Choosing Which MySQL Distribution to Install
latest, How to Get MySQL
mysql option, mysql Options
mysqld_multi option, mysqld_multi — Program for Managing Multiple MySQL Servers

VERSION(), Information Functions

vertical

mysql option, mysql Options

view restrictions, Restrictions on Views

views, Views, Views, CREATE VIEW Syntax

updatable, Views, CREATE VIEW Syntax

VIEWS

INFORMATION_SCHEMA table, The INFORMATION_SCHEMA VIEWS Table

virtual memory

problems while compiling, Dealing with Problems Compiling MySQL

Visual Basic, Programs Known to Work With MyODBC

W

wait

mysql option, mysql Options

WEEK(), Date and Time Functions

WEEKDAY(), Date and Time Functions

WEEKOFYEAR(), Date and Time Functions

Well-Known Binary format, Well-Known Binary (WKB) Format

Well-Known Text format, Well-Known Text (WKT) Format

What is an X509/Certificate?, Basic SSL Concepts

What is encryption, Basic SSL Concepts

WHERE, WHERE Clause Optimization

with SHOW, The INFORMATION_SCHEMA Database, Extensions to SHOW Statements

WHILE, WHILE Statement

widths

display, Data Types

Wildcard character (%), Strings

Wildcard character (_), Strings

wildcards

and LIKE, How MySQL Uses Indexes
in mysql.columns_priv table, Access Control, Stage 2: Request Verification
in mysql.db table, Access Control, Stage 2: Request Verification
in mysql.host table, Access Control, Stage 2: Request Verification
in mysql.tables_priv table, Access Control, Stage 2: Request Verification
in mysql.user table, Access Control, Stage 1: Connection Verification

Windows, MySQL Connector/ODBC

compiling on, Compiling MySQL Clients on Windows
open issues, MySQL on Windows Compared to MySQL on Unix
upgrading, Upgrading MySQL on Windows
versus Unix, MySQL on Windows Compared to MySQL on Unix

with-big-tables option, Typical configure Options

Within(), Functions That Test Spatial Relationships Between Geometries

without-server option, Typical configure Options

WKB format, Well-Known Binary (WKB) Format

WKT format, Well-Known Text (WKT) Format

Word program, Programs Known to Work With MyODBC

wrappers

Eiffel, MySQL Eiffel Wrapper

write access

tmp, Problems Running mysql_install_db

write_buffer_size myisamchk variable, General Options for myisamchk

X

X(), Point Functions

XA BEGIN, XA Transaction SQL Syntax

XA COMMIT, XA Transaction SQL Syntax

XA PREPARE, XA Transaction SQL Syntax

XA RECOVER, XA Transaction SQL Syntax

XA ROLLBACK, XA Transaction SQL Syntax

XA START, XA Transaction SQL Syntax

XA transactions, XA Transactions

transaction identifiers, XA Transaction SQL Syntax

xid

XA transaction identifier, XA Transaction SQL Syntax

xml

mysql option, mysql Options

XOR

bitwise, Bit Functions
logical, Logical Operators

Y

Y(), Point Functions
yaSSL, Using Secure Connections, Using yaSSL
Year 2000 compliance, Year 2000 Compliance
Year 2000 issues, Y2K Issues and Date Types
YEAR data type, Overview of Date and Time Types, The YEAR Type
YEAR(), Date and Time Functions
YEARWEEK(), Date and Time Functions