Index - MySQL 5.0参考手册英文版

Index
Prev聽	聽	聽

Index

Symbols

! (logical NOT), Logical Operators
!= (not equal), Comparison Functions and Operators
", Database, Table, Index, Column, and Alias Names
%, Arithmetic Operators
% (modulo), Mathematical Functions
% (wildcard character), Strings
& (bitwise AND), Bit Functions
&& (logical AND), Logical Operators
() (parentheses), Operator Precedence
(Control-Z) \Z, Strings
* (multiplication), Arithmetic Operators
+ (addition), Arithmetic Operators
- (subtraction), Arithmetic Operators
- (unary minus), Arithmetic Operators
--password option, Keeping Your Password Secure
-p option, Keeping Your Password Secure
.my.cnf file, Using Option Files, Connecting to the MySQL Server, Causes of Access denied Errors, Keeping Your Password Secure, Using Client Programs in a Multiple-Server Environment
.mysql_history file, mysql Options
.pid (process ID) file, Setting Up a Table Maintenance Schedule
/ (division), Arithmetic Operators
/etc/passwd, Making MySQL Secure Against Attackers, SELECT Syntax
:= (assignment), User-Defined Variables
< (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
= (assignment), User-Defined Variables
= (equal), Comparison Functions and Operators
> (greater than), Comparison Functions and Operators
>= (greater than or equal), Comparison Functions and Operators
>> (right shift), Bit Functions
[API] (MySQL Cluster), SQL Node and API Node Configuration Parameters
[MGM] (MySQL Cluster), Management Node Configuration Parameters
[NDBD] (MySQL Cluster), Data Node Configuration Parameters
[NDBD_DEFAULT] (MySQL Cluster), Data Node Configuration Parameters
[NDB_MGMD] (MySQL Cluster), Management Node Configuration Parameters
[SQL] (MySQL Cluster), SQL Node and API Node Configuration Parameters
\" (double quote), Strings
\' (single quote), Strings
\. (mysql client command), Using mysql in Batch Mode, Executing SQL Statements from a Text File
\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
_rowid, CREATE TABLE Syntax
`, Database, Table, Index, Column, and Alias Names
| (bitwise OR), Bit Functions
|| (logical OR), Logical Operators
~, Bit Functions

A

abort-slave-event-count option

mysqld, Command Options

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

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

Active Server Pages (ASP), Using Connector/ODBC with Active Server Pages (ASP)

ActiveState Perl, Installing ActiveState Perl on Windows

add-drop-database option

mysqldump, mysqldump 鈥� A Database Backup Program

add-drop-table option

mysqldump, mysqldump 鈥� A Database Backup Program

add-locks option

mysqldump, mysqldump 鈥� A Database Backup Program

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

addtodest option

mysqlhotcopy, mysqlhotcopy 鈥� A Database Backup Program

AES_DECRYPT(), Encryption and Compression Functions

AES_ENCRYPT(), Encryption and Compression Functions

age

calculating, Date Calculations

alias, Problems with Column Aliases

alias names

case sensitivity, Identifier Case Sensitivity

aliases

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

ALL, SELECT Syntax, Subqueries with ALL

all-databases option

mysqlcheck, mysqlcheck 鈥� A Table Maintenance and Repair Program
mysqldump, mysqldump 鈥� A Database Backup Program

all-in-1 option

mysqlcheck, mysqlcheck 鈥� A Table Maintenance and Repair Program

allow-keywords option

mysqldump, mysqldump 鈥� A Database Backup Program

allow-suspicious-udfs option

mysqld, Command Options, Security-Related mysqld Options

allowold option

mysqlhotcopy, mysqlhotcopy 鈥� A Database Backup Program

ALLOW_INVALID_DATES SQL mode, SQL Modes

ALTER COLUMN, ALTER TABLE Syntax

ALTER DATABASE, ALTER DATABASE Syntax

ALTER FUNCTION, ALTER PROCEDURE and ALTER FUNCTION Syntax

ALTER PROCEDURE, ALTER PROCEDURE and ALTER FUNCTION Syntax

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 option

myisamchk, Other myisamchk Options
mysqlcheck, mysqlcheck 鈥� A Table Maintenance and Repair Program

ANALYZE TABLE, ANALYZE TABLE Syntax

AND

bitwise, Bit Functions
logical, Logical Operators

angel-pid-file option

mysqlmanager, MySQL Instance Manager Command Options

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 option

mysqld, Command Options

ANSI SQL mode, SQL Modes

ANSI_QUOTES SQL mode, SQL Modes

answering questions

etiquette, Guidelines for Using the Mailing Lists

ANY, Subqueries with ANY, IN, and SOME

Apache, Using MySQL with Apache

API node (MySQL Cluster)

defined, Basic MySQL Cluster Concepts

API nodes, MySQL Server Process Usage for MySQL Cluster

API's

list of, Packages that support MySQL

APIs, APIs and Libraries

Perl, MySQL Perl API

approximate-value literals, Precision Math

ArbitrationDelay, Defining the Management Server, Defining SQL and Other API Nodes

ArbitrationRank, Defining the Management Server, Defining SQL and Other API Nodes

ArbitrationTimeout (MySQL Cluster configuration parameter), Defining Data Nodes

arbitrator, MySQL 5.0 FAQ 鈥� MySQL Cluster

ARCHIVE storage engine, 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, Obtaining Auto-Increment Values

auto-rehash option

mysql, mysql Options

auto-repair option

mysqlcheck, mysqlcheck 鈥� A Table Maintenance and Repair Program

autoclose option

mysqld_safe, mysqld_safe 鈥� MySQL Server Startup Script

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 option

myisamchk, myisamchk Repair Options
myisampack, myisampack 鈥� Generate Compressed, Read-Only MyISAM Tables

BACKUP TABLE, BACKUP TABLE Syntax

BackupDataBufferSize, Configuration for Cluster Backup

BackupDataBufferSize (MySQL Cluster configuration parameter), Defining Data Nodes

BackupDataDir, Defining Data Nodes

BackupLogBufferSize, Defining Data Nodes, Configuration for Cluster Backup

BackupMaxWriteSize, Defining Data Nodes, Configuration for Cluster Backup

BackupMemory, Defining Data Nodes, Configuration for Cluster Backup

backups, Database Backups

database, BACKUP TABLE Syntax
in MySQL Cluster, On-line Backup of MySQL Cluster, Cluster Backup Concepts, Using The Management Client to Create a Backup, Configuration for Cluster Backup

backups, troubleshooting

in MySQL Cluster, Backup Troubleshooting

BackupWriteSize, Defining Data Nodes, Configuration for Cluster Backup

basedir option

mysqld, Command Options
mysqld_safe, mysqld_safe 鈥� MySQL Server Startup Script
mysql_upgrade, mysql_upgrade 鈥� Check Tables for MySQL Upgrade

batch mode, Using mysql in Batch Mode

batch option

mysql, mysql Options

BatchByteSize, Defining SQL and Other API Nodes

BatchSize, Defining SQL and Other API Nodes

BatchSizePerLocalScan, Defining Data Nodes

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

BDB tables, Transactions and Atomic Operations

bdb-home option

mysqld, BDB Startup Options

bdb-lock-detect option

mysqld, BDB Startup Options

bdb-logdir option

mysqld, BDB Startup Options

bdb-no-recover option

mysqld, BDB Startup Options

bdb-no-sync option

mysqld, BDB Startup Options

bdb-shared-data option

mysqld, BDB Startup Options

bdb-tmpdir option

mysqld, BDB Startup Options

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 Syntax

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

BETWEEN ... AND, Comparison Functions and Operators

big5, MySQL 5.0 FAQ 鈥� MySQL Chinese, Japanese, and Korean Character Sets

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

bind-address option

mysqld, Command Options
mysqlmanager, MySQL Instance Manager Command Options

binlog-do-db option

mysqld, The Binary Log

binlog-ignore-db option

mysqld, 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

BLOB

inserting binary data, Strings
size, Data Type Storage Requirements

BLOB columns

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

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

block-search option

myisamchk, Other myisamchk Options

BOOL data type, Overview of Numeric Types

BOOLEAN data type, Overview of Numeric Types

bootstrap option

mysqld, Command Options

Borland Builder 4, Using Connector/ODBC with Borland Builder 4

Borland C++ compiler, Building MySQL from Source Using Borland C++

Boundary(), General Geometry Functions

brackets

square, Data Types

brief option

mysqlaccess, mysqlaccess 鈥� Client for Checking Access Privileges

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, Using Connector/ODBC with C++ Builder

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 Syntax

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 access checking, How the Privilege System Works
in identifiers, Identifier Case Sensitivity
in names, Identifier Case Sensitivity
in searches, Case Sensitivity in Searches
in string comparisons, String Comparison Functions

case-sensitivity

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, Type Conversion in Expression Evaluation, 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, Changes in MySQL Cluster
log, MySQL Change History
MySQL 5.0, Changes in release 5.0.x (Production)
MySQL Community Server, MySQL Community Server Enhancements and Release Notes
MySQL Enterprise, MySQL Enterprise Release Notes

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 Unix Socket File

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-set-client-handshake option

mysqld, Command Options

character-set-filesystem option

mysqld, Command Options

character-set-server option

mysqld, Command Options

character-sets-dir option

myisamchk, myisamchk Repair Options
myisampack, myisampack 鈥� Generate Compressed, Read-Only MyISAM Tables
mysql, mysql Options
mysqladmin, mysqladmin 鈥� Client for Administering a MySQL Server
mysqlbinlog, mysqlbinlog 鈥� Utility for Processing Binary Log Files
mysqlcheck, mysqlcheck 鈥� A Table Maintenance and Repair Program
mysqld, Command Options
mysqldump, mysqldump 鈥� A Database Backup Program
mysqlimport, mysqlimport 鈥� A Data Import Program
mysqlshow, mysqlshow 鈥� Display Database, Table, and Column Information

characters

multi-byte, Multi-Byte Character Support

CHARACTER_LENGTH(), String Functions

CHARACTER_SETS

INFORMATION_SCHEMA table, The INFORMATION_SCHEMA CHARACTER_SETS Table

charset option

comp_err, comp_err 鈥� Compile MySQL Error Message File

CHARSET(), Information Functions

CHAR_LENGTH(), String Functions

check option

myisamchk, myisamchk Check Options
mysqlcheck, mysqlcheck 鈥� A Table Maintenance and Repair Program

check options

myisamchk, myisamchk Check Options

CHECK TABLE, CHECK TABLE Syntax

check-only-changed option

myisamchk, myisamchk Check Options
mysqlcheck, mysqlcheck 鈥� A Table Maintenance and Repair Program

check-upgrade option

mysqlcheck, mysqlcheck 鈥� A Table Maintenance and Repair Program

checking

tables for errors, How to Check MyISAM Tables for Errors

CHECKPOINT Events (MySQL Cluster), Log Events

checkpoint option

mysqlhotcopy, mysqlhotcopy 鈥� A Database Backup Program

Checksum, Cluster TCP/IP Connections

Checksum (MySQL Cluster), Shared-Memory Connections, SCI Transport Connections

checksum errors, Solaris Notes

CHECKSUM TABLE, CHECKSUM TABLE Syntax

Chinese, Case Sensitivity in Searches

Chinese, Japanese, Korean character sets

frequently asked questions, MySQL 5.0 FAQ 鈥� MySQL Chinese, Japanese, and Korean Character Sets

choosing

a MySQL version, Choosing Which MySQL Distribution to Install

choosing types, Choosing the Right Type for a Column

chroot option

mysqld, Command Options
mysqlhotcopy, mysqlhotcopy 鈥� A Database Backup Program

CJK

FAQ, MySQL 5.0 FAQ 鈥� MySQL Chinese, Japanese, and Korean Character Sets

CJK (Chinese, Japanese, Korean)

Access, PHP, etc., MySQL 5.0 FAQ 鈥� MySQL Chinese, Japanese, and Korean Character Sets
availability of specific characters, MySQL 5.0 FAQ 鈥� MySQL Chinese, Japanese, and Korean Character Sets
available character sets, MySQL 5.0 FAQ 鈥� MySQL Chinese, Japanese, and Korean Character Sets
big5, MySQL 5.0 FAQ 鈥� MySQL Chinese, Japanese, and Korean Character Sets
character sets available, MySQL 5.0 FAQ 鈥� MySQL Chinese, Japanese, and Korean Character Sets
characters displayed as question marks, MySQL 5.0 FAQ 鈥� MySQL Chinese, Japanese, and Korean Character Sets
CJKV, MySQL 5.0 FAQ 鈥� MySQL Chinese, Japanese, and Korean Character Sets
collations, MySQL 5.0 FAQ 鈥� MySQL Chinese, Japanese, and Korean Character Sets
conversion problems with Japanese character sets, MySQL 5.0 FAQ 鈥� MySQL Chinese, Japanese, and Korean Character Sets
data truncation, MySQL 5.0 FAQ 鈥� MySQL Chinese, Japanese, and Korean Character Sets
Database and table names, MySQL 5.0 FAQ 鈥� MySQL Chinese, Japanese, and Korean Character Sets
documentation in Chinese, MySQL 5.0 FAQ 鈥� MySQL Chinese, Japanese, and Korean Character Sets
documentation in Japanese, MySQL 5.0 FAQ 鈥� MySQL Chinese, Japanese, and Korean Character Sets
documentation in Korean, MySQL 5.0 FAQ 鈥� MySQL Chinese, Japanese, and Korean Character Sets
gb2312, gbk, MySQL 5.0 FAQ 鈥� MySQL Chinese, Japanese, and Korean Character Sets
Japanese character sets, MySQL 5.0 FAQ 鈥� MySQL Chinese, Japanese, and Korean Character Sets
Korean character set, MySQL 5.0 FAQ 鈥� MySQL Chinese, Japanese, and Korean Character Sets
LIKE and FULLTEXT, MySQL 5.0 FAQ 鈥� MySQL Chinese, Japanese, and Korean Character Sets
MySQL 4.0 behavior, MySQL 5.0 FAQ 鈥� MySQL Chinese, Japanese, and Korean Character Sets
ORDER BY treatment, MySQL 5.0 FAQ 鈥� MySQL Chinese, Japanese, and Korean Character Sets
problems with Access, PHP, etc., MySQL 5.0 FAQ 鈥� MySQL Chinese, Japanese, and Korean Character Sets
problems with Big5 character sets (Chinese), MySQL 5.0 FAQ 鈥� MySQL Chinese, Japanese, and Korean Character Sets
problems with data truncation, MySQL 5.0 FAQ 鈥� MySQL Chinese, Japanese, and Korean Character Sets
problems with euckr character set (Korean), MySQL 5.0 FAQ 鈥� MySQL Chinese, Japanese, and Korean Character Sets
problems with GB character sets (Chinese), MySQL 5.0 FAQ 鈥� MySQL Chinese, Japanese, and Korean Character Sets
problems with LIKE and FULLTEXT, MySQL 5.0 FAQ 鈥� MySQL Chinese, Japanese, and Korean Character Sets
problems with Yen sign (Japanese), MySQL 5.0 FAQ 鈥� MySQL Chinese, Japanese, and Korean Character Sets
rejected characters, MySQL 5.0 FAQ 鈥� MySQL Chinese, Japanese, and Korean Character Sets
sort order problems, MySQL 5.0 FAQ 鈥� MySQL Chinese, Japanese, and Korean Character Sets
sorting problems, MySQL 5.0 FAQ 鈥� MySQL Chinese, Japanese, and Korean Character Sets
testing availability of characters, MySQL 5.0 FAQ 鈥� MySQL Chinese, Japanese, and Korean Character Sets
Unicode collations, MySQL 5.0 FAQ 鈥� MySQL Chinese, Japanese, and Korean Character Sets
Vietnamese, MySQL 5.0 FAQ 鈥� MySQL Chinese, Japanese, and Korean Character Sets
Yen sign, MySQL 5.0 FAQ 鈥� MySQL Chinese, Japanese, and Korean Character Sets

clear option

mysql_tableinfo, mysql_tableinfo 鈥� Generate Database Metadata

clear-only option

mysql_tableinfo, mysql_tableinfo 鈥� Generate Database Metadata

clearing

caches, FLUSH Syntax

client programs, Overview of Client and Utility Programs

building, Building Client Programs

client tools, APIs and Libraries

clients

threaded, How to Make a Threaded Client

CLOSE, Cursor CLOSE Statement

closing

tables, How MySQL Opens and Closes Tables

cluster logs, Event Reports Generated in MySQL Cluster, Logging Management Commands

Clustering, MySQL Cluster

CLUSTERLOG commands (MySQL Cluster), Logging Management Commands

CLUSTERLOG STATISTICS command (MySQL Cluster), Using CLUSTERLOG STATISTICS

CMake, Building MySQL from Source Using CMake and Visual Studio

COALESCE(), Comparison Functions and Operators

COERCIBILITY(), Information Functions

col option

mysql_tableinfo, mysql_tableinfo 鈥� Generate Database Metadata

ColdFusion, Using Connector/ODBC with ColdFusion

collating

strings, String Collating Support

COLLATION(), Information Functions

collation-server option

mysqld, Command Options

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
types, Data Types

column comments, CREATE TABLE Syntax

column names

case sensitivity, Identifier Case Sensitivity

column-names option

mysql, mysql Options

columns

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

COLUMNS

INFORMATION_SCHEMA table, The INFORMATION_SCHEMA COLUMNS Table

columns option

mysqlimport, mysqlimport 鈥� A Data Import Program

COLUMN_PRIVILEGES

INFORMATION_SCHEMA table, The INFORMATION_SCHEMA COLUMN_PRIVILEGES Table

comma-separated values data, reading, LOAD DATA INFILE Syntax, SELECT Syntax

command options

mysql, mysql Options
MySQL Cluster, Command Options for MySQL Cluster Processes, MySQL Cluster-Related Command Options for mysqld, Command Options for ndbd, Command Options for ndb_mgmd, Command Options for ndb_mgm
mysqladmin, mysqladmin 鈥� Client for Administering a MySQL Server
mysqld, Command Options

command syntax, Conventions Used in This Manual

command-line history

mysql, mysql Options

commands

for binary distribution, Installing MySQL on Other Unix-Like Systems

commands out of sync, Commands out of sync

Comment syntax, Comment Syntax

comments

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

comments option

mysqldump, mysqldump 鈥� A Database Backup Program

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

XA transactions, XA Transaction SQL Syntax

commit option

mysqlaccess, mysqlaccess 鈥� Client for Checking Access Privileges

compact option

mysqldump, mysqldump 鈥� A Database Backup Program

comparison operators, Comparison Functions and Operators

compatibility

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

compatible option

mysqldump, mysqldump 鈥� A Database Backup Program

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

complete-insert option

mysqldump, mysqldump 鈥� A Database Backup Program

compliance

Y2K, Year 2000 Issues and Date Types

compress option

mysql, mysql Options
mysqladmin, mysqladmin 鈥� Client for Administering a MySQL Server
mysqlcheck, mysqlcheck 鈥� A Table Maintenance and Repair Program
mysqldump, mysqldump 鈥� A Database Backup Program
mysqlimport, mysqlimport 鈥� A Data Import Program
mysqlshow, mysqlshow 鈥� Display Database, Table, and Column Information

COMPRESS(), Encryption and Compression Functions

compressed tables, Compressed Table Characteristics

comp_err, Overview of Server-Side Programs

charset option, comp_err 鈥� Compile MySQL Error Message File
debug option, comp_err 鈥� Compile MySQL Error Message File
debug-info option, comp_err 鈥� Compile MySQL Error Message File
header_file option, comp_err 鈥� Compile MySQL Error Message File
help option, comp_err 鈥� Compile MySQL Error Message File
in_file option, comp_err 鈥� Compile MySQL Error Message File
name_file option, comp_err 鈥� Compile MySQL Error Message File
out_dir option, comp_err 鈥� Compile MySQL Error Message File
out_file option, comp_err 鈥� Compile MySQL Error Message File
statefile option, comp_err 鈥� Compile MySQL Error Message File
version option, comp_err 鈥� Compile MySQL Error Message File

CONCAT(), String Functions

CONCAT_WS(), String Functions

concurrent inserts, Internal Locking Methods, Concurrent Inserts

Conditions, DECLARE Conditions

config-file option

mysqld_multi, mysqld_multi 鈥� Manage Multiple MySQL Servers
my_print_defaults, my_print_defaults 鈥� Display Options from Option Files
ndb_config, ndb_config 鈥� Extract NDB Configuration Information

config.cache, Dealing with Problems Compiling MySQL

config.cache file, Dealing with Problems Compiling MySQL

config.ini (MySQL Cluster), Multi-Computer Configuration, Configuration File, Basic Example Configuration, ndb_mgmd 鈥� The Management Server Process

configuration

MySQL Cluster, Overview of Cluster Configuration Parameters

configuration files, Causes of Access denied Errors

configuration options, Typical configure Options

configure

disable-grant-options option, Typical configure Options
enable-thread-safe-client option, Typical configure Options
localstatedir option, Typical configure Options
previx option, Typical configure Options
running after prior invocation, Dealing with Problems Compiling MySQL
with-big-tables option, Typical configure Options
with-charset option, Typical configure Options
with-collation option, Typical configure Options
with-debug option, Typical configure Options
with-embedded-server option, Typical configure Options
with-extra-charsets option, Typical configure Options
with-unix-socket-path option, Typical configure Options
without-server option, Typical configure Options

configure option

--with-low-memory, Dealing with Problems Compiling MySQL

configure script, Typical configure Options

configuring backups

in MySQL Cluster, Configuration for Cluster Backup

configuring MySQL Cluster, Simple Multi-Computer How-To, MySQL Cluster Configuration, MySQL Server Process Usage for MySQL Cluster, ndb_mgmd 鈥� The Management Server Process

Configuring MySQL Cluster (concepts), Basic MySQL Cluster Concepts

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 Events (MySQL Cluster), Log Events

CONNECTION_ID(), Information Functions

Connector/JDBC, Connectors

Connector/MXJ, Connectors

Connector/NET, Connectors, MySQL Connector/NET

reporting problems, Connector/NET Support

Connector/ODBC, Connectors, MySQL Connector/ODBC

Borland, Using Connector/ODBC with Borland Applications
Borland Database Engine, Using Connector/ODBC with Borland Applications
reporting problems, Connector/ODBC Support

Connectors

MySQL, Connectors

connectstring, The Cluster Connectstring

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

console option

mysqld, Command Options

constant table, Optimizing Queries with EXPLAIN, WHERE Clause Optimization

constraints, How MySQL Deals with Constraints

CONSTRAINTS

INFORMATION_SCHEMA table, The INFORMATION_SCHEMA TABLE_CONSTRAINTS Table

Contains(), Functions That Test Spatial Relationships Between Geometries

contributing companies

list of, Supporters of MySQL

contributors

list of, Contributors to MySQL

control access, Access Control, Stage 1: Connection Verification

control flow functions, Control Flow Functions

CONV(), String Functions

conventions

typographical, Conventions Used in This Manual

CONVERT, Cast Functions and Operators

CONVERT TO, ALTER TABLE Syntax

CONVERT_TZ(), Date and Time Functions

ConvexHull(), Spatial Operators

copy option

mysqlaccess, mysqlaccess 鈥� Client for Checking Access Privileges

copying databases, Copying MySQL Databases to Another Machine

copying tables, CREATE TABLE Syntax

core-file option

mysqld, Command Options

core-file-size option

mysqld_safe, mysqld_safe 鈥� MySQL Server Startup Script

correct-checksum option

myisamchk, myisamchk Repair Options

correlated subqueries, Correlated Subqueries

COS(), Mathematical Functions

COT(), Mathematical Functions

count option

myisam_ftdump, myisam_ftdump 鈥� Display Full-Text Index information
mysqladmin, mysqladmin 鈥� Client for Administering a MySQL Server
mysqlshow, mysqlshow 鈥� Display Database, Table, and Column Information

COUNT(), GROUP BY (Aggregate) Functions

COUNT(DISTINCT), GROUP BY (Aggregate) Functions

counting

table rows, Counting Rows

crash

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 Syntax, CREATE FUNCTION Syntax

CREATE INDEX, CREATE INDEX Syntax

CREATE PROCEDURE, CREATE PROCEDURE and CREATE FUNCTION Syntax

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

create-options option

mysqldump, mysqldump 鈥� A Database Backup Program

creating

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

creating user accounts, CREATE USER Syntax

CROSS JOIN, JOIN Syntax

Crosses(), Functions That Test Spatial Relationships Between Geometries

CR_SERVER_GONE_ERROR, MySQL server has gone away

CR_SERVER_LOST_ERROR, MySQL server has gone away

CSV data, reading, LOAD DATA INFILE Syntax, SELECT Syntax

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

CURDATE(), Date and Time Functions

CURRENT_DATE, Date and Time Functions

CURRENT_TIME, Date and Time Functions

CURRENT_TIMESTAMP, Date and Time Functions

CURRENT_USER(), Information Functions

Cursors, Cursors

CURTIME(), Date and Time Functions

customers

of MySQL, What We Have Used MySQL For

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

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

D

data

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

data node (MySQL Cluster)

defined, Basic MySQL Cluster Concepts

Data truncation with CJK characters, MySQL 5.0 FAQ 鈥� MySQL Chinese, Japanese, and Korean Character Sets

data type

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

data types, Data Types

C API, MySQL C API
overview, Data Type Overview

data-file-length option

myisamchk, myisamchk Repair Options

database

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

database design, Design Choices

Database information

obtaining, SHOW Syntax

database metadata, The INFORMATION_SCHEMA Database

database names

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

database option

mysql, mysql Options
mysqlbinlog, mysqlbinlog 鈥� Utility for Processing Binary Log Files

DATABASE(), Information Functions

databases

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

databases option

mysqlcheck, mysqlcheck 鈥� A Table Maintenance and Repair Program
mysqldump, mysqldump 鈥� A Database Backup Program

DataDir, Defining the Management Server, Defining Data Nodes

datadir option

mysqld, Command Options
mysqld_safe, mysqld_safe 鈥� MySQL Server Startup Script
mysql_upgrade, mysql_upgrade 鈥� Check Tables for MySQL Upgrade

DataJunction, Using Connector/ODBC with Pervasive Software DataJunction

DataMemory, Defining Data Nodes, Configuring Parameters for Local Checkpoints

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 Issues and Date Types

date option

mysql_explain_log, mysql_explain_log 鈥� Use EXPLAIN on Statements in Query Log

date types, Data Type Storage Requirements

Y2K issues, Year 2000 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 option

mysqlaccess, mysqlaccess 鈥� Client for Checking Access Privileges

db table

sorting, Access Control, Stage 2: Request Verification

DB2 SQL mode, SQL Modes

DBI interface, MySQL Perl API

DBI->quote, Strings

DBI/DBD interface, MySQL Perl API

DBI_TRACE environment variable, Environment Variables

DBI_USER environment variable, Environment Variables

DEALLOCATE PREPARE, SQL Syntax for Prepared Statements

debug option

comp_err, comp_err 鈥� Compile MySQL Error Message File
make_win_bin_dist, make_win_bin_dist 鈥� Package MySQL Distribution as ZIP Archive
myisamchk, myisamchk General Options
myisampack, myisampack 鈥� Generate Compressed, Read-Only MyISAM Tables
mysql, mysql Options
mysqlaccess, mysqlaccess 鈥� Client for Checking Access Privileges
mysqladmin, mysqladmin 鈥� Client for Administering a MySQL Server
mysqlbinlog, mysqlbinlog 鈥� Utility for Processing Binary Log Files
mysqlcheck, mysqlcheck 鈥� A Table Maintenance and Repair Program
mysqld, Command Options
mysqldump, mysqldump 鈥� A Database Backup Program
mysqlhotcopy, mysqlhotcopy 鈥� A Database Backup Program
mysqlimport, mysqlimport 鈥� A Data Import Program
mysqlshow, mysqlshow 鈥� Display Database, Table, and Column Information
my_print_defaults, my_print_defaults 鈥� Display Options from Option Files

debug-info option

comp_err, comp_err 鈥� Compile MySQL Error Message File
mysql, mysql Options

debugging support, Typical configure Options

DEC data type, Overview of Numeric Types

decimal arithmetic, Precision Math

DECIMAL data type, Overview of Numeric Types, Precision Math

decimal point, Data Types

DECLARE, DECLARE Statement Syntax

DECODE(), Encryption and Compression Functions

decode_bits myisamchk variable, myisamchk General Options

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, Data Type Default Values, CREATE TABLE Syntax

default values, MySQL Design Limitations and Tradeoffs, Data Type Default Values, CREATE TABLE Syntax, INSERT Syntax

BLOB and TEXT columns, The BLOB and TEXT Types
explicit, Data Type Default Values
implicit, Data Type Default Values
suppression, Constraints on Invalid Data

DEFAULT(), Miscellaneous Functions

default-character-set option

mysql, mysql Options
mysqladmin, mysqladmin 鈥� Client for Administering a MySQL Server
mysqlcheck, mysqlcheck 鈥� A Table Maintenance and Repair Program
mysqld, Command Options
mysqldump, mysqldump 鈥� A Database Backup Program
mysqlimport, mysqlimport 鈥� A Data Import Program
mysqlshow, mysqlshow 鈥� Display Database, Table, and Column Information

default-collation option

mysqld, Command Options

default-mysqld-path option

mysqlmanager, MySQL Instance Manager Command Options

default-storage-engine option

mysqld, Command Options

default-table-type option

mysqld, Command Options

default-time-zone option

mysqld, Command Options

defaults-extra-file option, Using Option Files

mysqld_safe, mysqld_safe 鈥� MySQL Server Startup Script
my_print_defaults, my_print_defaults 鈥� Display Options from Option Files

defaults-file option, Using Option Files

mysqld_safe, mysqld_safe 鈥� MySQL Server Startup Script
mysqlmanager, MySQL Instance Manager Command Options
my_print_defaults, my_print_defaults 鈥� Display Options from Option Files

defaults-group-suffix option, Using Option Files

my_print_defaults, my_print_defaults 鈥� Display Options from Option Files

DEGREES(), Mathematical Functions

delay-key-write option

mysqld, Command Options, MyISAM Startup Options

DELAYED, INSERT DELAYED Syntax

delayed-insert option

mysqldump, mysqldump 鈥� A Database Backup Program

delayed_insert_limit, INSERT DELAYED Syntax

DELETE, DELETE Syntax

and MySQL Cluster, Known Limitations of MySQL Cluster

delete option

mysqlimport, mysqlimport 鈥� A Data Import Program

delete-master-logs option

mysqldump, mysqldump 鈥� A Database Backup Program

deleting

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

deletion

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

delimiter option

mysql, mysql Options
ndb_select_all, ndb_select_all 鈥� Print Rows from NDB Table

Delphi, Using Connector/ODBC with Delphi

derived tables, Subqueries in the FROM clause

des-key-file option

mysqld, Command Options

DESC, DESCRIBE Syntax

descending option

ndb_select_all, ndb_select_all 鈥� Print Rows from NDB Table

DESCRIBE, Getting Information About Databases and Tables, DESCRIBE Syntax

description option

myisamchk, Other myisamchk Options

design

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

DES_DECRYPT(), Encryption and Compression Functions

DES_ENCRYPT(), Encryption and Compression Functions

developers

list of, Credits

development source tree, Installing from the Development Source Tree

Difference(), Spatial Operators

digits, Data Types

Dimension(), General Geometry Functions

directory structure

default, Installation Layouts

disable-grant-options option

configure, Typical configure Options

disable-keys option

mysqldump, mysqldump 鈥� A Database Backup Program

disable-log-bin option

mysqlbinlog, mysqlbinlog 鈥� Utility for Processing Binary Log Files

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

disconnect-slave-event-count option

mysqld, Command Options

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

Diskless, Defining Data Nodes

disks

splitting data across, Using Symbolic Links for Databases on Windows

display size, Data Types

display triggers, SHOW TRIGGERS Syntax

display width, Data Types

displaying

information

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

table status, SHOW TABLE STATUS Syntax

Distance(), Functions That Test Spatial Relationships Between Geometries

DISTINCT, Selecting Particular Columns, DISTINCT Optimization, SELECT Syntax

AVG(), GROUP BY (Aggregate) Functions
COUNT(), GROUP BY (Aggregate) Functions
MAX(), GROUP BY (Aggregate) Functions
MIN(), GROUP BY (Aggregate) Functions
SUM(), GROUP BY (Aggregate) Functions

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

Documentation

in Chinese, MySQL 5.0 FAQ 鈥� MySQL Chinese, Japanese, and Korean Character Sets
in Japanese, MySQL 5.0 FAQ 鈥� MySQL Chinese, Japanese, and Korean Character Sets
in Korean, MySQL 5.0 FAQ 鈥� MySQL Chinese, Japanese, and Korean Character Sets

Documenters

list of, Documenters and translators

DOUBLE data type, Overview of Numeric Types

DOUBLE PRECISION data type, Overview of Numeric Types

double quote (\"), Strings

downgrades

MySQL Cluster, Upgrading and Downgrading MySQL Cluster, Performing a Rolling Restart of the Cluster, Cluster Upgrade and Downgrade Compatibility

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 Syntax, DROP FUNCTION Syntax

DROP INDEX, ALTER TABLE Syntax, DROP INDEX Syntax

DROP PREPARE, SQL Syntax for Prepared Statements

DROP PRIMARY KEY, ALTER TABLE Syntax

DROP PROCEDURE, DROP PROCEDURE and DROP FUNCTION Syntax

DROP SCHEMA, DROP DATABASE Syntax

DROP TABLE, DROP TABLE Syntax

and MySQL Cluster, Known Limitations of MySQL Cluster

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

dryrun option

mysqlhotcopy, mysqlhotcopy 鈥� A Database Backup Program

DUAL, SELECT Syntax

dump option

myisam_ftdump, myisam_ftdump 鈥� Display Full-Text Index information

DUMPFILE, SELECT Syntax

dynamic table characteristics, Dynamic Table Characteristics

E

Eiffel Wrapper, MySQL Eiffel Wrapper

ELT(), String Functions

email lists, MySQL Mailing Lists

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

embedded option

make_win_bin_dist, make_win_bin_dist 鈥� Package MySQL Distribution as ZIP Archive

enable-named-pipe option

mysqld, Command Options

enable-pstack option

mysqld, Command Options

enable-thread-safe-client option

configure, Typical configure Options

ENCODE(), Encryption and Compression Functions

ENCRYPT(), Encryption and Compression Functions

encryption, Basic SSL Concepts

encryption functions, Encryption and Compression Functions

END, BEGIN ... END Compound Statement Syntax

EndPoint(), LineString Functions

enhancements

MySQL Community Server, MySQL Community Server Enhancements and Release Notes

Enhancements

MySQL Community Server, MySQL Community Server 5.0 Enhancements and Release Notes

ENTER SINGLE USER MODE command (MySQL Cluster), Commands in the MySQL Cluster Management Client

entering

queries, Entering Queries

ENUM

size, Data Type Storage Requirements

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

Envelope(), General Geometry Functions

environment variable

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

Environment variable

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

Environment variables

CXX, Dealing with Problems Compiling MySQL

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

list of, Environment Variables

equal (=), Comparison Functions and Operators

Equals(), Functions That Test Spatial Relationships Between Geometries

ERROR Events (MySQL Cluster), Log Events

error logs (MySQL Cluster), ndbd 鈥� The Storage Engine Node Process

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
in subqueries, Subquery Errors
known, Known Issues in MySQL
linking, Problems Linking to the MySQL Client Library
list of, Common Errors When Using MySQL Programs
reporting, General Information, How to Report Bugs or Problems

ERROR_FOR_DIVISION_BY_ZERO SQL mode, SQL Modes

escape (\\), Strings

escape characters, Literal Values

estimating

query performance, Estimating Query Performance

event log format (MySQL Cluster), Log Events

event logs (MySQL Cluster), Event Reports Generated in MySQL Cluster, Logging Management Commands

event severity levels (MySQL Cluster), Logging Management Commands

event types (MySQL Cluster), Event Reports Generated in MySQL Cluster, Log Events

exact-value literals, Precision Math

example option

mysqld_multi, mysqld_multi 鈥� Manage Multiple MySQL Servers

EXAMPLE storage engine, 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

exe-suffix option

make_win_bin_dist, make_win_bin_dist 鈥� Package MySQL Distribution as ZIP Archive

EXECUTE, SQL Syntax for Prepared Statements

execute option

mysql, mysql Options

EXECUTE statement, SQL Syntax for Prepared Statements

ExecuteOnComputer, Defining the Management Server, Defining Data Nodes, Defining SQL and Other API Nodes

executing SQL statements from text files, Using mysql in Batch Mode, Executing SQL Statements from a Text File

EXISTS

with subqueries, EXISTS and NOT EXISTS

EXIT command (MySQL Cluster), Commands in the MySQL Cluster Management Client

EXIT SINGLE USER MODE command (MySQL Cluster), Commands in the MySQL Cluster Management Client

exit-info option

mysqld, Command Options

EXP(), Mathematical Functions

EXPLAIN, Optimizing Queries with EXPLAIN

explicit default values, Data Type Default Values

EXPORT_SET(), String Functions

expression aliases, GROUP BY and HAVING with Hidden Fields, SELECT Syntax

expressions

extended, Pattern Matching

extend-check option

myisamchk, myisamchk Check Options, myisamchk Repair Options

extended option

mysqlcheck, mysqlcheck 鈥� A Table Maintenance and Repair Program

extended-insert option

mysqldump, mysqldump 鈥� A Database Backup Program

extensions

to standard SQL, MySQL Standards Compliance

ExteriorRing(), Polygon Functions

external locking, Command Options, System Variables, Using myisamchk for Crash Recovery, External Locking, SHOW PROCESSLIST Syntax

external-locking option

mysqld, Command Options

extra-file option

my_print_defaults, my_print_defaults 鈥� Display Options from Option Files

extra-partition-info option

ndb_desc, ndb_desc 鈥� Describe NDB Tables

EXTRACT(), Date and Time Functions

extracting

dates, Date Calculations

F

FALSE, Numbers, Boolean Values

testing for, Comparison Functions and Operators

fast option

myisamchk, myisamchk Check Options
mysqlcheck, mysqlcheck 鈥� A Table Maintenance and Repair Program

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

FETCH, Cursor FETCH Statement

field

changing, ALTER TABLE Syntax

FIELD(), String Functions

fields option

ndb_config, ndb_config 鈥� Extract NDB Configuration Information

fields-enclosed-by option

mysqldump, mysqldump 鈥� A Database Backup Program, mysqlimport 鈥� A Data Import Program

fields-escaped-by option

mysqldump, mysqldump 鈥� A Database Backup Program, mysqlimport 鈥� A Data Import Program

fields-optionally-enclosed-by option

mysqldump, mysqldump 鈥� A Database Backup Program, mysqlimport 鈥� A Data Import Program

fields-terminated-by option

mysqldump, mysqldump 鈥� A Database Backup Program, mysqlimport 鈥� A Data Import Program

FILE, String Functions

files

binary log, The Binary Log
config.cache, Dealing with Problems Compiling MySQL
error messages, Setting the Error Message Language
general query log, The General Query Log
log, Typical configure Options, Server Log Maintenance
my.cnf, Replication Features and Known Problems
not found message, Problems with File Permissions
permissions, Problems with File Permissions
repairing, myisamchk Repair Options
script, Using mysql in Batch Mode
size limits, The table is full
slow query log, The Slow Query Log
text, Executing SQL Statements from a Text File
tmp, Problems Running mysql_install_db
update log (obsolete), The Binary Log

filesort optimization, ORDER BY Optimization

FileSystemPath, Defining Data Nodes

FIND_IN_SET(), String Functions

first-slave option

mysqldump, mysqldump 鈥� A Database Backup Program

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 option

mysqld, Command Options

flush tables, mysqladmin 鈥� Client for Administering a MySQL Server

flush-logs option

mysqldump, mysqldump 鈥� A Database Backup Program

flush-privileges option

mysqldump, mysqldump 鈥� A Database Backup Program

flushlog option

mysqlhotcopy, mysqlhotcopy 鈥� A Database Backup Program

FOR UPDATE, SELECT Syntax

FORCE INDEX, Index Hint Syntax, Optimizer-Related Issues

FORCE KEY, Index Hint Syntax

force option

myisamchk, myisamchk Check Options, myisamchk Repair Options
myisampack, myisampack 鈥� Generate Compressed, Read-Only MyISAM Tables
mysql, mysql Options
mysqladmin, mysqladmin 鈥� Client for Administering a MySQL Server
mysqlcheck, mysqlcheck 鈥� A Table Maintenance and Repair Program
mysqldump, mysqldump 鈥� A Database Backup Program
mysqlimport, mysqlimport 鈥� A Data Import Program
mysql_upgrade, mysql_upgrade 鈥� Check Tables for MySQL Upgrade

force-read option

mysqlbinlog, mysqlbinlog 鈥� Utility for Processing Binary Log Files

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(), String Functions

Forums, MySQL Community Support at the MySQL Forums

FOUND_ROWS(), Information Functions

FreeBSD troubleshooting, Dealing with Problems Compiling MySQL

frequently-asked questions about MySQL Cluster, MySQL 5.0 FAQ 鈥� MySQL Cluster

FROM, SELECT Syntax

FROM_DAYS(), Date and Time Functions

FROM_UNIXTIME(), Date and Time Functions

ft_max_word_len myisamchk variable, myisamchk General Options

ft_min_word_len myisamchk variable, myisamchk General Options

ft_stopword_file myisamchk variable, myisamchk General Options

full disk, How MySQL Handles a Full Disk

full-text search, Full-Text Search Functions

FULLTEXT, Full-Text Search Functions

fulltext

stopword list, Fine-Tuning MySQL Full-Text Search

function

creating, CREATE FUNCTION Syntax
deleting, DROP FUNCTION Syntax

function names

parsing, Function Name Parsing and Resolution
resolving ambiguity, Function Name Parsing and Resolution

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 and Compression Functions

GROUP BY, GROUP BY (Aggregate) Functions

grouping, Operator Precedence

information, Information Functions

mathematical, Mathematical Functions

miscellaneous, Miscellaneous Functions

native

adding, Adding a New Native Function

new, Adding New Functions to MySQL

string, String Functions

string comparison, String Comparison Functions

user-defined, Adding New Functions to MySQL

adding, Adding a New User-Defined Function

Functions

user-defined, CREATE FUNCTION Syntax, DROP FUNCTION Syntax

functions for SELECT and WHERE clauses, Functions and Operators

Future development of MySQL Cluster, MySQL Cluster Development Roadmap

G

gap lock, InnoDB Startup Options and System Variables, InnoDB and TRANSACTION ISOLATION LEVEL, Next-Key Locking: Avoiding the Phantom Problem

gb2312, gbk, MySQL 5.0 FAQ 鈥� MySQL Chinese, Japanese, and Korean Character Sets

gcc, Typical configure Options

gci option

ndb_select_all, ndb_select_all 鈥� Print Rows from NDB Table

gdb option

mysqld, Command Options

general information, General Information

General Public License, What is MySQL?

general query log, The General Query Log

geographic feature, Introduction to MySQL Spatial Support

GeomCollFromText(), Creating Geometry Values Using WKT Functions

GeomCollFromWKB(), Creating Geometry Values Using WKB Functions

geometry, Introduction to MySQL Spatial Support

GEOMETRY data type, MySQL Spatial Data Types

GEOMETRYCOLLECTION data type, MySQL Spatial Data Types

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

GeometryCollectionFromText(), Creating Geometry Values Using WKT Functions

GeometryCollectionFromWKB(), Creating Geometry Values Using WKB Functions

GeometryFromText(), Creating Geometry Values Using WKT Functions

GeometryFromWKB(), Creating Geometry Values Using WKB Functions

GeometryN(), GeometryCollection Functions

GeometryType(), General Geometry Functions

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

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

geospatial feature, Introduction to MySQL Spatial Support

getting MySQL, How to Get MySQL

GET_FORMAT(), Date and Time Functions

GET_LOCK(), Miscellaneous Functions

GIS, Spatial Extensions, Introduction to MySQL Spatial Support

GLength(), LineString Functions, MultiLineString Functions

global privileges, GRANT Syntax, REVOKE Syntax

goals of MySQL, What is MySQL?

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 Syntax

GRANT statement, Adding New User Accounts to MySQL

grant tables, Access Control, Stage 2: Request Verification

re-creating, Problems Running mysql_install_db
sorting, Access Control, Stage 1: Connection Verification, Access Control, Stage 2: Request Verification

granting

privileges, GRANT Syntax

GRANTS, SHOW GRANTS Syntax

greater than (>), Comparison Functions and Operators

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

GREATEST(), Comparison Functions and Operators

GROUP BY, GROUP BY Optimization

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

GROUP BY functions, GROUP BY (Aggregate) Functions

grouping

expressions, Operator Precedence

GROUP_CONCAT(), GROUP BY (Aggregate) Functions

H

HANDLER, HANDLER Syntax

Handlers, DECLARE Handlers

handling

errors, UDF Return Values and Error Handling

HAVING, SELECT Syntax

header option

ndb_select_all, ndb_select_all 鈥� Print Rows from NDB Table

header_file option

comp_err, comp_err 鈥� Compile MySQL Error Message File

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

HeartbeatIntervalDbApi (MySQL Cluster configuration parameter), Defining Data Nodes

HeartbeatIntervalDbDb (MySQL Cluster configuration parameter), Defining Data Nodes

HELP command (MySQL Cluster), Commands in the MySQL Cluster Management Client

help option

comp_err, comp_err 鈥� Compile MySQL Error Message File
myisamchk, myisamchk General Options
myisampack, myisampack 鈥� Generate Compressed, Read-Only MyISAM Tables
myisam_ftdump, myisam_ftdump 鈥� Display Full-Text Index information
mysql, mysql Options
mysqlaccess, mysqlaccess 鈥� Client for Checking Access Privileges
mysqladmin, mysqladmin 鈥� Client for Administering a MySQL Server
mysqlbinlog, mysqlbinlog 鈥� Utility for Processing Binary Log Files
mysqlcheck, mysqlcheck 鈥� A Table Maintenance and Repair Program
mysqld, Command Options
mysqldump, mysqldump 鈥� A Database Backup Program
mysqld_multi, mysqld_multi 鈥� Manage Multiple MySQL Servers
mysqld_safe, mysqld_safe 鈥� MySQL Server Startup Script
mysqlhotcopy, mysqlhotcopy 鈥� A Database Backup Program
mysqlimport, mysqlimport 鈥� A Data Import Program
mysqlmanager, MySQL Instance Manager Command Options
mysqlshow, mysqlshow 鈥� Display Database, Table, and Column Information
mysql_explain_log, mysql_explain_log 鈥� Use EXPLAIN on Statements in Query Log
mysql_find_rows, mysql_find_rows 鈥� Extract Queries from Update Log
mysql_setpermission, mysql_setpermission 鈥� Interactively Set Permissions in Grant Tables
mysql_tableinfo, mysql_tableinfo 鈥� Generate Database Metadata
mysql_upgrade, mysql_upgrade 鈥� Check Tables for MySQL Upgrade
mysql_waitpid, mysql_waitpid 鈥� Kill Process and Wait for Its Termination
my_print_defaults, my_print_defaults 鈥� Display Options from Option Files
perror, perror 鈥� Explain Error Codes
resolveip, resolveip 鈥� Resolve Hostname to IP Address or Vice Versa
resolve_stack_dump, resolve_stack_dump 鈥� Resolve Numeric Stack Trace Dump to Symbols

HELP statement, HELP Syntax

HEX(), String Functions

hex-blob option

mysqldump, mysqldump 鈥� A Database Backup Program

hexadecimal values, Hexadecimal Values

hexdump option

mysqlbinlog, mysqlbinlog 鈥� Utility for Processing Binary Log Files

HIGH_NOT_PRECEDENCE SQL mode, SQL Modes

HIGH_PRIORITY, SELECT Syntax

hints, MySQL Extensions to Standard SQL

index, SELECT Syntax, Index Hint Syntax

history of MySQL, History of MySQL

HOME environment variable, Environment Variables, mysql Options

host option

mysql, mysql Options
mysqlaccess, mysqlaccess 鈥� Client for Checking Access Privileges
mysqladmin, mysqladmin 鈥� Client for Administering a MySQL Server
mysqlbinlog, mysqlbinlog 鈥� Utility for Processing Binary Log Files
mysqlcheck, mysqlcheck 鈥� A Table Maintenance and Repair Program
mysqldump, mysqldump 鈥� A Database Backup Program
mysqlhotcopy, mysqlhotcopy 鈥� A Database Backup Program
mysqlimport, mysqlimport 鈥� A Data Import Program
mysqlshow, mysqlshow 鈥� Display Database, Table, and Column Information
mysql_explain_log, mysql_explain_log 鈥� Use EXPLAIN on Statements in Query Log
mysql_setpermission, mysql_setpermission 鈥� Interactively Set Permissions in Grant Tables
mysql_tableinfo, mysql_tableinfo 鈥� Generate Database Metadata
ndb_config, ndb_config 鈥� Extract NDB Configuration Information

host table, Access Control, Stage 2: Request Verification

sorting, Access Control, Stage 2: Request Verification

Host*SciId* parameters, SCI Transport Connections

host.frm

problems finding, Unix Post-Installation Procedures

hostname

default, Connecting to the MySQL Server

HostName, Defining the Management Server, Defining Data Nodes, Defining SQL and Other API Nodes

hostname caching, How MySQL Uses DNS

HOUR(), Date and Time Functions

howto option

mysqlaccess, mysqlaccess 鈥� Client for Checking Access Privileges

html option

mysql, mysql Options

I

i-am-a-dummy option

mysql, mysql Options

Id, Defining the Management Server, Defining Data Nodes, Defining SQL and Other API Nodes

ID

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

id option

ndb_config, ndb_config 鈥� Extract NDB Configuration Information

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

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

idx option

mysql_tableinfo, mysql_tableinfo 鈥� Generate Database Metadata

IF, IF Statement

IF(), Control Flow Functions

IFNULL(), Control Flow Functions

IGNORE INDEX, Index Hint Syntax

IGNORE KEY, Index Hint Syntax

ignore option

mysqlimport, mysqlimport 鈥� A Data Import Program

ignore-lines option

mysqlimport, mysqlimport 鈥� A Data Import Program

ignore-spaces option

mysql, mysql Options

ignore-table option

mysqldump, mysqldump 鈥� A Database Backup Program

IGNORE_SPACE SQL mode, SQL Modes

implicit default values, Data Type Default Values

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

importing

data, Executing SQL Statements from a Text File

IN, Comparison Functions and Operators, Subqueries with ANY, IN, and SOME

increasing

performance, Replication FAQ

increasing with replication

speed, Replication

index

deleting, ALTER TABLE Syntax, DROP INDEX Syntax

index hints, SELECT Syntax, Index Hint 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, 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

IndexMemory, Defining Data Nodes, Configuring Parameters for Local Checkpoints

INET_ATON(), Miscellaneous Functions

INET_NTOA(), Miscellaneous Functions

INFO Events (MySQL Cluster), Log Events

information functions, Information Functions

information option

myisamchk, myisamchk Check Options

INFORMATION_SCHEMA, The INFORMATION_SCHEMA Database

init-file option

mysqld, Command Options

INNER JOIN, JOIN Syntax

innochecksum, Overview of Client and Utility Programs

InnoDB, InnoDB Overview

NFS, InnoDB Configuration, Restrictions on InnoDB Tables
Solaris 10 x86_64 issues, Solaris Notes

innodb option

mysqld, InnoDB Startup Options and System Variables

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

InnoDB tables, Transactions and Atomic Operations

innodb-safe-binlog option

mysqld, Command Options

innodb_status_file option

mysqld, InnoDB Startup Options and System Variables

INSERT, Speed of INSERT Statements, INSERT Syntax

INSERT ... SELECT, INSERT ... SELECT Syntax

INSERT DELAYED, INSERT DELAYED Syntax

INSERT statement

grant privileges, Adding New User Accounts to MySQL

INSERT(), String Functions

insert-ignore option

mysqldump, mysqldump 鈥� A Database Backup Program

inserting

speed of, Speed of INSERT Statements

inserts

concurrent, Internal Locking Methods, Concurrent Inserts

install option

mysqlmanager, MySQL Instance Manager Command Options

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
MySQL Community Server, Installing MySQL Community Server
MySQL Enterprise, Installing MySQL Enterprise
overview, Installing and Upgrading MySQL, MySQL Installation Overview
Perl, Perl Installation Notes
Perl on Windows, Installing ActiveState Perl on Windows
Solaris PKG packages, Installing MySQL on Solaris
source distribution, MySQL Installation Using a Source Distribution
user-defined functions, Compiling and Installing User-Defined Functions

installing MySQL Cluster, Simple Multi-Computer How-To, Multi-Computer Installation, Installing the Software

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, Internal Locking Methods

internals, MySQL Internals

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

Intersection(), Spatial Operators

Intersects(), Functions That Test Spatial Relationships Between Geometries

INTERVAL(), Comparison Functions and Operators

introducer

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

invalid data

constraint, Constraints on Invalid Data

in_file option

comp_err, comp_err 鈥� Compile MySQL Error Message File

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

IS boolean_value, Comparison Functions and Operators

IS NOT boolean_value, Comparison Functions and Operators

IS NOT NULL, Comparison Functions and Operators

IS NULL, IS NULL Optimization, Comparison Functions and Operators

and indexes, How MySQL Uses Indexes

isamchk, Overview of Client and Utility Programs

isamlog, Overview of Client and Utility Programs

IsClosed(), MultiLineString Functions

IsEmpty(), General Geometry Functions

ISNULL(), Comparison Functions and Operators

ISOLATION LEVEL, SET TRANSACTION Syntax

IsRing(), LineString Functions

IsSimple(), General Geometry Functions

IS_FREE_LOCK(), Miscellaneous Functions

IS_USED_LOCK(), Miscellaneous Functions

ITERATE, ITERATE Statement

J

Japanese character sets

conversion, MySQL 5.0 FAQ 鈥� MySQL Chinese, Japanese, and Korean Character Sets

Japanese, Korean, Chinese character sets

frequently asked questions, MySQL 5.0 FAQ 鈥� MySQL Chinese, Japanese, and Korean Character Sets

JOIN, JOIN Syntax

join option

myisampack, myisampack 鈥� Generate Compressed, Read-Only MyISAM Tables

K

keepold option

mysqlhotcopy, mysqlhotcopy 鈥� A Database Backup Program

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

keys option

mysqlshow, mysqlshow 鈥� Display Database, Table, and Column Information

keys-used option

myisamchk, myisamchk Repair Options

keywords, Reserved Words

key_buffer_size myisamchk variable, myisamchk General Options

KEY_COLUMN_USAGE

INFORMATION_SCHEMA table, The INFORMATION_SCHEMA KEY_COLUMN_USAGE Table

KILL, KILL Syntax

known errors, Known Issues in MySQL

Korean, MySQL 5.0 FAQ 鈥� MySQL Chinese, Japanese, and Korean Character Sets

Korean, Chinese, Japanese character sets

frequently asked questions, MySQL 5.0 FAQ 鈥� MySQL Chinese, Japanese, and Korean Character Sets

L

language option

mysqld, Command Options

language support

error messages, Setting the Error Message Language

large-pages option

mysqld, Command Options

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() and stored routines, Stored Procedures, Functions, Triggers, and LAST_INSERT_ID()

LAST_INSERT_ID() and triggers, Stored Procedures, Functions, Triggers, and LAST_INSERT_ID()

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, Environment Variables, Problems Using the Perl DBI/DBD Interface

LEAST(), Comparison Functions and Operators

LEAVE, LEAVE Statement

ledir option

mysqld_safe, mysqld_safe 鈥� MySQL Server Startup Script

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

LEFT OUTER JOIN, JOIN Syntax

LEFT(), String Functions

leftmost prefix of indexes, How MySQL Uses Indexes

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

length option

myisam_ftdump, myisam_ftdump 鈥� Display Full-Text Index information

LENGTH(), String Functions

less than (<), Comparison Functions and Operators

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

libmysqld, libmysqld, the Embedded MySQL Server Library

libraries

list of, Libraries used by and included with MySQL

library

mysqlclient, APIs and Libraries
mysqld, APIs and Libraries

License, MySQL FLOSS License Exception

LIKE, String Comparison Functions

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

LIMIT, LIMIT Optimization, Information Functions, SELECT Syntax

limitations

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

limitations of MySQL Cluster, Known Limitations of MySQL Cluster

limits

file-size, The table is full
MySQL Limits, limits in MySQL, Limits in MySQL

line-numbers option

mysql, mysql Options

linefeed (\n), Strings

LineFromText(), Creating Geometry Values Using WKT Functions

LineFromWKB(), Creating Geometry Values Using WKB Functions

lines-terminated-by option

mysqldump, mysqldump 鈥� A Database Backup Program, mysqlimport 鈥� A Data Import Program

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 checkpoints (MySQL Cluster), Configuring Parameters for Local Checkpoints

local option

mysqlimport, mysqlimport 鈥� A Data Import Program

local-infile option

mysql, mysql Options
mysqld, Security-Related mysqld Options

local-load option

mysqlbinlog, mysqlbinlog 鈥� Utility for Processing Binary Log Files

localstatedir option

configure, Typical configure Options

LOCALTIME, Date and Time Functions

LOCALTIMESTAMP, Date and Time Functions

LOCATE(), String Functions

LOCK IN SHARE MODE, SELECT Syntax

lock option

ndb_select_all, ndb_select_all 鈥� Print Rows from NDB Table

LOCK TABLES, LOCK TABLES and UNLOCK TABLES Syntax

lock-all-tables option

mysqldump, mysqldump 鈥� A Database Backup Program

lock-tables option

mysqldump, mysqldump 鈥� A Database Backup Program
mysqlimport, mysqlimport 鈥� A Data Import Program

locking, System Factors and Startup Parameter Tuning

external, Command Options, System Variables, Using myisamchk for Crash Recovery, External Locking, SHOW PROCESSLIST Syntax
internal, Internal Locking Methods
page-level, Internal Locking Methods
row-level, Transactions and Atomic Operations, Internal Locking Methods
table-level, Internal Locking Methods

locking methods, Internal Locking Methods

LockPagesInMainMemory, Defining Data Nodes

log

changes, MySQL Change History

log files, Typical configure Options, MySQL Server Logs

maintaining, Server Log Maintenance
names, Database Backups

log files (MySQL Cluster), ndbd 鈥� The Storage Engine Node Process

log option

mysqld, Command Options
mysqld_multi, mysqld_multi 鈥� Manage Multiple MySQL Servers
mysqlmanager, MySQL Instance Manager Command Options

LOG(), Mathematical Functions

log-bin option

mysqld, Command Options

log-bin-index option

mysqld, Command Options

log-bin-trust-function-creators option

mysqld, Command Options

log-bin-trust-routine-creators option

mysqld, Command Options

log-error option

mysqld, Command Options
mysqld_safe, mysqld_safe 鈥� MySQL Server Startup Script

log-isam option

mysqld, Command Options

log-long-format option

mysqld, Command Options

log-queries-not-using-indexes option

mysqld, Command Options

log-short-format option

mysqld, Command Options

log-slave-updates option

mysqld, Replication Startup Options

log-slow-admin-statements option

mysqld, Command Options

log-slow-queries option

mysqld, Command Options

log-tc option

mysqld, Command Options

log-tc-size option

mysqld, Command Options

log-warnings option

mysqld, Command Options, Replication Startup Options

LOG10(), Mathematical Functions

LOG2(), Mathematical Functions

LogDestination, Defining the Management Server

logging commands (MySQL Cluster), Logging Management Commands

logical operators, Logical Operators

LogLevelCheckpoint (MySQL Cluster configuration parameter), Defining Data Nodes

LogLevelConnection (MySQL Cluster configuration parameter), Defining Data Nodes

LogLevelError, Defining Data Nodes

LogLevelInfo, Defining Data Nodes

LogLevelNodeRestart (MySQL Cluster configuration parameter), Defining Data Nodes

LogLevelShutdown (MySQL Cluster configuration parameter), Defining Data Nodes

LogLevelStartup (MySQL Cluster configuration parameter), Defining Data Nodes

LogLevelStatistic (MySQL Cluster configuration parameter), Defining Data Nodes

LONG data type, The BLOB and TEXT Types

LONGBLOB data type, Overview of String Types

LongMessageBuffer, Defining Data Nodes

LONGTEXT data type, Overview of String Types

LOOP, LOOP Statement

loops option

ndb_show_tables, ndb_show_tables 鈥� Display List of NDB Tables

low-priority option

mysqlimport, mysqlimport 鈥� A Data Import Program

low-priority-updates option

mysqld, Command Options

LOWER(), String Functions

LPAD(), String Functions

LTRIM(), String Functions

M

Mac OS X, MySQL Connector/ODBC

installation, Installing MySQL on Mac OS X

mailing list address, General Information

mailing lists, MySQL Mailing Lists

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

main features of MySQL, The Main Features of MySQL

maintaining

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

MAKEDATE(), Date and Time Functions

MAKETIME(), Date and Time Functions

make_binary_distribution, Overview of Server-Side Programs

MAKE_SET(), String Functions

make_win_bin_dist, Overview of Server-Side Programs

debug option, make_win_bin_dist 鈥� Package MySQL Distribution as ZIP Archive
embedded option, make_win_bin_dist 鈥� Package MySQL Distribution as ZIP Archive
exe-suffix option, make_win_bin_dist 鈥� Package MySQL Distribution as ZIP Archive
no-debug option, make_win_bin_dist 鈥� Package MySQL Distribution as ZIP Archive
no-embedded option, make_win_bin_dist 鈥� Package MySQL Distribution as ZIP Archive
only-debug option, make_win_bin_dist 鈥� Package MySQL Distribution as ZIP Archive

make_win_src_distribution, Creating a Windows Source Package from the Latest Development Source, Overview of Server-Side Programs

management node (MySQL Cluster)

defined, Basic MySQL Cluster Concepts

managing MySQL Cluster, Management of MySQL Cluster

managing MySQL Cluster processes, Process Management in MySQL Cluster

manual

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

master-connect-retry option

mysqld, Replication Startup Options

master-data option

mysqldump, mysqldump 鈥� A Database Backup Program

master-host option

mysqld, Replication Startup Options

master-info-file option

mysqld, Replication Startup Options

master-password option

mysqld, Replication Startup Options

master-port option

mysqld, Replication Startup Options

master-retry-count option

mysqld, Replication Startup Options

master-ssl option

mysqld, Replication Startup Options

master-ssl-ca option

mysqld, Replication Startup Options

master-ssl-capath option

mysqld, Replication Startup Options

master-ssl-cert option

mysqld, Replication Startup Options

master-ssl-cipher option

mysqld, Replication Startup Options

master-ssl-key option

mysqld, Replication Startup Options

master-user option

mysqld, Replication Startup Options

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

max-binlog-dump-events option

mysqld, Command Options

max-record-length option

myisamchk, myisamchk Repair Options

max-relay-log-size option

mysqld, Replication Startup Options

MAXDB SQL mode, SQL Modes

maximum memory used, mysqladmin 鈥� Client for Administering a MySQL Server

maximums

maximum tables per join, Limits of Joins

MaxNoOfAttributes, Defining Data Nodes

MaxNoOfConcurrentIndexOperations, Defining Data Nodes

MaxNoOfConcurrentOperations, Defining Data Nodes

MaxNoOfConcurrentScans, Defining Data Nodes

MaxNoOfConcurrentTransactions, Defining Data Nodes

MaxNoOfFiredTriggers, Defining Data Nodes

MaxNoOfIndexes, Defining Data Nodes

MaxNoOfLocalOperations, Defining Data Nodes

MaxNoOfLocalScans, Defining Data Nodes

MaxNoOfOpenFiles, Defining Data Nodes

MaxNoOfOrderedIndexes, Defining Data Nodes

MaxNoOfSavedMessages, Defining Data Nodes

MaxNoOfTables, Defining Data Nodes

MaxNoOfTriggers, Defining Data Nodes

MaxNoOfUniqueHashIndexes, Defining Data Nodes

MaxScanBatchSize, Defining SQL and Other API Nodes

max_allowed_packet variable, mysql Options

MAX_CONNECTIONS_PER_HOUR, Limiting Account Resources

max_join_size variable, mysql Options

MAX_QUERIES_PER_HOUR, Limiting Account Resources

MAX_UPDATES_PER_HOUR, Limiting Account Resources

MAX_USER_CONNECTIONS, Limiting Account Resources

MBR, Relations on Geometry Minimal Bounding Rectangles (MBRs)

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

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

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

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

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

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

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

MD5(), Encryption and Compression Functions

medium-check option

myisamchk, myisamchk Check Options
mysqlcheck, mysqlcheck 鈥� A Table Maintenance and Repair Program

MEDIUMBLOB data type, Overview of String Types

MEDIUMINT data type, Overview of Numeric Types

MEDIUMTEXT data type, Overview of String Types

memlock option

mysqld, Command Options

MEMORY storage engine, 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

in MySQL Cluster, Known Limitations of MySQL Cluster

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

MERGE tables

defined, The MERGE Storage Engine

metadata

database, The INFORMATION_SCHEMA Database

method option

mysqlhotcopy, mysqlhotcopy 鈥� A Database Backup Program

methods

locking, Internal Locking Methods

mgmd (MySQL Cluster)

defined, Basic MySQL Cluster Concepts

MICROSECOND(), Date and Time Functions

Microsoft Access, Microsoft Access

Microsoft ADO, Microsoft ADO

Microsoft Excel, Microsoft Excel and Column Types

Microsoft Visual Basic, Microsoft Visual Basic

Microsoft Visual InterDev, Microsoft Visual InterDev

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

modulo (%), Mathematical Functions

modulo (MOD), Mathematical Functions

monitor

terminal, Tutorial

monitoring-interval option

mysqlmanager, MySQL Instance Manager Command Options

Mono, MySQL Connector/NET

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, SQL Modes

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

and MySQL Cluster, Multi-Computer Configuration, Configuration File, Basic Example Configuration
in MySQL Cluster, MySQL Server Process Usage for MySQL Cluster

my.cnf file, Replication Features and Known Problems

MyISAM

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

MyISAM key cache, The MyISAM Key Cache

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

myisam-recover option

mysqld, Command Options, MyISAM Startup Options

myisamchk, Typical configure Options, Overview of Client and Utility Programs

analyze option, Other myisamchk Options
backup option, myisamchk Repair Options
block-search option, Other myisamchk Options
character-sets-dir option, myisamchk Repair Options
check option, myisamchk Check Options
check-only-changed option, myisamchk Check Options
correct-checksum option, myisamchk Repair Options
data-file-length option, myisamchk Repair Options
debug option, myisamchk General Options
description option, Other myisamchk Options
example output, Getting Information About a Table
extend-check option, myisamchk Check Options, myisamchk Repair Options
fast option, myisamchk Check Options
force option, myisamchk Check Options, myisamchk Repair Options
help option, myisamchk General Options
information option, myisamchk Check Options
keys-used option, myisamchk Repair Options
max-record-length option, myisamchk Repair Options
medium-check option, myisamchk Check Options
no-symlinks option, myisamchk Repair Options
options, myisamchk General Options
parallel-recover option, myisamchk Repair Options
quick option, myisamchk Repair Options
read-only option, myisamchk Check Options
recover option, myisamchk Repair Options
safe-recover option, myisamchk Repair Options
set-auto-increment[ option, Other myisamchk Options
set-character-set option, myisamchk Repair Options
set-collation option, myisamchk Repair Options
silent option, myisamchk General Options
sort-index option, Other myisamchk Options
sort-records option, Other myisamchk Options
sort-recover option, myisamchk Repair Options
tmpdir option, myisamchk Repair Options
unpack option, myisamchk Repair Options
update-state option, myisamchk Check Options
verbose option, myisamchk General Options
version option, myisamchk General Options
wait option, myisamchk General Options

myisamlog, Overview of Client and Utility Programs

myisampack, Overview of Client and Utility Programs, Silent Column Specification Changes, Compressed Table Characteristics

backup option, myisampack 鈥� Generate Compressed, Read-Only MyISAM Tables
character-sets-dir option, myisampack 鈥� Generate Compressed, Read-Only MyISAM Tables
debug option, myisampack 鈥� Generate Compressed, Read-Only MyISAM Tables
force option, myisampack 鈥� Generate Compressed, Read-Only MyISAM Tables
help option, myisampack 鈥� Generate Compressed, Read-Only MyISAM Tables
join option, myisampack 鈥� Generate Compressed, Read-Only MyISAM Tables
packlength option, myisampack 鈥� Generate Compressed, Read-Only MyISAM Tables
silent option, myisampack 鈥� Generate Compressed, Read-Only MyISAM Tables
test option, myisampack 鈥� Generate Compressed, Read-Only MyISAM Tables
tmpdir option, myisampack 鈥� Generate Compressed, Read-Only MyISAM Tables
verbose option, myisampack 鈥� Generate Compressed, Read-Only MyISAM Tables
version option, myisampack 鈥� Generate Compressed, Read-Only MyISAM Tables
wait option, myisampack 鈥� Generate Compressed, Read-Only MyISAM Tables

myisam_block_size myisamchk variable, myisamchk General Options

myisam_ftdump, Overview of Client and Utility Programs

count option, myisam_ftdump 鈥� Display Full-Text Index information
dump option, myisam_ftdump 鈥� Display Full-Text Index information
help option, myisam_ftdump 鈥� Display Full-Text Index information
length option, myisam_ftdump 鈥� Display Full-Text Index information
stats option, myisam_ftdump 鈥� Display Full-Text Index information
verbose option, myisam_ftdump 鈥� Display Full-Text Index information

MyODBC, MySQL Connector/ODBC

MySQL

defined, What is MySQL?
introduction, What is MySQL?
pronunciation, What is MySQL?

mysql, Overview of Client and Utility Programs

auto-rehash option, mysql Options
batch option, mysql Options
character-sets-dir option, mysql Options
column-names option, mysql Options
compress option, mysql Options
database option, mysql Options
debug option, mysql Options
debug-info option, mysql Options
default-character-set option, mysql Options
delimiter option, mysql Options
execute option, mysql Options
force option, mysql Options
help option, mysql Options
host option, mysql Options
html option, mysql Options
i-am-a-dummy option, mysql Options
ignore-spaces option, mysql Options
line-numbers option, mysql Options
local-infile option, mysql Options
named-commands option, mysql Options
no-auto-rehash option, mysql Options
no-beep option, mysql Options
no-named-commands option, mysql Options
no-pager option, mysql Options
no-tee option, mysql Options
one-database option, mysql Options
pager option, mysql Options
password option, mysql Options
port option, mysql Options
prompt option, mysql Options
protocol option, mysql Options
quick option, mysql Options
raw option, mysql Options
reconnect option, mysql Options
safe-updates option, mysql Options
secure-auth option, mysql Options
show-warnings option, mysql Options
sigint-ignore option, mysql Options
silent option, mysql Options
skip-column-names option, mysql Options
skip-line-numbers option, mysql Options
socket option, mysql Options
SSL options, mysql Options
table option, mysql Options
tee option, mysql Options
unbuffered option, mysql Options
user option, mysql Options
verbose option, mysql Options
version option, mysql Options
vertical option, mysql Options
wait option, mysql Options
xml option, mysql Options

MySQL AB

defined, Overview of MySQL AB

MySQL binary distribution, Choosing Which MySQL Distribution to Install

MYSQL C type, C API Data types

MySQL Cluster, MySQL Cluster

administration, Command Options for MySQL Cluster Processes, MySQL Cluster-Related Command Options for mysqld, Command Options for ndbd, Command Options for ndb_mgmd, Command Options for ndb_mgm, Commands in the MySQL Cluster Management Client, Using CLUSTERLOG STATISTICS

and DNS, Simple Multi-Computer How-To

and IP addressing, Simple Multi-Computer How-To

and networking, Hardware, Software, and Networking

and transactions, MySQL 5.0 FAQ 鈥� MySQL Cluster

API node, Basic MySQL Cluster Concepts, Defining SQL and Other API Nodes

arbitrator, MySQL 5.0 FAQ 鈥� MySQL Cluster

available platforms, MySQL Cluster

backups, On-line Backup of MySQL Cluster, Cluster Backup Concepts, Using The Management Client to Create a Backup, Configuration for Cluster Backup, Backup Troubleshooting

benchmarks, Understanding the Impact of Cluster Interconnects

CHECKPOINT Events, Log Events

cluster logs, Event Reports Generated in MySQL Cluster, Logging Management Commands

CLUSTERLOG commands, Logging Management Commands

CLUSTERLOG STATISTICS command, Using CLUSTERLOG STATISTICS

commands, Command Options for MySQL Cluster Processes, MySQL Cluster-Related Command Options for mysqld, Command Options for ndbd, Command Options for ndb_mgmd, Command Options for ndb_mgm, Commands in the MySQL Cluster Management Client

compiling from source, Building MySQL Cluster from Source Code

concepts, Basic MySQL Cluster Concepts

configuration, Simple Multi-Computer How-To, MySQL Cluster Configuration, Quick Test Setup of MySQL Cluster, Defining Cluster Computers, Defining the Management Server, Defining Data Nodes, Defining SQL and Other API Nodes, Configuring Parameters for Local Checkpoints, MySQL Server Process Usage for MySQL Cluster, ndb_mgmd 鈥� The Management Server Process

configuration (example), Basic Example Configuration

configuration changes, Performing a Rolling Restart of the Cluster

configuration files, Multi-Computer Configuration, Configuration File

configuration parameters, Overview of Cluster Configuration Parameters, Data Node Configuration Parameters, Management Node Configuration Parameters, SQL Node and API Node Configuration Parameters

configuring, Configuration for Cluster Backup

CONNECTION Events, Log Events

connectstring, The Cluster Connectstring

data node, Basic MySQL Cluster Concepts, Defining Data Nodes

data types supported, MySQL 5.0 FAQ 鈥� MySQL Cluster

defining node hosts, Defining Cluster Computers

direct connections between nodes, TCP/IP Connections Using Direct Connections

ENTER SINGLE USER MODE command, Commands in the MySQL Cluster Management Client

ERROR Events, Log Events

error logs, ndbd 鈥� The Storage Engine Node Process

error messages, MySQL 5.0 FAQ 鈥� MySQL Cluster

event log format, Log Events

event logging thresholds, Logging Management Commands

event logs, Event Reports Generated in MySQL Cluster, Logging Management Commands

event severity levels, Logging Management Commands

event types, Event Reports Generated in MySQL Cluster, Log Events

EXIT command, Commands in the MySQL Cluster Management Client

EXIT SINGLE USER MODE command, Commands in the MySQL Cluster Management Client

FAQ, MySQL 5.0 FAQ 鈥� MySQL Cluster

general description, MySQL Cluster Overview

hardware requirements, MySQL 5.0 FAQ 鈥� MySQL Cluster

HELP command, Commands in the MySQL Cluster Management Client

how to obtain, MySQL 5.0 FAQ 鈥� MySQL Cluster

importing existing tables, MySQL 5.0 FAQ 鈥� MySQL Cluster

INFO Events, Log Events

information sources, MySQL Cluster

installation, Simple Multi-Computer How-To, Multi-Computer Installation, Installing the Software

interconnects, Using High-Speed Interconnects with MySQL Cluster

log files, ndbd 鈥� The Storage Engine Node Process

logging commands, Logging Management Commands

management commands, Using CLUSTERLOG STATISTICS

management node, Basic MySQL Cluster Concepts, Defining the Management Server

managing, Management of MySQL Cluster

memory requirements, MySQL 5.0 FAQ 鈥� MySQL Cluster

memory usage and recovery, Performing a Rolling Restart of the Cluster, Known Limitations of MySQL Cluster

mgm, Command Options for MySQL Cluster Processes

mgm client, Commands in the MySQL Cluster Management Client

mgm management client, Using CLUSTERLOG STATISTICS

mgm process, Command Options for ndb_mgm

mgmd, Command Options for MySQL Cluster Processes

mgmd process, Command Options for ndb_mgmd

mysqld process, MySQL Server Process Usage for MySQL Cluster, MySQL Cluster-Related Command Options for mysqld

ndbd, Command Options for MySQL Cluster Processes

ndbd process, Command Options for ndbd, Using CLUSTERLOG STATISTICS

ndb_mgm, Initial Startup

ndb_size.pl (utility), MySQL 5.0 FAQ 鈥� MySQL Cluster

network configuration (SCI), Configuring MySQL Cluster to use SCI Sockets

network transporters, Using High-Speed Interconnects with MySQL Cluster, Configuring MySQL Cluster to use SCI Sockets

networking, TCP/IP Connections Using Direct Connections, Shared-Memory Connections, SCI Transport Connections

networking requirements, MySQL 5.0 FAQ 鈥� MySQL Cluster

node failure (single user mode), Single User Mode

node identifiers, Shared-Memory Connections, SCI Transport Connections

node logs, Event Reports Generated in MySQL Cluster

node types, MySQL 5.0 FAQ 鈥� MySQL Cluster

NODERESTART Events, Log Events

nodes and node groups, MySQL Cluster Nodes, Node Groups, Replicas, and Partitions

nodes and types, Basic MySQL Cluster Concepts

number of computers required, MySQL 5.0 FAQ 鈥� MySQL Cluster

obtaining, Multi-Computer Installation

partitions, MySQL Cluster Nodes, Node Groups, Replicas, and Partitions

performance, Understanding the Impact of Cluster Interconnects

performing queries, Loading Sample Data and Performing Queries

platforms supported, MySQL 5.0 FAQ 鈥� MySQL Cluster

process management, Process Management in MySQL Cluster

quick configuration, Quick Test Setup of MySQL Cluster

QUIT command, Commands in the MySQL Cluster Management Client

replicas, MySQL Cluster Nodes, Node Groups, Replicas, and Partitions

requirements, Hardware, Software, and Networking

resetting, Performing a Rolling Restart of the Cluster

RESTART command, Commands in the MySQL Cluster Management Client

restarting, Safe Shutdown and Restart

roles of computers, MySQL 5.0 FAQ 鈥� MySQL Cluster

runtime statistics, Using CLUSTERLOG STATISTICS

SCI (Scalable Coherent Interface), SCI Transport Connections, Configuring MySQL Cluster to use SCI Sockets

SCI drivers, Configuring MySQL Cluster to use SCI Sockets

SCI network configuration, Configuring MySQL Cluster to use SCI Sockets

SCI software installation, Configuring MySQL Cluster to use SCI Sockets

SCI software requirements, Configuring MySQL Cluster to use SCI Sockets

SCI, performance vs TCP/IP, Understanding the Impact of Cluster Interconnects

security, MySQL 5.0 FAQ 鈥� MySQL Cluster

shared memory transport, Shared-Memory Connections

SHOW command, Commands in the MySQL Cluster Management Client

SHUTDOWN command, Commands in the MySQL Cluster Management Client

shutting down, Safe Shutdown and Restart

single user mode, Commands in the MySQL Cluster Management Client, Single User Mode

SQL node, Basic MySQL Cluster Concepts, Defining SQL and Other API Nodes

SQL nodes, MySQL Server Process Usage for MySQL Cluster

SQL statements, MySQL 5.0 FAQ 鈥� MySQL Cluster

SQL statements for monitoring, Quick Reference: MySQL Cluster SQL Statements

START BACKUP command, Using The Management Client to Create a Backup

START command, Commands in the MySQL Cluster Management Client

starting and stopping, MySQL 5.0 FAQ 鈥� MySQL Cluster

starting nodes, Initial Startup

starting or restarting, MySQL Cluster Startup Phases

starting with --initial, Quick Test Setup of MySQL Cluster

STARTUP Events, Log Events

STATISTICS Events, Log Events

STATUS command, Commands in the MySQL Cluster Management Client

STOP command, Commands in the MySQL Cluster Management Client

storage requirements, Data Type Storage Requirements

Table is full error, MySQL 5.0 FAQ 鈥� MySQL Cluster

terminology, MySQL Cluster Glossary

trace files, ndbd 鈥� The Storage Engine Node Process

transactions, Defining Data Nodes

transporters

Scalable Coherent Interface (SCI), SCI Transport Connections
shared memory (SHM), Shared-Memory Connections
TCP/IP, TCP/IP Connections Using Direct Connections

troubleshooting backups, Backup Troubleshooting

upgrades and downgrades, Upgrading and Downgrading MySQL Cluster, Performing a Rolling Restart of the Cluster, Cluster Upgrade and Downgrade Compatibility

using in a virtual machine, MySQL 5.0 FAQ 鈥� MySQL Cluster

using tables and data, Loading Sample Data and Performing Queries

vs replication, MySQL 5.0 FAQ 鈥� MySQL Cluster

MySQL Cluster Glossary, MySQL Cluster Glossary

MySQL Cluster How-To, Simple Multi-Computer How-To

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

MySQL Cluster limitations, Known Limitations of MySQL Cluster

causing errors, Known Limitations of MySQL Cluster
database objects, Known Limitations of MySQL Cluster
geometry datatypes, Known Limitations of MySQL Cluster
implementation, Known Limitations of MySQL Cluster
imposed by configuration, Known Limitations of MySQL Cluster
multiple management servers, Known Limitations of MySQL Cluster
multiple MySQL servers, Known Limitations of MySQL Cluster
performance, Known Limitations of MySQL Cluster
resolved in current version from previous versions, Known Limitations of MySQL Cluster
syntax, Known Limitations of MySQL Cluster
transactions, Known Limitations of MySQL Cluster
unsupported features, Known Limitations of MySQL Cluster

MySQL Cluster processes (types), Process Management in MySQL Cluster

MySQL Cluster utilities, Cluster Utility Programs

mysql command options, mysql Options

mysql commands

list of, mysql Commands

MySQL Community Server

changes, MySQL Community Server Enhancements and Release Notes
enhancements, MySQL Community Server Enhancements and Release Notes
release notes, MySQL Community Server Enhancements and Release Notes

MySQL Dolphin name, History of MySQL

MySQL Enterprise

changes, MySQL Enterprise Release Notes

MySQL history, History of MySQL

mysql history file, mysql Options

MySQL mailing lists, MySQL Mailing Lists

MySQL name, History of MySQL

mysql prompt command, mysql Commands

mysql source (command for reading from text files), Using mysql in Batch Mode, Executing SQL Statements from a Text File

MySQL source distribution, Choosing Which MySQL Distribution to Install

mysql status command, mysql Commands

MySQL storage engines, Storage Engines and Table Types

MySQL version, How to Get MySQL

mysql \. (command for reading from text files), Using mysql in Batch Mode, Executing SQL Statements from a Text File

MySQL++, MySQL C++ API

mysql.server, Overview of Server-Side Programs

mysql.sock

changing location of, Typical configure Options
protection, How to Protect or Change the MySQL Unix Socket File

MYSQL323 SQL mode, SQL Modes

MYSQL40 SQL mode, SQL Modes

mysqlaccess, Overview of Client and Utility Programs

brief option, mysqlaccess 鈥� Client for Checking Access Privileges
commit option, mysqlaccess 鈥� Client for Checking Access Privileges
copy option, mysqlaccess 鈥� Client for Checking Access Privileges
db option, mysqlaccess 鈥� Client for Checking Access Privileges
debug option, mysqlaccess 鈥� Client for Checking Access Privileges
help option, mysqlaccess 鈥� Client for Checking Access Privileges
host option, mysqlaccess 鈥� Client for Checking Access Privileges
howto option, mysqlaccess 鈥� Client for Checking Access Privileges
old_server option, mysqlaccess 鈥� Client for Checking Access Privileges
password option, mysqlaccess 鈥� Client for Checking Access Privileges
plan option, mysqlaccess 鈥� Client for Checking Access Privileges
preview option, mysqlaccess 鈥� Client for Checking Access Privileges
relnotes option, mysqlaccess 鈥� Client for Checking Access Privileges
rhost option, mysqlaccess 鈥� Client for Checking Access Privileges
rollback option, mysqlaccess 鈥� Client for Checking Access Privileges
spassword option, mysqlaccess 鈥� Client for Checking Access Privileges
superuser option, mysqlaccess 鈥� Client for Checking Access Privileges
table option, mysqlaccess 鈥� Client for Checking Access Privileges
user option, mysqlaccess 鈥� Client for Checking Access Privileges
version option, mysqlaccess 鈥� Client for Checking Access Privileges

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

character-sets-dir option, mysqladmin 鈥� Client for Administering a MySQL Server
compress option, mysqladmin 鈥� Client for Administering a MySQL Server
count option, mysqladmin 鈥� Client for Administering a MySQL Server
debug option, mysqladmin 鈥� Client for Administering a MySQL Server
default-character-set option, mysqladmin 鈥� Client for Administering a MySQL Server
force option, mysqladmin 鈥� Client for Administering a MySQL Server
help option, mysqladmin 鈥� Client for Administering a MySQL Server
host option, mysqladmin 鈥� Client for Administering a MySQL Server
password option, mysqladmin 鈥� Client for Administering a MySQL Server
port option, mysqladmin 鈥� Client for Administering a MySQL Server
protocol option, mysqladmin 鈥� Client for Administering a MySQL Server
relative option, mysqladmin 鈥� Client for Administering a MySQL Server
silent option, mysqladmin 鈥� Client for Administering a MySQL Server
sleep option, mysqladmin 鈥� Client for Administering a MySQL Server
socket option, mysqladmin 鈥� Client for Administering a MySQL Server
SSL options, mysqladmin 鈥� Client for Administering a MySQL Server
user option, mysqladmin 鈥� Client for Administering a MySQL Server
verbose option, mysqladmin 鈥� Client for Administering a MySQL Server
version option, mysqladmin 鈥� Client for Administering a MySQL Server
vertical option, mysqladmin 鈥� Client for Administering a MySQL Server
wait option, mysqladmin 鈥� Client for Administering a MySQL Server

mysqladmin command options, mysqladmin 鈥� Client for Administering a MySQL Server

mysqladmin option

mysqld_multi, mysqld_multi 鈥� Manage Multiple MySQL Servers

mysqlbinlog, Overview of Client and Utility Programs

character-sets-dir option, mysqlbinlog 鈥� Utility for Processing Binary Log Files
database option, mysqlbinlog 鈥� Utility for Processing Binary Log Files
debug option, mysqlbinlog 鈥� Utility for Processing Binary Log Files
disable-log-bin option, mysqlbinlog 鈥� Utility for Processing Binary Log Files
force-read option, mysqlbinlog 鈥� Utility for Processing Binary Log Files
help option, mysqlbinlog 鈥� Utility for Processing Binary Log Files
hexdump option, mysqlbinlog 鈥� Utility for Processing Binary Log Files
host option, mysqlbinlog 鈥� Utility for Processing Binary Log Files
local-load option, mysqlbinlog 鈥� Utility for Processing Binary Log Files
offset option, mysqlbinlog 鈥� Utility for Processing Binary Log Files
password option, mysqlbinlog 鈥� Utility for Processing Binary Log Files
port option, mysqlbinlog 鈥� Utility for Processing Binary Log Files
position option, mysqlbinlog 鈥� Utility for Processing Binary Log Files
protocol option, mysqlbinlog 鈥� Utility for Processing Binary Log Files
read-from-remote-server option, mysqlbinlog 鈥� Utility for Processing Binary Log Files
result-file option, mysqlbinlog 鈥� Utility for Processing Binary Log Files
set-charset option, mysqlbinlog 鈥� Utility for Processing Binary Log Files
short-form option, mysqlbinlog 鈥� Utility for Processing Binary Log Files
socket option, mysqlbinlog 鈥� Utility for Processing Binary Log Files
start-datetime option, mysqlbinlog 鈥� Utility for Processing Binary Log Files
start-position option, mysqlbinlog 鈥� Utility for Processing Binary Log Files
stop-datetime option, mysqlbinlog 鈥� Utility for Processing Binary Log Files
stop-position option, mysqlbinlog 鈥� Utility for Processing Binary Log Files
to-last-log option, mysqlbinlog 鈥� Utility for Processing Binary Log Files
user option, mysqlbinlog 鈥� Utility for Processing Binary Log Files
version option, mysqlbinlog 鈥� Utility for Processing Binary Log Files

mysqlbug script, How to Report Bugs or Problems

mysqlcheck, Overview of Client and Utility Programs

all-databases option, mysqlcheck 鈥� A Table Maintenance and Repair Program
all-in-1 option, mysqlcheck 鈥� A Table Maintenance and Repair Program
analyze option, mysqlcheck 鈥� A Table Maintenance and Repair Program
auto-repair option, mysqlcheck 鈥� A Table Maintenance and Repair Program
character-sets-dir option, mysqlcheck 鈥� A Table Maintenance and Repair Program
check option, mysqlcheck 鈥� A Table Maintenance and Repair Program
check-only-changed option, mysqlcheck 鈥� A Table Maintenance and Repair Program
check-upgrade option, mysqlcheck 鈥� A Table Maintenance and Repair Program
compress option, mysqlcheck 鈥� A Table Maintenance and Repair Program
databases option, mysqlcheck 鈥� A Table Maintenance and Repair Program
debug option, mysqlcheck 鈥� A Table Maintenance and Repair Program
default-character-set option, mysqlcheck 鈥� A Table Maintenance and Repair Program
extended option, mysqlcheck 鈥� A Table Maintenance and Repair Program
fast option, mysqlcheck 鈥� A Table Maintenance and Repair Program
force option, mysqlcheck 鈥� A Table Maintenance and Repair Program
help option, mysqlcheck 鈥� A Table Maintenance and Repair Program
host option, mysqlcheck 鈥� A Table Maintenance and Repair Program
medium-check option, mysqlcheck 鈥� A Table Maintenance and Repair Program
optimize option, mysqlcheck 鈥� A Table Maintenance and Repair Program
password option, mysqlcheck 鈥� A Table Maintenance and Repair Program
port option, mysqlcheck 鈥� A Table Maintenance and Repair Program
protocol option, mysqlcheck 鈥� A Table Maintenance and Repair Program
quick option, mysqlcheck 鈥� A Table Maintenance and Repair Program
repair option, mysqlcheck 鈥� A Table Maintenance and Repair Program
silent option, mysqlcheck 鈥� A Table Maintenance and Repair Program
socket option, mysqlcheck 鈥� A Table Maintenance and Repair Program
SSL options, mysqlcheck 鈥� A Table Maintenance and Repair Program
tables option, mysqlcheck 鈥� A Table Maintenance and Repair Program
use-frm option, mysqlcheck 鈥� A Table Maintenance and Repair Program
user option, mysqlcheck 鈥� A Table Maintenance and Repair Program
verbose option, mysqlcheck 鈥� A Table Maintenance and Repair Program
version option, mysqlcheck 鈥� A Table Maintenance and Repair Program

mysqlclient library, APIs and Libraries

mysqld, Overview of Server-Side Programs

abort-slave-event-count option, Command Options
allow-suspicious-udfs option, Command Options, Security-Related mysqld Options
ansi option, Command Options
as MySQL Cluster process, MySQL Server Process Usage for MySQL Cluster, MySQL Cluster-Related Command Options for mysqld
basedir option, Command Options
bdb-home option, BDB Startup Options
bdb-lock-detect option, BDB Startup Options
bdb-logdir option, BDB Startup Options
bdb-no-recover option, BDB Startup Options
bdb-no-sync option, BDB Startup Options
bdb-shared-data option, BDB Startup Options
bdb-tmpdir option, BDB Startup Options
bind-address option, Command Options
binlog-do-db option, The Binary Log
binlog-ignore-db option, The Binary Log
bootstrap option, Command Options
character-set-client-handshake option, Command Options
character-set-filesystem option, Command Options
character-set-server option, Command Options
character-sets-dir option, Command Options
chroot option, Command Options
collation-server option, Command Options
command options, Command Options
console option, Command Options
core-file option, Command Options
datadir option, Command Options
debug option, Command Options
default-character-set option, Command Options
default-collation option, Command Options
default-storage-engine option, Command Options
default-table-type option, Command Options
default-time-zone option, Command Options
delay-key-write option, Command Options, MyISAM Startup Options
des-key-file option, Command Options
disconnect-slave-event-count option, Command Options
enable-named-pipe option, Command Options
enable-pstack option, Command Options
exit-info option, Command Options
external-locking option, Command Options
flush option, Command Options
gdb option, Command Options
help option, Command Options
init-file option, Command Options
innodb option, InnoDB Startup Options and System Variables
innodb-safe-binlog option, Command Options
innodb_status_file option, InnoDB Startup Options and System Variables
language option, Command Options
large-pages option, Command Options
local-infile option, Security-Related mysqld Options
log option, Command Options
log-bin option, Command Options
log-bin-index option, Command Options
log-bin-trust-function-creators option, Command Options
log-bin-trust-routine-creators option, Command Options
log-error option, Command Options
log-isam option, Command Options
log-long-format option, Command Options
log-queries-not-using-indexes option, Command Options
log-short-format option, Command Options
log-slave-updates option, Replication Startup Options
log-slow-admin-statements option, Command Options
log-slow-queries option, Command Options
log-tc option, Command Options
log-tc-size option, Command Options
log-warnings option, Command Options, Replication Startup Options
low-priority-updates option, Command Options
master-connect-retry option, Replication Startup Options
master-host option, Replication Startup Options
master-info-file option, Replication Startup Options
master-password option, Replication Startup Options
master-port option, Replication Startup Options
master-retry-count option, Replication Startup Options
master-ssl option, Replication Startup Options
master-ssl-ca option, Replication Startup Options
master-ssl-capath option, Replication Startup Options
master-ssl-cert option, Replication Startup Options
master-ssl-cipher option, Replication Startup Options
master-ssl-key option, Replication Startup Options
master-user option, Replication Startup Options
max-binlog-dump-events option, Command Options
max-relay-log-size option, Replication Startup Options
memlock option, Command Options
myisam-recover option, Command Options, MyISAM Startup Options
ndb-connectstring option, Command Options
ndbcluster option, Command Options
old-passwords option, Command Options, Security-Related mysqld Options
one-thread option, Command Options
open-files-limit option, Command Options
pid-file option, Command Options
port option, Command Options
port-open-timeout option, Command Options
read-only option, Replication Startup Options
relay-log option, Replication Startup Options
relay-log-index option, Replication Startup Options
relay-log-info-file option, Replication Startup Options
relay-log-purge option, Replication Startup Options
relay-log-space-limit option, Replication Startup Options
replicate-do-db option, Replication Startup Options
replicate-do-table option, Replication Startup Options
replicate-ignore-db option, Replication Startup Options
replicate-ignore-table option, Replication Startup Options
replicate-rewrite-db option, Replication Startup Options
replicate-same-server-id option, Replication Startup Options
replicate-wild-do-table option, Replication Startup Options
replicate-wild-ignore-table option, Replication Startup Options
report-host option, Replication Startup Options
report-password option, Replication Startup Options
report-port option, Replication Startup Options
report-user option, Replication Startup Options
role in MySQL Cluster, Basic MySQL Cluster Concepts
safe-mode option, Command Options
safe-show-database option, Command Options, Security-Related mysqld Options
safe-user-create option, Command Options, Security-Related mysqld Options
secure-auth option, Command Options, Security-Related mysqld Options
shared-memory option, Command Options
shared-memory-base-name option, Command Options
show-slave-auth-info option, Replication Startup Options
skip-bdb option, Command Options, BDB Startup Options
skip-concurrent-insert option, Command Options
skip-external-locking option, Command Options
skip-grant-tables option, Command Options, Security-Related mysqld Options
skip-host-cache option, Command Options
skip-innodb option, Command Options
skip-merge option, Command Options
skip-name-resolve option, Command Options, Security-Related mysqld Options
skip-ndbcluster option, Command Options
skip-networking option, Command Options, Security-Related mysqld Options
skip-safemalloc option, Command Options
skip-show-database option, Command Options, Security-Related mysqld Options
skip-slave-start option, Replication Startup Options
skip-stack-trace option, Command Options
skip-symbolic-links option, Command Options
skip-thread-priority option, Command Options
slave-load-tmpdir option, Replication Startup Options
slave-net-timeout option, Replication Startup Options
slave-skip-errors option, Replication Startup Options
slave_compressed_protocol option, Replication Startup Options
socket option, Command Options
sporadic-binlog-dump-fail option, Command Options
sql-mode option, Command Options
SSL options, Command Options, Making MySQL Secure Against Attackers
standalone option, Command Options
starting, How to Run MySQL as a Normal User
symbolic-links option, Command Options
sync-bdb-logs option, BDB Startup Options
sysdate-is-now option, Command Options
tc-heuristic-recover option, Command Options
temp-pool option, Command Options
tmpdir option, Command Options
transaction-isolation option, Command Options
user option, Command Options
version option, Command Options

mysqld library, APIs and Libraries

mysqld option

mysqld_multi, mysqld_multi 鈥� Manage Multiple MySQL Servers
mysqld_safe, mysqld_safe 鈥� MySQL Server Startup Script

mysqld options, Tuning Server Parameters

mysqld server

buffer sizes, Tuning Server Parameters

mysqld-version option

mysqld_safe, mysqld_safe 鈥� MySQL Server Startup Script

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

add-drop-database option, mysqldump 鈥� A Database Backup Program
add-drop-table option, mysqldump 鈥� A Database Backup Program
add-locks option, mysqldump 鈥� A Database Backup Program
all-databases option, mysqldump 鈥� A Database Backup Program
allow-keywords option, mysqldump 鈥� A Database Backup Program
character-sets-dir option, mysqldump 鈥� A Database Backup Program
comments option, mysqldump 鈥� A Database Backup Program
compact option, mysqldump 鈥� A Database Backup Program
compatible option, mysqldump 鈥� A Database Backup Program
complete-insert option, mysqldump 鈥� A Database Backup Program
compress option, mysqldump 鈥� A Database Backup Program
create-options option, mysqldump 鈥� A Database Backup Program
databases option, mysqldump 鈥� A Database Backup Program
debug option, mysqldump 鈥� A Database Backup Program
default-character-set option, mysqldump 鈥� A Database Backup Program
delayed-insert option, mysqldump 鈥� A Database Backup Program
delete-master-logs option, mysqldump 鈥� A Database Backup Program
disable-keys option, mysqldump 鈥� A Database Backup Program
extended-insert option, mysqldump 鈥� A Database Backup Program
fields-enclosed-by option, mysqldump 鈥� A Database Backup Program, mysqlimport 鈥� A Data Import Program
fields-escaped-by option, mysqldump 鈥� A Database Backup Program, mysqlimport 鈥� A Data Import Program
fields-optionally-enclosed-by option, mysqldump 鈥� A Database Backup Program, mysqlimport 鈥� A Data Import Program
fields-terminated-by option, mysqldump 鈥� A Database Backup Program, mysqlimport 鈥� A Data Import Program
first-slave option, mysqldump 鈥� A Database Backup Program
flush-logs option, mysqldump 鈥� A Database Backup Program
flush-privileges option, mysqldump 鈥� A Database Backup Program
force option, mysqldump 鈥� A Database Backup Program
help option, mysqldump 鈥� A Database Backup Program
hex-blob option, mysqldump 鈥� A Database Backup Program
host option, mysqldump 鈥� A Database Backup Program
ignore-table option, mysqldump 鈥� A Database Backup Program
insert-ignore option, mysqldump 鈥� A Database Backup Program
lines-terminated-by option, mysqldump 鈥� A Database Backup Program, mysqlimport 鈥� A Data Import Program
lock-all-tables option, mysqldump 鈥� A Database Backup Program
lock-tables option, mysqldump 鈥� A Database Backup Program
master-data option, mysqldump 鈥� A Database Backup Program
no-autocommit option, mysqldump 鈥� A Database Backup Program
no-create-db option, mysqldump 鈥� A Database Backup Program
no-create-info option, mysqldump 鈥� A Database Backup Program
no-data option, mysqldump 鈥� A Database Backup Program
opt option, mysqldump 鈥� A Database Backup Program
order-by-primary option, mysqldump 鈥� A Database Backup Program
password option, mysqldump 鈥� A Database Backup Program
port option, mysqldump 鈥� A Database Backup Program
problems, mysqldump 鈥� A Database Backup Program, Restrictions on Views
protocol option, mysqldump 鈥� A Database Backup Program
quick option, mysqldump 鈥� A Database Backup Program
quote-names option, mysqldump 鈥� A Database Backup Program
result-file option, mysqldump 鈥� A Database Backup Program
routines option, mysqldump 鈥� A Database Backup Program
set-charset option, mysqldump 鈥� A Database Backup Program
single-transaction option, mysqldump 鈥� A Database Backup Program
skip-comments option, mysqldump 鈥� A Database Backup Program
skip-opt option, mysqldump 鈥� A Database Backup Program
socket option, mysqldump 鈥� A Database Backup Program
SSL options, mysqldump 鈥� A Database Backup Program
tab option, mysqldump 鈥� A Database Backup Program
tables option, mysqldump 鈥� A Database Backup Program
triggers option, mysqldump 鈥� A Database Backup Program
tz-utc option, mysqldump 鈥� A Database Backup Program
user option, mysqldump 鈥� A Database Backup Program
verbose option, mysqldump 鈥� A Database Backup Program
version option, mysqldump 鈥� A Database Backup Program
views, mysqldump 鈥� A Database Backup Program, Restrictions on Views
where option, mysqldump 鈥� A Database Backup Program
workarounds, mysqldump 鈥� A Database Backup Program, Restrictions on Views
xml option, mysqldump 鈥� A Database Backup Program

mysqld_multi, Overview of Server-Side Programs

config-file option, mysqld_multi 鈥� Manage Multiple MySQL Servers
example option, mysqld_multi 鈥� Manage Multiple MySQL Servers
help option, mysqld_multi 鈥� Manage Multiple MySQL Servers
log option, mysqld_multi 鈥� Manage Multiple MySQL Servers
mysqladmin option, mysqld_multi 鈥� Manage Multiple MySQL Servers
mysqld option, mysqld_multi 鈥� Manage Multiple MySQL Servers
no-log option, mysqld_multi 鈥� Manage Multiple MySQL Servers
password option, mysqld_multi 鈥� Manage Multiple MySQL Servers
silent option, mysqld_multi 鈥� Manage Multiple MySQL Servers
tcp-ip option, mysqld_multi 鈥� Manage Multiple MySQL Servers
user option, mysqld_multi 鈥� Manage Multiple MySQL Servers
verbose option, mysqld_multi 鈥� Manage Multiple MySQL Servers
version option, mysqld_multi 鈥� Manage Multiple MySQL Servers

mysqld_safe, Overview of Server-Side Programs

autoclose option, mysqld_safe 鈥� MySQL Server Startup Script
basedir option, mysqld_safe 鈥� MySQL Server Startup Script
core-file-size option, mysqld_safe 鈥� MySQL Server Startup Script
datadir option, mysqld_safe 鈥� MySQL Server Startup Script
defaults-extra-file option, mysqld_safe 鈥� MySQL Server Startup Script
defaults-file option, mysqld_safe 鈥� MySQL Server Startup Script
help option, mysqld_safe 鈥� MySQL Server Startup Script
ledir option, mysqld_safe 鈥� MySQL Server Startup Script
log-error option, mysqld_safe 鈥� MySQL Server Startup Script
mysqld option, mysqld_safe 鈥� MySQL Server Startup Script
mysqld-version option, mysqld_safe 鈥� MySQL Server Startup Script
nice option, mysqld_safe 鈥� MySQL Server Startup Script
no-defaults option, mysqld_safe 鈥� MySQL Server Startup Script
open-files-limit option, mysqld_safe 鈥� MySQL Server Startup Script
pid-file option, mysqld_safe 鈥� MySQL Server Startup Script
port option, mysqld_safe 鈥� MySQL Server Startup Script
socket option, mysqld_safe 鈥� MySQL Server Startup Script
timezone option, mysqld_safe 鈥� MySQL Server Startup Script
user option, mysqld_safe 鈥� MySQL Server Startup Script

mysqlhotcopy, Overview of Client and Utility Programs

addtodest option, mysqlhotcopy 鈥� A Database Backup Program
allowold option, mysqlhotcopy 鈥� A Database Backup Program
checkpoint option, mysqlhotcopy 鈥� A Database Backup Program
chroot option, mysqlhotcopy 鈥� A Database Backup Program
debug option, mysqlhotcopy 鈥� A Database Backup Program
dryrun option, mysqlhotcopy 鈥� A Database Backup Program
flushlog option, mysqlhotcopy 鈥� A Database Backup Program
help option, mysqlhotcopy 鈥� A Database Backup Program
host option, mysqlhotcopy 鈥� A Database Backup Program
keepold option, mysqlhotcopy 鈥� A Database Backup Program
method option, mysqlhotcopy 鈥� A Database Backup Program
noindices option, mysqlhotcopy 鈥� A Database Backup Program
password option, mysqlhotcopy 鈥� A Database Backup Program
port option, mysqlhotcopy 鈥� A Database Backup Program
quiet option, mysqlhotcopy 鈥� A Database Backup Program
record_log_pos option, mysqlhotcopy 鈥� A Database Backup Program
regexp option, mysqlhotcopy 鈥� A Database Backup Program
resetmaster option, mysqlhotcopy 鈥� A Database Backup Program
resetslave option, mysqlhotcopy 鈥� A Database Backup Program
socket option, mysqlhotcopy 鈥� A Database Backup Program
suffix option, mysqlhotcopy 鈥� A Database Backup Program
tmpdir option, mysqlhotcopy 鈥� A Database Backup Program
user option, mysqlhotcopy 鈥� A Database Backup Program

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

character-sets-dir option, mysqlimport 鈥� A Data Import Program
columns option, mysqlimport 鈥� A Data Import Program
compress option, mysqlimport 鈥� A Data Import Program
debug option, mysqlimport 鈥� A Data Import Program
default-character-set option, mysqlimport 鈥� A Data Import Program
delete option, mysqlimport 鈥� A Data Import Program
force option, mysqlimport 鈥� A Data Import Program
help option, mysqlimport 鈥� A Data Import Program
host option, mysqlimport 鈥� A Data Import Program
ignore option, mysqlimport 鈥� A Data Import Program
ignore-lines option, mysqlimport 鈥� A Data Import Program
local option, mysqlimport 鈥� A Data Import Program
lock-tables option, mysqlimport 鈥� A Data Import Program
low-priority option, mysqlimport 鈥� A Data Import Program
password option, mysqlimport 鈥� A Data Import Program
port option, mysqlimport 鈥� A Data Import Program
protocol option, mysqlimport 鈥� A Data Import Program
replace option, mysqlimport 鈥� A Data Import Program
silent option, mysqlimport 鈥� A Data Import Program
socket option, mysqlimport 鈥� A Data Import Program
SSL options, mysqlimport 鈥� A Data Import Program
user option, mysqlimport 鈥� A Data Import Program
verbose option, mysqlimport 鈥� A Data Import Program
version option, mysqlimport 鈥� A Data Import Program

mysqlmanager, Overview of Server-Side Programs

angel-pid-file option, MySQL Instance Manager Command Options
bind-address option, MySQL Instance Manager Command Options
default-mysqld-path option, MySQL Instance Manager Command Options
defaults-file option, MySQL Instance Manager Command Options
help option, MySQL Instance Manager Command Options
install option, MySQL Instance Manager Command Options
log option, MySQL Instance Manager Command Options
monitoring-interval option, MySQL Instance Manager Command Options
password-file option, MySQL Instance Manager Command Options
pid-file option, MySQL Instance Manager Command Options
port option, MySQL Instance Manager Command Options
print-defaults option, MySQL Instance Manager Command Options
print-password-line option, MySQL Instance Manager Command Options
remove option, MySQL Instance Manager Command Options
run-as-service option, MySQL Instance Manager Command Options
socket option, MySQL Instance Manager Command Options
standalone option, MySQL Instance Manager Command Options
user option, MySQL Instance Manager Command Options
version option, MySQL Instance Manager Command Options
wait-timeout option, MySQL Instance Manager Command Options

mysqlshow, Overview of Client and Utility Programs

character-sets-dir option, mysqlshow 鈥� Display Database, Table, and Column Information
compress option, mysqlshow 鈥� Display Database, Table, and Column Information
count option, mysqlshow 鈥� Display Database, Table, and Column Information
debug option, mysqlshow 鈥� Display Database, Table, and Column Information
default-character-set option, mysqlshow 鈥� Display Database, Table, and Column Information
help option, mysqlshow 鈥� Display Database, Table, and Column Information
host option, mysqlshow 鈥� Display Database, Table, and Column Information
keys option, mysqlshow 鈥� Display Database, Table, and Column Information
password option, mysqlshow 鈥� Display Database, Table, and Column Information
port option, mysqlshow 鈥� Display Database, Table, and Column Information
protocol option, mysqlshow 鈥� Display Database, Table, and Column Information
show-table-type option, mysqlshow 鈥� Display Database, Table, and Column Information
socket option, mysqlshow 鈥� Display Database, Table, and Column Information
SSL options, mysqlshow 鈥� Display Database, Table, and Column Information
status option, mysqlshow 鈥� Display Database, Table, and Column Information
user option, mysqlshow 鈥� Display Database, Table, and Column Information
verbose option, mysqlshow 鈥� Display Database, Table, and Column Information
version option, mysqlshow 鈥� Display Database, Table, and Column Information

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_convert_table_format, Overview of Client and Utility Programs

mysql_create_db(), mysql_create_db()

mysql_data_seek(), mysql_data_seek()

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

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_explain_log, Overview of Client and Utility Programs

date option, mysql_explain_log 鈥� Use EXPLAIN on Statements in Query Log
help option, mysql_explain_log 鈥� Use EXPLAIN on Statements in Query Log
host option, mysql_explain_log 鈥� Use EXPLAIN on Statements in Query Log
password option, mysql_explain_log 鈥� Use EXPLAIN on Statements in Query Log
printerror option, mysql_explain_log 鈥� Use EXPLAIN on Statements in Query Log
socket option, mysql_explain_log 鈥� Use EXPLAIN on Statements in Query Log
user option, mysql_explain_log 鈥� Use EXPLAIN on Statements in Query Log

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_find_rows, Overview of Client and Utility Programs

help option, mysql_find_rows 鈥� Extract Queries from Update Log
regexp option, mysql_find_rows 鈥� Extract Queries from Update Log
rows option, mysql_find_rows 鈥� Extract Queries from Update Log
skip-use-db option, mysql_find_rows 鈥� Extract Queries from Update Log
start_row option, mysql_find_rows 鈥� Extract Queries from Update Log

mysql_fix_extensions, Overview of Client and Utility Programs

mysql_fix_privilege_tables, Overview of Server-Side Programs

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_get_ssl_cipher(), mysql_get_ssl_cipher()

MYSQL_GROUP_SUFFIX environment variable, Environment Variables

mysql_hex_string(), mysql_hex_string()

MYSQL_HISTFILE environment variable, Environment Variables, mysql Options

MYSQL_HOME environment variable, Environment Variables

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

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 Server-Side Programs

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, Environment Variables, Connecting to the MySQL Server, Overview of Client and Utility Programs

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_secure_installation, Overview of Server-Side Programs

mysql_select_db(), mysql_select_db()

mysql_server_end(), mysql_server_end()

mysql_server_init(), mysql_server_init()

mysql_setpermission, Overview of Client and Utility Programs

help option, mysql_setpermission 鈥� Interactively Set Permissions in Grant Tables
host option, mysql_setpermission 鈥� Interactively Set Permissions in Grant Tables
password option, mysql_setpermission 鈥� Interactively Set Permissions in Grant Tables
port option, mysql_setpermission 鈥� Interactively Set Permissions in Grant Tables
socket option, mysql_setpermission 鈥� Interactively Set Permissions in Grant Tables
user option, mysql_setpermission 鈥� Interactively Set Permissions in Grant Tables

mysql_set_character_set(), mysql_set_character_set()

mysql_set_local_infile_default(), mysql_set_local_infile_default()

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_tableinfo, Overview of Client and Utility Programs

clear option, mysql_tableinfo 鈥� Generate Database Metadata
clear-only option, mysql_tableinfo 鈥� Generate Database Metadata
col option, mysql_tableinfo 鈥� Generate Database Metadata
help option, mysql_tableinfo 鈥� Generate Database Metadata
host option, mysql_tableinfo 鈥� Generate Database Metadata
idx option, mysql_tableinfo 鈥� Generate Database Metadata
password option, mysql_tableinfo 鈥� Generate Database Metadata
port option, mysql_tableinfo 鈥� Generate Database Metadata
prefix option, mysql_tableinfo 鈥� Generate Database Metadata
quiet option, mysql_tableinfo 鈥� Generate Database Metadata
socket option, mysql_tableinfo 鈥� Generate Database Metadata
tbl-status option, mysql_tableinfo 鈥� Generate Database Metadata
user option, mysql_tableinfo 鈥� Generate Database Metadata

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

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_TIME C type, C API Prepared Statement Data types

mysql_tzinfo_to_sql, Overview of Server-Side Programs

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

mysql_upgrade, Overview of Server-Side Programs, Causes of Access denied Errors

basedir option, mysql_upgrade 鈥� Check Tables for MySQL Upgrade
datadir option, mysql_upgrade 鈥� Check Tables for MySQL Upgrade
force option, mysql_upgrade 鈥� Check Tables for MySQL Upgrade
help option, mysql_upgrade 鈥� Check Tables for MySQL Upgrade
user option, mysql_upgrade 鈥� Check Tables for MySQL Upgrade
verbose option, mysql_upgrade 鈥� Check Tables for MySQL Upgrade

mysql_use_result(), mysql_use_result()

mysql_waitpid, Overview of Client and Utility Programs

help option, mysql_waitpid 鈥� Kill Process and Wait for Its Termination
verbose option, mysql_waitpid 鈥� Kill Process and Wait for Its Termination
version option, mysql_waitpid 鈥� Kill Process and Wait for Its Termination

mysql_warning_count(), mysql_warning_count()

mysql_zap, Overview of Client and Utility Programs

my_bool C type, C API Data types

my_bool values

printing, C API Data types

my_init(), my_init()

my_print_defaults, Overview of Client and Utility Programs

config-file option, my_print_defaults 鈥� Display Options from Option Files
debug option, my_print_defaults 鈥� Display Options from Option Files
defaults-extra-file option, my_print_defaults 鈥� Display Options from Option Files
defaults-file option, my_print_defaults 鈥� Display Options from Option Files
defaults-group-suffix option, my_print_defaults 鈥� Display Options from Option Files
extra-file option, my_print_defaults 鈥� Display Options from Option Files
help option, my_print_defaults 鈥� Display Options from Option Files
no-defaults option, my_print_defaults 鈥� Display Options from Option Files
verbose option, my_print_defaults 鈥� Display Options from Option Files
version option, my_print_defaults 鈥� Display Options from Option Files

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 option

mysql, mysql Options

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

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

NAME_CONST(), Miscellaneous Functions

name_file option

comp_err, comp_err 鈥� Compile MySQL Error Message File

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 Community Server

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

NDB, MySQL 5.0 FAQ 鈥� MySQL Cluster

ndb option

perror, perror 鈥� Explain Error Codes

NDB storage engine, MySQL Cluster

FAQ, MySQL 5.0 FAQ 鈥� MySQL Cluster

ndb-connectstring option

mysqld, Command Options
ndb_config, ndb_config 鈥� Extract NDB Configuration Information

ndbcluster option

mysqld, Command Options

ndbd (MySQL Cluster)

defined, Basic MySQL Cluster Concepts

ndb_config, Cluster Utility Programs

config-file option, ndb_config 鈥� Extract NDB Configuration Information
fields option, ndb_config 鈥� Extract NDB Configuration Information
host option, ndb_config 鈥� Extract NDB Configuration Information
id option, ndb_config 鈥� Extract NDB Configuration Information
ndb-connectstring option, ndb_config 鈥� Extract NDB Configuration Information
nodeid option, ndb_config 鈥� Extract NDB Configuration Information
nodes option, ndb_config 鈥� Extract NDB Configuration Information
query option, ndb_config 鈥� Extract NDB Configuration Information
rows option, ndb_config 鈥� Extract NDB Configuration Information
type option, ndb_config 鈥� Extract NDB Configuration Information
usage option, ndb_config 鈥� Extract NDB Configuration Information
version option, ndb_config 鈥� Extract NDB Configuration Information

ndb_cpcd, Cluster Utility Programs

ndb_delete_all, Cluster Utility Programs

transactional option, ndb_delete_all 鈥� Delete All Rows from NDB Table

ndb_desc, Cluster Utility Programs

extra-partition-info option, ndb_desc 鈥� Describe NDB Tables

ndb_drop_index, Cluster Utility Programs

ndb_drop_table, Cluster Utility Programs

ndb_error_reporter, Cluster Utility Programs

ndb_mgm (MySQL Cluster management node client), Initial Startup

ndb_mgmd (MySQL Cluster)

defined, Basic MySQL Cluster Concepts

ndb_print_backup_file, Cluster Utility Programs

ndb_print_schema_file, Cluster Utility Programs

ndb_print_sys_file, Cluster Utility Programs

ndb_restore

errors, ndb_restore 鈥� Restore a Cluster Backup

ndb_select_all, Cluster Utility Programs

delimiter option, ndb_select_all 鈥� Print Rows from NDB Table
descending option, ndb_select_all 鈥� Print Rows from NDB Table
gci option, ndb_select_all 鈥� Print Rows from NDB Table
header option, ndb_select_all 鈥� Print Rows from NDB Table
lock option, ndb_select_all 鈥� Print Rows from NDB Table
nodata option, ndb_select_all 鈥� Print Rows from NDB Table
order option, ndb_select_all 鈥� Print Rows from NDB Table
rowid option, ndb_select_all 鈥� Print Rows from NDB Table
tupscan option, ndb_select_all 鈥� Print Rows from NDB Table
useHexFormat option, ndb_select_all 鈥� Print Rows from NDB Table

ndb_select_count, Cluster Utility Programs

ndb_show_tables, Cluster Utility Programs

loops option, ndb_show_tables 鈥� Display List of NDB Tables
parsable option, ndb_show_tables 鈥� Display List of NDB Tables
type option, ndb_show_tables 鈥� Display List of NDB Tables
unqualified option, ndb_show_tables 鈥� Display List of NDB Tables

ndb_size.pl, Cluster Utility Programs

ndb_size.pl (utility), MySQL 5.0 FAQ 鈥� MySQL Cluster

ndb_waiter, Cluster Utility Programs

no-contact option, ndb_waiter 鈥� Wait for Cluster to Reach a Given Status
not-started option, ndb_waiter 鈥� Wait for Cluster to Reach a Given Status
timeout option, ndb_waiter 鈥� Wait for Cluster to Reach a Given Status

negative values, Numbers

nested queries, Subquery Syntax

net etiquette, Guidelines for Using the Mailing Lists

netmask notation

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

NetWare, Installing MySQL on NetWare

net_buffer_length variable, mysql Options

New features in MySQL Cluster, MySQL Cluster Development Roadmap

new procedures

adding, Adding New Procedures to MySQL

new users

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

newline (\n), Strings

next-key lock, InnoDB Startup Options and System Variables, InnoDB and TRANSACTION ISOLATION LEVEL, Next-Key Locking: Avoiding the Phantom Problem

NFS

InnoDB, InnoDB Configuration, Restrictions on InnoDB Tables

nice option

mysqld_safe, mysqld_safe 鈥� MySQL Server Startup Script

no matching rows, Solving Problems with No Matching Rows

no-auto-rehash option

mysql, mysql Options

no-autocommit option

mysqldump, mysqldump 鈥� A Database Backup Program

no-beep option

mysql, mysql Options

no-contact option

ndb_waiter, ndb_waiter 鈥� Wait for Cluster to Reach a Given Status

no-create-db option

mysqldump, mysqldump 鈥� A Database Backup Program

no-create-info option

mysqldump, mysqldump 鈥� A Database Backup Program

no-data option

mysqldump, mysqldump 鈥� A Database Backup Program

no-debug option

make_win_bin_dist, make_win_bin_dist 鈥� Package MySQL Distribution as ZIP Archive

no-defaults option, Using Option Files

mysqld_safe, mysqld_safe 鈥� MySQL Server Startup Script
my_print_defaults, my_print_defaults 鈥� Display Options from Option Files

no-embedded option

make_win_bin_dist, make_win_bin_dist 鈥� Package MySQL Distribution as ZIP Archive

no-log option

mysqld_multi, mysqld_multi 鈥� Manage Multiple MySQL Servers

no-named-commands option

mysql, mysql Options

no-pager option

mysql, mysql Options

no-symlinks option

myisamchk, myisamchk Repair Options

no-tee option

mysql, mysql Options

nodata option

ndb_select_all, ndb_select_all 鈥� Print Rows from NDB Table

node groups (MySQL Cluster), MySQL Cluster Nodes, Node Groups, Replicas, and Partitions

node identifiers (MySQL Cluster), Shared-Memory Connections, SCI Transport Connections

node logs (MySQL Cluster), Event Reports Generated in MySQL Cluster

nodeid option

ndb_config, ndb_config 鈥� Extract NDB Configuration Information

NODERESTART Events (MySQL Cluster), Log Events

nodes option

ndb_config, ndb_config 鈥� Extract NDB Configuration Information

noindices option

mysqlhotcopy, mysqlhotcopy 鈥� A Database Backup Program

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

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

NoOfDiskPagesToDiskAfterRestartACC

calculating, Configuring Parameters for Local Checkpoints

NoOfDiskPagesToDiskAfterRestartACC (MySQL Cluster configuration parameter), Defining Data Nodes

NoOfDiskPagesToDiskAfterRestartTUP

calculating, Configuring Parameters for Local Checkpoints

NoOfDiskPagesToDiskAfterRestartTUP (MySQL Cluster configuration parameter), Defining Data Nodes

NoOfDiskPagesToDiskDuringRestartACC (MySQL Cluster configuration parameter), Defining Data Nodes

NoOfDiskPagesToDiskDuringRestartTUP (MySQL Cluster configuration parameter), Defining Data Nodes

NoOfFragmentLogFiles, Defining Data Nodes

calculating, Configuring Parameters for Local Checkpoints

NoOfReplicas, Defining Data Nodes

NOT

logical, Logical Operators

NOT BETWEEN, Comparison Functions and Operators

not equal (!=), Comparison Functions and Operators

not equal (<>), Comparison Functions and Operators

NOT EXISTS

with subqueries, EXISTS and NOT EXISTS

NOT IN, Comparison Functions and Operators

NOT LIKE, String Comparison Functions

NOT NULL

constraint, Constraints on Invalid Data

NOT REGEXP, String Comparison Functions

not-started option

ndb_waiter, ndb_waiter 鈥� Wait for Cluster to Reach a Given Status

Novell NetWare, Installing MySQL on NetWare

NOW(), Date and Time Functions

NO_AUTO_CREATE_USER SQL mode, SQL Modes

NO_AUTO_VALUE_ON_ZERO SQL mode, SQL Modes

NO_BACKSLASH_ESCAPES SQL mode, SQL Modes

NO_DIR_IN_CREATE SQL mode, SQL Modes

NO_FIELD_OPTIONS SQL mode, SQL Modes

NO_KEY_OPTIONS SQL mode, SQL Modes

NO_TABLE_OPTIONS SQL mode, SQL Modes

NO_UNSIGNED_SUBTRACTION SQL mode, SQL Modes

NO_ZERO_DATE SQL mode, SQL Modes

NO_ZERO_IN_DATE SQL mode, SQL Modes

NUL, Strings

NULL, Working with NULL Values, Problems with NULL Values

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

NULL value, Working with NULL Values, NULL Values

NULL values

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

NULLIF(), Control Flow Functions

numbers, Numbers

NUMERIC data type, Overview of Numeric Types

numeric types, Data Type Storage Requirements

numeric-dump-file option

resolve_stack_dump, resolve_stack_dump 鈥� Resolve Numeric Stack Trace Dump to Symbols

NumGeometries(), GeometryCollection Functions

NumInteriorRings(), Polygon Functions

NumPoints(), LineString Functions

O

Obtaining MySQL Cluster, Multi-Computer Installation

OCT(), String Functions

OCTET_LENGTH(), String Functions

ODBC, MySQL Connector/ODBC

ODBC compatibility, Identifier Qualifiers, Overview of Numeric Types, Type Conversion in Expression Evaluation, Comparison Functions and Operators, CREATE TABLE Syntax, JOIN Syntax

offset option

mysqlbinlog, mysqlbinlog 鈥� Utility for Processing Binary Log Files

OLAP, GROUP BY Modifiers

old-passwords option

mysqld, Command Options, Security-Related mysqld Options

OLD_PASSWORD(), Encryption and Compression Functions

old_server option

mysqlaccess, mysqlaccess 鈥� Client for Checking Access Privileges

ON DUPLICATE KEY, INSERT Syntax

one-database option

mysql, mysql Options

one-thread option

mysqld, Command Options

online location of manual, About This Manual

only-debug option

make_win_bin_dist, make_win_bin_dist 鈥� Package MySQL Distribution as ZIP Archive

ONLY_FULL_GROUP_BY

SQL mode, GROUP BY and HAVING with Hidden Fields

ONLY_FULL_GROUP_BY SQL mode, SQL Modes

OPEN, Cursor OPEN Statement

Open Source

defined, What is MySQL?

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

open-files-limit option

mysqld, Command Options
mysqld_safe, mysqld_safe 鈥� MySQL Server Startup Script

OpenGIS, Introduction to MySQL Spatial Support

opening

tables, How MySQL Opens and Closes Tables

opens, mysqladmin 鈥� Client for Administering a MySQL Server

OpenSSL, Using Secure Connections, Using SSL Connections

open_files_limit variable, mysqlbinlog 鈥� Utility for Processing Binary Log Files

operating systems

file-size limits, The table is full
supported, Operating Systems Supported by MySQL Community Server
Windows versus Unix, MySQL on Windows Compared to MySQL on Unix

operations

arithmetic, Arithmetic Operators

operators, Functions and Operators

assignment, User-Defined Variables
cast, Arithmetic Operators, Cast Functions and Operators
logical, Logical Operators
precedence, Operator Precedence

opt option

mysqldump, mysqldump 鈥� A Database Backup Program

optimization

subquery, Optimizing IN/=ANY Subqueries
tips, Other Optimization Tips

optimizations, WHERE Clause Optimization, Index Merge Optimization

optimize option

mysqlcheck, mysqlcheck 鈥� A Table Maintenance and Repair Program

OPTIMIZE TABLE, OPTIMIZE TABLE Syntax

optimizer

controlling, Controlling Query Optimizer Performance

optimizing

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

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

options

command-line

mysql, mysql Options
mysqladmin, mysqladmin 鈥� Client for Administering a MySQL Server

configure, Typical configure Options

myisamchk, myisamchk General Options

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

ORACLE SQL mode, SQL Modes

ORD(), String Functions

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

NULL, ORDER BY Optimization, SELECT Syntax

order option

ndb_select_all, ndb_select_all 鈥� Print Rows from NDB Table

order-by-primary option

mysqldump, mysqldump 鈥� A Database Backup Program

OUTFILE, SELECT Syntax

out_dir option

comp_err, comp_err 鈥� Compile MySQL Error Message File

out_file option

comp_err, comp_err 鈥� Compile MySQL Error Message File

Overlaps(), Functions That Test Spatial Relationships Between Geometries

overview, General Information

P

packages

list of, Packages that support MySQL

packlength option

myisampack, myisampack 鈥� Generate Compressed, Read-Only MyISAM Tables

pack_isam, Overview of Client and Utility Programs

page-level locking, Internal Locking Methods

pager option

mysql, mysql Options

parallel-recover option

myisamchk, myisamchk Repair Options

parameters

server, Tuning Server Parameters

parentheses ( and ), Operator Precedence

parsable option

ndb_show_tables, ndb_show_tables 鈥� Display List of NDB Tables

partitions (MySQL Cluster), MySQL Cluster Nodes, Node Groups, Replicas, and Partitions

password

root user, Securing the Initial MySQL Accounts

password encryption

reversibility of, Encryption and Compression Functions

password option

mysql, mysql Options
mysqlaccess, mysqlaccess 鈥� Client for Checking Access Privileges
mysqladmin, mysqladmin 鈥� Client for Administering a MySQL Server
mysqlbinlog, mysqlbinlog 鈥� Utility for Processing Binary Log Files
mysqlcheck, mysqlcheck 鈥� A Table Maintenance and Repair Program
mysqldump, mysqldump 鈥� A Database Backup Program
mysqld_multi, mysqld_multi 鈥� Manage Multiple MySQL Servers
mysqlhotcopy, mysqlhotcopy 鈥� A Database Backup Program
mysqlimport, mysqlimport 鈥� A Data Import Program
mysqlshow, mysqlshow 鈥� Display Database, Table, and Column Information
mysql_explain_log, mysql_explain_log 鈥� Use EXPLAIN on Statements in Query Log
mysql_setpermission, mysql_setpermission 鈥� Interactively Set Permissions in Grant Tables
mysql_tableinfo, mysql_tableinfo 鈥� Generate Database Metadata

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

password-file option

mysqlmanager, MySQL Instance Manager Command Options

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 Syntax, SET PASSWORD Syntax

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

pattern matching, Pattern Matching, Regular Expressions

performance

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

PERIOD_ADD(), Date and Time Functions

PERIOD_DIFF(), Date and Time Functions

Perl

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

Perl API, MySQL Perl API

Perl DBI/DBD

installation problems, Problems Using the Perl DBI/DBD Interface

permission checks

effect on speed, Optimizing SELECT and Other Statements

perror, Overview of Client and Utility Programs

--ndb option, MySQL 5.0 FAQ 鈥� MySQL Cluster
help option, perror 鈥� Explain Error Codes
ndb option, perror 鈥� Explain Error Codes
silent option, perror 鈥� Explain Error Codes
verbose option, perror 鈥� Explain Error Codes
version option, perror 鈥� Explain Error Codes

PHP API, MySQL PHP API

PI(), Mathematical Functions

pid-file option

mysqld, Command Options
mysqld_safe, mysqld_safe 鈥� MySQL Server Startup Script
mysqlmanager, MySQL Instance Manager Command Options

PIPES_AS_CONCAT SQL mode, SQL Modes

plan option

mysqlaccess, mysqlaccess 鈥� Client for Checking Access Privileges

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 option

mysql, mysql Options
mysqladmin, mysqladmin 鈥� Client for Administering a MySQL Server
mysqlbinlog, mysqlbinlog 鈥� Utility for Processing Binary Log Files
mysqlcheck, mysqlcheck 鈥� A Table Maintenance and Repair Program
mysqld, Command Options
mysqldump, mysqldump 鈥� A Database Backup Program
mysqld_safe, mysqld_safe 鈥� MySQL Server Startup Script
mysqlhotcopy, mysqlhotcopy 鈥� A Database Backup Program
mysqlimport, mysqlimport 鈥� A Data Import Program
mysqlmanager, MySQL Instance Manager Command Options
mysqlshow, mysqlshow 鈥� Display Database, Table, and Column Information
mysql_setpermission, mysql_setpermission 鈥� Interactively Set Permissions in Grant Tables
mysql_tableinfo, mysql_tableinfo 鈥� Generate Database Metadata

port-open-timeout option

mysqld, Command Options

portability, Designing Applications for Portability

types, Using Data Types from Other Database Engines

PortNumber, Defining the Management Server, Cluster TCP/IP Connections

position option

mysqlbinlog, mysqlbinlog 鈥� Utility for Processing Binary Log Files

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, SQL Modes

POW(), Mathematical Functions

POWER(), Mathematical Functions

precedence

operator, Operator Precedence

precision

arithmetic, Precision Math

precision math, Precision Math

prefix option

mysql_tableinfo, mysql_tableinfo 鈥� Generate Database Metadata

PREPARE, SQL Syntax for Prepared Statements

XA transactions, XA Transaction SQL Syntax

preview option

mysqlaccess, mysqlaccess 鈥� Client for Checking Access Privileges

previx option

configure, Typical configure Options

PRIMARY KEY, ALTER TABLE Syntax, CREATE TABLE Syntax

constraint, PRIMARY KEY and UNIQUE Index Constraints

primary key

deleting, ALTER TABLE Syntax

print-defaults option, Using Option Files

mysqlmanager, MySQL Instance Manager Command Options

print-password-line option

mysqlmanager, MySQL Instance Manager Command Options

printerror option

mysql_explain_log, mysql_explain_log 鈥� Use EXPLAIN on Statements in Query Log

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 Syntax
revoking, 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, Connector/ODBC Support
reporting, How to Report Bugs or Problems
starting the server, Starting and Troubleshooting the MySQL Server
table locking, Table Locking Issues
time zone, Time Zone Problems

PROCEDURE, SELECT Syntax

procedures

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

process management (MySQL Cluster), Process Management in MySQL Cluster

process support, Operating Systems Supported by MySQL Community Server

processes

display, SHOW PROCESSLIST Syntax

processing

arguments, UDF Argument Processing

PROCESSLIST, SHOW PROCESSLIST Syntax

PROFILING

INFORMATION_SCHEMA table, The INFORMATION_SCHEMA PROFILING Table

program variables

setting, Using Options to Set Program Variables

programs

client, Overview of Client and Utility Programs, Building Client Programs
crash-me, Designing Applications for Portability
server side, Overview of Server-Side Programs
utility, Overview of Client and Utility Programs

prompt option

mysql, mysql Options

prompts

meanings, Entering Queries

pronunciation

MySQL, What is MySQL?

protocol option

mysql, mysql Options
mysqladmin, mysqladmin 鈥� Client for Administering a MySQL Server
mysqlbinlog, mysqlbinlog 鈥� Utility for Processing Binary Log Files
mysqlcheck, mysqlcheck 鈥� A Table Maintenance and Repair Program
mysqldump, mysqldump 鈥� A Database Backup Program
mysqlimport, mysqlimport 鈥� A Data Import Program
mysqlshow, mysqlshow 鈥� Display Database, Table, and Column Information

PURGE MASTER LOGS, PURGE MASTER LOGS Syntax

PURGE STALE SESSIONS, MySQL Cluster Startup Phases

Python API, MySQL Python API

Q

QUARTER(), Date and Time Functions

queries

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

Query Cache, The MySQL Query Cache

query option

ndb_config, ndb_config 鈥� Extract NDB Configuration Information

questions, mysqladmin 鈥� Client for Administering a MySQL Server

answering, Guidelines for Using the Mailing Lists

quick option

myisamchk, myisamchk Repair Options
mysql, mysql Options
mysqlcheck, mysqlcheck 鈥� A Table Maintenance and Repair Program
mysqldump, mysqldump 鈥� A Database Backup Program

quiet option

mysqlhotcopy, mysqlhotcopy 鈥� A Database Backup Program
mysql_tableinfo, mysql_tableinfo 鈥� Generate Database Metadata

QUIT command (MySQL Cluster), Commands in the MySQL Cluster Management Client

QUOTE(), String Functions

quote-names option

mysqldump, mysqldump 鈥� A Database Backup Program

quotes

in strings, Strings

quoting, Strings

quoting binary data, Strings

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

R

RADIANS(), Mathematical Functions

RAND(), Mathematical Functions

raw option

mysql, mysql Options

re-creating

grant tables, Problems Running mysql_install_db

read-from-remote-server option

mysqlbinlog, mysqlbinlog 鈥� Utility for Processing Binary Log Files

read-only option

myisamchk, myisamchk Check Options
mysqld, Replication Startup Options

read_buffer_size myisamchk variable, myisamchk General Options

REAL data type, Overview of Numeric Types

REAL_AS_FLOAT SQL mode, SQL Modes

ReceiveBufferMemory, Cluster TCP/IP Connections

reconfiguring, Dealing with Problems Compiling MySQL

reconnect option

mysql, mysql Options

record_log_pos option

mysqlhotcopy, mysqlhotcopy 鈥� A Database Backup Program

RECOVER

XA transactions, XA Transaction SQL Syntax

recover option

myisamchk, myisamchk Repair Options

recovery

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

RedoBuffer, Defining Data Nodes

reducing

data size, Make Your Data as Small as Possible

references, ALTER TABLE Syntax

ref_or_null, IS NULL Optimization

REGEXP, String Comparison Functions

REGEXP operator, Regular Expressions

regexp option

mysqlhotcopy, mysqlhotcopy 鈥� A Database Backup Program
mysql_find_rows, mysql_find_rows 鈥� Extract Queries from Update Log

regular expression syntax, Regular Expressions

relational databases

defined, What is MySQL?

relative option

mysqladmin, mysqladmin 鈥� Client for Administering a MySQL Server

relay-log option

mysqld, Replication Startup Options

relay-log-index option

mysqld, Replication Startup Options

relay-log-info-file option

mysqld, Replication Startup Options

relay-log-purge option

mysqld, Replication Startup Options

relay-log-space-limit option

mysqld, Replication Startup Options

release notes, MySQL Enterprise Release Notes, MySQL Community Server Enhancements and Release Notes

MySQL Community Server, MySQL Community Server Enhancements and Release Notes
MySQL Enterprise, MySQL Enterprise Release Notes

Release Notes

MySQL Community Server, MySQL Community Server 5.0 Enhancements and Release Notes
MySQL Enterprise, MySQL Enterprise 5.0 Release Notes

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

relnotes option

mysqlaccess, mysqlaccess 鈥� Client for Checking Access Privileges

remove option

mysqlmanager, MySQL Instance Manager Command Options

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 option

mysqlcheck, mysqlcheck 鈥� A Table Maintenance and Repair Program

repair options

myisamchk, myisamchk Repair Options

REPAIR TABLE, REPAIR TABLE Syntax

repairing

tables, How to Repair Tables

REPEAT, REPEAT Statement

REPEAT(), String Functions

replace, Overview of Client and Utility Programs

REPLACE, REPLACE Syntax

replace option

mysqlimport, mysqlimport 鈥� A Data Import Program

REPLACE(), String Functions

replicas (MySQL Cluster), MySQL Cluster Nodes, Node Groups, Replicas, and Partitions

replicate-do-db option

mysqld, Replication Startup Options

replicate-do-table option

mysqld, Replication Startup Options

replicate-ignore-db option

mysqld, Replication Startup Options

replicate-ignore-table option

mysqld, Replication Startup Options

replicate-rewrite-db option

mysqld, Replication Startup Options

replicate-same-server-id option

mysqld, Replication Startup Options

replicate-wild-do-table option

mysqld, Replication Startup Options

replicate-wild-ignore-table option

mysqld, Replication Startup Options

replication, Replication

replication limitations, Replication Features and Known Problems

replication masters

statements, SQL Statements for Controlling Master Servers

replication options, Replication Features and Known Problems

replication slaves

statements, SQL Statements for Controlling Slave Servers

report-host option

mysqld, Replication Startup Options

report-password option

mysqld, Replication Startup Options

report-port option

mysqld, Replication Startup Options

report-user option

mysqld, Replication Startup Options

reporting

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

REQUIRE GRANT option, GRANT Syntax

reserved words, Reserved Words

RESET MASTER, RESET MASTER Syntax

RESET SLAVE, RESET SLAVE Syntax

resetmaster option

mysqlhotcopy, mysqlhotcopy 鈥� A Database Backup Program

resetslave option

mysqlhotcopy, mysqlhotcopy 鈥� A Database Backup Program

resolveip, Overview of Client and Utility Programs

help option, resolveip 鈥� Resolve Hostname to IP Address or Vice Versa
silent option, resolveip 鈥� Resolve Hostname to IP Address or Vice Versa
version option, resolveip 鈥� Resolve Hostname to IP Address or Vice Versa

resolve_stack_dump, Overview of Client and Utility Programs

help option, resolve_stack_dump 鈥� Resolve Numeric Stack Trace Dump to Symbols
numeric-dump-file option, resolve_stack_dump 鈥� Resolve Numeric Stack Trace Dump to Symbols
symbols-file option, resolve_stack_dump 鈥� Resolve Numeric Stack Trace Dump to Symbols
version option, resolve_stack_dump 鈥� Resolve Numeric Stack Trace Dump to Symbols

RESTART command (MySQL Cluster), Commands in the MySQL Cluster Management Client

restarting

the server, Unix Post-Installation Procedures

RestartOnErrorInsert, Defining Data Nodes

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

result-file option

mysqlbinlog, mysqlbinlog 鈥� Utility for Processing Binary Log Files
mysqldump, mysqldump 鈥� A Database Backup Program

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, REVOKE Syntax

revoking

privileges, REVOKE Syntax

rhost option

mysqlaccess, mysqlaccess 鈥� Client for Checking Access Privileges

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 option

mysqlaccess, mysqlaccess 鈥� Client for Checking Access Privileges

ROLLBACK TO SAVEPOINT, SAVEPOINT and ROLLBACK TO SAVEPOINT Syntax

rolling restart (MySQL Cluster), Performing a Rolling Restart of the Cluster

rolling upgrades and downgrades (MySQL Cluster), Performing a Rolling Restart of the Cluster

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

routines option

mysqldump, mysqldump 鈥� A Database Backup Program

ROW, Row Subqueries

row subqueries, Row Subqueries

row-level locking, Internal Locking Methods

rowid option

ndb_select_all, ndb_select_all 鈥� Print Rows from NDB Table

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

rows option

mysql_find_rows, mysql_find_rows 鈥� Extract Queries from Update Log
ndb_config, ndb_config 鈥� Extract NDB Configuration Information

ROW_COUNT(), Information Functions

RPAD(), String Functions

RPM file, Installing MySQL on Linux

RPM Package Manager, Installing MySQL on Linux

RTRIM(), String Functions

run-as-service option

mysqlmanager, MySQL Instance Manager Command Options

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-mode option

mysqld, Command Options

safe-recover option

myisamchk, myisamchk Repair Options

safe-show-database option

mysqld, Command Options, Security-Related mysqld Options

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

mysql, mysql Options

safe-user-create option

mysqld, Command Options, Security-Related mysqld Options

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

SCI (Scalable Coherent Interface), SCI Transport Connections, Configuring MySQL Cluster to use SCI Sockets

script files, Using mysql in Batch Mode

scripts

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

searching

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

SECOND(), Date and Time Functions

secure-auth option

mysql, mysql Options
mysqld, Command Options, Security-Related mysqld Options

security

against attackers, Making MySQL Secure Against Attackers

security system, The MySQL Access Privilege System

SEC_TO_TIME(), Date and Time Functions

SELECT

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

SELECT INTO, SELECT ... INTO Statement

SELECT INTO TABLE, SELECT INTO TABLE

SELECT speed, Speed of SELECT Queries

selecting

databases, Creating and Selecting a Database

select_limit variable, mysql Options

SendBufferMemory, Cluster TCP/IP Connections

SendLimit, SCI Transport Connections

SendSignalId, Cluster TCP/IP Connections, Shared-Memory Connections, SCI Transport Connections

SEQUENCE, Using AUTO_INCREMENT

sequence emulation, Information Functions

sequences, Using AUTO_INCREMENT

SERIAL, Overview of Numeric Types

SERIAL DEFAULT VALUE, Data Type Default Values

server

connecting, Connecting to and Disconnecting from the Server, Connecting to the 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, System Variables, SHOW VARIABLES Syntax

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

server-side programs, Overview of Server-Side Programs

ServerPort, Defining Data Nodes

servers

multiple, Running Multiple MySQL Servers on the Same Machine

SESSION_USER(), Information Functions

SET, SET Syntax, Variable SET Statement

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

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

SET GLOBAL SQL_SLAVE_SKIP_COUNTER, SET GLOBAL SQL_SLAVE_SKIP_COUNTER Syntax

SET OPTION, SET Syntax

SET PASSWORD, SET PASSWORD Syntax

SET PASSWORD statement, Assigning Account Passwords

SET SQL_LOG_BIN, SET SQL_LOG_BIN Syntax

SET TRANSACTION, SET TRANSACTION Syntax

set-auto-increment[ option

myisamchk, Other myisamchk Options

set-character-set option

myisamchk, myisamchk Repair Options

set-charset option

mysqlbinlog, mysqlbinlog 鈥� Utility for Processing Binary Log Files
mysqldump, mysqldump 鈥� A Database Backup Program

set-collation option

myisamchk, myisamchk Repair Options

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 and Compression Functions

SHA1(), Encryption and Compression Functions

shared memory transporter, Shared-Memory Connections

shared-memory option

mysqld, Command Options

shared-memory-base-name option

mysqld, Command Options

SharedBufferSize, SCI Transport Connections

shell syntax, Conventions Used in This Manual

ShmKey, Shared-Memory Connections

ShmSize, Shared-Memory Connections

short-form option

mysqlbinlog, mysqlbinlog 鈥� Utility for Processing Binary Log Files

SHOW

in MySQL Cluster management client, Quick Test Setup of MySQL Cluster

SHOW BINARY LOGS, SHOW BINARY 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 command (MySQL Cluster), Commands in the MySQL Cluster Management Client

SHOW CREATE DATABASE, SHOW Syntax, SHOW CREATE DATABASE Syntax

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

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

SHOW CREATE SCHEMA, SHOW Syntax, SHOW CREATE DATABASE Syntax

SHOW CREATE TABLE, SHOW Syntax, SHOW CREATE TABLE Syntax

SHOW CREATE VIEW, SHOW Syntax, SHOW CREATE VIEW Syntax

SHOW DATABASES, SHOW Syntax, SHOW DATABASES Syntax

SHOW ENGINE, SHOW Syntax, SHOW ENGINE Syntax

used with MySQL Cluster, Quick Reference: MySQL Cluster SQL Statements

SHOW ENGINE BDB LOGS, SHOW ENGINE Syntax

SHOW ENGINE INNODB STATUS, SHOW ENGINE Syntax

SHOW ENGINE NDB STATUS, SHOW ENGINE Syntax, Quick Reference: MySQL Cluster SQL Statements

SHOW ENGINE NDBCLUSTER STATUS, Quick Reference: MySQL Cluster SQL Statements

SHOW ENGINES, SHOW Syntax, SHOW ENGINES Syntax

used with MySQL Cluster, Quick Reference: MySQL Cluster SQL Statements

SHOW ERRORS, SHOW Syntax, SHOW ERRORS Syntax

and MySQL Cluster, MySQL 5.0 FAQ 鈥� MySQL Cluster

SHOW extensions, Extensions to SHOW Statements

SHOW FIELDS, SHOW Syntax

SHOW FUNCTION CODE, SHOW Syntax, SHOW PROCEDURE CODE and SHOW FUNCTION CODE Syntax

SHOW FUNCTION STATUS, SHOW Syntax, SHOW PROCEDURE STATUS and SHOW FUNCTION STATUS Syntax

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 BINARY LOGS Syntax

SHOW MASTER STATUS, SHOW Syntax, SHOW MASTER STATUS Syntax

SHOW MUTEX STATUS, SHOW Syntax

SHOW OPEN TABLES, SHOW Syntax, SHOW OPEN TABLES Syntax

SHOW PRIVILEGES, SHOW Syntax, SHOW PRIVILEGES Syntax

SHOW PROCEDURE CODE, SHOW Syntax, SHOW PROCEDURE CODE and SHOW FUNCTION CODE Syntax

SHOW PROCEDURE STATUS, SHOW Syntax, SHOW PROCEDURE STATUS and SHOW FUNCTION STATUS Syntax

SHOW PROCESSLIST, SHOW Syntax, SHOW PROCESSLIST Syntax

SHOW PROFILE, SHOW Syntax, SHOW PROFILES and SHOW PROFILE Syntax

SHOW PROFILES, SHOW Syntax, SHOW PROFILES and SHOW PROFILE 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

used with MySQL Cluster, Quick Reference: MySQL Cluster SQL Statements

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

used with MySQL Cluster, Quick Reference: MySQL Cluster SQL Statements

SHOW WARNINGS, SHOW Syntax, SHOW WARNINGS Syntax

and MySQL Cluster, MySQL 5.0 FAQ 鈥� MySQL Cluster

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

show-slave-auth-info option

mysqld, Replication Startup Options

show-table-type option

mysqlshow, mysqlshow 鈥� Display Database, Table, and Column Information

show-warnings option

mysql, mysql Options

SHUTDOWN command (MySQL Cluster), Commands in the MySQL Cluster Management Client

shutdown_timeout variable, mysqladmin 鈥� Client for Administering a MySQL Server

shutting down

the server, Unix Post-Installation Procedures

sigint-ignore option

mysql, mysql Options

SIGN(), Mathematical Functions

silent column changes, Silent Column Specification Changes

silent option

myisamchk, myisamchk General Options
myisampack, myisampack 鈥� Generate Compressed, Read-Only MyISAM Tables
mysql, mysql Options
mysqladmin, mysqladmin 鈥� Client for Administering a MySQL Server
mysqlcheck, mysqlcheck 鈥� A Table Maintenance and Repair Program
mysqld_multi, mysqld_multi 鈥� Manage Multiple MySQL Servers
mysqlimport, mysqlimport 鈥� A Data Import Program
perror, perror 鈥� Explain Error Codes
resolveip, resolveip 鈥� Resolve Hostname to IP Address or Vice Versa

SIN(), Mathematical Functions

single quote (\'), Strings

single user mode (MySQL Cluster), Commands in the MySQL Cluster Management Client, Single User Mode

and ndb_restore, ndb_restore 鈥� Restore a Cluster Backup

single-transaction option

mysqldump, mysqldump 鈥� A Database Backup Program

size of tables, The table is full

sizes

display, Data Types

skip-bdb option

mysqld, Command Options, BDB Startup Options

skip-column-names option

mysql, mysql Options

skip-comments option

mysqldump, mysqldump 鈥� A Database Backup Program

skip-concurrent-insert option

mysqld, Command Options

skip-external-locking option

mysqld, Command Options

skip-grant-tables option

mysqld, Command Options, Security-Related mysqld Options

skip-host-cache option

mysqld, Command Options

skip-innodb option

mysqld, Command Options

skip-line-numbers option

mysql, mysql Options

skip-merge option

mysqld, Command Options

skip-name-resolve option

mysqld, Command Options, Security-Related mysqld Options

skip-ndbcluster option

mysqld, Command Options

skip-networking option

mysqld, Command Options, Security-Related mysqld Options

skip-opt option

mysqldump, mysqldump 鈥� A Database Backup Program

skip-safemalloc option

mysqld, Command Options

skip-show-database option

mysqld, Command Options, Security-Related mysqld Options

skip-slave-start option

mysqld, Replication Startup Options

skip-stack-trace option

mysqld, Command Options

skip-symbolic-links option

mysqld, Command Options

skip-thread-priority option

mysqld, Command Options

skip-use-db option

mysql_find_rows, mysql_find_rows 鈥� Extract Queries from Update Log

slave-load-tmpdir option

mysqld, Replication Startup Options

slave-net-timeout option

mysqld, Replication Startup Options

slave-skip-errors option

mysqld, Replication Startup Options

slave_compressed_protocol option

mysqld, Replication Startup Options

sleep option

mysqladmin, mysqladmin 鈥� Client for Administering a MySQL Server

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 location

changing, Typical configure Options

socket option

mysql, mysql Options
mysqladmin, mysqladmin 鈥� Client for Administering a MySQL Server
mysqlbinlog, mysqlbinlog 鈥� Utility for Processing Binary Log Files
mysqlcheck, mysqlcheck 鈥� A Table Maintenance and Repair Program
mysqld, Command Options
mysqldump, mysqldump 鈥� A Database Backup Program
mysqld_safe, mysqld_safe 鈥� MySQL Server Startup Script
mysqlhotcopy, mysqlhotcopy 鈥� A Database Backup Program
mysqlimport, mysqlimport 鈥� A Data Import Program
mysqlmanager, MySQL Instance Manager Command Options
mysqlshow, mysqlshow 鈥� Display Database, Table, and Column Information
mysql_explain_log, mysql_explain_log 鈥� Use EXPLAIN on Statements in Query Log
mysql_setpermission, mysql_setpermission 鈥� Interactively Set Permissions in Grant Tables
mysql_tableinfo, mysql_tableinfo 鈥� Generate Database Metadata

Solaris

installation, Installing MySQL on Solaris

Solaris installation problems, Solaris Notes

Solaris troubleshooting, Dealing with Problems Compiling MySQL

Solaris x86_64 issues, InnoDB Performance Tuning Tips

SOME, Subqueries with ANY, IN, and SOME

sort-index option

myisamchk, Other myisamchk Options

sort-records option

myisamchk, Other myisamchk Options

sort-recover option

myisamchk, myisamchk Repair Options

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, myisamchk General Options

sort_key_blocks myisamchk variable, myisamchk General Options

SOUNDEX(), String Functions

SOUNDS LIKE, String Functions

source (mysql client command), Using mysql in Batch Mode, Executing SQL Statements from a Text File

source distribution

installing, MySQL Installation Using a Source Distribution

source distributions

on Linux, Linux Source Distribution Notes

SPACE(), String Functions

spassword option

mysqlaccess, mysqlaccess 鈥� Client for Checking Access Privileges

Spatial Extensions in MySQL, Introduction to MySQL Spatial Support

speed

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

sporadic-binlog-dump-fail option

mysqld, Command Options

SQL

defined, What is MySQL?

SQL mode

ONLY_FULL_GROUP_BY, GROUP BY and HAVING with Hidden Fields

SQL node (MySQL Cluster)

defined, Basic MySQL Cluster Concepts

SQL nodes (MySQL Cluster), MySQL Server Process Usage for MySQL Cluster

SQL statements

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

SQL statements relating to MySQL Cluster, Quick Reference: MySQL Cluster SQL Statements

SQL-92

extensions to, MySQL Standards Compliance

sql-mode option

mysqld, Command Options

SQL_BIG_RESULT, SELECT Syntax

SQL_BUFFER_RESULT, SELECT Syntax

SQL_CACHE, Query Cache SELECT Options, SELECT Syntax

SQL_CALC_FOUND_ROWS, SELECT Syntax

SQL_NO_CACHE, Query Cache SELECT Options, SELECT Syntax

SQL_SMALL_RESULT, SELECT Syntax

sql_yacc.cc problems, Dealing with Problems Compiling MySQL

SQRT(), Mathematical Functions

square brackets, Data Types

SRID(), General Geometry Functions

SSH, Connecting to MySQL Remotely from Windows with SSH

SSL, Using SSL Connections

SSL and X509 Basics, Using Secure Connections

SSL command options, SSL Command Options

ssl option, SSL Command Options

SSL options

mysql, mysql Options
mysqladmin, mysqladmin 鈥� Client for Administering a MySQL Server
mysqlcheck, mysqlcheck 鈥� A Table Maintenance and Repair Program
mysqld, Command Options, Making MySQL Secure Against Attackers
mysqldump, mysqldump 鈥� A Database Backup Program
mysqlimport, mysqlimport 鈥� A Data Import Program
mysqlshow, mysqlshow 鈥� Display Database, Table, and Column Information

SSL related options, GRANT Syntax

ssl-ca option, SSL Command Options

ssl-capath option, SSL Command Options

ssl-cert option, SSL Command Options

ssl-cipher option, SSL Command Options

ssl-key option, SSL Command Options

ssl-verify-server-cert option, SSL Command Options

standalone option

mysqld, Command Options
mysqlmanager, MySQL Instance Manager Command Options

Standard SQL

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

standards compatibility, MySQL Standards Compliance

START

XA transactions, XA Transaction SQL Syntax

START BACKUP command (MySQL Cluster), Using The Management Client to Create a Backup

START command (MySQL Cluster), Commands in the MySQL Cluster Management Client

START SLAVE, START SLAVE Syntax

START TRANSACTION, START TRANSACTION, COMMIT, and ROLLBACK Syntax

start-datetime option

mysqlbinlog, mysqlbinlog 鈥� Utility for Processing Binary Log Files

start-position option

mysqlbinlog, mysqlbinlog 鈥� Utility for Processing Binary Log Files

StartFailureTimeout (MySQL Cluster configuration parameter), Defining Data Nodes

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

StartPartialTimeout, Defining Data Nodes

StartPartitionedTimeout (MySQL Cluster configuration parameter), Defining Data Nodes

StartPoint(), LineString Functions

STARTUP Events (MySQL Cluster), Log Events

startup options

default, Using Option Files

startup parameters, Tuning Server Parameters

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

start_row option

mysql_find_rows, mysql_find_rows 鈥� Extract Queries from Update Log

statefile option

comp_err, comp_err 鈥� Compile MySQL Error Message File

statements

GRANT, Adding New User Accounts to MySQL
INSERT, Adding New User Accounts to MySQL
replication masters, SQL Statements for Controlling Master Servers
replication slaves, SQL Statements for Controlling Slave Servers

statically

compiling, Typical configure Options

STATISTICS

INFORMATION_SCHEMA table, The INFORMATION_SCHEMA STATISTICS Table

STATISTICS Events (MySQL Cluster), Log Events

stats option

myisam_ftdump, myisam_ftdump 鈥� Display Full-Text Index information

stats_method myisamchk variable, myisamchk General Options

status

tables, SHOW TABLE STATUS Syntax

status command

results, mysqladmin 鈥� Client for Administering a MySQL Server

STATUS command (MySQL Cluster), Commands in the MySQL Cluster Management Client

status option

mysqlshow, mysqlshow 鈥� Display Database, Table, and Column Information

status variables, 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 command (MySQL Cluster), Commands in the MySQL Cluster Management Client

STOP SLAVE, STOP SLAVE Syntax

stop-datetime option

mysqlbinlog, mysqlbinlog 鈥� Utility for Processing Binary Log Files

stop-position option

mysqlbinlog, mysqlbinlog 鈥� Utility for Processing Binary Log Files

StopOnError, Defining Data Nodes

stopping

the server, Starting and Stopping MySQL Automatically

stopword list

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

storage engine

ARCHIVE, The ARCHIVE Storage Engine

storage engines

choosing, Storage Engines and Table Types

storage of data, Design Choices

storage requirements

data type, Data Type Storage Requirements

storage space

minimizing, Make Your Data as Small as Possible

stored procedures, Stored Procedures and Functions

stored procedures and triggers

defined, Stored Routines and Triggers

stored routine restrictions, Restrictions on Stored Routines and Triggers

stored routines

LAST_INSERT_ID(), Stored Procedures, Functions, Triggers, and LAST_INSERT_ID()

STRAIGHT_JOIN, SELECT Syntax, JOIN Syntax

STRCMP(), String Comparison Functions

STRICT SQL mode, SQL Modes

STRICT_ALL_TABLES SQL mode, SQL Modes

STRICT_TRANS_TABLES SQL mode, SQL Modes

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

StringMemory, Defining Data Nodes

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

correlated, Correlated Subqueries
errors, Subquery Errors
rewriting as joins, Rewriting Subqueries as Joins for Earlier MySQL Versions
with ALL, Subqueries with ALL
with ANY, IN, SOME, Subqueries with ANY, IN, and SOME
with EXISTS, EXISTS and NOT EXISTS
with NOT EXISTS, EXISTS and NOT EXISTS
with ROW, Row Subqueries

subquery, Subquery Syntax

subquery optimization, Optimizing IN/=ANY Subqueries

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

suffix option

mysqlhotcopy, mysqlhotcopy 鈥� A Database Backup Program

SUM(), GROUP BY (Aggregate) Functions

SUM(DISTINCT), GROUP BY (Aggregate) Functions

superuser, Securing the Initial MySQL Accounts

superuser option

mysqlaccess, mysqlaccess 鈥� Client for Checking Access Privileges

support

for operating systems, Operating Systems Supported by MySQL Community Server

suppression

default values, Constraints on Invalid Data

Sybase compatibility, USE Syntax

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

symbolic-links option

mysqld, Command Options

symbols-file option

resolve_stack_dump, resolve_stack_dump 鈥� Resolve Numeric Stack Trace Dump to Symbols

SymDifference(), Spatial Operators

sync-bdb-logs option

mysqld, BDB Startup Options

syntax

regular expression, Regular Expressions

SYSDATE(), Date and Time Functions

sysdate-is-now option

mysqld, Command Options

system

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

system optimization, System Factors and Startup Parameter Tuning

system table, Optimizing Queries with EXPLAIN

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

SYSTEM_USER(), Information Functions

T

tab (\t), Strings

tab option

mysqldump, mysqldump 鈥� A Database Backup Program

table

changing, ALTER TABLE Syntax, Problems with ALTER TABLE
deleting, DROP TABLE Syntax

table aliases, SELECT Syntax

table cache, How MySQL Opens and Closes Tables

table is full, SET Syntax, The table is full

Table is full error

MySQL Cluster, MySQL 5.0 FAQ 鈥� MySQL Cluster

table names

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

table option

mysql, mysql Options
mysqlaccess, mysqlaccess 鈥� Client for Checking Access Privileges

table scans

avoiding, How to Avoid Table Scans

table types

choosing, Storage Engines and Table Types

table-level locking, Internal Locking Methods

tables

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, myisamchk Check Options
closing, How MySQL Opens and Closes Tables
compressed format, Compressed Table Characteristics
constant, Optimizing Queries with EXPLAIN, WHERE Clause Optimization
copying, CREATE TABLE Syntax
counting rows, Counting Rows
creating, Creating a Table
CSV, The CSV Storage Engine
defragment, Dynamic Table Characteristics
defragmenting, Setting Up a Table Maintenance Schedule, 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 schedule, Setting Up a Table Maintenance Schedule
maximum size, The table is full
MEMORY, The MEMORY (HEAP) Storage Engine
MERGE, The MERGE Storage Engine
merging, The MERGE Storage Engine
multiple, Using More Than one Table
MyISAM, The MyISAM Storage Engine
names, Database, Table, Index, Column, and Alias Names
open, How MySQL Opens and Closes Tables
opening, How MySQL Opens and Closes Tables
optimizing, Table Optimization
partitioning, The MERGE Storage Engine
repairing, How to Repair Tables
retrieving data, Retrieving Information from a Table
selecting columns, Selecting Particular Columns
selecting rows, Selecting Particular Rows
sorting rows, Sorting Rows
symbolic links, Using Symbolic Links for Tables on Unix
system, Optimizing Queries with EXPLAIN
too many, Drawbacks to Creating Many Tables in the Same Database
unique ID for last row, How to Get the Unique ID for the Last Inserted Row
updating, Transactions and Atomic Operations

TABLES

INFORMATION_SCHEMA table, The INFORMATION_SCHEMA TABLES Table

tables option

mysqlcheck, mysqlcheck 鈥� A Table Maintenance and Repair Program
mysqldump, mysqldump 鈥� A Database Backup Program

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, Installing MySQL on Solaris, Solaris Notes

tbl-status option

mysql_tableinfo, mysql_tableinfo 鈥� Generate Database Metadata

tc-heuristic-recover option

mysqld, Command Options

Tcl API, MySQL Tcl API

tcp-ip option

mysqld_multi, mysqld_multi 鈥� Manage Multiple MySQL Servers

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

tee option

mysql, mysql Options

temp-pool option

mysqld, Command Options

temporary file

write access, Problems Running mysql_install_db

temporary tables

internal, How MySQL Uses Internal Temporary Tables
problems, TEMPORARY TABLE Problems

terminal monitor

defined, Tutorial

test option

myisampack, myisampack 鈥� Generate Compressed, Read-Only MyISAM Tables

testing

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

testing mysqld

mysqltest, MySQL Test Suite

TEXT

size, Data Type Storage Requirements

TEXT columns

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

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

text files

importing, Executing SQL Statements from a Text File

thread support, Operating Systems Supported by MySQL Community Server

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

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

time types, Data Type Storage Requirements

time zone problems, Time Zone Problems

TIME(), Date and Time Functions

TimeBetweenGlobalCheckpoints (MySQL Cluster configuration parameter), Defining Data Nodes

TimeBetweenInactiveTransactionAbortCheck (MySQL Cluster configuration parameter), Defining Data Nodes

TimeBetweenLocalCheckpoints (MySQL Cluster configuration parameter), Defining Data Nodes

TimeBetweenWatchDogCheck, Defining Data Nodes

TIMEDIFF(), Date and Time Functions

timeout, System Variables, Miscellaneous Functions, INSERT DELAYED Syntax

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

timeout option

ndb_waiter, ndb_waiter 鈥� Wait for Cluster to Reach a Given Status

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

timezone option

mysqld_safe, mysqld_safe 鈥� MySQL Server Startup Script

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

tmpdir option

myisamchk, myisamchk Repair Options
myisampack, myisampack 鈥� Generate Compressed, Read-Only MyISAM Tables
mysqld, Command Options
mysqlhotcopy, mysqlhotcopy 鈥� A Database Backup Program

to-last-log option

mysqlbinlog, mysqlbinlog 鈥� Utility for Processing Binary Log Files

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 files (MySQL Cluster), ndbd 鈥� The Storage Engine Node Process

TRADITIONAL SQL mode, SQL Modes

transaction-isolation option

mysqld, Command Options

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

transactional option

ndb_delete_all, ndb_delete_all 鈥� Delete All Rows from NDB Table

TransactionBufferMemory, Defining Data Nodes

TransactionDeadlockDetectionTimeout (MySQL Cluster configuration parameter), Defining Data Nodes

TransactionInactiveTimeout (MySQL Cluster configuration parameter), Defining Data Nodes

transactions

support, Transactions and Atomic Operations, InnoDB Overview

Translators

list of, Documenters and translators

trigger restrictions, Restrictions on Stored Routines and Triggers

trigger, creating, CREATE TRIGGER Syntax

trigger, dropping, DROP TRIGGER Syntax

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

LAST_INSERT_ID(), Stored Procedures, Functions, Triggers, and LAST_INSERT_ID()

TRIGGERS

INFORMATION_SCHEMA table, The INFORMATION_SCHEMA TRIGGERS Table

triggers option

mysqldump, mysqldump 鈥� A Database Backup Program

TRIM(), String Functions

troubleshooting

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

TRUE, Numbers, Boolean Values

testing for, Comparison Functions and Operators

TRUNCATE, TRUNCATE Syntax

and MySQL Cluster, Known Limitations of MySQL Cluster

TRUNCATE(), Mathematical Functions

tupscan option

ndb_select_all, ndb_select_all 鈥� Print Rows from NDB Table

tutorial, Tutorial

Twin Studies

queries, Queries from the Twin Project

type conversions, Type Conversion in Expression Evaluation, Comparison Functions and Operators

type option

ndb_config, ndb_config 鈥� Extract NDB Configuration Information
ndb_show_tables, ndb_show_tables 鈥� Display List of NDB Tables

types

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

typographical conventions, Conventions Used in This Manual

TZ environment variable, Environment Variables, Time Zone Problems

tz-utc option

mysqldump, mysqldump 鈥� A Database Backup Program

U

UCASE(), String Functions

UCS-2, Character Set Support

UDFs, CREATE FUNCTION Syntax, DROP FUNCTION Syntax

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

ulimit, 'File' Not Found and Similar Errors

UMASK environment variable, Environment Variables, Problems with File Permissions

UMASK_DIR environment variable, Environment Variables, Problems with File Permissions

unary minus (-), Arithmetic Operators

unbuffered option

mysql, mysql Options

UNCOMPRESS(), Encryption and Compression Functions

UNCOMPRESSED_LENGTH(), Encryption and Compression Functions

UndoDataBuffer, Defining Data Nodes

UndoIndexBuffer, Defining Data Nodes

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, MySQL Connector/ODBC, MySQL Connector/NET

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

unpack option

myisamchk, myisamchk Repair Options

unqualified option

ndb_show_tables, ndb_show_tables 鈥� Display List of NDB Tables

UNTIL, REPEAT Statement

UPDATE, UPDATE Syntax

update-state option

myisamchk, myisamchk Check Options

updating

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

upgrades

MySQL Cluster, Upgrading and Downgrading MySQL Cluster, Performing a Rolling Restart of the Cluster, Cluster Upgrade and Downgrade Compatibility

upgrades and downgrades (MySQL Cluster)

compatibility between versions, Cluster Upgrade and Downgrade Compatibility

upgrading, Upgrading MySQL

different architecture, Copying MySQL Databases to Another Machine
to 5.0, Upgrading from MySQL 4.1 to 5.0

upgrading tables

ISAM, Upgrading from MySQL 4.1 to 5.0

UPPER(), String Functions

uptime, mysqladmin 鈥� Client for Administering a MySQL Server

URLs for downloading MySQL, How to Get MySQL

usage option

ndb_config, ndb_config 鈥� Extract NDB Configuration Information

USE, USE Syntax

USE INDEX, Index Hint Syntax

USE KEY, Index Hint Syntax

use-frm option

mysqlcheck, mysqlcheck 鈥� A Table Maintenance and Repair Program

useHexFormat option

ndb_select_all, ndb_select_all 鈥� Print Rows from NDB Table

user accounts

creating, CREATE USER Syntax
renaming, RENAME USER Syntax

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

user option

mysql, mysql Options
mysqlaccess, mysqlaccess 鈥� Client for Checking Access Privileges
mysqladmin, mysqladmin 鈥� Client for Administering a MySQL Server
mysqlbinlog, mysqlbinlog 鈥� Utility for Processing Binary Log Files
mysqlcheck, mysqlcheck 鈥� A Table Maintenance and Repair Program
mysqld, Command Options
mysqldump, mysqldump 鈥� A Database Backup Program
mysqld_multi, mysqld_multi 鈥� Manage Multiple MySQL Servers
mysqld_safe, mysqld_safe 鈥� MySQL Server Startup Script
mysqlhotcopy, mysqlhotcopy 鈥� A Database Backup Program
mysqlimport, mysqlimport 鈥� A Data Import Program
mysqlmanager, MySQL Instance Manager Command Options
mysqlshow, mysqlshow 鈥� Display Database, Table, and Column Information
mysql_explain_log, mysql_explain_log 鈥� Use EXPLAIN on Statements in Query Log
mysql_setpermission, mysql_setpermission 鈥� Interactively Set Permissions in Grant Tables
mysql_tableinfo, mysql_tableinfo 鈥� Generate Database Metadata
mysql_upgrade, mysql_upgrade 鈥� Check Tables for MySQL Upgrade

user privileges

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

user table

sorting, Access Control, Stage 1: Connection Verification

user variables, User-Defined Variables

USER(), Information Functions

user-defined functions

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

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

usernames

and passwords, MySQL Usernames and Passwords

users

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

USER_PRIVILEGES

INFORMATION_SCHEMA table, The INFORMATION_SCHEMA USER_PRIVILEGES Table

uses

of MySQL, What We Have Used MySQL For

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

UTC_DATE(), Date and Time Functions

UTC_TIME(), Date and Time Functions

UTC_TIMESTAMP(), Date and Time Functions

UTF-8, Character Set Support

utility programs, Overview of Client and Utility Programs

UUID(), Miscellaneous Functions

V

valid numbers

examples, Numbers

VALUES(), Miscellaneous Functions

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

VARCHAR

size, Data Type Storage Requirements

VARCHAR data type, Overview of String Types, String Types

VARCHARACTER data type, Overview of String Types

variables

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

VARIANCE(), GROUP BY (Aggregate) Functions

VAR_POP(), GROUP BY (Aggregate) Functions

VAR_SAMP(), GROUP BY (Aggregate) Functions

verbose option

myisamchk, myisamchk General Options
myisampack, myisampack 鈥� Generate Compressed, Read-Only MyISAM Tables
myisam_ftdump, myisam_ftdump 鈥� Display Full-Text Index information
mysql, mysql Options
mysqladmin, mysqladmin 鈥� Client for Administering a MySQL Server
mysqlcheck, mysqlcheck 鈥� A Table Maintenance and Repair Program
mysqldump, mysqldump 鈥� A Database Backup Program
mysqld_multi, mysqld_multi 鈥� Manage Multiple MySQL Servers
mysqlimport, mysqlimport 鈥� A Data Import Program
mysqlshow, mysqlshow 鈥� Display Database, Table, and Column Information
mysql_upgrade, mysql_upgrade 鈥� Check Tables for MySQL Upgrade
mysql_waitpid, mysql_waitpid 鈥� Kill Process and Wait for Its Termination
my_print_defaults, my_print_defaults 鈥� Display Options from Option Files
perror, perror 鈥� Explain Error Codes

version

choosing, Choosing Which MySQL Distribution to Install
latest, How to Get MySQL

version option

comp_err, comp_err 鈥� Compile MySQL Error Message File
myisamchk, myisamchk General Options
myisampack, myisampack 鈥� Generate Compressed, Read-Only MyISAM Tables
mysql, mysql Options
mysqlaccess, mysqlaccess 鈥� Client for Checking Access Privileges
mysqladmin, mysqladmin 鈥� Client for Administering a MySQL Server
mysqlbinlog, mysqlbinlog 鈥� Utility for Processing Binary Log Files
mysqlcheck, mysqlcheck 鈥� A Table Maintenance and Repair Program
mysqld, Command Options
mysqldump, mysqldump 鈥� A Database Backup Program
mysqld_multi, mysqld_multi 鈥� Manage Multiple MySQL Servers
mysqlimport, mysqlimport 鈥� A Data Import Program
mysqlmanager, MySQL Instance Manager Command Options
mysqlshow, mysqlshow 鈥� Display Database, Table, and Column Information
mysql_waitpid, mysql_waitpid 鈥� Kill Process and Wait for Its Termination
my_print_defaults, my_print_defaults 鈥� Display Options from Option Files
ndb_config, ndb_config 鈥� Extract NDB Configuration Information
perror, perror 鈥� Explain Error Codes
resolveip, resolveip 鈥� Resolve Hostname to IP Address or Vice Versa
resolve_stack_dump, resolve_stack_dump 鈥� Resolve Numeric Stack Trace Dump to Symbols

VERSION(), Information Functions

vertical option

mysql, mysql Options
mysqladmin, mysqladmin 鈥� Client for Administering a MySQL Server

Vietnamese, MySQL 5.0 FAQ 鈥� MySQL Chinese, Japanese, and Korean Character Sets

view restrictions, Restrictions on Views

views, Views, Views, CREATE VIEW Syntax

updatable, Views, CREATE VIEW Syntax

VIEWS

INFORMATION_SCHEMA table, The INFORMATION_SCHEMA VIEWS Table

Views

limitations, Restrictions on Views
privileges, Restrictions on Views
problems, Restrictions on Views

virtual memory

problems while compiling, Dealing with Problems Compiling MySQL

Vision, Using Connector/ODBC with SunSystems Vision

Visual Objects, Visual Objects

Visual Studio, Building MySQL from Source Using CMake and Visual Studio

Visual Studio Plugin, Connectors

W

wait option

myisamchk, myisamchk General Options
myisampack, myisampack 鈥� Generate Compressed, Read-Only MyISAM Tables
mysql, mysql Options
mysqladmin, mysqladmin 鈥� Client for Administering a MySQL Server

wait-timeout option

mysqlmanager, MySQL Instance Manager Command 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

WHERE, WHERE Clause Optimization

with SHOW, The INFORMATION_SCHEMA Database, Extensions to SHOW Statements

where option

mysqldump, mysqldump 鈥� A Database Backup Program

WHILE, WHILE Statement

widths

display, Data Types

Wildcard character (%), Strings

Wildcard character (_), Strings

wildcards

and LIKE, How MySQL Uses Indexes
in mysql.columns_priv table, Access Control, Stage 2: Request Verification
in mysql.db table, Access Control, Stage 2: Request Verification
in mysql.host table, Access Control, Stage 2: Request Verification
in mysql.procs_priv 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, MySQL Connector/NET

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

configure, Typical configure Options

with-debug option

configure, Typical configure Options

with-embedded-server option

configure, Typical configure Options

with-extra-charsets option

configure, Typical configure Options

with-unix-socket-path option

configure, Typical configure Options

Within(), Functions That Test Spatial Relationships Between Geometries

without-server option, Typical configure Options

configure, Typical configure Options

WKB format, Well-Known Binary (WKB) Format

WKT format, Well-Known Text (WKT) Format

wrappers

Eiffel, MySQL Eiffel Wrapper

write access

tmp, Problems Running mysql_install_db

write_buffer_size myisamchk variable, myisamchk General Options

X

X(), Point Functions

X509/Certificate, Basic SSL Concepts

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 option

mysql, mysql Options
mysqldump, mysqldump 鈥� A Database Backup Program

XOR

bitwise, Bit Functions
logical, Logical Operators

Y

Y(), Point Functions
yaSSL, Using Secure Connections, Using SSL Connections
Year 2000 compliance, Year 2000 Issues and Date Types
Year 2000 issues, Year 2000 Issues and Date Types
YEAR data type, Overview of Date and Time Types, The YEAR Type
YEAR(), Date and Time Functions
YEARWEEK(), Date and Time Functions
Yen sign (Japanese), MySQL 5.0 FAQ 鈥� MySQL Chinese, Japanese, and Korean Character Sets

Prev聽	聽	聽
Appendix聽H.聽Credits聽	Home	聽