Index

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, 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 Answering Questions on the Mailing List
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, 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, Column 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, Column 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
Cluster, MySQL Cluster Change History
log, MySQL Change History
MySQL 5.0, Changes in release 5.0.x (Production)
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, 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 Column Types from Other Database Engines
selecting, Selecting Particular Columns
storage requirements, Column Type Storage Requirements
types, Column 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, Options
command-line options, mysqld Command-Line Options
mysql, Options
mysqladmin, mysqladmin — Client for Administering a MySQL Server
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 Version 4.1 to 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
compress
mysql option, Options
COMPRESS(), String Functions
compressed tables, Compressed Table Characteristics
CONCAT(), String Functions
CONCAT_WS(), String Functions
concurrent inserts, 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, Options, mysqladmin — Client for Administering a MySQL Server
constant table, EXPLAIN Syntax (Get Information About a SELECT), How MySQL Optimizes WHERE Clauses
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/DROP 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
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
customer support
mailing address, How to Report Bugs or Problems
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 Column Types from Other Database Engines
BOOLEAN, Overview of Numeric Types, Using Column 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, Column Types
C API, MySQL C API
overview, Column Type Overview
database
altering, ALTER DATABASE Syntax
creating, CREATE DATABASE Syntax
deleting, DROP DATABASE Syntax
mysql option, Options
database design, Design Choices
Database information
obtaining, SHOW Syntax
database metadata, The INFORMATION_SCHEMA Information 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, Column 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, Options
debug-info
mysql option, 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, Column 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, 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, CREATE 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, Column 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, Column Types
display triggers, SHOW TRIGGERS Syntax
display width, Column 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, How MySQL Optimizes DISTINCT, 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, CREATE 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, The 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, Column 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, Options
LD_RUN_PATH, Linux Source Distribution Notes, Solaris Notes
MYSQL_DEBUG, Overview of the Client-Side Scripts and Utilities
MYSQL_HISTFILE, Options
MYSQL_HOST, Connecting to the MySQL Server
MYSQL_PWD, Connecting to the MySQL Server, Overview of the Client-Side Scripts and Utilities
MYSQL_TCP_PORT, Running Multiple Servers on Unix, Using Client Programs in a Multiple-Server Environment, Overview of the Client-Side Scripts and Utilities
MYSQL_UNIX_PORT, Running Multiple Servers on Unix, Using Client Programs in a Multiple-Server Environment, Overview of the Client-Side Scripts and Utilities
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_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 the Client-Side Scripts and Utilities
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, MySQL Mailing Lists, 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, Options
EXECUTE, SQL Syntax for Prepared Statements
EXP(), Mathematical Functions
EXPLAIN, EXPLAIN Syntax (Get Information About a SELECT)
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

F

FALSE, Numbers
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 Big 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, How MySQL Optimizes ORDER BY
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, 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
deleting, CREATE FUNCTION/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/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
GeomCollFromText(), Creating Geometry Values Using WKT Functions
GeomCollFromWKB(), Creating Geometry Values Using WKB Functions
geometry, Introduction
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
getting MySQL, How to Get MySQL
GET_FORMAT(), Date and Time Functions
GET_LOCK(), Miscellaneous Functions
GIS, Spatial Extensions in MySQL, Introduction
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, Unix Post-Installation Procedures
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, How MySQL Optimizes GROUP BY
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

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, 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 functions, Information Functions
INFORMATION_SCHEMA, The INFORMATION_SCHEMA Information 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
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
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 IRC (Internet Relay Chat)
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 IRC (Internet Relay Chat)
IS boolean_value, Comparison Functions and Operators
IS NOT boolean_value, Comparison Functions and Operators
IS NOT NULL, Comparison Functions and Operators
IS NULL, How MySQL Optimizes IS NULL, 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

K

Key cache
MyISAM, The MyISAM Key Cache
key cache
assigning indexes to, CACHE INDEX Syntax
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, How MySQL Optimizes LEFT JOIN and RIGHT JOIN, 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, How MySQL Optimizes LIMIT, 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 Big MySQL Tables Can Be
MySQL Limits, limits in MySQL, Limits in MySQL
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
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, 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 address
for customer support, How to Report Bugs or Problems
mailing list address, General Information
mailing lists, The MySQL Mailing Lists
archive location, Asking Questions or Reporting Bugs
guidelines, Guidelines for Answering Questions on the Mailing List
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, Options
MAX_CONNECTIONS_PER_HOUR, Limiting Account Resources
max_join_size variable, 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 Information 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, Column 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
myisampack, Overview of the Client-Side Scripts and Utilities, Silent Column Specification Changes, 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 the Client-Side Scripts and Utilities
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, Options
mysql commands
list of, mysql Commands
MySQL Dolphin name, History of MySQL
MySQL history, History of MySQL
mysql history file, 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 the Client-Side Scripts and Utilities
mysqladmin, Overview of the Client-Side Scripts and Utilities, 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 the Client-Side Scripts and Utilities
mysqlbug, Overview of the Server-Side Scripts and Utilities
mysqlbug script, How to Report Bugs or Problems
location, General Information
mysqlcheck, Overview of the Client-Side Scripts and Utilities
mysqlclient library, APIs and Libraries
mysqld, Overview of the Server-Side Scripts and Utilities
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, mysqld Command-Line 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 the Client-Side Scripts and Utilities
mysqld_multi, Overview of the Server-Side Scripts and Utilities
mysqld_safe, Overview of the Server-Side Scripts and Utilities
mysqlhotcopy, Overview of the Client-Side Scripts and Utilities
mysqlimport, Copying MySQL Databases to Another Machine, Overview of the Client-Side Scripts and Utilities, LOAD DATA INFILE Syntax
mysqlshow, Overview of the Client-Side Scripts and Utilities
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 the Client-Side Scripts and Utilities, 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, Options, 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 the Client-Side Scripts and Utilities, 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 the Client-Side Scripts and Utilities, 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 the Client-Side Scripts and Utilities, Environment Variables
mysql_use_result(), mysql_use_result()
mysql_warning_count()., mysql_warning_count()
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, Options
names, Database, Table, Index, Column, and Alias Names
case sensitivity, Identifier Case Sensitivity
variables, User 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, Asking Questions or Reporting Bugs, Guidelines for Answering Questions on the Mailing List
netmask notation
in mysql.user table, Access Control, Stage 1: Connection Verification
NetWare, Installing MySQL on NetWare
net_buffer_length variable, 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, Options
no-beep
mysql option, Options
no-log
mysqld_multi option, mysqld_multi — Program for Managing Multiple MySQL Servers
no-named-commands
mysql option, Options
no-pager
mysql option, Options
no-tee
mysql option, 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
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, Column 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, 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 Counts Open Tables, mysqladmin — Client for Administering a MySQL Server
OpenGIS, Introduction
opening
tables, How MySQL Opens and Closes Tables
opens, mysqladmin — Client for Administering a MySQL Server
OpenSSL, Using Secure Connections, Using yaSSL
open_files_limit variable, mysqlbinlog — Utility for Processing Binary Log Files
operating systems
file-size limits, How Big 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, How MySQL Optimizes WHERE Clauses, Index Merge Optimization
OPTIMIZE TABLE, OPTIMIZE TABLE Syntax
optimizer
controlling, Controlling Query Optimizer Performance
optimizing
DISTINCT, How MySQL Optimizes DISTINCT
filesort, How MySQL Optimizes ORDER BY
GROUP BY, How MySQL Optimizes GROUP BY
LEFT JOIN, How MySQL Optimizes LEFT JOIN and RIGHT JOIN
LIMIT, How MySQL Optimizes LIMIT
tables, Table Optimization
option files, Using Option Files, Causes of Access denied Errors
options
command-line, mysqld Command-Line Options
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
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, Options
parameters
server, Tuning Server Parameters
parentheses ( and ), Parentheses
password
mysql option, 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 Statements and Other Queries
perror, Overview of the Client-Side Scripts and Utilities
PHP API, MySQL PHP API
PI(), Mathematical Functions
PIPES_AS_CONCAT SQL mode, The Server SQL Mode
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, Options
portability, Designing Applications for Portability
types, Using Column 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 Procedures 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, Options
prompts
meanings, Entering Queries
pronunciation
MySQL, Overview of the MySQL Database Management System
protocol
mysql option, Options
PURGE MASTER LOGS, PURGE MASTER LOGS Syntax
Python API, MySQL Python API

R

RADIANS(), Mathematical Functions
RAND(), Mathematical Functions
raw
mysql option, Options
re-creating
grant tables, Unix Post-Installation Procedures
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, 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, How MySQL Optimizes IS NULL
regex, MySQL Regular Expressions
REGEXP, String Comparison Functions
regular expression syntax
described, MySQL Regular Expressions
Related(), Functions That Test Spatial Relationships Between Geometries
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 the Client-Side Scripts and Utilities
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, MySQL Mailing Lists
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, 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, Asking Questions or Reporting Bugs
two keys, Searching on Two Keys
SECOND(), Date and Time Functions
secure-auth
mysql option, 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, EXPLAIN Syntax (Get Information About a SELECT)
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, 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
size, Column Type Storage Requirements
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 Information Database, Extensions to SHOW Statements
show-warnings
mysql option, Options
shutdown_timeout variable, mysqladmin — Client for Administering a MySQL Server
shutting down
the server, Unix Post-Installation Procedures
sigint-ignore
mysql option, Options
SIGN(), Mathematical Functions
silent
mysql option, 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 Big MySQL Tables Can Be
sizes
display, Column Types
skip-column-names
mysql option, Options
skip-line-numbers
mysql option, 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, 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
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 Statements and Other Queries, 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, Column Types
SRID(), General Geometry Functions
SSH, Connecting to MySQL Remotely from Windows with SSH
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
extensions to, MySQL Standards Compliance
Standard SQL
differences from, GRANT and REVOKE Syntax
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, 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
column type, Column Type Storage Requirements
storage space
minimising, Make Your Data as Small as Possible
stored procedures, Stored Procedures and Functions
stored procedures and triggers
defined, Stored Procedures 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
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
mailing address, How to Report Bugs or Problems
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, EXPLAIN Syntax (Get Information About a SELECT)
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, 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, EXPLAIN Syntax (Get Information About a SELECT), How MySQL Optimizes WHERE Clauses
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 Big 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 Counts Open 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, EXPLAIN Syntax (Get Information About a SELECT)
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_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
technical support
mailing address, How to Report Bugs or Problems
tee
mysql option, 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, Column 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, Column 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, 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 Procedures 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
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, Column Types, Choosing the Right Type for a Column
data, Column Types
date, Column Type Storage Requirements
Date and Time, Date and Time Types
numeric, Column Type Storage Requirements
of tables, Storage Engines and Table Types
portability, Using Column Types from Other Database Engines
strings, String Types
time, Column 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/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, Options
UNCOMPRESS(), String Functions
UNCOMPRESSED_LENGTH(), String Functions
UNHEX(), String Functions
Unicode, Character Set Support
Unicode Collation Algorithm, Unicode Character Sets
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
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.0, Upgrading from Version 4.1 to 5.0
upgrading tables
ISAM, Upgrading from Version 4.1 to 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, 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 Variables
USER(), Information Functions
user-defined functions
adding, Adding New Functions to MySQL, Adding a New User-Defined Function
User-defined functions, CREATE FUNCTION/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
UTF8, Character Set Support
UUID(), Miscellaneous Functions

W

wait
mysql option, 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, How MySQL Optimizes WHERE Clauses
with SHOW, The INFORMATION_SCHEMA Information Database, Extensions to SHOW Statements
WHILE, WHILE Statement
widths
display, Column 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, Options
XOR
bitwise, Bit Functions
logical, Logical Operators