Index

Symbols  | A  | B  | C  | D  | E  | F  | G  | H  | I  | J  | K  | L  | M  | N  | O  | P  | Q  | R  | S  | T  | U  | V  | W  | X  | Y  | Z

Symbols

[index top]
! (logical NOT), Logical Operators
!= (not equal), Comparison Functions and Operators
", Schema Object Names
#mysql50 identifier prefix, Schema Object Names, Mapping of Identifiers to File Names
%, Arithmetic Operators
% (modulo), Mathematical Functions
% (wildcard character), Strings
& (bitwise AND), Bit Functions
&& (logical AND), Logical Operators
() (parentheses), Operator Precedence
(Control-Z) \Z, Strings, LOAD DATA INFILE Syntax
* (multiplication), Arithmetic Operators
+ (addition), Arithmetic Operators
- (subtraction), Arithmetic Operators
- (unary minus), Arithmetic Operators
--password option, End-User Guidelines for Password Security
-p option, End-User Guidelines for Password Security
.my.cnf file, Connecting to the MySQL Server, Using Option Files, Causes of Access-Denied Errors, End-User Guidelines for Password Security, Using Client Programs in a Multiple-Server Environment
.mysql_history file, mysql Options, End-User Guidelines for Password Security
.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
\" (double quote), Strings
\' (single quote), Strings
\. (mysql client command), Using mysql in Batch Mode, Executing SQL Statements from a Text File
\0 (ASCII NUL), Strings, LOAD DATA INFILE Syntax
\b (backspace), Strings, LOAD DATA INFILE Syntax
\n (linefeed), Strings, LOAD DATA INFILE Syntax
\n (newline), Strings, LOAD DATA INFILE Syntax
\N (NULL), LOAD DATA INFILE Syntax
\r (carriage return), Strings, LOAD DATA INFILE Syntax
\t (tab), Strings, LOAD DATA INFILE Syntax
\Z (Control-Z) ASCII 26, Strings, LOAD DATA INFILE Syntax
\\ (escape), Strings
^ (bitwise XOR), Bit Functions
_ (wildcard character), Strings
_rowid, CREATE TABLE Syntax
`, Schema Object Names
| (bitwise OR), Bit Functions
|| (logical OR), Logical Operators
~, Bit Functions

A

[index top]
abort-slave-event-count option
mysqld, Replication Slave Options and Variables
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 names, Specifying Account Names
account privileges
adding, Adding User Accounts
accounts
anonymous user, Securing the Initial MySQL Accounts
root, Securing the Initial MySQL Accounts
ACID, Transactions and Atomic Operations, The InnoDB Storage Engine
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 User Accounts
new functions, Adding New Functions to MySQL
new user privileges, Adding User Accounts
new users, Installing MySQL from tar.gz Packages 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
administration
server, mysqladmin — Client for Administering a MySQL Server
administrative programs, Overview of MySQL Programs
AES_DECRYPT(), Encryption and Compression Functions
AES_ENCRYPT(), Encryption and Compression Functions
After create
thread state, General Thread States
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 Columns
for tables, SELECT Syntax
in GROUP BY clauses, GROUP BY and HAVING with Hidden Columns
names, Schema Object Names
on expressions, SELECT Syntax
ALL, SELECT Syntax, Subqueries with ALL
ALL join type
optimizer, Optimizing Queries with EXPLAIN
all option
mysqlbackup, mysqlbackup — Display Backup Information
all-databases option
mysqlcheck, mysqlcheck — A Table Maintenance Program
mysqldump, mysqldump — A Database Backup Program
all-in-1 option
mysqlcheck, mysqlcheck — A Table Maintenance Program
allocating local table
thread state, Delayed-Insert Thread States
allow-keywords option
mysqldump, mysqldump — A Database Backup Program
allow-suspicious-udfs option
mysqld, Server Command Options, Security-Related mysqld Options
allowold option
mysqlhotcopy, mysqlhotcopy — A Database Backup Program
ALLOW_INVALID_DATES SQL mode, Server SQL Modes
ALTER COLUMN, ALTER TABLE Syntax
ALTER DATABASE, ALTER DATABASE Syntax
ALTER EVENT, ALTER EVENT Syntax
ALTER FUNCTION, ALTER FUNCTION Syntax
ALTER PROCEDURE, ALTER PROCEDURE Syntax
ALTER SCHEMA, ALTER DATABASE Syntax
ALTER SERVER, ALTER SERVER 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 Program
ANALYZE TABLE, ANALYZE TABLE Syntax
and partitioning, Maintenance of Partitions
Analyzing
thread state, General Thread States
AND
bitwise, Bit Functions
logical, Logical Operators
anonymous user, Securing the Initial MySQL Accounts, Access Control, Stage 1: Connection Verification, Access Control, Stage 2: Request Verification
ANSI mode
running, Running MySQL in ANSI Mode
ansi option
mysqld, Server Command Options
ANSI SQL mode, Server SQL Modes
ANSI_QUOTES SQL mode, Server SQL Modes
answering questions
etiquette, Guidelines for Using the Mailing Lists
ANY, Subqueries with ANY, IN, and SOME
Apache, Using MySQL with Apache
API's
list of, Packages that support MySQL
APIs, Connectors and APIs
Perl, MySQL Perl API
apply-slave-statements option
mysqldump, mysqldump — A Database Backup Program
approximate-value literals, Precision Math
ARCHIVE storage engine, Storage Engines, 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
attribute promotion
replication, Replication of Columns Having Different Data Types
auto-generate-sql option
mysqlslap, mysqlslap — Load Emulation Client
auto-generate-sql-add-autoincrement option
mysqlslap, mysqlslap — Load Emulation Client
auto-generate-sql-execute-number option
mysqlslap, mysqlslap — Load Emulation Client
auto-generate-sql-guid-primary option
mysqlslap, mysqlslap — Load Emulation Client
auto-generate-sql-load-type option
mysqlslap, mysqlslap — Load Emulation Client
auto-generate-sql-secondary-indexes option
mysqlslap, mysqlslap — Load Emulation Client
auto-generate-sql-select-columns option
mysqlslap, mysqlslap — Load Emulation Client
auto-generate-sql-unique-query-number option
mysqlslap, mysqlslap — Load Emulation Client
auto-generate-sql-unique-write-number option
mysqlslap, mysqlslap — Load Emulation Client
auto-generate-sql-write-number option
mysqlslap, mysqlslap — Load Emulation Client
AUTO-INCREMENT
ODBC, Obtaining Auto-Increment Values
auto-rehash option
mysql, mysql Options
auto-repair option
mysqlcheck, mysqlcheck — A Table Maintenance Program
auto-vertical-output option
mysql, mysql Options
autoclose option
mysqld_safe, mysqld_safe — MySQL Server Startup Script
autocommit session variable, Session System Variables
automatic_sp_privileges system variable, Server System Variables
AUTO_INCREMENT, Using AUTO_INCREMENT, Numeric Types
and NULL values, Problems with NULL Values
and replication, Replication and AUTO_INCREMENT
auto_increment_increment system variable, Replication Master Options and Variables
auto_increment_offset system variable, Replication Master Options and Variables
AVG(), GROUP BY (Aggregate) Functions
AVG(DISTINCT), GROUP BY (Aggregate) Functions

B

[index top]
backslash
escape character, Literal Values
backspace (\b), Strings, LOAD DATA INFILE Syntax
BACKUP DATABASE, BACKUP DATABASE Syntax
BACKUP DATABASE restrictions, Restrictions on BACKUP DATABASE and RESTORE
backup option
myisamchk, myisamchk Repair Options
myisampack, myisampack — Generate Compressed, Read-Only MyISAM Tables
backupdir system variable, Server System Variables
backups, Backup and Recovery
databases and tables, mysqldump — A Database Backup Program, mysqlhotcopy — A Database Backup Program
backup_history_log system variable, Server System Variables
backup_history_log_file system variable, Server System Variables
backup_progress_log system variable, Server System Variables
backup_progress_log_file system variable, Server System Variables
backup_wait_timeout session variable, Session System Variables
back_log system variable, Server System Variables
base64-output option
mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files
basedir option
mysql.server, mysql.server — MySQL Server Startup Script
mysqld, Server Command Options
mysqld_safe, mysqld_safe — MySQL Server Startup Script
mysql_install_db, mysql_install_db — Initialize MySQL Data Directory
mysql_upgrade, mysql_upgrade — Check Tables for MySQL Upgrade
basedir system variable, Server System Variables
batch mode, Using mysql in Batch Mode
batch option
mysql, mysql Options
batch SQL files, mysql — The MySQL Command-Line Tool
Batched Key Access
optimization, Block Nested-Loop and Batched Key Access Joins, Batched Key Access Joins
Bazaar tree, Installing from the Development Source Tree
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
BETWEEN ... AND, Comparison Functions and Operators
big-tables option
mysqld, Server Command Options
big5, MySQL 6.0 FAQ — MySQL Chinese, Japanese, and Korean Character Sets
BIGINT data type, Overview of Numeric Types
big_tables session variable, Session System Variables
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 Sun Microsystems, Inc.
installing, Installing MySQL from tar.gz Packages on Other Unix-Like Systems
on Linux, Linux Binary Distribution Notes
binary log, The Binary Log
event groups, SET GLOBAL SQL_SLAVE_SKIP_COUNTER Syntax
bind-address option
mysqld, Server Command Options
BINLOG, BINLOG Syntax
Binlog Dump
thread command, Thread Command Values
BINLOG statement
mysqlbinlog output, mysqlbinlog Row Event Display
binlog-do-db option
mysqld, Binary Log Options and Variables
binlog-format option
mysqld, Server Command Options
binlog-ignore-db option
mysqld, Binary Log Options and Variables
binlog-row-event-max-size option
mysqld, Binary Log Options and Variables
binlog_cache_size system variable, Binary Log Options and Variables
binlog_format system variable, Binary Log Options and Variables
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, 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 Nested-Loop
optimization, Block Nested-Loop and Batched Key Access Joins, Block Nested-Loop Algorithm for Outer Joins and Semi-Joins
Block Nested-Loop join algorithm, Nested-Loop Join Algorithms
block-search option
myisamchk, Other myisamchk Options
BOOL data type, Overview of Numeric Types
BOOLEAN data type, Overview of Numeric Types
boolean options, Program Option Modifiers
bootstrap option
mysqld, Server Command Options
Borland Builder 4, Using Connector/ODBC with Borland Builder 4
Boundary(), General Geometry Functions
brackets
square, Data Types
brief option
mysqlaccess, mysqlaccess — Client for Checking Access Privileges
buffer sizes
client, Connectors and APIs
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
bulk_insert_buffer_size system variable, Server System Variables
burnin option
mysqlslap, mysqlslap — Load Emulation Client

C

[index top]
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
and partitioning, Restrictions and Limitations on Partitioning
caches
clearing, FLUSH Syntax
calculating
dates, Date Calculations
calendar, What Calendar Is Used By MySQL?
CALL, CALL 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, LOAD DATA INFILE Syntax
CASE, Control Flow Functions, CASE Statement
case sensitivity
in access checking, Privilege System Grant Tables
in identifiers, Identifier Case Sensitivity
in names, Identifier Case Sensitivity
in searches, Case Sensitivity in String 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
catalog-details option
mysqlbackup, mysqlbackup — Display Backup Information
catalog-summary option
mysqlbackup, mysqlbackup — Display Backup Information
CC environment variable, Typical configure Options, Dealing with Problems Compiling MySQL, Environment Variables
cc1plus problems, Dealing with Problems Compiling MySQL
CEIL(), Mathematical Functions
CEILING(), Mathematical Functions
Centroid(), MultiPolygon Functions
CFLAGS environment variable, Typical configure Options, Dealing with Problems Compiling MySQL, Environment Variables
cflags option
mysql_config, mysql_config — Get Compile Options for Compiling Clients
CHANGE MASTER TO, CHANGE MASTER TO Syntax
Change user
thread command, Thread Command Values
ChangeLog, MySQL Change History
changes
log, MySQL Change History
MySQL 5.2, Changes in Release 5.2.x (Development)
MySQL 6.0, Changes in Release 6.0.x (Development)
changes to privileges, When Privilege Changes Take Effect
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 master
thread state, Replication Slave Connection Thread States
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
and replication, Replication and Character Sets
Character sets, Character Set Support
CHARACTER VARYING data type, Overview of String Types
character-set-client-handshake option
mysqld, Server Command Options
character-set-filesystem option
mysqld, Server Command Options
character-set-server option
mysqld, Server 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 Program
mysqld, Server 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
character_sets_dir system variable, Server System Variables
character_set_client system variable, Server System Variables
character_set_connection system variable, Server System Variables
character_set_database system variable, Server System Variables
character_set_filesystem system variable, Server System Variables
character_set_results system variable, Server System Variables
character_set_server system variable, Server System Variables
character_set_system system variable, Server System Variables
charset command
mysql, mysql Commands
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 Program
check options
myisamchk, myisamchk Check Options
CHECK TABLE, CHECK TABLE Syntax
and partitioning, Maintenance of Partitions
check-only-changed option
myisamchk, myisamchk Check Options
mysqlcheck, mysqlcheck — A Table Maintenance Program
check-upgrade option
mysqlcheck, mysqlcheck — A Table Maintenance Program
checking
tables for errors, How to Check MyISAM Tables for Errors
Checking master version
thread state, Replication Slave I/O Thread States
checking permissions
thread state, General Thread States
Checking table
thread state, General Thread States
checkpoint option
mysqlhotcopy, mysqlhotcopy — A Database Backup Program
checksum errors, Solaris Notes
CHECKSUM TABLE, CHECKSUM TABLE Syntax
Chinese, Japanese, Korean character sets
frequently asked questions, MySQL 6.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, Server Command Options
mysqlhotcopy, mysqlhotcopy — A Database Backup Program
CJK
FAQ, MySQL 6.0 FAQ — MySQL Chinese, Japanese, and Korean Character Sets
CJK (Chinese, Japanese, Korean)
Access, PHP, etc., MySQL 6.0 FAQ — MySQL Chinese, Japanese, and Korean Character Sets
availability of specific characters, MySQL 6.0 FAQ — MySQL Chinese, Japanese, and Korean Character Sets
available character sets, MySQL 6.0 FAQ — MySQL Chinese, Japanese, and Korean Character Sets
big5, MySQL 6.0 FAQ — MySQL Chinese, Japanese, and Korean Character Sets
character sets available, MySQL 6.0 FAQ — MySQL Chinese, Japanese, and Korean Character Sets
characters displayed as question marks, MySQL 6.0 FAQ — MySQL Chinese, Japanese, and Korean Character Sets
CJKV, MySQL 6.0 FAQ — MySQL Chinese, Japanese, and Korean Character Sets
collations, MySQL 6.0 FAQ — MySQL Chinese, Japanese, and Korean Character Sets
conversion problems with Japanese character sets, MySQL 6.0 FAQ — MySQL Chinese, Japanese, and Korean Character Sets
data truncation, MySQL 6.0 FAQ — MySQL Chinese, Japanese, and Korean Character Sets
Database and table names, MySQL 6.0 FAQ — MySQL Chinese, Japanese, and Korean Character Sets
documentation in Chinese, MySQL 6.0 FAQ — MySQL Chinese, Japanese, and Korean Character Sets
documentation in Japanese, MySQL 6.0 FAQ — MySQL Chinese, Japanese, and Korean Character Sets
documentation in Korean, MySQL 6.0 FAQ — MySQL Chinese, Japanese, and Korean Character Sets
gb2312, gbk, MySQL 6.0 FAQ — MySQL Chinese, Japanese, and Korean Character Sets
Japanese character sets, MySQL 6.0 FAQ — MySQL Chinese, Japanese, and Korean Character Sets
Korean character set, MySQL 6.0 FAQ — MySQL Chinese, Japanese, and Korean Character Sets
LIKE and FULLTEXT, MySQL 6.0 FAQ — MySQL Chinese, Japanese, and Korean Character Sets
MySQL 4.0 behavior, MySQL 6.0 FAQ — MySQL Chinese, Japanese, and Korean Character Sets
ORDER BY treatment, MySQL 6.0 FAQ — MySQL Chinese, Japanese, and Korean Character Sets
problems with Access, PHP, etc., MySQL 6.0 FAQ — MySQL Chinese, Japanese, and Korean Character Sets
problems with Big5 character sets (Chinese), MySQL 6.0 FAQ — MySQL Chinese, Japanese, and Korean Character Sets
problems with data truncation, MySQL 6.0 FAQ — MySQL Chinese, Japanese, and Korean Character Sets
problems with euckr character set (Korean), MySQL 6.0 FAQ — MySQL Chinese, Japanese, and Korean Character Sets
problems with GB character sets (Chinese), MySQL 6.0 FAQ — MySQL Chinese, Japanese, and Korean Character Sets
problems with LIKE and FULLTEXT, MySQL 6.0 FAQ — MySQL Chinese, Japanese, and Korean Character Sets
problems with Yen sign (Japanese), MySQL 6.0 FAQ — MySQL Chinese, Japanese, and Korean Character Sets
rejected characters, MySQL 6.0 FAQ — MySQL Chinese, Japanese, and Korean Character Sets
sort order problems, MySQL 6.0 FAQ — MySQL Chinese, Japanese, and Korean Character Sets
sorting problems, MySQL 6.0 FAQ — MySQL Chinese, Japanese, and Korean Character Sets
testing availability of characters, MySQL 6.0 FAQ — MySQL Chinese, Japanese, and Korean Character Sets
Unicode collations, MySQL 6.0 FAQ — MySQL Chinese, Japanese, and Korean Character Sets
Vietnamese, MySQL 6.0 FAQ — MySQL Chinese, Japanese, and Korean Character Sets
Yen sign, MySQL 6.0 FAQ — MySQL Chinese, Japanese, and Korean Character Sets
cleaning up
thread state, General Thread States
clear command
mysql, mysql Commands
Clearing
thread state, Event Scheduler Thread States
clearing
caches, FLUSH Syntax
client connection threads, How MySQL Uses Threads for Client Connections
client programs, Overview of MySQL Programs
building, Building Client Programs
client tools, Connectors and APIs
clients
debugging, Debugging a MySQL Client
threaded, How to Make a Threaded Client
CLOSE, Cursor CLOSE Statement
Close stmt
thread command, Thread Command Values
closing
tables, How MySQL Opens and Closes Tables
closing tables
thread state, General Thread States
clustered index
InnoDB, Clustered and Secondary Indexes
CMake, Building MySQL from Source Using CMake and Visual Studio
COALESCE(), Comparison Functions and Operators
COERCIBILITY(), Information Functions
ColdFusion, Using Connector/ODBC with ColdFusion
collating
strings, String Collating Support
collation
adding, How to Add a New Collation to a Character Set
COLLATION(), Information Functions
collation-server option
mysqld, Server 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
collation_connection system variable, Server System Variables
collation_database system variable, Server System Variables
collation_server system variable, Server System Variables
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
column-type-info option
mysql, mysql Options
columns
changing, How to Change the Order of Columns in a Table
displaying, mysqlshow — Display Database, Table, and Column Information
indexes, Column Indexes
names, Schema Object 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
mysqladmin, mysqladmin — Client for Administering a MySQL Server
mysqld, Server Command Options
command syntax, Typographical and Syntax Conventions, Conventions Used in This Document
command-line history
mysql, mysql Options
command-line tool, mysql — The MySQL Command-Line Tool
commands
for binary distribution, Installing MySQL from tar.gz Packages 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
mysql, mysql Options
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
mysqlslap, mysqlslap — Load Emulation Client
compact option
mysqldump, mysqldump — A Database Backup Program
comparison operators, Comparison Functions and Operators
compatibility
between MySQL versions, Upgrading from MySQL 5.1 to 6.0
with mSQL, Regular Expressions
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
completion_type system variable, Server System Variables
compliance
Y2K, Year 2000 Issues and Date Types
composite partitioning, Subpartitioning
compound statements, MySQL Compound-Statement Syntax
compress option
mysql, mysql Options
mysqladmin, mysqladmin — Client for Administering a MySQL Server
mysqlcheck, mysqlcheck — A Table Maintenance Program
mysqldump, mysqldump — A Database Backup Program
mysqlimport, mysqlimport — A Data Import Program
mysqlshow, mysqlshow — Display Database, Table, and Column Information
mysqlslap, mysqlslap — Load Emulation Client
COMPRESS(), Encryption and Compression Functions
compressed tables, myisampack — Generate Compressed, Read-Only MyISAM Tables, Compressed Table Characteristics
comp_err, Overview of MySQL Programs, comp_err — Compile MySQL Error Message File
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
concatenation
string, Strings, String Functions
CONCAT_WS(), String Functions
concurrency option
mysqlslap, mysqlslap — Load Emulation Client
concurrent inserts, Internal Locking Methods, Concurrent Inserts
concurrent_insert system variable, Server System Variables
Conditions, DECLARE for Conditions
config-file option
mysqld_multi, mysqld_multi — Manage Multiple MySQL Servers
my_print_defaults, my_print_defaults — Display Options from Option Files
config.cache, Dealing with Problems Compiling MySQL
config.cache file, Dealing with Problems Compiling MySQL
configuration files, Causes of Access-Denied Errors
configuration options, Typical configure Options
configure
disable-grant-options option, Typical configure Options
enable-community-features option, Typical configure Options
enable-debug-sync option, Typical configure Options
enable-dtrace option, Typical configure Options
enable-profiling option, Typical configure Options
enable-thread-safe-client option, Typical configure Options
localstatedir option, Typical configure Options
prefix 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-client-ldflags 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-libevent option, Typical configure Options
with-unix-socket-path option, Typical configure Options
with-zlib-dir 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
Connect
thread command, Thread Command Values
connect command
mysql, mysql Commands
Connect Out
thread command, Thread Command Values
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
Connecting to master
thread state, Replication Slave I/O Thread States
connection
aborted, Communication Errors and Aborted Connections
CONNECTION_ID(), Information Functions
Connector/C, Connectors and APIs
Connector/C++, Connectors and APIs
Connector/JDBC, Connectors and APIs
Connector/MXJ, Connectors and APIs
Connector/NET, Connectors and APIs, MySQL Connector/NET
reporting problems, Connector/NET Support
Connector/ODBC, Connectors and APIs, MySQL Connector/ODBC
Borland, Using Connector/ODBC with Borland Applications
Borland Database Engine, Using Connector/ODBC with Borland Applications
reporting problems, Connector/ODBC Support
Connector/OpenOffice.org, Connectors and APIs
Connectors
MySQL, Connectors and APIs
connect_timeout system variable, Server System Variables
connect_timeout variable, mysql Options, mysqladmin — Client for Administering a MySQL Server
console option
mysqld, Server Command Options
const table
optimizer, Optimizing Queries with EXPLAIN, SELECT Syntax
constant table, 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 flow functions, Control Flow Functions
CONV(), Mathematical Functions
conventions
syntax, Typographical and Syntax Conventions
typographical, Typographical and Syntax Conventions, Conventions Used in This Document
CONVERT, Cast Functions and Operators
CONVERT TO, ALTER TABLE Syntax
converting HEAP to MyISAM
thread state, General Thread States
CONVERT_TZ(), Date and Time Functions
ConvexHull(), Spatial Operators
copy option
mysqlaccess, mysqlaccess — Client for Checking Access Privileges
copy to tmp table
thread state, General Thread States
copying databases, Copying MySQL Databases to Another Machine
copying tables, CREATE TABLE Syntax
Copying to group table
thread state, General Thread States
Copying to tmp table
thread state, General Thread States
Copying to tmp table on disk
thread state, General Thread States
core-file option
mysqld, Server 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, Debugging a MySQL Server
recovery, Using myisamchk for Crash Recovery
repeated, What to Do If MySQL Keeps Crashing
replication, Replication During a Master Crash
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 DB
thread command, Thread Command Values
CREATE EVENT, CREATE EVENT Syntax
CREATE FUNCTION, CREATE PROCEDURE and CREATE FUNCTION Syntax, CREATE FUNCTION Syntax
CREATE INDEX, CREATE INDEX Syntax
create option
mysqlslap, mysqlslap — Load Emulation Client
CREATE PROCEDURE, CREATE PROCEDURE and CREATE FUNCTION Syntax
CREATE SCHEMA, CREATE DATABASE Syntax
CREATE SERVER, CREATE SERVER Syntax
CREATE TABLE, CREATE TABLE Syntax
DIRECTORY options
and replication, Replication and DIRECTORY Table Options
CREATE TABLE ... SELECT
and replication, Replication of CREATE TABLE ... SELECT Statements
CREATE TRIGGER, CREATE TRIGGER Syntax
CREATE USER, CREATE USER Syntax
CREATE VIEW, CREATE VIEW Syntax
create-options option
mysqldump, mysqldump — A Database Backup Program
create-schema option
mysqlslap, mysqlslap — Load Emulation Client
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 delayed handler
thread state, Delayed-Insert Thread States
Creating index
thread state, General Thread States
Creating sort index
thread state, General Thread States
creating table
thread state, General Thread States
Creating tmp table
thread state, General Thread States
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 option
mysqlslap, mysqlslap — Load Emulation Client
CSV storage engine, Storage Engines, 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

[index top]
Daemon
thread command, Thread Command Values
data
character sets, The Character Set Used for Data and Sorting
importing, Executing SQL Statements from a Text File, mysqlimport — A Data Import Program
loading into tables, Loading Data into a Table
retrieving, Retrieving Information from a Table
size, Make Your Data as Small as Possible
DATA DIRECTORY
and replication, Replication and DIRECTORY Table Options
Data truncation with CJK characters, MySQL 6.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
NATIONAL VARCHAR, Overview of String Types
NCHAR, Overview of String Types
NUMERIC, Overview of Numeric Types
NVARCHAR, Overview of String 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-chunks option
mysqlbackup, mysqlbackup — Display Backup Information
data-file-length option
myisamchk, myisamchk Repair Options
data-totals option
mysqlbackup, mysqlbackup — Display Backup Information
database
altering, ALTER DATABASE Syntax
creating, CREATE DATABASE Syntax
deleting, DROP DATABASE Syntax
Database information
obtaining, SHOW Syntax
database metadata, INFORMATION_SCHEMA Tables
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, Backup and Recovery
copying, Copying MySQL Databases to Another Machine
creating, Creating and Using a Database
defined, What is MySQL?
displaying, mysqlshow — Display Database, Table, and Column Information
dumping, mysqldump — A Database Backup Program, mysqlhotcopy — A Database Backup Program
information about, Getting Information About Databases and Tables
names, Schema Object 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 Program
mysqldump, mysqldump — A Database Backup Program
datadir option
mysql.server, mysql.server — MySQL Server Startup Script
mysqld, Server Command Options
mysqld_safe, mysqld_safe — MySQL Server Startup Script
mysql_install_db, mysql_install_db — Initialize MySQL Data Directory
mysql_upgrade, mysql_upgrade — Check Tables for MySQL Upgrade
datadir system variable, Server System Variables
DataJunction, Using Connector/ODBC with Pervasive Software DataJunction
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 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
dates
used with partitioning, Partition Types
used with partitioning (examples), RANGE Partitioning, HASH Partitioning, Subpartitioning, Partition Pruning
DATETIME data type, Overview of Date and Time Types, The DATETIME, DATE, and TIMESTAMP Types
datetime_format system variable, Server System Variables
DATE_ADD(), Date and Time Functions
date_format system variable, Server System Variables
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, Server SQL Modes
DBI interface, MySQL Perl API
DBI->quote, Strings
DBI->trace, Debugging mysqld under gdb
DBI/DBD interface, MySQL Perl API
DBI_TRACE environment variable, Environment Variables, Debugging mysqld under gdb
DBI_USER environment variable, Environment Variables
DBUG package, The DBUG Package
DEALLOCATE PREPARE, SQL Syntax for Prepared Statements, DEALLOCATE PREPARE Syntax
Debug
thread command, Thread Command Values
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
mysqlbackup, mysqlbackup — Display Backup Information
mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files
mysqlcheck, mysqlcheck — A Table Maintenance Program
mysqld, Server Command Options
mysqldump, mysqldump — A Database Backup Program
mysqldumpslow, mysqldumpslow — Summarize Slow Query Log Files
mysqlhotcopy, mysqlhotcopy — A Database Backup Program
mysqlimport, mysqlimport — A Data Import Program
mysqlshow, mysqlshow — Display Database, Table, and Column Information
mysqlslap, mysqlslap — Load Emulation Client
my_print_defaults, my_print_defaults — Display Options from Option Files
debug system variable, Server System Variables
debug-check 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 Program
mysqldump, mysqldump — A Database Backup Program
mysqlimport, mysqlimport — A Data Import Program
mysqlshow, mysqlshow — Display Database, Table, and Column Information
mysqlslap, mysqlslap — Load Emulation Client
mysql_upgrade, mysql_upgrade — Check Tables for MySQL Upgrade
debug-info option
comp_err, comp_err — Compile MySQL Error Message File
mysql, mysql Options
mysqladmin, mysqladmin — Client for Administering a MySQL Server
mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files
mysqlcheck, mysqlcheck — A Table Maintenance Program
mysqldump, mysqldump — A Database Backup Program
mysqlimport, mysqlimport — A Data Import Program
mysqlshow, mysqlshow — Display Database, Table, and Column Information
mysqlslap, mysqlslap — Load Emulation Client
mysql_upgrade, mysql_upgrade — Check Tables for MySQL Upgrade
debug-sync-timeout option
mysqld, Server Command Options
debugging
client, Debugging a MySQL Client
server, Debugging a MySQL Server
debugging support, Typical configure Options
debug_sync system variable, Server System Variables
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 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 host name, 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 Program
mysqld, Server 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, Server Command Options
default-storage-engine option
mysqld, Server Command Options
default-table-type option
mysqld, Server Command Options
default-time-zone option
mysqld, Server Command Options
defaults
embedded, Options with the Embedded Server
defaults-extra-file option, Command-Line Options that Affect Option-File Handling
mysqld_multi, mysqld_multi — Manage Multiple MySQL Servers
mysqld_safe, mysqld_safe — MySQL Server Startup Script
my_print_defaults, my_print_defaults — Display Options from Option Files
defaults-file option, Command-Line Options that Affect Option-File Handling
mysqld_multi, mysqld_multi — Manage Multiple MySQL Servers
mysqld_safe, mysqld_safe — MySQL Server Startup Script
my_print_defaults, my_print_defaults — Display Options from Option Files
defaults-group-suffix option, Command-Line Options that Affect Option-File Handling
my_print_defaults, my_print_defaults — Display Options from Option Files
default_week_format system variable, Server System Variables
DEGREES(), Mathematical Functions
delay-key-write option
mysqld, Server Command Options, MyISAM Startup Options
DELAYED, INSERT DELAYED Syntax
when ignored, INSERT Syntax
Delayed insert
thread command, Thread Command Values
delayed inserts
thread states, Delayed-Insert Thread States
delayed-insert option
mysqldump, mysqldump — A Database Backup Program
delayed-start option
mysqlslap, mysqlslap — Load Emulation Client
delayed_insert_limit, INSERT DELAYED Syntax
delayed_insert_limit system variable, Server System Variables
delayed_insert_timeout system variable, Server System Variables
delayed_queue_size system variable, Server System Variables
delay_key_write system variable, Server System Variables
DELETE, DELETE Syntax
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, DROP USER Syntax
users, Removing User Accounts, DROP USER Syntax
deleting from main table
thread state, General Thread States
deleting from reference tables
thread state, General Thread States
deletion
mysql.sock, How to Protect or Change the MySQL Unix Socket File
delimiter command
mysql, mysql Commands
delimiter option
mysql, mysql Options
mysqlslap, mysqlslap — Load Emulation Client
Delphi, Using Connector/ODBC with Delphi
derived tables, Subqueries in the FROM clause
des-key-file option
mysqld, Server Command Options
DESC, DESCRIBE Syntax
DESCRIBE, Getting Information About Databases and Tables, DESCRIBE Syntax
description option
myisamchk, Other myisamchk Options
design
issues, Known Issues in MySQL
limitations, MySQL Design Limitations and Tradeoffs
DES_DECRYPT(), Encryption and Compression Functions
DES_ENCRYPT(), Encryption and Compression Functions
detach option
mysqlslap, mysqlslap — Load Emulation Client
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 named command
mysql, mysql Options
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
discard_or_import_tablespace
thread state, General Thread States
disconnect-slave-event-count option
mysqld, Replication Slave Options and Variables
disconnecting
from the server, Connecting to and Disconnecting from the Server
Disjoint(), Functions That Test Spatial Relationships Between Geometries
disk full, How MySQL Handles a Full Disk
disk issues, Disk Issues
disks
splitting data across, Using Symbolic Links for Databases on Windows
display size, Data Types
display triggers, SHOW TRIGGERS Syntax
display width, Data Types
displaying
database information, mysqlshow — Display Database, Table, and Column Information
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
div_precision_increment system variable, Server System Variables
DNS, How MySQL Uses DNS
DO, DO Syntax
DocBook XML
documentation source format, About This Manual
Documentation
in Chinese, MySQL 6.0 FAQ — MySQL Chinese, Japanese, and Korean Character Sets
in Japanese, MySQL 6.0 FAQ — MySQL Chinese, Japanese, and Korean Character Sets
in Korean, MySQL 6.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
downgrading, Upgrading or Downgrading MySQL, Downgrading MySQL
downloading, How to Get MySQL
drbd
FAQ, MySQL 6.0 FAQ — MySQL, DRBD, and Heartbeat
DRBD, Distributed Replicated Block Device (DRBD) Basics
DRBD license, Distributed Replicated Block Device (DRBD) Basics
DROP ... IF EXISTS
and replication, Replication of DROP ... IF EXISTS Statements
DROP DATABASE, DROP DATABASE Syntax
Drop DB
thread command, Thread Command Values
DROP EVENT, DROP EVENT 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, DEALLOCATE PREPARE Syntax
DROP PRIMARY KEY, ALTER TABLE Syntax
DROP PROCEDURE, DROP PROCEDURE and DROP FUNCTION Syntax
DROP SCHEMA, DROP DATABASE Syntax
DROP SERVER, DROP SERVER Syntax
DROP TABLE, DROP TABLE Syntax
DROP TRIGGER, DROP TRIGGER Syntax
DROP USER, DROP USER Syntax
DROP VIEW, DROP VIEW Syntax
dropping
user, Removing User Accounts, 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
dump-date option
mysqldump, mysqldump — A Database Backup Program
dump-slave option
mysqldump, mysqldump — A Database Backup Program
DUMPFILE, SELECT Syntax
dumping
databases and tables, mysqldump — A Database Backup Program, mysqlhotcopy — A Database Backup Program
dynamic table characteristics, Dynamic Table Characteristics

E

[index top]
edit command
mysql, mysql Commands
ego command
mysql, mysql Commands
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
mysql_config, mysql_config — Get Compile Options for Compiling Clients
enable-community-features option
configure, Typical configure Options
enable-debug-sync option
configure, Typical configure Options
enable-dtrace option
configure, Typical configure Options
enable-named-pipe option
mysqld, Server Command Options
enable-profiling option
configure, Typical configure Options
enable-pstack option
mysqld, Server 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
thread state, General Thread States
END, BEGIN ... END Compound Statement Syntax
EndPoint(), LineString Functions
engine option
mysqlslap, mysqlslap — Load Emulation Client
ENGINES
INFORMATION_SCHEMA table, The INFORMATION_SCHEMA ENGINES Table
engine_condition_pushdown system variable, Server System Variables
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, Environment Variables
CFLAGS, Typical configure Options, Dealing with Problems Compiling MySQL, Environment Variables
CXX, Typical configure Options, Dealing with Problems Compiling MySQL, Environment Variables
CXXFLAGS, Typical configure Options, Dealing with Problems Compiling MySQL, Environment Variables
DBI_TRACE, Environment Variables, Debugging mysqld under gdb
DBI_USER, Environment Variables
HOME, Environment Variables, mysql Options
LD_LIBRARY_PATH, Problems Using the Perl DBI/DBD Interface
LD_RUN_PATH, Linux Source Distribution Notes, Solaris Notes, Environment Variables, Problems Using the Perl DBI/DBD Interface
MYSQL_DEBUG, Environment Variables, Overview of MySQL Programs, Debugging a MySQL Client
MYSQL_GROUP_SUFFIX, Environment Variables
MYSQL_HISTFILE, Environment Variables, mysql Options
MYSQL_HOME, Environment Variables
MYSQL_HOST, Environment Variables, Connecting to the MySQL Server
MYSQL_PS1, Environment Variables
MYSQL_PWD, Environment Variables, Overview of MySQL Programs, Connecting to the MySQL Server
MYSQL_TCP_PORT, Environment Variables, Overview of MySQL Programs, Running Multiple Servers on Unix, Using Client Programs in a Multiple-Server Environment
MYSQL_UNIX_PORT, Problems Running mysql_install_db, Environment Variables, Overview of MySQL Programs, Running Multiple Servers on Unix, Using Client Programs in a Multiple-Server Environment
PATH, Installing MySQL from tar.gz Packages on Other Unix-Like Systems, Environment Variables, Invoking MySQL Programs
TMPDIR, Problems Running mysql_install_db, Environment Variables, Overview of MySQL Programs, Where MySQL Stores Temporary Files
TZ, Environment Variables, Time Zone Problems
UMASK, Environment Variables, Problems with File Permissions
UMASK_DIR, Environment Variables, Problems with File Permissions
USER, Environment Variables, Connecting to the MySQL Server
environment variables, Overview of MySQL Programs, Setting Environment Variables, Causes of Access-Denied Errors
CXX, Dealing with Problems Compiling MySQL
list of, Environment Variables
equal (=), Comparison Functions and Operators
Equals(), Functions That Test Spatial Relationships Between Geometries
eq_ref join type
optimizer, Optimizing Queries with EXPLAIN
Errcode, perror — Explain Error Codes
errno, perror — Explain Error Codes
Error
thread command, Thread Command Values
error messages
can't find file, Problems with File Permissions
displaying, perror — Explain Error Codes
languages, Setting the Error Message Language
errors
access denied, Access denied
and replication, Slave Errors during Replication
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
lost connection, Lost connection to MySQL server
reporting, General Information, How to Report Bugs or Problems
error_count session variable, Session System Variables
ERROR_FOR_DIVISION_BY_ZERO SQL mode, Server SQL Modes
escape (\\), Strings
escape characters, Literal Values
estimating
query performance, Estimating Query Performance
event groups, SET GLOBAL SQL_SLAVE_SKIP_COUNTER Syntax
event restrictions, Restrictions on Stored Routines, Triggers, and Events
event scheduler, Stored Programs and Views
thread states, Event Scheduler Thread States
Event Scheduler, Using the Event Scheduler
altering events, ALTER EVENT Syntax
and MySQL privileges, The Event Scheduler and MySQL Privileges
and mysqladmin debug, Event Scheduler Status
and replication, Replication of Invoked Features
and SHOW PROCESSLIST, Event Scheduler Configuration
concepts, Event Scheduler Overview
creating events, CREATE EVENT Syntax
dropping events, DROP EVENT Syntax
enabling and disabling, Event Scheduler Configuration
event metadata, Event Metadata
obtaining status information, Event Scheduler Status
SQL statements, Event Syntax
starting and stopping, Event Scheduler Configuration
event-scheduler option
mysqld, Server Command Options
events, Stored Programs and Views, Using the Event Scheduler
altering, ALTER EVENT Syntax
creating, CREATE EVENT Syntax
dropping, DROP EVENT Syntax
metadata, Event Metadata
status variables, The Event Scheduler and MySQL Privileges
EVENTS
INFORMATION_SCHEMA table, The Event Scheduler and MySQL Privileges, The INFORMATION_SCHEMA EVENTS Table
events option
mysqldump, mysqldump — A Database Backup Program
event_scheduler system variable, Server System Variables
exact option
mysqlbackup, mysqlbackup — Display Backup Information
exact-value literals, Precision Math
example option
mysqld_multi, mysqld_multi — Manage Multiple MySQL Servers
EXAMPLE storage engine, Storage Engines, 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
thread command, Thread Command Values
EXECUTE, SQL Syntax for Prepared Statements, EXECUTE Syntax
execute option
mysql, mysql Options
executing
thread state, General Thread States
executing SQL statements from text files, Using mysql in Batch Mode, Executing SQL Statements from a Text File
Execution of init_command
thread state, General Thread States
EXISTS
with subqueries, EXISTS and NOT EXISTS
exit command
mysql, mysql Commands
exit-info option
mysqld, Server Command Options
EXP(), Mathematical Functions
expire_logs_days system variable, Server System Variables
EXPLAIN, Optimizing Queries with EXPLAIN, EXPLAIN Syntax
EXPLAIN PARTITIONS, Obtaining Information About Partitions
EXPLAIN used with partitioned tables, Obtaining Information About Partitions
explicit default values, Data Type Default Values
EXPORT_SET(), String Functions
expression aliases, GROUP BY and HAVING with Hidden Columns, SELECT Syntax
expressions
extended, Pattern Matching
extend-check option
myisamchk, myisamchk Check Options, myisamchk Repair Options
extended option
mysqlcheck, mysqlcheck — A Table Maintenance Program
extended-insert option
mysqldump, mysqldump — A Database Backup Program
extensions
to standard SQL, MySQL Standards Compliance
ExteriorRing(), Polygon Functions
external locking, Server Command Options, Server System Variables, Using myisamchk for Crash Recovery, External Locking, General Thread States
external-locking option
mysqld, Server Command Options
extra-file option
my_print_defaults, my_print_defaults — Display Options from Option Files
EXTRACT(), Date and Time Functions
extracting
dates, Date Calculations
ExtractValue(), XML Functions

F

[index top]
Falcon storage engine, Storage Engines, The Falcon Storage Engine
FALSE, Numbers, Boolean Values
testing for, Comparison Functions and Operators
fast option
myisamchk, myisamchk Check Options
mysqlcheck, mysqlcheck — A Table Maintenance Program
fatal signal 11, Dealing with Problems Compiling MySQL
features of MySQL, The Main Features of MySQL
FEDERATED storage engine, Storage Engines, The FEDERATED Storage Engine
Fetch
thread command, Thread Command Values
FETCH, Cursor FETCH Statement
field
changing, ALTER TABLE Syntax
Field List
thread command, Thread Command Values
FIELD(), String Functions
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 Issues
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, mysqlimport — A Data Import Program
tmp, Problems Running mysql_install_db
FILES
INFORMATION_SCHEMA table, The INFORMATION_SCHEMA FILES Table
filesort optimization, ORDER BY Optimization
FIND_IN_SET(), String Functions
Finished reading one binlog; switching to next binlog
thread state, Replication Master Thread States
first-slave option
mysqldump, mysqldump — A Database Backup Program
fix-db-names option
mysqlcheck, mysqlcheck — A Table Maintenance Program
fix-table-names option
mysqlcheck, mysqlcheck — A Table Maintenance 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
floating-point values
and replication, Replication with Floating-Point Values
floats, Numbers
FLOOR(), Mathematical Functions
FLUSH, FLUSH Syntax
and replication, Replication and FLUSH
flush option
mysqld, Server Command Options
flush system variable, Server System Variables
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
Flushing tables
thread state, General Thread States
flushlog option
mysqlhotcopy, mysqlhotcopy — A Database Backup Program
flush_time system variable, Server System Variables
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 Program
mysqldump, mysqldump — A Database Backup Program
mysqlimport, mysqlimport — A Data Import Program
mysql_convert_table_format, mysql_convert_table_format — Convert Tables to Use a Given Storage Engine
mysql_install_db, mysql_install_db — Initialize MySQL Data Directory
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
foreign_key_checks session variable, Session System Variables
FORMAT(), String Functions
Forums, MySQL Community Support at the MySQL Forums
FOUND_ROWS(), Information Functions
FreeBSD troubleshooting, Dealing with Problems Compiling MySQL
freeing items
thread state, General Thread States
frequently-asked questions about DRBD, MySQL 6.0 FAQ — MySQL, DRBD, and Heartbeat
frequently-asked questions about MySQL Cluster, MySQL 6.0 FAQ — MySQL Cluster
FROM, SELECT Syntax
FROM_DAYS(), Date and Time Functions
FROM_UNIXTIME(), Date and Time Functions
ft_boolean_syntax system variable, Server System Variables
ft_max_word_len myisamchk variable, myisamchk General Options
ft_max_word_len system variable, Server System Variables
ft_min_word_len myisamchk variable, myisamchk General Options
ft_min_word_len system variable, Server System Variables
ft_query_expansion_limit system variable, Server System Variables
ft_stopword_file myisamchk variable, myisamchk General Options
ft_stopword_file system variable, Server System Variables
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
FULLTEXT initialization
thread state, General Thread States
fulltext join type
optimizer, Optimizing Queries with EXPLAIN
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
and replication, Replication and System Functions
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
stored, Using Stored Routines (Procedures and Functions)
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

G

[index top]
gap lock
InnoDB, InnoDB Startup Options and System Variables, The InnoDB Transaction Model and Locking, InnoDB Record, Gap, and Next-Key Locks, Avoiding the Phantom Problem Using Next-Key Locking
gb2312, gbk, MySQL 6.0 FAQ — MySQL Chinese, Japanese, and Korean Character Sets
gcc, Typical configure Options
gdb
using, Debugging mysqld under gdb
gdb option
mysqld, Server Command Options
general information, General Information
General Public License, What is MySQL?
general query log, The General Query Log
general-log option
mysqld, Server Command Options
general_log system variable, Server System Variables
general_log_file system variable, Server System Variables
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
GLOBAL_STATUS
INFORMATION_SCHEMA table, The INFORMATION_SCHEMA GLOBAL_STATUS and SESSION_STATUS Tables
GLOBAL_VARIABLES
INFORMATION_SCHEMA table, The INFORMATION_SCHEMA GLOBAL_VARIABLES and SESSION_VARIABLES Tables
go command
mysql, mysql Commands
goals of MySQL, What is MySQL?
got handler lock
thread state, Delayed-Insert Thread States
got old table
thread state, Delayed-Insert Thread States
GRANT, GRANT Syntax
GRANT statement, Adding User Accounts
grant tables
re-creating, Problems Running mysql_install_db
sorting, Access Control, Stage 1: Connection Verification, Access Control, Stage 2: Request Verification
structure, Privilege System Grant Tables
upgrading, mysql_fix_privilege_tables — Upgrade MySQL System Tables
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 Columns
extensions to standard SQL, GROUP BY and HAVING with Hidden Columns, SELECT Syntax
GROUP BY functions, GROUP BY (Aggregate) Functions
grouping
expressions, Operator Precedence
GROUP_CONCAT(), GROUP BY (Aggregate) Functions
group_concat_max_len system variable, Server System Variables

H

[index top]
HANDLER, HANDLER Syntax
Handlers, DECLARE for Handlers
handling
errors, UDF Return Values and Error Handling
Has read all relay log; waiting for the slave I/O thread to update it
thread state, Replication Slave SQL Thread States
Has sent all binlog to slave; waiting for binlog to be updated
thread state, Replication Master Thread States
hash partitioning, HASH Partitioning
hash partitions
managing, Management of HASH and KEY Partitions
splitting and merging, Management of HASH and KEY Partitions
have_compress system variable, Server System Variables
have_crypt system variable, Server System Variables
have_csv system variable, Server System Variables
have_dynamic_loading system variable, Server System Variables
have_geometry system variable, Server System Variables
have_innodb system variable, Server System Variables
have_openssl system variable, Server System Variables
have_partitioning system variable, Server System Variables
have_query_cache system variable, Server System Variables
have_rtree_keys system variable, Server System Variables
have_ssl system variable, Server System Variables
have_symlink system variable, Server System Variables
HAVING, SELECT Syntax
header_file option
comp_err, comp_err — Compile MySQL Error Message File
HEAP storage engine, Storage Engines, The MEMORY (HEAP) Storage Engine
help command
mysql, mysql Commands
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
mysqlbackup, mysqlbackup — Display Backup Information
mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files
mysqlcheck, mysqlcheck — A Table Maintenance Program
mysqld, Server Command Options
mysqldump, mysqldump — A Database Backup Program
mysqldumpslow, mysqldumpslow — Summarize Slow Query Log Files
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
mysqlshow, mysqlshow — Display Database, Table, and Column Information
mysqlslap, mysqlslap — Load Emulation Client
mysql_convert_table_format, mysql_convert_table_format — Convert Tables to Use a Given Storage Engine
mysql_find_rows, mysql_find_rows — Extract SQL Statements from Files
mysql_setpermission, mysql_setpermission — Interactively Set Permissions in Grant Tables
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 Host name to IP Address or Vice Versa
resolve_stack_dump, resolve_stack_dump — Resolve Numeric Stack Trace Dump to Symbols
HELP option
myisamchk, myisamchk General Options
HELP statement, HELP Syntax
HEX(), String Functions, Mathematical 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, Server 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 name
default, Connecting to the MySQL Server
host name caching, How MySQL Uses DNS
host name resolution, How MySQL Uses DNS
host option, Connecting to the MySQL Server
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 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
mysqlslap, mysqlslap — Load Emulation Client
mysql_convert_table_format, mysql_convert_table_format — Convert Tables to Use a Given Storage Engine
mysql_setpermission, mysql_setpermission — Interactively Set Permissions in Grant Tables
host table, Access Control, Stage 2: Request Verification
sorting, Access Control, Stage 2: Request Verification
host.frm
problems finding, Unix Post-Installation Procedures
hostname system variable, Server System Variables
HOUR(), Date and Time Functions
howto option
mysqlaccess, mysqlaccess — Client for Checking Access Privileges
html option
mysql, mysql Options

I

[index top]
i-am-a-dummy option
mysql, mysql Options
IBMDB2I storage engine, Storage Engines
ID
unique, How to Get the Unique ID for the Last Inserted Row
identifiers, Schema Object Names
case sensitivity, Identifier Case Sensitivity
quoting, Schema Object Names
identity session variable, Session System Variables
IF, IF Statement
IF(), Control Flow Functions
IFNULL(), Control Flow Functions
IGNORE
with partitioned tables, INSERT Syntax
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-sql-errors option
mysqlslap, mysqlslap — Load Emulation Client
ignore-table option
mysqldump, mysqldump — A Database Backup Program
IGNORE_SPACE SQL mode, Server SQL Modes
image-order option
mysqlbackup, mysqlbackup — Display Backup Information
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, mysqlimport — A Data Import Program
IN, Comparison Functions and Operators, Subqueries with ANY, IN, and SOME
include option
mysql_config, mysql_config — Get Compile Options for Compiling Clients
include-master-host-port option
mysqldump, mysqldump — A Database Backup Program
increasing
performance, Replication FAQ
increasing with replication
speed, Replication
index
deleting, ALTER TABLE Syntax, DROP INDEX Syntax
rebuilding, Rebuilding or Repairing Tables or Indexes
INDEX DIRECTORY
and replication, Replication and DIRECTORY Table Options
index hints, SELECT Syntax, Index Hint Syntax
index join type
optimizer, Optimizing Queries with EXPLAIN
index-record lock
InnoDB, InnoDB Startup Options and System Variables, The InnoDB Transaction Model and Locking, InnoDB Record, Gap, and Next-Key Locks, Avoiding the Phantom Problem Using Next-Key Locking
indexes, CREATE INDEX Syntax
and BLOB columns, Column Indexes, CREATE TABLE Syntax
and IS NULL, How MySQL Uses Indexes
and LIKE, How MySQL Uses Indexes
and NULL values, CREATE TABLE Syntax
and TEXT columns, Column Indexes, CREATE TABLE Syntax
assigning to key cache, CACHE INDEX Syntax
block size, Server System Variables
columns, Column Indexes
leftmost prefix of, How MySQL Uses Indexes
multi-column, Multiple-Column Indexes
multiple-part, CREATE INDEX Syntax
names, Schema Object Names
use of, How MySQL Uses Indexes
index_merge join type
optimizer, Optimizing Queries with EXPLAIN
index_subquery join type
optimizer, Optimizing Queries with EXPLAIN
INET_ATON(), Miscellaneous Functions
INET_NTOA(), Miscellaneous Functions
information functions, Information Functions
information option
myisamchk, myisamchk Check Options
INFORMATION_SCHEMA, INFORMATION_SCHEMA Tables
init
thread state, General Thread States
Init DB
thread command, Thread Command Values
init-file option
mysqld, Server Command Options
Initialized
thread state, Event Scheduler Thread States
init_connect system variable, Server System Variables
init_file system variable, Server System Variables
init_slave system variable, Replication Slave Options and Variables
INNER JOIN, JOIN Syntax
innochecksum, Overview of MySQL Programs, innochecksum — Offline InnoDB File Checksum Utility
InnoDB, The InnoDB Storage Engine
clustered index, Clustered and Secondary Indexes
gap lock, InnoDB Startup Options and System Variables, The InnoDB Transaction Model and Locking, InnoDB Record, Gap, and Next-Key Locks, Avoiding the Phantom Problem Using Next-Key Locking
index-record lock, InnoDB Startup Options and System Variables, The InnoDB Transaction Model and Locking, InnoDB Record, Gap, and Next-Key Locks, Avoiding the Phantom Problem Using Next-Key Locking
Monitors, Backing Up and Recovering an InnoDB Database, File Space Management, SHOW ENGINE INNODB STATUS and the InnoDB Monitors, InnoDB General Troubleshooting, Troubleshooting InnoDB Data Dictionary Operations
next-key lock, InnoDB Startup Options and System Variables, The InnoDB Transaction Model and Locking, InnoDB Record, Gap, and Next-Key Locks, Avoiding the Phantom Problem Using Next-Key Locking
NFS, InnoDB Configuration, Restrictions on InnoDB Tables
record-level locks, InnoDB Startup Options and System Variables, The InnoDB Transaction Model and Locking, InnoDB Record, Gap, and Next-Key Locks, Avoiding the Phantom Problem Using Next-Key Locking
secondary index, Clustered and Secondary Indexes
semi-consistent read, InnoDB Startup Options and System Variables
Solaris 10 x86_64 issues, Solaris Notes
transaction isolation levels, The InnoDB Transaction Model and Locking
innodb option
mysqld, InnoDB Startup Options and System Variables
InnoDB storage engine, Storage Engines, The InnoDB Storage Engine
InnoDB tables, Transactions and Atomic Operations
innodb_status_file option
mysqld, InnoDB Startup Options and System Variables
INSERT, Speed of INSERT Statements, INSERT Syntax
insert
thread state, Delayed-Insert Thread States
INSERT ... SELECT, INSERT ... SELECT Syntax
INSERT DELAYED, INSERT DELAYED Syntax
INSERT statement
grant privileges, Adding User Accounts
INSERT(), String Functions
insert-ignore option
mysqldump, mysqldump — A Database Backup Program
insertable views
insertable, Updatable and Insertable Views
inserting
speed of, Speed of INSERT Statements
inserts
concurrent, Internal Locking Methods, Concurrent Inserts
insert_id session variable, Session System Variables
INSTALL PLUGIN, INSTALL PLUGIN Syntax
installation layouts, Installation Layouts
installation overview, MySQL Installation Using a Source Distribution
installing
binary distribution, Installing MySQL from tar.gz Packages on Other Unix-Like Systems
Linux RPM packages, Installing MySQL from RPM Packages on Linux
Mac OS X PKG packages, Installing MySQL on Mac OS X
overview, Installing and Upgrading MySQL
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 plugins, INSTALL PLUGIN Syntax
INSTR(), String Functions
INT data type, Overview of Numeric Types
integer arithmetic, Precision Math
INTEGER data type, Overview of Numeric Types
integers, Numbers
interactive_timeout system variable, Server System Variables
InteriorRingN(), Polygon Functions
internal compiler errors, Dealing with Problems Compiling MySQL
internal locking, Internal Locking Methods
internals, MySQL Internals
internationalization, Internationalization and Localization
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
isamlog, Overview of MySQL Programs, myisamlog — Display MyISAM Log File Contents
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
iterations option
mysqlslap, mysqlslap — Load Emulation Client

K

[index top]
keepold option
mysqlhotcopy, mysqlhotcopy — A Database Backup Program
keep_files_on_create system variable, Server System Variables
Key cache
MyISAM, The MyISAM Key Cache
key cache
assigning indexes to, CACHE INDEX Syntax
key partitioning, KEY Partitioning
key partitions
managing, Management of HASH and KEY Partitions
splitting and merging, Management of HASH and KEY Partitions
key space
MyISAM, Space Needed for Keys
keys, Column Indexes
foreign, Foreign Keys, Using Foreign Keys
multi-column, Multiple-Column Indexes
searching on two, Searching on Two Keys
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_buffer_size system variable, Server System Variables
key_cache_age_threshold system variable, Server System Variables
key_cache_block_size system variable, Server System Variables
key_cache_division_limit system variable, Server System Variables
KEY_COLUMN_USAGE
INFORMATION_SCHEMA table, The INFORMATION_SCHEMA KEY_COLUMN_USAGE Table
Kill
thread command, Thread Command Values
KILL, KILL Syntax
Killed
thread state, General Thread States
Killing slave
thread state, Replication Slave Connection Thread States
known errors, Known Issues in MySQL
Korean, MySQL 6.0 FAQ — MySQL Chinese, Japanese, and Korean Character Sets
Korean, Chinese, Japanese character sets
frequently asked questions, MySQL 6.0 FAQ — MySQL Chinese, Japanese, and Korean Character Sets

L

[index top]
label option
mysqlslap, mysqlslap — Load Emulation Client
language option
mysqld, Server Command Options
language support
error messages, Setting the Error Message Language
language system variable, Server System Variables
large page support, Enabling Large Page Support
large-pages option
mysqld, Server Command Options
large_files_support system variable, Server System Variables
large_pages system variable, Server System Variables
large_page_size system variable, Server System Variables
last row
unique ID, How to Get the Unique ID for the Last Inserted Row
LAST_DAY(), Date and Time Functions
last_insert_id session variable, Session System Variables
LAST_INSERT_ID(), Transactions and Atomic Operations, INSERT Syntax
and replication, Replication and AUTO_INCREMENT
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([<replaceable>expr</replaceable>]), Information Functions
layout of installation, Installation Layouts
LCASE(), String Functions
lc_time_names system variable, Server System Variables
ldata option
mysql_install_db, mysql_install_db — Initialize MySQL Data Directory
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, Schema Object 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
options, Options with the Embedded Server
libmysqld-libs option
mysql_config, mysql_config — Get Compile Options for Compiling Clients
library
mysqlclient, Connectors and APIs
mysqld, Connectors and APIs
libs option
mysql_config, mysql_config — Get Compile Options for Compiling Clients
libs_r option
mysql_config, mysql_config — Get Compile Options for Compiling Clients
license system variable, Server System Variables
LIKE, String Comparison Functions
and indexes, How MySQL Uses Indexes
and wildcards, How MySQL Uses Indexes
LIMIT, LIMIT Optimization, Information Functions, SELECT Syntax
and replication, Replication and LIMIT
limitations
design, MySQL Design Limitations and Tradeoffs
MySQL Limitations, Limits in MySQL
replication, Replication Features and Issues
limits
file-size, The table is full
MySQL Limits, limits in MySQL, Limits in MySQL
line-numbers option
mysql, mysql Options
linear hash partitioning, LINEAR HASH Partitioning
linear key partitioning, KEY Partitioning
linefeed (\n), Strings, LOAD DATA INFILE Syntax
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
list partitioning, LIST Partitioning
list partitions
adding and dropping, Management of RANGE and LIST Partitions
managing, Management of RANGE and LIST Partitions
literals, Literal Values
LN(), Mathematical Functions
LOAD DATA
and replication, Replication and LOAD DATA
LOAD DATA INFILE, LOAD DATA INFILE Syntax, Problems with NULL Values
load emulation, mysqlslap — Load Emulation Client
LOAD INDEX INTO CACHE
and partitioning, Restrictions and Limitations on Partitioning
LOAD XML, LOAD XML Syntax
loading
tables, Loading Data into a Table
LOAD_FILE(), String Functions
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
localization, Internationalization and Localization
localstatedir option
configure, Typical configure Options
LOCALTIME, Date and Time Functions
LOCALTIMESTAMP, Date and Time Functions
local_infile system variable, Server System Variables
LOCATE(), String Functions
LOCK IN SHARE MODE, SELECT Syntax
Lock Monitor
InnoDB, SHOW ENGINE INNODB STATUS and the InnoDB Monitors
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
Locked
thread state, General Thread States
locked_in_memory system variable, Server System Variables
locking, System Factors and Startup Parameter Tuning
external, Server Command Options, Server System Variables, Using myisamchk for Crash Recovery, External Locking, General Thread States
internal, Internal Locking Methods
row-level, Transactions and Atomic Operations, Internal Locking Methods
table-level, Internal Locking Methods
locking methods, Internal Locking Methods
log
changes, MySQL Change History
log files, Typical configure Options
maintaining, Server Log Maintenance
log option
mysqld, Server Command Options
mysqld_multi, mysqld_multi — Manage Multiple MySQL Servers
log system variable, Server System Variables
LOG(), Mathematical Functions
log-backup-output option
mysqld, Server Command Options
log-bin option
mysqld, Binary Log Options and Variables
log-bin-index option
mysqld, Binary Log Options and Variables
log-bin-trust-function-creators option
mysqld, Binary Log Options and Variables
log-error option
mysqld, Server Command Options
mysqldump, mysqldump — A Database Backup Program
mysqld_safe, mysqld_safe — MySQL Server Startup Script
log-isam option
mysqld, Server Command Options
log-long-format option
mysqld, Server Command Options
log-output option
mysqld, Server Command Options
log-queries-not-using-indexes option
mysqld, Server Command Options
log-short-format option
mysqld, Server Command Options
log-slave-updates option
mysqld, Replication Slave Options and Variables
log-slow-admin-statements option
mysqld, Server Command Options
log-slow-queries option
mysqld, Server Command Options
log-slow-slave-statements option
mysqld, Replication Slave Options and Variables
log-tc option
mysqld, Server Command Options
log-tc-size option
mysqld, Server Command Options
log-warnings option
mysqld, Server Command Options, Replication Slave Options and Variables
LOG10(), Mathematical Functions
LOG2(), Mathematical Functions
logging slow query
thread state, General Thread States
logical operators, Logical Operators
login
thread state, General Thread States
logs
server, MySQL Server Logs
log_backup_output system variable, Server System Variables
log_bin system variable, Server System Variables
log_bin_trust_function_creators system variable, Server System Variables
log_error system variable, Server System Variables
log_output system variable, Server System Variables
log_queries_not_using_indexes system variable, Server System Variables
log_slave_updates system variable, Server System Variables
log_slow_queries system variable, Server System Variables
log_warnings system variable, Server System Variables
Long Data
thread command, Thread Command Values
LONG data type, The BLOB and TEXT Types
LONGBLOB data type, Overview of String Types
LONGTEXT data type, Overview of String Types
long_query_time system variable, Server System Variables
LOOP, LOOP Statement
lost connection errors, Lost connection to MySQL server
low-priority option
mysqlimport, mysqlimport — A Data Import Program
low-priority-updates option
mysqld, Server Command Options
LOWER(), String Functions
lower_case_file_system system variable, Server System Variables
lower_case_table_names system variable, Server System Variables
low_priority_updates system variable, Server System Variables
LPAD(), String Functions
LTRIM(), String Functions

M

[index top]
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
maintenance
tables, mysqlcheck — A Table Maintenance Program
MAKEDATE(), Date and Time Functions
MAKETIME(), Date and Time Functions
make_binary_distribution, Overview of MySQL Programs
MAKE_SET(), String Functions
make_win_bin_dist, Overview of MySQL Programs, make_win_bin_dist — Package MySQL Distribution as ZIP Archive
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
Making temp file
thread state, Replication Slave SQL Thread States
manual
available formats, About This Manual
online location, About This Manual
syntax conventions, Typographical and Syntax Conventions
typographical conventions, Typographical and Syntax Conventions
master-data option
mysqldump, mysqldump — A Database Backup Program
master-info-file option
mysqld, Replication Slave Options and Variables
master-retry-count option
mysqld, Replication Slave Options and Variables
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, Binary Log Options and Variables
max-record-length option
myisamchk, myisamchk Repair Options
max-relay-log-size option
mysqld, Replication Slave Options and Variables
MAXDB SQL mode, Server SQL Modes
maximum memory used, mysqladmin — Client for Administering a MySQL Server
maximums
maximum columns per table, The Maximum Number of Columns Per Table
maximum tables per join, Limits of Joins
max_allowed_packet system variable, Server System Variables
max_allowed_packet variable, mysql Options
max_binlog_cache_size system variable, Binary Log Options and Variables
max_binlog_size system variable, Binary Log Options and Variables
max_connections system variable, Server System Variables
MAX_CONNECTIONS_PER_HOUR, Limiting Account Resources
max_connect_errors system variable, Server System Variables
max_delayed_threads system variable, Server System Variables
max_error_count system variable, Server System Variables
max_heap_table_size system variable, Server System Variables
max_insert_delayed_threads system variable, Server System Variables
max_join_size system variable, Server System Variables
max_join_size variable, mysql Options
max_length_for_sort_data system variable, Server System Variables
max_prepared_stmt_count system variable, Server System Variables
MAX_QUERIES_PER_HOUR, Limiting Account Resources
max_relay_log_size system variable, Server System Variables
max_seeks_for_key system variable, Server System Variables
max_sort_length system variable, Server System Variables
max_sp_recursion_depth system variable, Server System Variables
max_tmp_tables system variable, Server System Variables
MAX_UPDATES_PER_HOUR, Limiting Account Resources
MAX_USER_CONNECTIONS, Limiting Account Resources
max_user_connections system variable, Server System Variables
max_write_lock_count system variable, Server System Variables
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 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, Server Command Options
MEMORY storage engine, Storage Engines, The MEMORY (HEAP) Storage Engine
and replication, Replication with MEMORY Tables
memory usage
myisamchk, myisamchk Memory Usage
memory use, mysqladmin — Client for Administering a MySQL Server, How MySQL Uses Memory
MERGE storage engine, Storage Engines, The MERGE Storage Engine
MERGE tables
defined, The MERGE Storage Engine
metadata
database, INFORMATION_SCHEMA Tables
stored routines, Stored Routine Metadata
triggers, Trigger Metadata
views, View Metadata
metadata locking
transactions, Metadata Locking Within Transactions
metadata-extra option
mysqlbackup, mysqlbackup — Display Backup Information
metadata-statements option
mysqlbackup, mysqlbackup — Display Backup Information
method option
mysqlhotcopy, mysqlhotcopy — A Database Backup Program
methods
locking, Internal Locking Methods
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
min-examined-row-limit option
mysqld, Server Command Options
Minimum Bounding Rectangle, Relations on Geometry Minimal Bounding Rectangles (MBRs)
minus
unary (-), Arithmetic Operators
MINUTE(), Date and Time Functions
min_examined_row_limit system variable, Server System Variables
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
Monitors
InnoDB, Backing Up and Recovering an InnoDB Database, File Space Management, SHOW ENGINE INNODB STATUS and the InnoDB Monitors, InnoDB General Troubleshooting, Troubleshooting InnoDB Data Dictionary Operations
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, Regular Expressions
msql2mysql, msql2mysql — Convert mSQL Programs for Use with MySQL
MSSQL SQL mode, Server SQL Modes
multi mysqld, mysqld_multi — Manage Multiple MySQL Servers
multi-byte character sets, Can't initialize character set
multi-byte characters, Multi-Byte Character Support
multi-column indexes, Multiple-Column Indexes
Multi-Range Read
optimization, Multi-Range Read Optimization
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
multi_range_count system variable, Server System Variables
My
derivation, History of MySQL
my.cnf file, Replication Features and Issues
MyISAM
compressed tables, myisampack — Generate Compressed, Read-Only MyISAM Tables, Compressed Table Characteristics
MyISAM key cache, The MyISAM Key Cache
MyISAM storage engine, Storage Engines, The MyISAM Storage Engine
myisam-block-size option
mysqld, Server Command Options
myisam-recover option
mysqld, Server Command Options, MyISAM Startup Options
myisamchk, Typical configure Options, Overview of MySQL Programs, myisamchk — MyISAM Table-Maintenance Utility
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
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 MySQL Programs, myisamlog — Display MyISAM Log File Contents
myisampack, Overview of MySQL Programs, myisampack — Generate Compressed, Read-Only MyISAM Tables, 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
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_data_pointer_size system variable, Server System Variables
myisam_ftdump, Overview of MySQL Programs, myisam_ftdump — Display Full-Text Index information
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
myisam_max_sort_file_size system variable, Server System Variables
myisam_recover_options system variable, Server System Variables
myisam_repair_threads system variable, Server System Variables
myisam_sort_buffer_size system variable, Server System Variables
myisam_stats_method system variable, Server System Variables
myisam_use_mmap system variable, Server System Variables
MyODBC, MySQL Connector/ODBC
MySQL
defined, What is MySQL?
introduction, What is MySQL?
pronunciation, What is MySQL?
upgrading, mysql_upgrade — Check Tables for MySQL Upgrade
mysql, Overview of MySQL Programs, mysql — The MySQL Command-Line Tool
auto-rehash option, mysql Options
auto-vertical-output option, mysql Options
batch option, mysql Options
character-sets-dir option, mysql Options
charset command, mysql Commands
clear command, mysql Commands
column-names option, mysql Options
column-type-info option, mysql Options
comments option, mysql Options
compress option, mysql Options
connect command, mysql Commands
database option, mysql Options
debug option, mysql Options
debug-check option, mysql Options
debug-info option, mysql Options
default-character-set option, mysql Options
delimiter command, mysql Commands
delimiter option, mysql Options
disable named commands, mysql Options
edit command, mysql Commands
ego command, mysql Commands
execute option, mysql Options
exit command, mysql Commands
force option, mysql Options
go command, mysql Commands
help command, mysql Commands
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
nopager command, mysql Commands
notee command, mysql Commands
nowarning command, mysql Commands
one-database option, mysql Options
pager command, mysql Commands
pager option, mysql Options
password option, mysql Options
pipe option, mysql Options
port option, mysql Options
print command, mysql Commands
prompt command, mysql Commands
prompt option, mysql Options
protocol option, mysql Options
quick option, mysql Options
quit command, mysql Commands
raw option, mysql Options
reconnect option, mysql Options
rehash command, mysql Commands
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
source command, mysql Commands
SSL options, mysql Options
status command, mysql Commands
system command, mysql Commands
table option, mysql Options
tee command, mysql Commands
tee option, mysql Options
unbuffered option, mysql Options
use command, mysql Commands
user option, mysql Options
verbose option, mysql Options
version option, mysql Options
vertical option, mysql Options
wait option, mysql Options
warnings command, mysql Commands
xml option, mysql Options
MySQL binary distribution, Choosing Which MySQL Distribution to Install
MYSQL C type, C API Data Types
MySQL Cluster
FAQ, MySQL 6.0 FAQ — MySQL Cluster
mysql command options, mysql Options
mysql commands
list of, mysql Commands
MySQL Dolphin name, History of MySQL
MySQL history, History of MySQL
mysql history file, mysql Options
MySQL mailing lists, MySQL Mailing Lists
MySQL name, History of MySQL
mysql prompt command, mysql Commands
MySQL server
mysqld, mysqld — The MySQL Server, The MySQL Server
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 storage engines, Storage Engines
MySQL system tables
and replication, Replication of the System mysql Database
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.event table, The Event Scheduler and MySQL Privileges
mysql.server, Overview of MySQL Programs, mysql.server — MySQL Server Startup Script
basedir option, mysql.server — MySQL Server Startup Script
datadir option, mysql.server — MySQL Server Startup Script
pid-file option, mysql.server — MySQL Server Startup Script
service-startup-timeout option, mysql.server — MySQL Server Startup Script
use-mysqld_safe option, mysql.server — MySQL Server Startup Script
user option, mysql.server — MySQL Server Startup Script
mysql.sock
changing location of, Typical configure Options
protection, How to Protect or Change the MySQL Unix Socket File
MYSQL323 SQL mode, Server SQL Modes
MYSQL40 SQL mode, Server SQL Modes
mysqlaccess, Overview of MySQL Programs, mysqlaccess — Client for Checking Access Privileges
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 MySQL Programs, mysqladmin — Client for Administering a MySQL Server, 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
debug-check option, mysqladmin — Client for Administering a MySQL Server
debug-info 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
no-beep option, mysqladmin — Client for Administering a MySQL Server
password option, mysqladmin — Client for Administering a MySQL Server
pipe 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
mysqlbackup, mysqlbackup — Display Backup Information
all option, mysqlbackup — Display Backup Information
catalog-details option, mysqlbackup — Display Backup Information
catalog-summary option, mysqlbackup — Display Backup Information
data-chunks option, mysqlbackup — Display Backup Information
data-totals option, mysqlbackup — Display Backup Information
debug option, mysqlbackup — Display Backup Information
exact option, mysqlbackup — Display Backup Information
help option, mysqlbackup — Display Backup Information
image-order option, mysqlbackup — Display Backup Information
metadata-extra option, mysqlbackup — Display Backup Information
metadata-statements option, mysqlbackup — Display Backup Information
open_files_limit option, mysqlbackup — Display Backup Information
search option, mysqlbackup — Display Backup Information
snapshots option, mysqlbackup — Display Backup Information
summary option, mysqlbackup — Display Backup Information
verbose option, mysqlbackup — Display Backup Information
version option, mysqlbackup — Display Backup Information
mysqlbinlog, Overview of MySQL Programs, mysqlbinlog — Utility for Processing Binary Log Files
base64-output option, mysqlbinlog — Utility for Processing Binary Log Files
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
debug-check option, mysqlbinlog — Utility for Processing Binary Log Files
debug-info 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
server-id 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
verbose option, mysqlbinlog — Utility for Processing Binary Log Files
version option, mysqlbinlog — Utility for Processing Binary Log Files
write-binlog option, mysqlbinlog — Utility for Processing Binary Log Files
mysqlbug, mysqlbug — Generate Bug Report
mysqlbug script, How to Report Bugs or Problems
mysqlcheck, Overview of MySQL Programs, mysqlcheck — A Table Maintenance Program
all-databases option, mysqlcheck — A Table Maintenance Program
all-in-1 option, mysqlcheck — A Table Maintenance Program
analyze option, mysqlcheck — A Table Maintenance Program
auto-repair option, mysqlcheck — A Table Maintenance Program
character-sets-dir option, mysqlcheck — A Table Maintenance Program
check option, mysqlcheck — A Table Maintenance Program
check-only-changed option, mysqlcheck — A Table Maintenance Program
check-upgrade option, mysqlcheck — A Table Maintenance Program
compress option, mysqlcheck — A Table Maintenance Program
databases option, mysqlcheck — A Table Maintenance Program
debug option, mysqlcheck — A Table Maintenance Program
debug-check option, mysqlcheck — A Table Maintenance Program
debug-info option, mysqlcheck — A Table Maintenance Program
default-character-set option, mysqlcheck — A Table Maintenance Program
extended option, mysqlcheck — A Table Maintenance Program
fast option, mysqlcheck — A Table Maintenance Program
fix-db-names option, mysqlcheck — A Table Maintenance Program
fix-table-names option, mysqlcheck — A Table Maintenance Program
force option, mysqlcheck — A Table Maintenance Program
help option, mysqlcheck — A Table Maintenance Program
host option, mysqlcheck — A Table Maintenance Program
medium-check option, mysqlcheck — A Table Maintenance Program
optimize option, mysqlcheck — A Table Maintenance Program
password option, mysqlcheck — A Table Maintenance Program
pipe option, mysqlcheck — A Table Maintenance Program
port option, mysqlcheck — A Table Maintenance Program
protocol option, mysqlcheck — A Table Maintenance Program
quick option, mysqlcheck — A Table Maintenance Program
repair option, mysqlcheck — A Table Maintenance Program
silent option, mysqlcheck — A Table Maintenance Program
socket option, mysqlcheck — A Table Maintenance Program
SSL options, mysqlcheck — A Table Maintenance Program
tables option, mysqlcheck — A Table Maintenance Program
use-frm option, mysqlcheck — A Table Maintenance Program
user option, mysqlcheck — A Table Maintenance Program
verbose option, mysqlcheck — A Table Maintenance Program
version option, mysqlcheck — A Table Maintenance Program
mysqlclient library, Connectors and APIs
mysqld, Overview of MySQL Programs
abort-slave-event-count option, Replication Slave Options and Variables
allow-suspicious-udfs option, Server Command Options, Security-Related mysqld Options
ansi option, Server Command Options
basedir option, Server Command Options
big-tables option, Server Command Options
bind-address option, Server Command Options
binlog-do-db option, Binary Log Options and Variables
binlog-format option, Server Command Options
binlog-ignore-db option, Binary Log Options and Variables
binlog-row-event-max-size option, Binary Log Options and Variables
bootstrap option, Server Command Options
character-set-client-handshake option, Server Command Options
character-set-filesystem option, Server Command Options
character-set-server option, Server Command Options
character-sets-dir option, Server Command Options
chroot option, Server Command Options
collation-server option, Server Command Options
command options, Server Command Options
console option, Server Command Options
core-file option, Server Command Options
datadir option, Server Command Options
debug option, Server Command Options
debug-sync-timeout option, Server Command Options
default-character-set option, Server Command Options
default-collation option, Server Command Options
default-storage-engine option, Server Command Options
default-table-type option, Server Command Options
default-time-zone option, Server Command Options
delay-key-write option, Server Command Options, MyISAM Startup Options
des-key-file option, Server Command Options
disconnect-slave-event-count option, Replication Slave Options and Variables
enable-named-pipe option, Server Command Options
enable-pstack option, Server Command Options
event-scheduler option, Server Command Options
exit-info option, Server Command Options
external-locking option, Server Command Options
flush option, Server Command Options
gdb option, Server Command Options
general-log option, Server Command Options
help option, Server Command Options
init-file option, Server Command Options
innodb option, InnoDB Startup Options and System Variables
innodb_status_file option, InnoDB Startup Options and System Variables
language option, Server Command Options
large-pages option, Server Command Options
local-infile option, Security-Related mysqld Options
log option, Server Command Options
log-backup-output option, Server Command Options
log-bin option, Binary Log Options and Variables
log-bin-index option, Binary Log Options and Variables
log-bin-trust-function-creators option, Binary Log Options and Variables
log-error option, Server Command Options
log-isam option, Server Command Options
log-long-format option, Server Command Options
log-output option, Server Command Options
log-queries-not-using-indexes option, Server Command Options
log-short-format option, Server Command Options
log-slave-updates option, Replication Slave Options and Variables
log-slow-admin-statements option, Server Command Options
log-slow-queries option, Server Command Options
log-slow-slave-statements option, Replication Slave Options and Variables
log-tc option, Server Command Options
log-tc-size option, Server Command Options
log-warnings option, Server Command Options, Replication Slave Options and Variables
low-priority-updates option, Server Command Options
master-info-file option, Replication Slave Options and Variables
master-retry-count option, Replication Slave Options and Variables
max-binlog-dump-events option, Binary Log Options and Variables
max-relay-log-size option, Replication Slave Options and Variables
memlock option, Server Command Options
min-examined-row-limit option, Server Command Options
myisam-block-size option, Server Command Options
myisam-recover option, Server Command Options, MyISAM Startup Options
MySQL server, mysqld — The MySQL Server, The MySQL Server
old-alter-table option, Server Command Options
old-passwords option, Server Command Options, Security-Related mysqld Options
old-style-user-limits option, Server Command Options
one-thread option, Server Command Options
open-files-limit option, Server Command Options
pid-file option, Server Command Options
plugin-load option, Server Command Options
port option, Server Command Options
port-open-timeout option, Server Command Options
read-only option, Replication Slave Options and Variables
relay-log option, Replication Slave Options and Variables
relay-log-index option, Replication Slave Options and Variables
relay-log-info-file option, Replication Slave Options and Variables
relay-log-purge option, Replication Slave Options and Variables
relay-log-recovery option, Replication Slave Options and Variables
relay-log-space-limit option, Replication Slave Options and Variables
replicate-do-db option, Replication Slave Options and Variables
replicate-do-table option, Replication Slave Options and Variables
replicate-ignore-db option, Replication Slave Options and Variables
replicate-ignore-table option, Replication Slave Options and Variables
replicate-rewrite-db option, Replication Slave Options and Variables
replicate-same-server-id option, Replication Slave Options and Variables
replicate-wild-do-table option, Replication Slave Options and Variables
replicate-wild-ignore-table option, Replication Slave Options and Variables
report-host option, Replication Slave Options and Variables
report-password option, Replication Slave Options and Variables
report-port option, Replication Slave Options and Variables
report-user option, Replication Slave Options and Variables
safe-mode option, Server Command Options
safe-show-database option, Server Command Options, Security-Related mysqld Options
safe-user-create option, Server Command Options, Security-Related mysqld Options
secure-auth option, Server Command Options, Security-Related mysqld Options
secure-backup-file-priv option, Server Command Options, Security-Related mysqld Options
secure-file-priv option, Server Command Options, Security-Related mysqld Options
server-id option, Replication and Binary Logging Options and Variables
shared-memory option, Server Command Options
shared-memory-base-name option, Server Command Options
show-slave-auth-info option, Replication Slave Options and Variables
skip-concurrent-insert option, Server Command Options
skip-external-locking option, Server Command Options
skip-grant-tables option, Server Command Options, Security-Related mysqld Options
skip-host-cache option, Server Command Options
skip-innodb option, Server Command Options
skip-name-resolve option, Server Command Options, Security-Related mysqld Options
skip-networking option, Server Command Options, Security-Related mysqld Options
skip-safemalloc option, Server Command Options
skip-show-database option, Server Command Options, Security-Related mysqld Options
skip-slave-start option, Replication Slave Options and Variables
skip-stack-trace option, Server Command Options
skip-symbolic-links option, Server Command Options
skip-thread-priority option, Server Command Options
slave-load-tmpdir option, Replication Slave Options and Variables
slave-net-timeout option, Replication Slave Options and Variables
slave-skip-errors option, Replication Slave Options and Variables
slave_compressed_protocol option, Replication Slave Options and Variables
slow-query-log option, Server Command Options
socket option, Server Command Options
sporadic-binlog-dump-fail option, Binary Log Options and Variables
sql-mode option, Server Command Options
SSL options, Server Command Options, Security-Related mysqld Options
standalone option, Server Command Options
starting, How to Run MySQL as a Normal User
symbolic-links option, Server Command Options
sysdate-is-now option, Server Command Options
tc-heuristic-recover option, Server Command Options
temp-pool option, Server Command Options
tmpdir option, Server Command Options
transaction-isolation option, Server Command Options
user option, Server Command Options
verbose option, Server Command Options
version option, Server Command Options
mysqld library, Connectors and APIs
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 MySQL Programs, mysqldump — A Database Backup Program
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
apply-slave-statements 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
debug-check option, mysqldump — A Database Backup Program
debug-info 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
dump-date option, mysqldump — A Database Backup Program
dump-slave option, mysqldump — A Database Backup Program
events 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
include-master-host-port 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
log-error 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
no-set-names 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
pipe 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
replace 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
mysqldumpslow, Overview of MySQL Programs, mysqldumpslow — Summarize Slow Query Log Files
debug option, mysqldumpslow — Summarize Slow Query Log Files
help option, mysqldumpslow — Summarize Slow Query Log Files
verbose option, mysqldumpslow — Summarize Slow Query Log Files
mysqld_multi, Overview of MySQL Programs, mysqld_multi — Manage Multiple MySQL Servers
config-file option, mysqld_multi — Manage Multiple MySQL Servers
defaults-extra-file option, mysqld_multi — Manage Multiple MySQL Servers
defaults-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-defaults 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 MySQL Programs, mysqld_safe — MySQL Server Startup Script
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
skip-kill-mysqld option, mysqld_safe — MySQL Server Startup Script
skip-syslog option, mysqld_safe — MySQL Server Startup Script
socket option, mysqld_safe — MySQL Server Startup Script
syslog option, mysqld_safe — MySQL Server Startup Script
syslog-tag 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 MySQL Programs, mysqlhotcopy — A Database Backup Program
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 MySQL Programs, mysqlimport — A Data Import Program, 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
debug-check option, mysqlimport — A Data Import Program
debug-info 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
pipe 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
use-threads option, 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
mysqlshow, Overview of MySQL Programs, mysqlshow — Display Database, Table, and Column Information
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
debug-check option, mysqlshow — Display Database, Table, and Column Information
debug-info 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
pipe 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
mysqlslap, Overview of MySQL Programs, mysqlslap — Load Emulation Client
auto-generate-sql option, mysqlslap — Load Emulation Client
auto-generate-sql-add-autoincrement option, mysqlslap — Load Emulation Client
auto-generate-sql-execute-number option, mysqlslap — Load Emulation Client
auto-generate-sql-guid-primary option, mysqlslap — Load Emulation Client
auto-generate-sql-load-type option, mysqlslap — Load Emulation Client
auto-generate-sql-secondary-indexes option, mysqlslap — Load Emulation Client
auto-generate-sql-select-columns option, mysqlslap — Load Emulation Client
auto-generate-sql-unique-query-number option, mysqlslap — Load Emulation Client
auto-generate-sql-unique-write-number option, mysqlslap — Load Emulation Client
auto-generate-sql-write-number option, mysqlslap — Load Emulation Client
burnin option, mysqlslap — Load Emulation Client
commit option, mysqlslap — Load Emulation Client
compress option, mysqlslap — Load Emulation Client
concurrency option, mysqlslap — Load Emulation Client
create option, mysqlslap — Load Emulation Client
create-schema option, mysqlslap — Load Emulation Client
csv option, mysqlslap — Load Emulation Client
debug option, mysqlslap — Load Emulation Client
debug-check option, mysqlslap — Load Emulation Client
debug-info option, mysqlslap — Load Emulation Client
delayed-start option, mysqlslap — Load Emulation Client
delimiter option, mysqlslap — Load Emulation Client
detach option, mysqlslap — Load Emulation Client
engine option, mysqlslap — Load Emulation Client
help option, mysqlslap — Load Emulation Client
host option, mysqlslap — Load Emulation Client
ignore-sql-errors option, mysqlslap — Load Emulation Client
iterations option, mysqlslap — Load Emulation Client
label option, mysqlslap — Load Emulation Client
number-blob-cols option, mysqlslap — Load Emulation Client
number-char-cols option, mysqlslap — Load Emulation Client
number-int-cols option, mysqlslap — Load Emulation Client
number-of-queries option, mysqlslap — Load Emulation Client
only-print option, mysqlslap — Load Emulation Client
password option, mysqlslap — Load Emulation Client
pipe option, mysqlslap — Load Emulation Client
port option, mysqlslap — Load Emulation Client
post-query option, mysqlslap — Load Emulation Client
post-system option, mysqlslap — Load Emulation Client
pre-query option, mysqlslap — Load Emulation Client
pre-system option, mysqlslap — Load Emulation Client
preserve-schema option, mysqlslap — Load Emulation Client
protocol option, mysqlslap — Load Emulation Client
query option, mysqlslap — Load Emulation Client
set-random-seed option, mysqlslap — Load Emulation Client
shared-memory-base-name option, mysqlslap — Load Emulation Client
silent option, mysqlslap — Load Emulation Client
slave option, mysqlslap — Load Emulation Client
socket option, mysqlslap — Load Emulation Client
SSL options, mysqlslap — Load Emulation Client
timer-length option, mysqlslap — Load Emulation Client
user option, mysqlslap — Load Emulation Client
verbose option, mysqlslap — Load Emulation Client
version option, mysqlslap — Load Emulation Client
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_config, mysql_config — Get Compile Options for Compiling Clients
cflags option, mysql_config — Get Compile Options for Compiling Clients
embedded option, mysql_config — Get Compile Options for Compiling Clients
include option, mysql_config — Get Compile Options for Compiling Clients
libmysqld-libs option, mysql_config — Get Compile Options for Compiling Clients
libs option, mysql_config — Get Compile Options for Compiling Clients
libs_r option, mysql_config — Get Compile Options for Compiling Clients
plugindir option, mysql_config — Get Compile Options for Compiling Clients
port option, mysql_config — Get Compile Options for Compiling Clients
socket option, mysql_config — Get Compile Options for Compiling Clients
version option, mysql_config — Get Compile Options for Compiling Clients
mysql_connect(), mysql_connect()
mysql_convert_table_format, Overview of MySQL Programs, mysql_convert_table_format — Convert Tables to Use a Given Storage Engine
force option, mysql_convert_table_format — Convert Tables to Use a Given Storage Engine
help option, mysql_convert_table_format — Convert Tables to Use a Given Storage Engine
host option, mysql_convert_table_format — Convert Tables to Use a Given Storage Engine
password option, mysql_convert_table_format — Convert Tables to Use a Given Storage Engine
port option, mysql_convert_table_format — Convert Tables to Use a Given Storage Engine
socket option, mysql_convert_table_format — Convert Tables to Use a Given Storage Engine
type option, mysql_convert_table_format — Convert Tables to Use a Given Storage Engine
user option, mysql_convert_table_format — Convert Tables to Use a Given Storage Engine
verbose option, mysql_convert_table_format — Convert Tables to Use a Given Storage Engine
version option, mysql_convert_table_format — Convert Tables to Use a Given Storage Engine
mysql_create_db(), mysql_create_db()
mysql_data_seek(), mysql_data_seek()
MYSQL_DEBUG environment variable, Environment Variables, Overview of MySQL Programs, Debugging a MySQL Client
mysql_debug(), mysql_debug()
mysql_drop_db(), mysql_drop_db()
mysql_dump_debug_info(), mysql_dump_debug_info()
mysql_eof(), mysql_eof()
mysql_errno(), mysql_errno()
mysql_error(), mysql_error()
mysql_escape_string(), mysql_escape_string()
mysql_fetch_field(), mysql_fetch_field()
mysql_fetch_fields(), mysql_fetch_fields()
mysql_fetch_field_direct(), mysql_fetch_field_direct()
mysql_fetch_lengths(), mysql_fetch_lengths()
mysql_fetch_row(), mysql_fetch_row()
MYSQL_FIELD C type, C API Data Types
mysql_field_count(), mysql_field_count(), mysql_num_fields()
MYSQL_FIELD_OFFSET C type, C API Data Types
mysql_field_seek(), mysql_field_seek()
mysql_field_tell(), mysql_field_tell()
mysql_find_rows, Overview of MySQL Programs, mysql_find_rows — Extract SQL Statements from Files
help option, mysql_find_rows — Extract SQL Statements from Files
regexp option, mysql_find_rows — Extract SQL Statements from Files
rows option, mysql_find_rows — Extract SQL Statements from Files
skip-use-db option, mysql_find_rows — Extract SQL Statements from Files
start_row option, mysql_find_rows — Extract SQL Statements from Files
mysql_fix_extensions, Overview of MySQL Programs, mysql_fix_extensions — Normalize Table File Name Extensions
mysql_fix_privilege_tables, mysql_fix_privilege_tables — Upgrade MySQL System Tables
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, Problems Running mysql_install_db, Overview of MySQL Programs, mysql_install_db — Initialize MySQL Data Directory
basedir option, mysql_install_db — Initialize MySQL Data Directory
datadir option, mysql_install_db — Initialize MySQL Data Directory
force option, mysql_install_db — Initialize MySQL Data Directory
ldata option, mysql_install_db — Initialize MySQL Data Directory
rpm option, mysql_install_db — Initialize MySQL Data Directory
skip-name-resolve option, mysql_install_db — Initialize MySQL Data Directory
srcdir option, mysql_install_db — Initialize MySQL Data Directory
user option, mysql_install_db — Initialize MySQL Data Directory
verbose option, mysql_install_db — Initialize MySQL Data Directory
windows option, mysql_install_db — Initialize MySQL Data Directory
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, Overview of MySQL Programs, Connecting to the MySQL Server
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 MySQL Programs, mysql_secure_installation — Improve MySQL Installation Security
mysql_select_db(), mysql_select_db()
mysql_server_end(), mysql_server_end()
mysql_server_init(), mysql_server_init()
mysql_setpermission, Overview of MySQL Programs, mysql_setpermission — Interactively Set Permissions in Grant Tables
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_next_result(), mysql_stmt_next_result()
mysql_stmt_num_rows(), mysql_stmt_num_rows()
mysql_stmt_param_count(), mysql_stmt_param_count()
mysql_stmt_param_metadata(), mysql_stmt_param_metadata()
mysql_stmt_prepare(), mysql_stmt_prepare()
mysql_stmt_reset(), mysql_stmt_reset()
mysql_stmt_result_metadata, mysql_stmt_result_metadata()
mysql_stmt_row_seek(), mysql_stmt_row_seek()
mysql_stmt_row_tell(), mysql_stmt_row_tell()
mysql_stmt_send_long_data(), mysql_stmt_send_long_data()
mysql_stmt_sqlstate(), mysql_stmt_sqlstate()
mysql_stmt_store_result(), mysql_stmt_store_result()
mysql_store_result(), mysql_store_result(), Common Questions and Problems When Using the C API
MYSQL_TCP_PORT environment variable, Environment Variables, Overview of MySQL Programs, Running Multiple Servers on Unix, Using Client Programs in a Multiple-Server Environment
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 MySQL Programs, mysql_tzinfo_to_sql — Load the Time Zone Tables
MYSQL_UNIX_PORT environment variable, Problems Running mysql_install_db, Environment Variables, Overview of MySQL Programs, Running Multiple Servers on Unix, Using Client Programs in a Multiple-Server Environment
mysql_upgrade, Overview of MySQL Programs, mysql_upgrade — Check Tables for MySQL Upgrade, Causes of Access-Denied Errors
basedir option, mysql_upgrade — Check Tables for MySQL Upgrade
datadir option, mysql_upgrade — Check Tables for MySQL Upgrade
debug-check option, mysql_upgrade — Check Tables for MySQL Upgrade
debug-info 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
mysql_upgrade_info file, mysql_upgrade — Check Tables for MySQL Upgrade
tmpdir 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_upgrade_info file
mysql_upgrade, mysql_upgrade — Check Tables for MySQL Upgrade
mysql_use_result(), mysql_use_result()
mysql_waitpid, Overview of MySQL Programs, mysql_waitpid — Kill Process and Wait for Its Termination
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 MySQL Programs, mysql_zap — Kill Processes That Match a Pattern
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 MySQL Programs, my_print_defaults — Display Options from Option Files
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

[index top]
named pipes, Selecting a MySQL Server Type, Testing The MySQL Installation
named-commands option
mysql, mysql Options
named_pipe system variable, Server System Variables
names, Schema Object 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
NATIONAL VARCHAR 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 storage engine
FAQ, MySQL 6.0 FAQ — MySQL Cluster
negative values, Numbers
nested queries, Subquery Syntax
Nested-Loop join algorithm, Nested-Loop Join Algorithms
nested-loop join algorithm, Nested Join Optimization
net etiquette, Guidelines for Using the Mailing Lists
netmask notation
in account names, Specifying Account Names
NetWare, Installing MySQL on NetWare
net_buffer_length system variable, Server System Variables
net_buffer_length variable, mysql Options
net_read_timeout system variable, Server System Variables
net_retry_count system variable, Server System Variables
net_write_timeout system variable, Server System Variables
new procedures
adding, Adding New Procedures to MySQL
new system variable, Server System Variables
new users
adding, Installing MySQL from tar.gz Packages on Other Unix-Like Systems, Source Installation Overview
newline (\n), Strings, LOAD DATA INFILE Syntax
next-key lock
InnoDB, InnoDB Startup Options and System Variables, The InnoDB Transaction Model and Locking, InnoDB Record, Gap, and Next-Key Locks, Avoiding the Phantom Problem Using Next-Key Locking
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
mysqladmin, mysqladmin — Client for Administering a MySQL Server
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, Command-Line Options that Affect Option-File Handling
mysqld_multi, mysqld_multi — Manage Multiple MySQL Servers
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-set-names option
mysqldump, mysqldump — A Database Backup Program
no-symlinks option
myisamchk, myisamchk Repair Options
no-tee option
mysql, mysql Options
noindices option
mysqlhotcopy, mysqlhotcopy — A Database Backup Program
nondelimited strings, The DATETIME, DATE, and TIMESTAMP Types
Nontransactional tables, Rollback Failure for Nontransactional Tables
nopager command
mysql, mysql Commands
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, Regular Expressions
notee command
mysql, mysql Commands
Novell NetWare, Installing MySQL on NetWare
NOW(), Date and Time Functions
nowarning command
mysql, mysql Commands
NO_AUTO_CREATE_USER SQL mode, Server SQL Modes
NO_AUTO_VALUE_ON_ZERO SQL mode, Server SQL Modes
NO_BACKSLASH_ESCAPES SQL mode, Server SQL Modes
NO_DIR_IN_CREATE SQL mode, Server SQL Modes
NO_ENGINE_SUBSTITUTION SQL mode, Server SQL Modes
NO_FIELD_OPTIONS SQL mode, Server SQL Modes
NO_KEY_OPTIONS SQL mode, Server SQL Modes
NO_TABLE_OPTIONS SQL mode, Server SQL Modes
NO_UNSIGNED_SUBTRACTION SQL mode, Server SQL Modes
NO_ZERO_DATE SQL mode, Server SQL Modes
NO_ZERO_IN_DATE SQL mode, Server SQL Modes
NUL, Strings, LOAD DATA INFILE Syntax
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
thread state, General Thread States
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
number-blob-cols option
mysqlslap, mysqlslap — Load Emulation Client
number-char-cols option
mysqlslap, mysqlslap — Load Emulation Client
number-int-cols option
mysqlslap, mysqlslap — Load Emulation Client
number-of-queries option
mysqlslap, mysqlslap — Load Emulation Client
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
NVARCHAR data type, Overview of String Types

O

[index top]
obtaining information about partitions, Obtaining Information About Partitions
OCT(), Mathematical 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 system variable, Server System Variables
old-alter-table option
mysqld, Server Command Options
old-passwords option
mysqld, Server Command Options, Security-Related mysqld Options
old-style-user-limits option
mysqld, Server Command Options
old_alter_table system variable, Server System Variables
OLD_PASSWORD(), Encryption and Compression Functions
old_passwords system variable, Server System Variables
old_server option
mysqlaccess, mysqlaccess — Client for Checking Access Privileges
ON DUPLICATE KEY UPDATE, INSERT Syntax
one-database option
mysql, mysql Options
one-thread option
mysqld, Server Command Options
one_shot system variable, Server System Variables
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-print option
mysqlslap, mysqlslap — Load Emulation Client
ONLY_FULL_GROUP_BY
SQL mode, GROUP BY and HAVING with Hidden Columns
ONLY_FULL_GROUP_BY SQL mode, Server SQL Modes
OPEN, Cursor OPEN Statement
Open Source
defined, What is MySQL?
open tables, mysqladmin — Client for Administering a MySQL Server, How MySQL Opens and Closes Tables
open-files-limit option
mysqld, Server Command Options
mysqld_safe, mysqld_safe — MySQL Server Startup Script
OpenGIS, Introduction to MySQL Spatial Support
opening
tables, How MySQL Opens and Closes Tables
Opening master dump table
thread state, Replication Slave Connection Thread States
Opening table
thread state, General Thread States
Opening tables
thread state, General Thread States
opens, mysqladmin — Client for Administering a MySQL Server
OpenSSL, Using SSL for Secure Connections, Using SSL Connections
open_files_limit option
mysqlbackup, mysqlbackup — Display Backup Information
open_files_limit system variable, Server System Variables
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
Batched Key Access, Block Nested-Loop and Batched Key Access Joins, Batched Key Access Joins
Block Nested-Loop, Block Nested-Loop and Batched Key Access Joins, Block Nested-Loop Algorithm for Outer Joins and Semi-Joins
Multi-Range Read, Multi-Range Read Optimization
subquery, Optimizing IN/=ANY Subqueries
tips, Other Optimization Tips
optimizations, WHERE Clause Optimization, Index Merge Optimization
optimize option
mysqlcheck, mysqlcheck — A Table Maintenance Program
OPTIMIZE TABLE, OPTIMIZE TABLE Syntax
and partitioning, Maintenance of Partitions
optimizer
and replication, Replication and the Query Optimizer
controlling, Controlling Query Optimizer Performance
optimizer_prune_level system variable, Server System Variables
optimizer_search_depth system variable, Server System Variables
optimizer_switch system variable, Server System Variables, Using optimizer_switch to Control the Optimizer
optimizer_use_mrr system variable, Server System Variables
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
option modifiers, Program Option Modifiers
options
boolean, Program Option Modifiers
command-line
mysql, mysql Options
mysqladmin, mysqladmin — Client for Administering a MySQL Server
configure, Typical configure Options
embedded server, Options with the Embedded Server
libmysqld, Options with the Embedded Server
myisamchk, myisamchk General Options
provided by MySQL, Tutorial
replication, Replication Features and Issues
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, Server SQL Modes
ORD(), String Functions
ORDER BY, Sorting Rows, ALTER TABLE Syntax, SELECT Syntax
NULL, ORDER BY Optimization, SELECT Syntax
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

[index top]
packages
list of, Packages that support MySQL
PAD_CHAR_TO_FULL_LENGTH SQL mode, Server SQL Modes
pager command
mysql, mysql Commands
pager option
mysql, mysql Options
parallel-recover option
myisamchk, myisamchk Repair Options
parameters
server, Tuning Server Parameters
PARAMETERS
INFORMATION_SCHEMA table, The INFORMATION_SCHEMA PARAMETERS Table
parentheses ( and ), Operator Precedence
PARTITION, Partitioning
partition management, Partition Management
partition pruning, Partition Pruning
partitioning, Partitioning
advantages, Overview of Partitioning in MySQL
and dates, Partition Types
and foreign keys, Restrictions and Limitations on Partitioning
and FULLTEXT indexes, Restrictions and Limitations on Partitioning
and key cache, Restrictions and Limitations on Partitioning
and server SQL mode, Restrictions and Limitations on Partitioning
and subqueries, Restrictions and Limitations on Partitioning
and temporary tables, Restrictions and Limitations on Partitioning, Partitioning Keys, Primary Keys, and Unique Keys
by hash, HASH Partitioning
by key, KEY Partitioning
by linear hash, LINEAR HASH Partitioning
by linear key, KEY Partitioning
by list, LIST Partitioning
by range, RANGE Partitioning
concepts, Overview of Partitioning in MySQL
data type of partitioning key, Restrictions and Limitations on Partitioning
enabling, Partitioning
functions supported in partitioning expressions, Partitioning Limitations Relating to Functions
limitations, Restrictions and Limitations on Partitioning
operators disallowed in partitioning expressions, Restrictions and Limitations on Partitioning
operators supported in partitioning expressions, Restrictions and Limitations on Partitioning
optimization, Obtaining Information About Partitions, Partition Pruning
resources, Partitioning
storage engines (limitations), Partitioning Limitations Relating to Storage Engines
subpartitioning, Restrictions and Limitations on Partitioning
support, Partitioning
types, Partition Types
Partitioning
maximum number of partitions, Restrictions and Limitations on Partitioning
partitioning information statements, Obtaining Information About Partitions
partitioning keys and primary keys, Partitioning Keys, Primary Keys, and Unique Keys
partitioning keys and unique keys, Partitioning Keys, Primary Keys, and Unique Keys
partitions
adding and dropping, Partition Management
analyzing, Maintenance of Partitions
checking, Maintenance of Partitions
managing, Partition Management
modifying, Partition Management
optimizing, Maintenance of Partitions
repairing, Maintenance of Partitions
splitting and merging, Partition Management
PARTITIONS
INFORMATION_SCHEMA table, The INFORMATION_SCHEMA PARTITIONS Table
password
root user, Securing the Initial MySQL Accounts
password encryption
reversibility of, Encryption and Compression Functions
password option, Connecting to the MySQL Server
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 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
mysqlslap, mysqlslap — Load Emulation Client
mysql_convert_table_format, mysql_convert_table_format — Convert Tables to Use a Given Storage Engine
mysql_setpermission, mysql_setpermission — Interactively Set Permissions in Grant Tables
PASSWORD(), Access Control, Stage 1: Connection Verification, Assigning Account Passwords, Encryption and Compression Functions, Ignoring user
passwords
administrator guidelines, Administrator Guidelines for Password Security
for users, User Names and Passwords
forgotten, How to Reset the Root Password
hashing, Password Hashing in MySQL
lost, How to Reset the Root Password
resetting, How to Reset the Root Password
security, The MySQL Access Privilege System, Password Security in MySQL
setting, Assigning Account Passwords, GRANT Syntax, SET PASSWORD Syntax
user guidelines, End-User Guidelines for Password Security
PATH environment variable, Installing MySQL from tar.gz Packages 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, Make Your Data as Small as Possible, Replication FAQ
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 MySQL Programs, perror — Explain Error Codes
help option, perror — Explain Error Codes
silent option, perror — Explain Error Codes
verbose option, perror — Explain Error Codes
version option, perror — Explain Error Codes
phantom rows, Avoiding the Phantom Problem Using Next-Key Locking
PHP API, MySQL PHP API
PI(), Mathematical Functions
pid-file option
mysql.server, mysql.server — MySQL Server Startup Script
mysqld, Server Command Options
mysqld_safe, mysqld_safe — MySQL Server Startup Script
pid_file system variable, Server System Variables
Ping
thread command, Thread Command Values
pipe option, Connecting to the MySQL Server
mysql, mysql Options, mysqlcheck — A Table Maintenance Program
mysqladmin, mysqladmin — Client for Administering a MySQL Server
mysqldump, mysqldump — A Database Backup Program
mysqlimport, mysqlimport — A Data Import Program
mysqlshow, mysqlshow — Display Database, Table, and Column Information
mysqlslap, mysqlslap — Load Emulation Client
PIPES_AS_CONCAT SQL mode, Server SQL Modes
plan option
mysqlaccess, mysqlaccess — Client for Checking Access Privileges
plugin API, The MySQL Plugin Interface
plugin-load option
mysqld, Server Command Options
plugindir option
mysql_config, mysql_config — Get Compile Options for Compiling Clients
plugins
adding, The MySQL Plugin Interface
installing, INSTALL PLUGIN Syntax
uninstalling, UNINSTALL PLUGIN Syntax
PLUGINS
INFORMATION_SCHEMA table, The INFORMATION_SCHEMA PLUGINS Table
plugin_dir system variable, Server System Variables
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, Connecting to the MySQL Server
mysql, mysql Options
mysqladmin, mysqladmin — Client for Administering a MySQL Server
mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files
mysqlcheck, mysqlcheck — A Table Maintenance Program
mysqld, Server 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
mysqlshow, mysqlshow — Display Database, Table, and Column Information
mysqlslap, mysqlslap — Load Emulation Client
mysql_config, mysql_config — Get Compile Options for Compiling Clients
mysql_convert_table_format, mysql_convert_table_format — Convert Tables to Use a Given Storage Engine
mysql_setpermission, mysql_setpermission — Interactively Set Permissions in Grant Tables
port system variable, Server System Variables
port-open-timeout option
mysqld, Server Command Options
portability, Designing Applications for Portability
types, Using Data Types from Other Database Engines
porting
to other systems, Debugging and Porting MySQL
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
post-query option
mysqlslap, mysqlslap — Load Emulation Client
post-system option
mysqlslap, mysqlslap — Load Emulation Client
PostgreSQL compatibility, MySQL Extensions to Standard SQL
POSTGRESQL SQL mode, Server SQL Modes
POW(), Mathematical Functions
POWER(), Mathematical Functions
pre-query option
mysqlslap, mysqlslap — Load Emulation Client
pre-system option
mysqlslap, mysqlslap — Load Emulation Client
precedence
operator, Operator Precedence
precision
arithmetic, Precision Math
precision math, Precision Math
prefix option
configure, Typical configure Options
preload_buffer_size system variable, Server System Variables
Prepare
thread command, Thread Command Values
PREPARE, SQL Syntax for Prepared Statements, PREPARE Syntax
XA transactions, XA Transaction SQL Syntax
prepared statements, SQL Syntax for Prepared Statements, PREPARE Syntax, EXECUTE Syntax, DEALLOCATE PREPARE Syntax, C API Prepared Statements
repreparation, Automatic Prepared Statement Repreparation
preparing
thread state, General Thread States
preserve-schema option
mysqlslap, mysqlslap — Load Emulation Client
preview option
mysqlaccess, mysqlaccess — Client for Checking Access Privileges
primary key
constraint, PRIMARY KEY and UNIQUE Index Constraints
deleting, ALTER TABLE Syntax
PRIMARY KEY, ALTER TABLE Syntax, CREATE TABLE Syntax
primary keys
and partitioning keys, Partitioning Keys, Primary Keys, and Unique Keys
print command
mysql, mysql Commands
print-defaults option, Command-Line Options that Affect Option-File Handling
privilege
changes, When Privilege Changes Take Effect
privilege information
location, Privilege System Grant Tables
privilege system, The MySQL Access Privilege System
privileges
access, The MySQL Access Privilege System
adding, Adding User Accounts
and replication, Replication of the System mysql Database
default, Securing the Initial MySQL Accounts
deleting, Removing User Accounts, DROP USER Syntax
display, SHOW GRANTS Syntax
dropping, Removing User Accounts, 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
lost connection errors, Lost connection to MySQL server
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, Using Stored Routines (Procedures and Functions)
process support, Operating Systems Supported by MySQL Community Server
processes
display, SHOW PROCESSLIST Syntax
processing
arguments, UDF Argument Processing
Processlist
thread command, Thread Command Values
PROCESSLIST, SHOW PROCESSLIST Syntax
INFORMATION_SCHEMA table, The INFORMATION_SCHEMA PROCESSLIST Table
PROFILING
INFORMATION_SCHEMA table, The INFORMATION_SCHEMA PROFILING Table
profiling session variable, Session System Variables
profiling_history_size session variable, Session System Variables
program variables
setting, Using Options to Set Program Variables
program-development utilities, Overview of MySQL Programs
programs
administrative, Overview of MySQL Programs
client, Overview of MySQL Programs, Building Client Programs
crash-me, Designing Applications for Portability
stored, MySQL Compound-Statement Syntax, Stored Programs and Views
utility, Overview of MySQL Programs
prompt command
mysql, mysql Commands
prompt option
mysql, mysql Options
prompts
meanings, Entering Queries
pronunciation
MySQL, What is MySQL?
protocol option, Connecting to the MySQL Server
mysql, mysql Options
mysqladmin, mysqladmin — Client for Administering a MySQL Server
mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files
mysqlcheck, mysqlcheck — A Table Maintenance Program
mysqldump, mysqldump — A Database Backup Program
mysqlimport, mysqlimport — A Data Import Program
mysqlshow, mysqlshow — Display Database, Table, and Column Information
mysqlslap, mysqlslap — Load Emulation Client
protocol_version system variable, Server System Variables
pseudo_thread_id system variable, Server System Variables
PURGE BACKUP LOGS, PURGE BACKUP LOGS Syntax
PURGE BINARY LOGS, PURGE BINARY LOGS Syntax
PURGE MASTER LOGS, PURGE BINARY LOGS Syntax
Purging old relay logs
thread state, General Thread States
Python API, MySQL Python API

Q

[index top]
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
thread command, Thread Command Values
Query Cache, The MySQL Query Cache
query end
thread state, General Thread States
query option
mysqlslap, mysqlslap — Load Emulation Client
query_alloc_block_size system variable, Server System Variables
query_cache_limit system variable, Server System Variables
query_cache_min_res_unit system variable, Server System Variables
query_cache_size system variable, Server System Variables
query_cache_type system variable, Server System Variables
query_cache_wlock_invalidate system variable, Server System Variables
query_prealloc_size system variable, Server System Variables
questions, mysqladmin — Client for Administering a MySQL Server
answering, Guidelines for Using the Mailing Lists
Queueing master event to the relay log
thread state, Replication Slave I/O Thread States
quick option
myisamchk, myisamchk Repair Options
mysql, mysql Options
mysqlcheck, mysqlcheck — A Table Maintenance Program
mysqldump, mysqldump — A Database Backup Program
quiet option
mysqlhotcopy, mysqlhotcopy — A Database Backup Program
Quit
thread command, Thread Command Values
quit command
mysql, mysql Commands
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, Schema Object Names

R

[index top]
RADIANS(), Mathematical Functions
RAND(), Mathematical Functions
rand_seed1 session variable, Session System Variables
rand_seed2 session variable, Session System Variables
range join type
optimizer, Optimizing Queries with EXPLAIN
range partitioning, RANGE Partitioning
range partitions
adding and dropping, Management of RANGE and LIST Partitions
managing, Management of RANGE and LIST Partitions
range_alloc_block_size system variable, Server System Variables
raw option
mysql, mysql Options
re-creating
grant tables, Problems Running mysql_install_db
READ COMMITTED
transaction isolation level, SET TRANSACTION Syntax
READ UNCOMMITTED
transaction isolation level, SET TRANSACTION Syntax
read-from-remote-server option
mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files
read-only option
myisamchk, myisamchk Check Options
mysqld, Replication Slave Options and Variables
Reading event from the relay log
thread state, Replication Slave SQL Thread States
Reading from net
thread state, General Thread States
Reading master dump table data
thread state, Replication Slave Connection Thread States
read_buffer_size myisamchk variable, myisamchk General Options
read_buffer_size system variable, Server System Variables
read_only system variable, Server System Variables
read_rnd_buffer_size system variable, Server System Variables
REAL data type, Overview of Numeric Types
REAL_AS_FLOAT SQL mode, Server SQL Modes
Rebuilding the index on master dump table
thread state, Replication Slave Connection Thread States
reconfiguring, Dealing with Problems Compiling MySQL
reconnect option
mysql, mysql Options
Reconnecting after a failed binlog dump request
thread state, Replication Slave I/O Thread States
Reconnecting after a failed master event read
thread state, Replication Slave I/O Thread States
record-level locks
InnoDB, InnoDB Startup Options and System Variables, The InnoDB Transaction Model and Locking, InnoDB Record, Gap, and Next-Key Locks, Avoiding the Phantom Problem Using Next-Key Locking
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
reducing
data size, Make Your Data as Small as Possible
ref join type
optimizer, Optimizing Queries with EXPLAIN
references, ALTER TABLE Syntax
REFERENTIAL_CONSTRAINTS
INFORMATION_SCHEMA table, The INFORMATION_SCHEMA REFERENTIAL_CONSTRAINTS Table
Refresh
thread command, Thread Command Values
ref_or_null, IS NULL Optimization
ref_or_null join type
optimizer, Optimizing Queries with EXPLAIN
REGEXP, Regular Expressions
REGEXP operator, Regular Expressions
regexp option
mysqlhotcopy, mysqlhotcopy — A Database Backup Program
mysql_find_rows, mysql_find_rows — Extract SQL Statements from Files
Register Slave
thread command, Thread Command Values
Registering slave on master
thread state, Replication Slave I/O Thread States
regular expression syntax, Regular Expressions
rehash command
mysql, mysql Commands
Related(), Functions That Test Spatial Relationships Between Geometries
relational databases
defined, What is MySQL?
relative option
mysqladmin, mysqladmin — Client for Administering a MySQL Server
relay-log option
mysqld, Replication Slave Options and Variables
relay-log-index option
mysqld, Replication Slave Options and Variables
relay-log-info-file option
mysqld, Replication Slave Options and Variables
relay-log-purge option
mysqld, Replication Slave Options and Variables
relay-log-recovery option
mysqld, Replication Slave Options and Variables
relay-log-space-limit option
mysqld, Replication Slave Options and Variables
relay_log_purge system variable, Server System Variables
relay_log_recovery system variable, Replication Slave Options and Variables
relay_log_space_limit system variable, Server System Variables
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
Removing duplicates
thread state, General Thread States
removing tmp table
thread state, General Thread States
rename
thread state, General Thread States
rename result table
thread state, General Thread States
RENAME TABLE, RENAME TABLE Syntax
RENAME USER, RENAME USER Syntax
renaming user accounts, RENAME USER Syntax
Reopen tables
thread state, General Thread States
reordering
columns, How to Change the Order of Columns in a Table
repair
tables, mysqlcheck — A Table Maintenance Program
Repair by sorting
thread state, General Thread States
Repair done
thread state, General Thread States
repair option
mysqlcheck, mysqlcheck — A Table Maintenance Program
repair options
myisamchk, myisamchk Repair Options
REPAIR TABLE, REPAIR TABLE Syntax
and partitioning, Maintenance of Partitions
Repair with keycache
thread state, General Thread States
repairing
tables, How to Repair Tables
REPEAT, REPEAT Statement
REPEAT(), String Functions
REPEATABLE READ
transaction isolation level, SET TRANSACTION Syntax
replace, Overview of MySQL Programs
REPLACE, REPLACE Syntax
replace option
mysqldump, mysqldump — A Database Backup Program
mysqlimport, mysqlimport — A Data Import Program
replace utility, replace — A String-Replacement Utility
REPLACE(), String Functions
replicate-do-db option
mysqld, Replication Slave Options and Variables
replicate-do-table option
mysqld, Replication Slave Options and Variables
replicate-ignore-db option
mysqld, Replication Slave Options and Variables
replicate-ignore-table option
mysqld, Replication Slave Options and Variables
replicate-rewrite-db option
mysqld, Replication Slave Options and Variables
replicate-same-server-id option
mysqld, Replication Slave Options and Variables
replicate-wild-do-table option
mysqld, Replication Slave Options and Variables
replicate-wild-ignore-table option
mysqld, Replication Slave Options and Variables
replication, Replication
and AUTO_INCREMENT, Replication and AUTO_INCREMENT
and character sets, Replication and Character Sets
and CREATE TABLE ... SELECT, Replication of CREATE TABLE ... SELECT Statements
and DATA DIRECTORY, Replication and DIRECTORY Table Options
and DROP ... IF EXISTS, Replication of DROP ... IF EXISTS Statements
and errors on slave, Slave Errors during Replication
and floating-point values, Replication with Floating-Point Values
and FLUSH, Replication and FLUSH
and functions, Replication and System Functions
and INDEX DIRECTORY, Replication and DIRECTORY Table Options
and invoked features, Replication of Invoked Features
and LAST_INSERT_ID(), Replication and AUTO_INCREMENT
and LIMIT, Replication and LIMIT
and LOAD DATA, Replication and LOAD DATA
and MEMORY tables, Replication with MEMORY Tables
and mysql (system) database, Replication of the System mysql Database
and partial updates, Replication and Transactions
and privileges, Replication of the System mysql Database
and query optimizer, Replication and the Query Optimizer
and reserved words, Replication and Reserved Words
and scheduled events, Replication of Invoked Features
and slow query log, Replication and the Slow Query Log
and stored routines, Replication of Invoked Features
and temporary tables, Replication and Temporary Tables
and time zones, Replication and Time Zones
and TIMESTAMP, Replication and AUTO_INCREMENT
and transactions, Replication Retries and Timeouts, Replication and Transactions
and triggers, Replication of Invoked Features, Replication and Triggers
and TRUNCATE, Replication and TRUNCATE
and variables, Replication and Variables
and views, Replication and Views
attribute promotion, Replication of Columns Having Different Data Types
crashes, Replication During a Master Crash
row-based vs statement-based, Comparison of Statement-Based and Row-Based Replication
semisynchronous, Semisynchronous Replication
shutdown and restart, Replication During a Master Shutdown, Replication during a Slave Shutdown, Replication and Temporary Tables
statements incompatible with STATEMENT mode, Comparison of Statement-Based and Row-Based Replication
timeouts, Replication Retries and Timeouts
with differing tables on master and slave, Replication with Differing Tables on Master and Slave
replication formats
compared, Comparison of Statement-Based and Row-Based Replication
replication implementation, Replication Implementation
replication limitations, Replication Features and Issues
replication master
thread states, Replication Master Thread States
replication masters, Replication During a Master Crash
statements, SQL Statements for Controlling Master Servers
replication options, Replication Features and Issues
replication slave
thread states, Replication Slave I/O Thread States, Replication Slave SQL Thread States, Replication Slave Connection Thread States
replication slaves
statements, SQL Statements for Controlling Slave Servers
report-host option
mysqld, Replication Slave Options and Variables
report-password option
mysqld, Replication Slave Options and Variables
report-port option
mysqld, Replication Slave Options and Variables
report-user option
mysqld, Replication Slave Options and Variables
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
report_host system variable, Server System Variables
report_password system variable, Server System Variables
report_port system variable, Server System Variables
report_user system variable, Server System Variables
Requesting binlog dump
thread state, Replication Slave I/O Thread States
REQUIRE GRANT option, GRANT Syntax
reschedule
thread state, Delayed-Insert Thread States
reserved words, Reserved Words
and replication, Replication and Reserved Words
RESET MASTER, RESET MASTER Syntax
RESET SLAVE, RESET SLAVE Syntax
Reset stmt
thread command, Thread Command Values
resetmaster option
mysqlhotcopy, mysqlhotcopy — A Database Backup Program
resetslave option
mysqlhotcopy, mysqlhotcopy — A Database Backup Program
RESIGNAL, RESIGNAL Syntax
resolveip, Overview of MySQL Programs, resolveip — Resolve Host name to IP Address or Vice Versa
help option, resolveip — Resolve Host name to IP Address or Vice Versa
silent option, resolveip — Resolve Host name to IP Address or Vice Versa
version option, resolveip — Resolve Host name to IP Address or Vice Versa
resolve_stack_dump, Overview of MySQL Programs, resolve_stack_dump — Resolve Numeric Stack Trace Dump to Symbols
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
restarting
the server, Unix Post-Installation Procedures
RESTORE, RESTORE Syntax
RESTORE restrictions, Restrictions on BACKUP DATABASE and RESTORE
restrictions
BACKUP DATABASE, Restrictions on BACKUP DATABASE and RESTORE
events, Restrictions on Stored Routines, Triggers, and Events
RESTORE, Restrictions on BACKUP DATABASE and RESTORE
server-side cursors, Restrictions on Server-Side Cursors
signal, Restrictions on Signals
stored routines, Restrictions on Stored Routines, Triggers, and Events
subqueries, Restrictions on Subqueries
triggers, Restrictions on Stored Routines, Triggers, and Events
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, RETURN Syntax
return (\r), Strings, LOAD DATA INFILE Syntax
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, Regular Expressions
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 back
thread state, General Thread States
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-based replication
advantages, Comparison of Statement-Based and Row-Based Replication
disadvantages, Comparison of Statement-Based and Row-Based Replication
row-level locking, Internal Locking Methods
rows
counting, Counting Rows
deleting, Deleting Rows from Related Tables
locking, Transactions and Atomic Operations
matching problems, Solving Problems with No Matching Rows
selecting, Selecting Particular Rows
sorting, Sorting Rows
rows option
mysql_find_rows, mysql_find_rows — Extract SQL Statements from Files
ROW_COUNT(), Information Functions
RPAD(), String Functions
Rpl_semi_sync_master_clients status variable, Server Status Variables
rpl_semi_sync_master_enabled system variable, Server System Variables
Rpl_semi_sync_master_net_avg_wait_time status variable, Server Status Variables
Rpl_semi_sync_master_net_waits status variable, Server Status Variables
Rpl_semi_sync_master_net_wait_time status variable, Server Status Variables
Rpl_semi_sync_master_no_times status variable, Server Status Variables
Rpl_semi_sync_master_no_tx status variable, Server Status Variables
rpl_semi_sync_master_reply_log_file_pos system variable, Server System Variables
Rpl_semi_sync_master_status status variable, Server Status Variables
Rpl_semi_sync_master_timefunc_failures status variable, Server Status Variables
rpl_semi_sync_master_timeout system variable, Server System Variables
rpl_semi_sync_master_trace_level system variable, Server System Variables
Rpl_semi_sync_master_tx_avg_wait_time status variable, Server Status Variables
Rpl_semi_sync_master_tx_waits status variable, Server Status Variables
Rpl_semi_sync_master_tx_wait_time status variable, Server Status Variables
Rpl_semi_sync_master_wait_pos_backtraverse status variable, Server Status Variables
Rpl_semi_sync_master_wait_sessions status variable, Server Status Variables
Rpl_semi_sync_master_yes_tx status variable, Server Status Variables
rpl_semi_sync_slave_enabled status variable, Server Status Variables
rpl_semi_sync_slave_enabled system variable, Server System Variables
Rpl_semi_sync_slave_status status variable, Server Status Variables
rpl_semi_sync_slave_trace_level system variable, Server System Variables
RPM file, Installing MySQL from RPM Packages on Linux
rpm option
mysql_install_db, mysql_install_db — Initialize MySQL Data Directory
RPM Package Manager, Installing MySQL from RPM Packages on Linux
RTRIM(), String Functions
RTS-threads, Comments about RTS Threads
Ruby API, MySQL Ruby APIs
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

[index top]
safe-mode option
mysqld, Server Command Options
safe-recover option
myisamchk, myisamchk Repair Options
safe-show-database option
mysqld, Server Command Options, Security-Related mysqld Options
safe-updates option, Using the --safe-updates Option
mysql, mysql Options
safe-user-create option
mysqld, Server Command Options, Security-Related mysqld Options
Sakila, History of MySQL
SAVEPOINT, SAVEPOINT and ROLLBACK TO SAVEPOINT Syntax
Saving state
thread state, General Thread States
scale
arithmetic, Precision Math
schema
altering, ALTER DATABASE Syntax
creating, CREATE DATABASE Syntax
deleting, DROP DATABASE Syntax
SCHEMA(), Information Functions
SCHEMATA
INFORMATION_SCHEMA table, The INFORMATION_SCHEMA SCHEMATA Table
SCHEMA_PRIVILEGES
INFORMATION_SCHEMA table, The INFORMATION_SCHEMA SCHEMA_PRIVILEGES Table
script files, Using mysql in Batch Mode
scripts, mysqld_safe — MySQL Server Startup Script, mysqld_multi — Manage Multiple MySQL Servers
mysqlbug, How to Report Bugs or Problems
mysql_install_db, Problems Running mysql_install_db
SQL, mysql — The MySQL Command-Line Tool
search option
mysqlbackup, mysqlbackup — Display Backup Information
searching
and case sensitivity, Case Sensitivity in String Searches
full-text, Full-Text Search Functions
MySQL Web pages, How to Report Bugs or Problems
two keys, Searching on Two Keys
Searching rows for update
thread state, General Thread States
SECOND(), Date and Time Functions
secondary index
InnoDB, Clustered and Secondary Indexes
secure-auth option
mysql, mysql Options
mysqld, Server Command Options, Security-Related mysqld Options
secure-backup-file-priv option
mysqld, Server Command Options, Security-Related mysqld Options
secure-file-priv option
mysqld, Server Command Options, Security-Related mysqld Options
secure_auth system variable, Server System Variables
secure_backup_file_priv system variable, Server System Variables
secure_file_priv system variable, Server System Variables
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, EXPLAIN Syntax
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
semi-consistent read
InnoDB, InnoDB Startup Options and System Variables
semi-joins, Semi-Join Strategies
semisynchronous replication, Semisynchronous Replication
administrative interface, Semisynchronous Replication Administrative Interface
configuration, Semisynchronous Replication Installation and Configuration
installation, Semisynchronous Replication Installation and Configuration
monitoring, Semisynchronous Replication Monitoring
Sending binlog event to slave
thread state, Replication Master Thread States
SEQUENCE, Using AUTO_INCREMENT
sequence emulation, Information Functions
sequences, Using AUTO_INCREMENT
SERIAL, Overview of Numeric Types
SERIAL DEFAULT VALUE, Data Type Default Values
SERIALIZABLE
transaction isolation level, SET TRANSACTION Syntax
server
connecting, Connecting to and Disconnecting from the Server, Connecting to the MySQL Server
debugging, Debugging a MySQL Server
disconnecting, Connecting to and Disconnecting from the Server
logs, MySQL Server Logs
restart, Unix Post-Installation Procedures
shutdown, Unix Post-Installation Procedures
signal handling, Server Response to Signals
starting, Unix Post-Installation Procedures
starting and stopping, Starting and Stopping MySQL Automatically
starting problems, Starting and Troubleshooting the MySQL Server
server administration, mysqladmin — Client for Administering a MySQL Server
server variables, Server System Variables, SHOW VARIABLES Syntax
server-id option
mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files
mysqld, Replication and Binary Logging Options and Variables
server-side cursor restrictions, Restrictions on Server-Side Cursors
servers
multiple, Running Multiple MySQL Servers on the Same Machine
server_id system variable, Server System Variables
service-startup-timeout option
mysql.server, mysql.server — MySQL Server Startup Script
session server variables, Session System Variables
session system variables, Session System Variables
session variable
autocommit, Session System Variables
backup_wait_timeout, Session System Variables
big_tables, Session System Variables
error_count, Session System Variables
foreign_key_checks, Session System Variables
identity, Session System Variables
insert_id, Session System Variables
last_insert_id, Session System Variables
profiling, Session System Variables
profiling_history_size, Session System Variables
rand_seed1, Session System Variables
rand_seed2, Session System Variables
sql_auto_is_null, Session System Variables
sql_big_selects, Session System Variables
sql_buffer_result, Session System Variables
sql_log_bin, Session System Variables
sql_log_off, Session System Variables
sql_log_update, Session System Variables
sql_notes, Session System Variables
sql_quote_show_create, Session System Variables
sql_safe_updates, Session System Variables
sql_warnings, Session System Variables
timestamp, Session System Variables
unique_checks, Session System Variables
warning_count, Session System Variables
session variables
and replication, Replication and Variables
server, Session System Variables
system, Session System Variables
SESSION_STATUS
INFORMATION_SCHEMA table, The INFORMATION_SCHEMA GLOBAL_STATUS and SESSION_STATUS Tables
SESSION_USER(), Information Functions
SESSION_VARIABLES
INFORMATION_SCHEMA table, The INFORMATION_SCHEMA GLOBAL_VARIABLES and SESSION_VARIABLES Tables
SET, SET Syntax, Variable SET Statement
CHARACTER SET, Connection Character Sets and Collations, SET Syntax
NAMES, Connection Character Sets and Collations, Configuring the Character Set and Collation for Applications, SET Syntax
ONE_SHOT, SET Syntax
size, Data Type Storage Requirements
SET data type, Overview of String Types, The SET Type
SET GLOBAL SQL_SLAVE_SKIP_COUNTER, SET GLOBAL SQL_SLAVE_SKIP_COUNTER Syntax
Set option
thread command, Thread Command Values
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
set-random-seed option
mysqlslap, mysqlslap — Load Emulation Client
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
thread state, General Thread States
SHA(), Encryption and Compression Functions
SHA1(), Encryption and Compression Functions
SHA2(), Encryption and Compression Functions
shared-memory option
mysqld, Server Command Options
shared-memory-base-name option, Connecting to the MySQL Server
mysqld, Server Command Options
mysqlslap, mysqlslap — Load Emulation Client
shared_memory system variable, Server System Variables
shared_memory_base_name system variable, Server System Variables
shell syntax, Typographical and Syntax Conventions, Conventions Used in This Document
short-form option
mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files
SHOW AUTHORS, SHOW Syntax, SHOW AUTHORS Syntax
SHOW BINARY LOGS, SHOW BINARY LOGS Syntax
SHOW BINLOG EVENTS, SHOW Syntax, SHOW BINLOG EVENTS Syntax
SHOW CHARACTER SET, SHOW Syntax, SHOW CHARACTER SET Syntax
SHOW COLLATION, SHOW Syntax, SHOW COLLATION Syntax
SHOW COLUMNS, SHOW Syntax, SHOW COLUMNS Syntax
SHOW CONTRIBUTORS, SHOW Syntax, SHOW CONTRIBUTORS Syntax
SHOW CREATE DATABASE, SHOW Syntax, SHOW CREATE DATABASE Syntax
SHOW CREATE EVENT, SHOW Syntax
SHOW CREATE FUNCTION, SHOW Syntax, SHOW CREATE FUNCTION Syntax
SHOW CREATE PROCEDURE, SHOW Syntax, SHOW CREATE PROCEDURE Syntax
SHOW CREATE SCHEMA, SHOW Syntax, SHOW CREATE DATABASE Syntax
SHOW CREATE TABLE, SHOW Syntax, SHOW CREATE TABLE Syntax
SHOW CREATE TRIGGER, SHOW Syntax, SHOW CREATE TRIGGER Syntax
SHOW CREATE VIEW, SHOW Syntax, SHOW CREATE VIEW Syntax
SHOW DATABASES, SHOW Syntax, SHOW DATABASES Syntax
SHOW ENGINE, SHOW Syntax, SHOW ENGINE Syntax
SHOW ENGINE INNODB STATUS, SHOW ENGINE Syntax
SHOW ENGINES, SHOW Syntax, SHOW ENGINES Syntax
SHOW ERRORS, SHOW Syntax, SHOW ERRORS Syntax
SHOW EVENTS, SHOW Syntax, SHOW EVENTS Syntax
SHOW extensions, Extensions to SHOW Statements
SHOW FIELDS, SHOW Syntax, SHOW COLUMNS Syntax
SHOW FUNCTION CODE, SHOW Syntax, SHOW FUNCTION CODE Syntax
SHOW FUNCTION STATUS, SHOW Syntax, SHOW FUNCTION STATUS Syntax
SHOW GRANTS, SHOW Syntax, SHOW GRANTS Syntax
SHOW INDEX, SHOW Syntax, SHOW INDEX 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 OPEN TABLES, SHOW Syntax, SHOW OPEN TABLES Syntax
SHOW PLUGINS, SHOW Syntax, SHOW PLUGINS Syntax
SHOW PRIVILEGES, SHOW Syntax, SHOW PRIVILEGES Syntax
SHOW PROCEDURE CODE, SHOW Syntax, SHOW PROCEDURE CODE Syntax
SHOW PROCEDURE STATUS, SHOW Syntax, SHOW PROCEDURE STATUS Syntax
SHOW PROCESSLIST, SHOW Syntax, SHOW PROCESSLIST Syntax
SHOW PROFILE, SHOW Syntax, SHOW PROFILE Syntax, SHOW PROFILES Syntax
SHOW PROFILES, SHOW Syntax, SHOW PROFILES Syntax
SHOW SCHEDULER STATUS, SHOW Syntax
SHOW SCHEMAS, SHOW Syntax, SHOW DATABASES Syntax
SHOW SLAVE HOSTS, SHOW Syntax, SHOW SLAVE HOSTS Syntax
SHOW SLAVE STATUS, SHOW Syntax, SHOW SLAVE STATUS Syntax
SHOW STATUS, SHOW Syntax
SHOW STORAGE ENGINES, SHOW ENGINES Syntax
SHOW TABLE STATUS, SHOW Syntax
SHOW TABLES, SHOW Syntax, SHOW TABLES Syntax
SHOW TRIGGERS, SHOW Syntax, SHOW TRIGGERS Syntax
SHOW VARIABLES, SHOW Syntax
SHOW WARNINGS, SHOW Syntax, SHOW WARNINGS Syntax
SHOW with WHERE, INFORMATION_SCHEMA Tables, Extensions to SHOW Statements
show-slave-auth-info option
mysqld, Replication Slave Options and Variables
show-table-type option
mysqlshow, mysqlshow — Display Database, Table, and Column Information
show-warnings option
mysql, mysql Options
showing
database information, mysqlshow — Display Database, Table, and Column Information
Shutdown
thread command, Thread Command Values
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
SIGNAL, SIGNAL Syntax
signal restrictions, Restrictions on Signals
signals
server response, Server Response to Signals
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 Program
mysqld_multi, mysqld_multi — Manage Multiple MySQL Servers
mysqlimport, mysqlimport — A Data Import Program
mysqlslap, mysqlslap — Load Emulation Client
perror, perror — Explain Error Codes
resolveip, resolveip — Resolve Host name to IP Address or Vice Versa
SIN(), Mathematical Functions
single quote (\'), Strings
single-transaction option
mysqldump, mysqldump — A Database Backup Program
size of tables, The table is full
sizes
display, Data Types
skip-column-names option
mysql, mysql Options
skip-comments option
mysqldump, mysqldump — A Database Backup Program
skip-concurrent-insert option
mysqld, Server Command Options
skip-external-locking option
mysqld, Server Command Options
skip-grant-tables option
mysqld, Server Command Options, Security-Related mysqld Options
skip-host-cache option
mysqld, Server Command Options
skip-innodb option
mysqld, Server Command Options
skip-kill-mysqld option
mysqld_safe, mysqld_safe — MySQL Server Startup Script
skip-line-numbers option
mysql, mysql Options
skip-name-resolve option
mysqld, Server Command Options, Security-Related mysqld Options
mysql_install_db, mysql_install_db — Initialize MySQL Data Directory
skip-networking option
mysqld, Server Command Options, Security-Related mysqld Options
skip-opt option
mysqldump, mysqldump — A Database Backup Program
skip-safemalloc option
mysqld, Server Command Options
skip-show-database option
mysqld, Server Command Options, Security-Related mysqld Options
skip-slave-start option
mysqld, Replication Slave Options and Variables
skip-stack-trace option
mysqld, Server Command Options
skip-symbolic-links option
mysqld, Server Command Options
skip-syslog option
mysqld_safe, mysqld_safe — MySQL Server Startup Script
skip-thread-priority option
mysqld, Server Command Options
skip-use-db option
mysql_find_rows, mysql_find_rows — Extract SQL Statements from Files
skip_external_locking system variable, Server System Variables
skip_networking system variable, Server System Variables
skip_show_database system variable, Server System Variables
slave option
mysqlslap, mysqlslap — Load Emulation Client
slave-load-tmpdir option
mysqld, Replication Slave Options and Variables
slave-net-timeout option
mysqld, Replication Slave Options and Variables
slave-skip-errors option
mysqld, Replication Slave Options and Variables
slave_compressed_protocol option
mysqld, Replication Slave Options and Variables
slave_compressed_protocol system variable, Replication Slave Options and Variables
slave_exec_mode system variable, Replication Slave Options and Variables
slave_load_tmpdir system variable, Replication Slave Options and Variables
slave_net_timeout system variable, Replication Slave Options and Variables
slave_skip_errors system variable, Replication Slave Options and Variables
slave_transaction_retries system variable, Replication Slave Options and Variables
Sleep
thread command, Thread Command Values
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
and replication, Replication and the Slow Query Log
slow-query-log option
mysqld, Server Command Options
slow_launch_time system variable, Server System Variables
slow_query_log system variable, Server System Variables
slow_query_log_file system variable, Server System Variables
SMALLINT data type, Overview of Numeric Types
snapshots option
mysqlbackup, mysqlbackup — Display Backup Information
socket location
changing, Typical configure Options
socket option, Connecting to the MySQL Server
mysql, mysql Options
mysqladmin, mysqladmin — Client for Administering a MySQL Server
mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files
mysqlcheck, mysqlcheck — A Table Maintenance Program
mysqld, Server 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
mysqlshow, mysqlshow — Display Database, Table, and Column Information
mysqlslap, mysqlslap — Load Emulation Client
mysql_config, mysql_config — Get Compile Options for Compiling Clients
mysql_convert_table_format, mysql_convert_table_format — Convert Tables to Use a Given Storage Engine
mysql_setpermission, mysql_setpermission — Interactively Set Permissions in Grant Tables
socket system variable, Server System Variables
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
Sorting for group
thread state, General Thread States
Sorting for order
thread state, General Thread States
Sorting index
thread state, General Thread States
Sorting result
thread state, General Thread States
sort_buffer_size myisamchk variable, myisamchk General Options
sort_buffer_size system variable, Server System Variables
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 command
mysql, mysql Commands
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, Binary Log Options and Variables
SQL
defined, What is MySQL?
SQL mode, Server SQL Modes
ALLOW_INVALID_DATES, Server SQL Modes
ANSI, Server SQL Modes
ANSI_QUOTES, Server SQL Modes
DB2, Server SQL Modes
ERROR_FOR_DIVISION_BY_ZERO, Server SQL Modes
HIGH_NOT_PRECEDENCE, Server SQL Modes
IGNORE_SPACE, Server SQL Modes
MAXDB, Server SQL Modes
MSSQL, Server SQL Modes
MYSQL323, Server SQL Modes
MYSQL40, Server SQL Modes
NO_AUTO_CREATE_USER, Server SQL Modes
NO_AUTO_VALUE_ON_ZERO, Server SQL Modes
NO_BACKSLASH_ESCAPES, Server SQL Modes
NO_DIR_IN_CREATE, Server SQL Modes
NO_ENGINE_SUBSTITUTION, Server SQL Modes
NO_FIELD_OPTIONS, Server SQL Modes
NO_KEY_OPTIONS, Server SQL Modes
NO_TABLE_OPTIONS, Server SQL Modes
NO_UNSIGNED_SUBTRACTION, Server SQL Modes
NO_ZERO_DATE, Server SQL Modes
NO_ZERO_IN_DATE, Server SQL Modes
ONLY_FULL_GROUP_BY, Server SQL Modes, GROUP BY and HAVING with Hidden Columns
ORACLE, Server SQL Modes
PAD_CHAR_TO_FULL_LENGTH, Server SQL Modes
PIPES_AS_CONCAT, Server SQL Modes
POSTGRESQL, Server SQL Modes
REAL_AS_FLOAT, Server SQL Modes
strict, Server SQL Modes
STRICT_ALL_TABLES, Server SQL Modes
STRICT_TRANS_TABLES, Server SQL Modes
TRADITIONAL, Server SQL Modes
SQL scripts, mysql — The MySQL Command-Line Tool
SQL statements
replication masters, SQL Statements for Controlling Master Servers
replication slaves, SQL Statements for Controlling Slave Servers
SQL-92
extensions to, MySQL Standards Compliance
sql-mode option
mysqld, Server Command Options
sql_auto_is_null session variable, Session System Variables
SQL_BIG_RESULT, SELECT Syntax
sql_big_selects session variable, Session System Variables
SQL_BUFFER_RESULT, SELECT Syntax
sql_buffer_result session variable, Session System Variables
SQL_CACHE, Query Cache SELECT Options, SELECT Syntax
SQL_CALC_FOUND_ROWS, SELECT Syntax
sql_log_bin session variable, Session System Variables
sql_log_off session variable, Session System Variables
sql_log_update session variable, Session System Variables
sql_mode system variable, Server System Variables
sql_notes session variable, Session System Variables
SQL_NO_CACHE, Query Cache SELECT Options, SELECT Syntax
sql_quote_show_create session variable, Session System Variables
sql_safe_updates session variable, Session System Variables
sql_select_limit system variable, Server System Variables
SQL_SLAVE_SKIP_COUNTER, SET GLOBAL SQL_SLAVE_SKIP_COUNTER Syntax
sql_slave_skip_counter system variable, Replication Slave Options and Variables
SQL_SMALL_RESULT, SELECT Syntax
sql_warnings session variable, Session System Variables
sql_yacc.cc problems, Dealing with Problems Compiling MySQL
SQRT(), Mathematical Functions
square brackets, Data Types
srcdir option
mysql_install_db, mysql_install_db — Initialize MySQL Data Directory
SRID(), General Geometry Functions
SSH, Connecting to MySQL Remotely from Windows with SSH
SSL, Using SSL Connections
SSL and X509 Basics, Using SSL for Secure Connections
SSL command options, SSL Command Options
ssl option, SSL Command Options
SSL options, Connecting to the MySQL Server
mysql, mysql Options
mysqladmin, mysqladmin — Client for Administering a MySQL Server
mysqlcheck, mysqlcheck — A Table Maintenance Program
mysqld, Server Command Options, Security-Related mysqld Options
mysqldump, mysqldump — A Database Backup Program
mysqlimport, mysqlimport — A Data Import Program
mysqlshow, mysqlshow — Display Database, Table, and Column Information
mysqlslap, mysqlslap — Load Emulation Client
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
ssl_ca system variable, Server System Variables
ssl_capath system variable, Server System Variables
ssl_cert system variable, Server System Variables
ssl_cipher system variable, Server System Variables
ssl_key system variable, Server System Variables
standalone option
mysqld, Server Command Options
Standard Monitor
InnoDB, SHOW ENGINE INNODB STATUS and the InnoDB Monitors
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 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
starting
comments, '--' as the Start of a Comment
mysqld, How to Run MySQL as a Normal User
the server, Unix Post-Installation Procedures
the server automatically, Starting and Stopping MySQL Automatically
Starting many servers, Running Multiple MySQL Servers on the Same Machine
StartPoint(), LineString Functions
startup options
default, Using Option Files
startup parameters, Tuning Server Parameters
mysql, mysql Options
mysqladmin, mysqladmin — Client for Administering a MySQL Server
tuning, System Factors and Startup Parameter Tuning
start_row option
mysql_find_rows, mysql_find_rows — Extract SQL Statements from Files
statefile option
comp_err, comp_err — Compile MySQL Error Message File
statement-based replication
advantages, Comparison of Statement-Based and Row-Based Replication
disadvantages, Comparison of Statement-Based and Row-Based Replication
unsafe statements, Comparison of Statement-Based and Row-Based Replication
statements
compound, MySQL Compound-Statement Syntax
GRANT, Adding User Accounts
INSERT, Adding User Accounts
replication masters, SQL Statements for Controlling Master Servers
replication slaves, SQL Statements for Controlling Slave Servers
statically
compiling, Typical configure Options
Statistics
thread command, Thread Command Values
statistics
thread state, General Thread States
STATISTICS
INFORMATION_SCHEMA table, The INFORMATION_SCHEMA STATISTICS Table
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
mysql, mysql Commands
results, mysqladmin — Client for Administering a MySQL Server
status option
mysqlshow, mysqlshow — Display Database, Table, and Column Information
status variable
Rpl_semi_sync_master_clients, Server Status Variables
Rpl_semi_sync_master_net_avg_wait_time, Server Status Variables
Rpl_semi_sync_master_net_waits, Server Status Variables
Rpl_semi_sync_master_net_wait_time, Server Status Variables
Rpl_semi_sync_master_no_times, Server Status Variables
Rpl_semi_sync_master_no_tx, Server Status Variables
Rpl_semi_sync_master_status, Server Status Variables
Rpl_semi_sync_master_timefunc_failures, Server Status Variables
Rpl_semi_sync_master_tx_avg_wait_time, Server Status Variables
Rpl_semi_sync_master_tx_waits, Server Status Variables
Rpl_semi_sync_master_tx_wait_time, Server Status Variables
Rpl_semi_sync_master_wait_pos_backtraverse, Server Status Variables
Rpl_semi_sync_master_wait_sessions, Server Status Variables
Rpl_semi_sync_master_yes_tx, Server Status Variables
rpl_semi_sync_slave_enabled, Server Status Variables
Rpl_semi_sync_slave_status, Server Status Variables
status variables, Server Status Variables, SHOW STATUS Syntax
STD(), GROUP BY (Aggregate) Functions
STDDEV(), GROUP BY (Aggregate) Functions
STDDEV_POP(), GROUP BY (Aggregate) Functions
STDDEV_SAMP(), GROUP BY (Aggregate) Functions
STOP SLAVE, STOP SLAVE Syntax
stop-datetime option
mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files
stop-position option
mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files
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
storage requirements
data type, Data Type Storage Requirements
storage space
minimizing, Make Your Data as Small as Possible
storage_engine system variable, Server System Variables
stored functions, Using Stored Routines (Procedures and Functions)
and INSERT DELAYED, INSERT Syntax
stored procedures, Using Stored Routines (Procedures and Functions)
stored procedures and triggers
defined, Stored Routines and Triggers
stored programs, MySQL Compound-Statement Syntax, Stored Programs and Views
stored routine restrictions, Restrictions on Stored Routines, Triggers, and Events
stored routines
and replication, Replication of Invoked Features
LAST_INSERT_ID(), Stored Procedures, Functions, Triggers, and LAST_INSERT_ID()
metadata, Stored Routine Metadata
storing row into queue
thread state, Delayed-Insert Thread States
STRAIGHT_JOIN, Optimizing Queries with EXPLAIN, LEFT JOIN and RIGHT JOIN Optimization, SELECT Syntax, JOIN Syntax
STRCMP(), String Comparison Functions
strict SQL mode, Server SQL Modes
STRICT_ALL_TABLES SQL mode, Server SQL Modes
STRICT_TRANS_TABLES SQL mode, Server SQL Modes
string collating, String Collating Support
string comparison functions, String Comparison Functions
string comparisons
case sensitivity, String Comparison Functions
string concatenation, Strings, String Functions
string functions, String Functions
string literal introducer, Strings, Character String Literal Character Set and Collation
string replacement
replace utility, replace — A String-Replacement Utility
string types, String Types
strings
defined, Literal Values
escaping characters, Literal Values
nondelimited, The DATETIME, DATE, and TIMESTAMP Types
striping
defined, Disk Issues
STR_TO_DATE(), Date and Time Functions
SUBDATE(), Date and Time Functions
subpartitioning, Subpartitioning
subpartitions, Subpartitioning
subqueries, Subquery Syntax
correlated, Correlated Subqueries
errors, Subquery Errors
rewriting as joins, Rewriting Subqueries as Joins
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
summary option
mysqlbackup, mysqlbackup — Display Backup Information
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, Server Command Options
symbols-file option
resolve_stack_dump, resolve_stack_dump — Resolve Numeric Stack Trace Dump to Symbols
SymDifference(), Spatial Operators
sync_binlog system variable, Binary Log Options and Variables
sync_frm system variable, Server System Variables
sync_master_info system variable, Replication Slave Options and Variables
sync_relay_log system variable, Replication Slave Options and Variables
sync_relay_log_info system variable, Replication Slave Options and Variables
syntax
regular expression, Regular Expressions
syntax conventions, Typographical and Syntax Conventions
SYSDATE(), Date and Time Functions
sysdate-is-now option
mysqld, Server Command Options
syslog option
mysqld_safe, mysqld_safe — MySQL Server Startup Script
syslog-tag option
mysqld_safe, mysqld_safe — MySQL Server Startup Script
system
privilege, The MySQL Access Privilege System
security, General Security Issues
system command
mysql, mysql Commands
System lock
thread state, General Thread States
system optimization, System Factors and Startup Parameter Tuning
system table
optimizer, Optimizing Queries with EXPLAIN, SELECT Syntax
system variable
automatic_sp_privileges, Server System Variables
auto_increment_increment, Replication Master Options and Variables
auto_increment_offset, Replication Master Options and Variables
backupdir, Server System Variables
backup_history_log, Server System Variables
backup_history_log_file, Server System Variables
backup_progress_log, Server System Variables
backup_progress_log_file, Server System Variables
back_log, Server System Variables
basedir, Server System Variables
binlog_cache_size, Binary Log Options and Variables
binlog_format, Binary Log Options and Variables
bulk_insert_buffer_size, Server System Variables
character_sets_dir, Server System Variables
character_set_client, Server System Variables
character_set_connection, Server System Variables
character_set_database, Server System Variables
character_set_filesystem, Server System Variables
character_set_results, Server System Variables
character_set_server, Server System Variables
character_set_system, Server System Variables
collation_connection, Server System Variables
collation_database, Server System Variables
collation_server, Server System Variables
completion_type, Server System Variables
concurrent_insert, Server System Variables
connect_timeout, Server System Variables
datadir, Server System Variables
datetime_format, Server System Variables
date_format, Server System Variables
debug, Server System Variables
debug_sync, Server System Variables
default_week_format, Server System Variables
delayed_insert_limit, Server System Variables
delayed_insert_timeout, Server System Variables
delayed_queue_size, Server System Variables
delay_key_write, Server System Variables
div_precision_increment, Server System Variables
engine_condition_pushdown, Server System Variables
event_scheduler, Server System Variables
expire_logs_days, Server System Variables
flush, Server System Variables
flush_time, Server System Variables
ft_boolean_syntax, Server System Variables
ft_max_word_len, Server System Variables
ft_min_word_len, Server System Variables
ft_query_expansion_limit, Server System Variables
ft_stopword_file, Server System Variables
general_log, Server System Variables
general_log_file, Server System Variables
group_concat_max_len, Server System Variables
have_compress, Server System Variables
have_crypt, Server System Variables
have_csv, Server System Variables
have_dynamic_loading, Server System Variables
have_geometry, Server System Variables
have_innodb, Server System Variables
have_openssl, Server System Variables
have_partitioning, Server System Variables
have_query_cache, Server System Variables
have_rtree_keys, Server System Variables
have_ssl, Server System Variables
have_symlink, Server System Variables
hostname, Server System Variables
init_connect, Server System Variables
init_file, Server System Variables
init_slave, Replication Slave Options and Variables
interactive_timeout, Server System Variables
join_buffer_size, Server System Variables
join_cache_level, Server System Variables
keep_files_on_create, Server System Variables
key_buffer_size, Server System Variables
key_cache_age_threshold, Server System Variables
key_cache_block_size, Server System Variables
key_cache_division_limit, Server System Variables
language, Server System Variables
large_files_support, Server System Variables
large_pages, Server System Variables
large_page_size, Server System Variables
lc_time_names, Server System Variables
license, Server System Variables
local_infile, Server System Variables
locked_in_memory, Server System Variables
log, Server System Variables
log_backup_output, Server System Variables
log_bin, Server System Variables
log_bin_trust_function_creators, Server System Variables
log_error, Server System Variables
log_output, Server System Variables
log_queries_not_using_indexes, Server System Variables
log_slave_updates, Server System Variables
log_slow_queries, Server System Variables
log_warnings, Server System Variables
long_query_time, Server System Variables
lower_case_file_system, Server System Variables
lower_case_table_names, Server System Variables
low_priority_updates, Server System Variables
max_allowed_packet, Server System Variables
max_binlog_cache_size, Binary Log Options and Variables
max_binlog_size, Binary Log Options and Variables
max_connections, Server System Variables
max_connect_errors, Server System Variables
max_delayed_threads, Server System Variables
max_error_count, Server System Variables
max_heap_table_size, Server System Variables
max_insert_delayed_threads, Server System Variables
max_join_size, Server System Variables
max_length_for_sort_data, Server System Variables
max_prepared_stmt_count, Server System Variables
max_relay_log_size, Server System Variables
max_seeks_for_key, Server System Variables
max_sort_length, Server System Variables
max_sp_recursion_depth, Server System Variables
max_tmp_tables, Server System Variables
max_user_connections, Server System Variables
max_write_lock_count, Server System Variables
min_examined_row_limit, Server System Variables
myisam_data_pointer_size, Server System Variables
myisam_max_sort_file_size, Server System Variables
myisam_recover_options, Server System Variables
myisam_repair_threads, Server System Variables
myisam_sort_buffer_size, Server System Variables
myisam_stats_method, Server System Variables
myisam_use_mmap, Server System Variables
named_pipe, Server System Variables
net_buffer_length, Server System Variables
net_read_timeout, Server System Variables
net_retry_count, Server System Variables
net_write_timeout, Server System Variables
new, Server System Variables
old, Server System Variables
old_alter_table, Server System Variables
old_passwords, Server System Variables
one_shot, Server System Variables
open_files_limit, Server System Variables
optimizer_prune_level, Server System Variables
optimizer_search_depth, Server System Variables
optimizer_switch, Server System Variables
optimizer_use_mrr, Server System Variables
pid_file, Server System Variables
plugin_dir, Server System Variables
port, Server System Variables
preload_buffer_size, Server System Variables
protocol_version, Server System Variables
pseudo_thread_id, Server System Variables
query_alloc_block_size, Server System Variables
query_cache_limit, Server System Variables
query_cache_min_res_unit, Server System Variables
query_cache_size, Server System Variables
query_cache_type, Server System Variables
query_cache_wlock_invalidate, Server System Variables
query_prealloc_size, Server System Variables
range_alloc_block_size, Server System Variables
read_buffer_size, Server System Variables
read_only, Server System Variables
read_rnd_buffer_size, Server System Variables
relay_log_purge, Server System Variables
relay_log_recovery, Replication Slave Options and Variables
relay_log_space_limit, Server System Variables
report_host, Server System Variables
report_password, Server System Variables
report_port, Server System Variables
report_user, Server System Variables
rpl_semi_sync_master_enabled, Server System Variables
rpl_semi_sync_master_reply_log_file_pos, Server System Variables
rpl_semi_sync_master_timeout, Server System Variables
rpl_semi_sync_master_trace_level, Server System Variables
rpl_semi_sync_slave_enabled, Server System Variables
rpl_semi_sync_slave_trace_level, Server System Variables
secure_auth, Server System Variables
secure_backup_file_priv, Server System Variables
secure_file_priv, Server System Variables
server_id, Server System Variables
shared_memory, Server System Variables
shared_memory_base_name, Server System Variables
skip_external_locking, Server System Variables
skip_networking, Server System Variables
skip_show_database, Server System Variables
slave_compressed_protocol, Replication Slave Options and Variables
slave_exec_mode, Replication Slave Options and Variables
slave_load_tmpdir, Replication Slave Options and Variables
slave_net_timeout, Replication Slave Options and Variables
slave_skip_errors, Replication Slave Options and Variables
slave_transaction_retries, Replication Slave Options and Variables
slow_launch_time, Server System Variables
slow_query_log, Server System Variables
slow_query_log_file, Server System Variables
socket, Server System Variables
sort_buffer_size, Server System Variables
sql_mode, Server System Variables
sql_select_limit, Server System Variables
sql_slave_skip_counter, Replication Slave Options and Variables
ssl_ca, Server System Variables
ssl_capath, Server System Variables
ssl_cert, Server System Variables
ssl_cipher, Server System Variables
ssl_key, Server System Variables
storage_engine, Server System Variables
sync_binlog, Binary Log Options and Variables
sync_frm, Server System Variables
sync_master_info, Replication Slave Options and Variables
sync_relay_log, Replication Slave Options and Variables
sync_relay_log_info, Replication Slave Options and Variables
system_time_zone, Server System Variables
table_definition_cache, Server System Variables
table_lock_wait_timeout, Server System Variables
table_open_cache, Server System Variables
thread_cache_size, Server System Variables
thread_concurrency, Server System Variables
thread_handling, Server System Variables
thread_pool_size, Server System Variables
thread_stack, Server System Variables
timed_mutexes, Server System Variables
time_format, Server System Variables
time_zone, Server System Variables
tmpdir, Server System Variables
tmp_table_size, Server System Variables
transaction_alloc_block_size, Server System Variables
transaction_prealloc_size, Server System Variables
tx_isolation, Server System Variables
updatable_views_with_limit, Server System Variables
version, Server System Variables
version_comment, Server System Variables
version_compile_machine, Server System Variables
version_compile_os, Server System Variables
wait_timeout, Server System Variables
system variables, Server System Variables, Using System Variables, SHOW VARIABLES Syntax
and replication, Replication and Variables
system_time_zone system variable, Server System Variables
SYSTEM_USER(), Information Functions

T

[index top]
tab (\t), Strings, LOAD DATA INFILE Syntax
tab option
mysqldump, mysqldump — A Database Backup Program
table
changing, ALTER TABLE Syntax, Problems with ALTER TABLE
deleting, DROP TABLE Syntax
rebuilding, Rebuilding or Repairing Tables or Indexes
repair, Rebuilding or Repairing Tables or Indexes
row size, Data Type Storage Requirements
table aliases, SELECT Syntax
table cache, How MySQL Opens and Closes Tables
Table Dump
thread command, Thread Command Values
table is full, Session System Variables, The table is full
Table lock
thread state, General Thread States
Table Monitor
InnoDB, SHOW ENGINE INNODB STATUS and the InnoDB Monitors, Troubleshooting InnoDB Data Dictionary Operations
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
table-level locking, Internal Locking Methods
tables
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, myisampack — Generate Compressed, Read-Only MyISAM Tables
compressed format, Compressed Table Characteristics
const, Optimizing Queries with EXPLAIN
constant, 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, mysqlshow — Display Database, Table, and Column Information
displaying status, SHOW TABLE STATUS Syntax
dumping, mysqldump — A Database Backup Program, mysqlhotcopy — A Database Backup Program
dynamic, Dynamic Table Characteristics
error checking, How to Check MyISAM Tables for Errors
EXAMPLE, The EXAMPLE Storage Engine
Falcon, The Falcon Storage Engine
FEDERATED, The FEDERATED Storage Engine
flush, mysqladmin — Client for Administering a MySQL Server
fragmentation, OPTIMIZE TABLE Syntax
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, mysqlcheck — A Table Maintenance Program
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, Schema Object Names
open, How MySQL Opens and Closes Tables
opening, How MySQL Opens and Closes Tables
optimizing, Table Optimization
partitioning, The MERGE Storage Engine
repair, mysqlcheck — A Table Maintenance Program
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, Disadvantages of 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 Program
mysqldump, mysqldump — A Database Backup Program
TABLESPACE
INFORMATION_SCHEMA table, The INFORMATION_SCHEMA TABLESPACES Table
Tablespace Monitor
InnoDB, Backing Up and Recovering an InnoDB Database, File Space Management, SHOW ENGINE INNODB STATUS and the InnoDB Monitors
table_definition_cache system variable, Server System Variables
table_lock_wait_timeout system variable, Server System Variables
table_open_cache, How MySQL Opens and Closes Tables
table_open_cache system variable, Server System Variables
TABLE_PRIVILEGES
INFORMATION_SCHEMA table, The INFORMATION_SCHEMA TABLE_PRIVILEGES Table
TAN(), Mathematical Functions
tar
problems on Solaris, Installing MySQL on Solaris, Solaris Notes
tc-heuristic-recover option
mysqld, Server 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 command
mysql, mysql Commands
tee option
mysql, mysql Options
temp-pool option
mysqld, Server Command Options
temporary file
write access, Problems Running mysql_install_db
temporary files, Where MySQL Stores Temporary Files
temporary tables
and replication, Replication and 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, mysqlimport — A Data Import Program
thread cache, How MySQL Uses Threads for Client Connections
thread command
Binlog Dump, Thread Command Values
Change user, Thread Command Values
Close stmt, Thread Command Values
Connect, Thread Command Values
Connect Out, Thread Command Values
Create DB, Thread Command Values
Daemon, Thread Command Values
Debug, Thread Command Values
Delayed insert, Thread Command Values
Drop DB, Thread Command Values
Error, Thread Command Values
Execute, Thread Command Values
Fetch, Thread Command Values
Field List, Thread Command Values
Init DB, Thread Command Values
Kill, Thread Command Values
Long Data, Thread Command Values
Ping, Thread Command Values
Prepare, Thread Command Values
Processlist, Thread Command Values
Query, Thread Command Values
Quit, Thread Command Values
Refresh, Thread Command Values
Register Slave, Thread Command Values
Reset stmt, Thread Command Values
Set option, Thread Command Values
Shutdown, Thread Command Values
Sleep, Thread Command Values
Statistics, Thread Command Values
Table Dump, Thread Command Values
Time, Thread Command Values
thread commands, Thread Command Values
thread packages
differences between, Differences Between Thread Packages
thread pooling, How MySQL Uses Threads for Client Connections
thread state
After create, General Thread States
allocating local table, Delayed-Insert Thread States
Analyzing, General Thread States
Changing master, Replication Slave Connection Thread States
Checking master version, Replication Slave I/O Thread States
checking permissions, General Thread States
Checking table, General Thread States
cleaning up, General Thread States
Clearing, Event Scheduler Thread States
closing tables, General Thread States
Connecting to master, Replication Slave I/O Thread States
converting HEAP to MyISAM, General Thread States
copy to tmp table, General Thread States
Copying to group table, General Thread States
Copying to tmp table, General Thread States
Copying to tmp table on disk, General Thread States
Creating delayed handler, Delayed-Insert Thread States
Creating index, General Thread States
Creating sort index, General Thread States
creating table, General Thread States
Creating tmp table, General Thread States
deleting from main table, General Thread States
deleting from reference tables, General Thread States
discard_or_import_tablespace, General Thread States
end, General Thread States
executing, General Thread States
Execution of init_command, General Thread States
Finished reading one binlog; switching to next binlog, Replication Master Thread States
Flushing tables, General Thread States
freeing items, General Thread States
FULLTEXT initialization, General Thread States
got handler lock, Delayed-Insert Thread States
got old table, Delayed-Insert Thread States
Has read all relay log; waiting for the slave I/O thread to update it, Replication Slave SQL Thread States
Has sent all binlog to slave; waiting for binlog to be updated, Replication Master Thread States
init, General Thread States
Initialized, Event Scheduler Thread States
insert, Delayed-Insert Thread States
Killed, General Thread States
Killing slave, Replication Slave Connection Thread States
Locked, General Thread States
logging slow query, General Thread States
login, General Thread States
Making temp file, Replication Slave SQL Thread States
NULL, General Thread States
Opening master dump table, Replication Slave Connection Thread States
Opening table, General Thread States
Opening tables, General Thread States
preparing, General Thread States
Purging old relay logs, General Thread States
query end, General Thread States
Queueing master event to the relay log, Replication Slave I/O Thread States
Reading event from the relay log, Replication Slave SQL Thread States
Reading from net, General Thread States
Reading master dump table data, Replication Slave Connection Thread States
Rebuilding the index on master dump table, Replication Slave Connection Thread States
Reconnecting after a failed binlog dump request, Replication Slave I/O Thread States
Reconnecting after a failed master event read, Replication Slave I/O Thread States
Registering slave on master, Replication Slave I/O Thread States
Removing duplicates, General Thread States
removing tmp table, General Thread States
rename, General Thread States
rename result table, General Thread States
Reopen tables, General Thread States
Repair by sorting, General Thread States
Repair done, General Thread States
Repair with keycache, General Thread States
Requesting binlog dump, Replication Slave I/O Thread States
reschedule, Delayed-Insert Thread States
Rolling back, General Thread States
Saving state, General Thread States
Searching rows for update, General Thread States
Sending binlog event to slave, Replication Master Thread States
setup, General Thread States
Sorting for group, General Thread States
Sorting for order, General Thread States
Sorting index, General Thread States
Sorting result, General Thread States
statistics, General Thread States
storing row into queue, Delayed-Insert Thread States
System lock, General Thread States
Table lock, General Thread States
update, Delayed-Insert Thread States
Updating, General Thread States
updating main table, General Thread States
updating reference tables, General Thread States
upgrading lock, Delayed-Insert Thread States
User lock, General Thread States
waiting for delay_list, Delayed-Insert Thread States
waiting for handler insert, Delayed-Insert Thread States
waiting for handler lock, Delayed-Insert Thread States
waiting for handler open, Delayed-Insert Thread States
Waiting for INSERT, Delayed-Insert Thread States
Waiting for master to send event, Replication Slave I/O Thread States
Waiting for master update, Replication Slave I/O Thread States
Waiting for next activation, Event Scheduler Thread States
Waiting for scheduler to stop, Event Scheduler Thread States
Waiting for slave mutex on exit, Replication Slave I/O Thread States, Replication Slave SQL Thread States
Waiting for table, General Thread States
Waiting for tables, General Thread States
Waiting for the next event in relay log, Replication Slave SQL Thread States
Waiting for the slave SQL thread to free enough relay log space, Replication Slave I/O Thread States
Waiting on cond, General Thread States
Waiting on empty queue, Event Scheduler Thread States
Waiting to finalize termination, Replication Master Thread States
Waiting to reconnect after a failed binlog dump request, Replication Slave I/O Thread States
Waiting to reconnect after a failed master event read, Replication Slave I/O Thread States
Writing to net, General Thread States
thread states
delayed inserts, Delayed-Insert Thread States
event scheduler, Event Scheduler Thread States
general, General Thread States
replication master, Replication Master Thread States
replication slave, Replication Slave I/O Thread States, Replication Slave SQL Thread States, Replication Slave Connection Thread States
thread support, Operating Systems Supported by MySQL Community Server
nonnative, MIT-pthreads Notes
threaded clients, How to Make a Threaded Client
threads, mysqladmin — Client for Administering a MySQL Server, SHOW PROCESSLIST Syntax, MySQL Internals
display, SHOW PROCESSLIST Syntax
RTS, Comments about RTS Threads
thread_cache_size system variable, Server System Variables
thread_concurrency system variable, Server System Variables
thread_handling system variable, Server System Variables
thread_pool_size system variable, Server System Variables
thread_stack system variable, Server System Variables
Time
thread command, Thread Command Values
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 zone tables, mysql_tzinfo_to_sql — Load the Time Zone Tables
time zones
and replication, Replication and Time Zones
leap seconds, Time Zone Leap Second Support
support, MySQL Server Time Zone Support
upgrading, Staying Current with Time Zone Changes
TIME(), Date and Time Functions
TIMEDIFF(), Date and Time Functions
timed_mutexes system variable, Server System Variables
timeout, Server System Variables, Miscellaneous Functions, INSERT DELAYED Syntax
connect_timeout variable, mysql Options, mysqladmin — Client for Administering a MySQL Server
shutdown_timeout variable, mysqladmin — Client for Administering a MySQL Server
timeouts (replication), Replication Retries and Timeouts
timer-length option
mysqlslap, mysqlslap — Load Emulation Client
TIMESTAMP
and NULL values, Problems with NULL Values
and replication, Replication and AUTO_INCREMENT
TIMESTAMP data type, Overview of Date and Time Types, The DATETIME, DATE, and TIMESTAMP Types
timestamp session variable, Session System Variables
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 system variable, Server System Variables
TIME_FORMAT(), Date and Time Functions
TIME_TO_SEC(), Date and Time Functions
time_zone system variable, Server System Variables
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, Overview of MySQL Programs, Where MySQL Stores Temporary Files
tmpdir option
myisamchk, myisamchk Repair Options
myisampack, myisampack — Generate Compressed, Read-Only MyISAM Tables
mysqld, Server Command Options
mysqlhotcopy, mysqlhotcopy — A Database Backup Program
mysql_upgrade, mysql_upgrade — Check Tables for MySQL Upgrade
tmpdir system variable, Server System Variables
tmp_table_size system variable, Server System Variables
to-last-log option
mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files
TODO
symlinks, Using Symbolic Links for Tables on Unix
tools
command-line, mysql — The MySQL Command-Line Tool
list of, Tools that were used to create MySQL
mysqld_multi, mysqld_multi — Manage Multiple MySQL Servers
mysqld_safe, mysqld_safe — MySQL Server Startup Script
Touches(), Functions That Test Spatial Relationships Between Geometries
TO_DAYS(), Date and Time Functions
trace DBI method, Debugging mysqld under gdb
TRADITIONAL SQL mode, Server SQL Modes
transaction isolation level, SET TRANSACTION Syntax
READ COMMITTED, SET TRANSACTION Syntax
READ UNCOMMITTED, SET TRANSACTION Syntax
REPEATABLE READ, SET TRANSACTION Syntax
SERIALIZABLE, SET TRANSACTION Syntax
transaction-isolation option
mysqld, Server Command Options
transaction-safe tables, Transactions and Atomic Operations, The InnoDB Storage Engine
transactions
and replication, Replication Retries and Timeouts, Replication and Transactions
metadata locking, Metadata Locking Within Transactions
support, Transactions and Atomic Operations, The InnoDB Storage Engine
transaction_alloc_block_size system variable, Server System Variables
transaction_prealloc_size system variable, Server System Variables
Translators
list of, Documenters and translators
trigger restrictions, Restrictions on Stored Routines, Triggers, and Events
trigger, creating, CREATE TRIGGER Syntax
trigger, dropping, DROP TRIGGER Syntax
triggers, Stored Routines and Triggers, SHOW TRIGGERS Syntax, Stored Programs and Views, Using Triggers
and INSERT DELAYED, INSERT Syntax
and replication, Replication of Invoked Features, Replication and Triggers
LAST_INSERT_ID(), Stored Procedures, Functions, Triggers, and LAST_INSERT_ID()
metadata, Trigger Metadata
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 replication, Replication and TRUNCATE
TRUNCATE(), Mathematical Functions
tutorial, Tutorial
Twin Studies
queries, Queries from the Twin Project
tx_isolation system variable, Server System Variables
type conversions, Type Conversion in Expression Evaluation, Comparison Functions and Operators
type option
mysql_convert_table_format, mysql_convert_table_format — Convert Tables to Use a Given Storage Engine
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
portability, Using Data Types from Other Database Engines
strings, String Types
time, Data Type Storage Requirements
typographical conventions, Typographical and Syntax Conventions, Conventions Used in This Document
TZ environment variable, Environment Variables, Time Zone Problems
tz-utc option
mysqldump, mysqldump — A Database Backup Program

U

[index top]
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
UNHEX(), String Functions
Unicode, Character Set Support
Unicode Collation Algorithm, Unicode Character Sets
UNINSTALL PLUGIN, UNINSTALL PLUGIN Syntax
uninstalling plugins, UNINSTALL PLUGIN Syntax
UNION, Searching on Two Keys, UNION Syntax
Union(), Spatial Operators
UNIQUE, ALTER TABLE Syntax
unique ID, How to Get the Unique ID for the Last Inserted Row
unique key
constraint, PRIMARY KEY and UNIQUE Index Constraints
unique keys
and partitioning keys, Partitioning Keys, Primary Keys, and Unique Keys
unique_checks session variable, Session System Variables
unique_subquery join type
optimizer, Optimizing Queries with EXPLAIN
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
UNSIGNED, Overview of Numeric Types, Numeric Types
UNTIL, REPEAT Statement
updatable views, Updatable and Insertable Views
updatable_views_with_limit system variable, Server System Variables
update
thread state, Delayed-Insert Thread States
UPDATE, UPDATE Syntax
update-state option
myisamchk, myisamchk Check Options
UpdateXML(), XML Functions
updating
releases of MySQL, How and When Updates Are Released
tables, Transactions and Atomic Operations
Updating
thread state, General Thread States
updating main table
thread state, General Thread States
updating reference tables
thread state, General Thread States
upgrading, Upgrading or Downgrading MySQL, Upgrading MySQL
different architecture, Copying MySQL Databases to Another Machine
grant tables, mysql_fix_privilege_tables — Upgrade MySQL System Tables
to &current-series;, Upgrading from MySQL 5.1 to 6.0
upgrading lock
thread state, Delayed-Insert Thread States
upgrading MySQL, mysql_upgrade — Check Tables for MySQL Upgrade
UPPER(), String Functions
uptime, mysqladmin — Client for Administering a MySQL Server
URLs for downloading MySQL, How to Get MySQL
USE, USE Syntax
use command
mysql, mysql Commands
USE INDEX, Index Hint Syntax
USE KEY, Index Hint Syntax
use-frm option
mysqlcheck, mysqlcheck — A Table Maintenance Program
use-mysqld_safe option
mysql.server, mysql.server — MySQL Server Startup Script
use-threads option
mysqlimport, mysqlimport — A Data Import Program
user accounts
creating, CREATE USER Syntax
renaming, RENAME USER Syntax
USER environment variable, Environment Variables, Connecting to the MySQL Server
User lock
thread state, General Thread States
user names
and passwords, User Names and Passwords
user option, Connecting to the MySQL Server
mysql, mysql Options
mysql.server, mysql.server — MySQL Server Startup Script
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 Program
mysqld, Server 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
mysqlshow, mysqlshow — Display Database, Table, and Column Information
mysqlslap, mysqlslap — Load Emulation Client
mysql_convert_table_format, mysql_convert_table_format — Convert Tables to Use a Given Storage Engine
mysql_install_db, mysql_install_db — Initialize MySQL Data Directory
mysql_setpermission, mysql_setpermission — Interactively Set Permissions in Grant Tables
mysql_upgrade, mysql_upgrade — Check Tables for MySQL Upgrade
user privileges
adding, Adding User Accounts
deleting, Removing User Accounts, DROP USER Syntax
dropping, Removing User Accounts, DROP USER Syntax
user table
sorting, Access Control, Stage 1: Connection Verification
user variables, User-Defined Variables
and replication, Replication and Variables
USER(), Information Functions
User-defined functions, CREATE FUNCTION Syntax, DROP FUNCTION Syntax
user-defined functions
adding, Adding New Functions to MySQL, Adding a New User-Defined Function
users
adding, Installing MySQL from tar.gz Packages on Other Unix-Like Systems, Source Installation Overview
deleting, Removing User Accounts, 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
utilities
program-development, Overview of MySQL Programs
utility programs, Overview of MySQL Programs
UUID(), Miscellaneous Functions
UUID_SHORT(), Miscellaneous Functions

V

[index top]
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
and replication, Replication and Variables
environment, Overview of MySQL Programs
mysqld, Tuning Server Parameters
server, Server System Variables, SHOW VARIABLES Syntax
status, Server Status Variables, SHOW STATUS Syntax
system, Server 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
mysqlbackup, mysqlbackup — Display Backup Information
mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files
mysqlcheck, mysqlcheck — A Table Maintenance Program
mysqld, Server Command Options
mysqldump, mysqldump — A Database Backup Program
mysqldumpslow, mysqldumpslow — Summarize Slow Query Log Files
mysqld_multi, mysqld_multi — Manage Multiple MySQL Servers
mysqlimport, mysqlimport — A Data Import Program
mysqlshow, mysqlshow — Display Database, Table, and Column Information
mysqlslap, mysqlslap — Load Emulation Client
mysql_convert_table_format, mysql_convert_table_format — Convert Tables to Use a Given Storage Engine
mysql_install_db, mysql_install_db — Initialize MySQL Data Directory
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
mysqlbackup, mysqlbackup — Display Backup Information
mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files
mysqlcheck, mysqlcheck — A Table Maintenance Program
mysqld, Server Command Options
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
mysqlslap, mysqlslap — Load Emulation Client
mysql_config, mysql_config — Get Compile Options for Compiling Clients
mysql_convert_table_format, mysql_convert_table_format — Convert Tables to Use a Given Storage Engine
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 Host name to IP Address or Vice Versa
resolve_stack_dump, resolve_stack_dump — Resolve Numeric Stack Trace Dump to Symbols
version system variable, Server System Variables
VERSION(), Information Functions
version_comment system variable, Server System Variables
version_compile_machine system variable, Server System Variables
version_compile_os system variable, Server System Variables
vertical option
mysql, mysql Options
mysqladmin, mysqladmin — Client for Administering a MySQL Server
Vietnamese, MySQL 6.0 FAQ — MySQL Chinese, Japanese, and Korean Character Sets
view restrictions, Restrictions on Views
views, Views, CREATE VIEW Syntax, Stored Programs and Views, Using Views
algorithms, View Processing Algorithms
and replication, Replication and Views
metadata, View Metadata
updatable, Views, CREATE VIEW Syntax, Updatable and Insertable Views
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

W

[index top]
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
waiting for delay_list
thread state, Delayed-Insert Thread States
waiting for handler insert
thread state, Delayed-Insert Thread States
waiting for handler lock
thread state, Delayed-Insert Thread States
waiting for handler open
thread state, Delayed-Insert Thread States
Waiting for INSERT
thread state, Delayed-Insert Thread States
Waiting for master to send event
thread state, Replication Slave I/O Thread States
Waiting for master update
thread state, Replication Slave I/O Thread States
Waiting for next activation
thread state, Event Scheduler Thread States
Waiting for scheduler to stop
thread state, Event Scheduler Thread States
Waiting for slave mutex on exit
thread state, Replication Slave I/O Thread States, Replication Slave SQL Thread States
Waiting for table
thread state, General Thread States
Waiting for tables
thread state, General Thread States
Waiting for the next event in relay log
thread state, Replication Slave SQL Thread States
Waiting for the slave SQL thread to free enough relay log space
thread state, Replication Slave I/O Thread States
Waiting on cond
thread state, General Thread States
Waiting on empty queue
thread state, Event Scheduler Thread States
Waiting to finalize termination
thread state, Replication Master Thread States
Waiting to reconnect after a failed binlog dump request
thread state, Replication Slave I/O Thread States
Waiting to reconnect after a failed master event read
thread state, Replication Slave I/O Thread States
wait_timeout system variable, Server System Variables
warnings command
mysql, mysql Commands
warning_count session variable, Session System Variables
WEEK(), Date and Time Functions
WEEKDAY(), Date and Time Functions
WEEKOFYEAR(), Date and Time Functions
WEIGHT_STRING(), String 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, INFORMATION_SCHEMA Tables, 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 account names, Specifying Account Names
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
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
windows option
mysql_install_db, mysql_install_db — Initialize MySQL Data Directory
with-big-tables option, Typical configure Options
configure, Typical configure Options
with-client-ldflags option
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-libevent option
configure, Typical configure Options
with-unix-socket-path option
configure, Typical configure Options
with-zlib-dir 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-binlog option
mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files
write_buffer_size myisamchk variable, myisamchk General Options
Writing to net
thread state, General Thread States