Index
Prev   

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

Symbols

[index top]
! (logical NOT), Logical Operators
!= (not equal), Comparison Functions and Operators
", Identifiers
#mysql50 identifier prefix, Identifiers, Mapping of Identifiers to Filenames
%, 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
--bind-address option (ndb_mgmd), Command Options for ndb_mgmd
--config-file option (ndb_mgmd), Command Options for ndb_mgmd
--connect-string option (MySQL Cluster), Command Options for MySQL Cluster Processes
--debug option (MySQL Cluster), Command Options for MySQL Cluster Processes
--execute option (MySQL Cluster), Command Options for MySQL Cluster Processes
--help option
MySQL Cluster programs, Command Options for MySQL Cluster Processes
--initial option (ndbd), Command Options for ndbd
--initial-start option (ndbd), Command Options for ndbd
--ndb-connectstring option (MySQL Cluster), MySQL Cluster-Related Command Options for mysqld
--ndb-log-update-as-write (mysqld option), MySQL Cluster Replication Conflict Resolution
--ndb-log-updated-only (mysqld option), MySQL Cluster Replication Conflict Resolution
--ndbcluster option (MySQL Cluster), MySQL Cluster-Related Command Options for mysqld
--nodaemon option (ndbd), Command Options for ndbd
--nostart option (ndbd), Command Options for ndbd
--nowait-nodes option (ndbd), Command Options for ndbd
--password option, Keeping Your Password Secure
--usage option
MySQL Cluster programs, Command Options for MySQL Cluster Processes
--version option (MySQL Cluster), Command Options for MySQL Cluster Processes
-? option
MySQL Cluster programs, Command Options for MySQL Cluster Processes
-c option (MySQL Cluster), Command Options for MySQL Cluster Processes
-c option (ndb_mgmd) (OBSOLETE), Command Options for ndb_mgmd
-e option (MySQL Cluster), Command Options for MySQL Cluster Processes
-f option (ndb_mgmd), Command Options for ndb_mgmd
-n option (ndbd), Command Options for ndbd
-p option, Keeping Your Password Secure
-V option (MySQL Cluster), Command Options for MySQL Cluster Processes
.my.cnf file, Using Option Files, Connecting to the MySQL Server, Causes of Access denied Errors, Keeping Your Password Secure, Using Client Programs in a Multiple-Server Environment
.mysql_history file, mysql Options
.pid (process ID) file, Setting Up a Table Maintenance Schedule
/ (division), Arithmetic Operators
/etc/passwd, Making MySQL Secure Against Attackers, SELECT Syntax
:= (assignment), User-Defined Variables
< (less than), Comparison Functions and Operators
<<, Calculating Visits Per Day
<< (left shift), Bit Functions
<= (less than or equal), Comparison Functions and Operators
<=> (equal to), Comparison Functions and Operators
<> (not equal), Comparison Functions and Operators
= (assignment), User-Defined Variables
= (equal), Comparison Functions and Operators
> (greater than), Comparison Functions and Operators
>= (greater than or equal), Comparison Functions and Operators
>> (right shift), Bit Functions
[API] (MySQL Cluster), SQL Node and API Node Configuration Parameters
[MGM] (MySQL Cluster), Management Node Configuration Parameters
[NDBD] (MySQL Cluster), Data Node Configuration Parameters
[NDBD_DEFAULT] (MySQL Cluster), Data Node Configuration Parameters
[NDB_MGMD] (MySQL Cluster), Management Node Configuration Parameters
[SQL] (MySQL Cluster), SQL Node and API Node Configuration Parameters
\" (double quote), Strings
\' (single quote), Strings
\. (mysql client command), Using mysql in Batch Mode, Executing SQL Statements from a Text File
\0 (ASCII 0), Strings, 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
`, Identifiers
| (bitwise OR), Bit Functions
|| (logical OR), Logical Operators
~, Bit Functions

A

[index top]
abort-slave-event-count option
mysqld, Command Options
aborted clients, Communication Errors and Aborted Connections
aborted connection, Communication Errors and Aborted Connections
ABS(), Mathematical Functions
access control, Access Control, Stage 1: Connection Verification
access denied errors, Access denied
access privileges, The MySQL Access Privilege System
account privileges
adding, Adding New User Accounts to MySQL
accounts
anonymous user, Securing the Initial MySQL Accounts
root, Securing the Initial MySQL Accounts
ACID, Transactions and Atomic Operations, InnoDB Overview
ACLs, The MySQL Access Privilege System
ACOS(), Mathematical Functions
Active Server Pages (ASP), Using Connector/ODBC with Active Server Pages (ASP)
ActiveState Perl, Installing ActiveState Perl on Windows
add-drop-database option
mysqldump, mysqldump — A Database Backup Program
add-drop-table option
mysqldump, mysqldump — A Database Backup Program
add-locks option
mysqldump, mysqldump — A Database Backup Program
add-user option
mysqlmanager, MySQL Instance Manager Command Options
ADDDATE(), Date and Time Functions
adding
character sets, Adding a New Character Set
native functions, Adding a New Native Function
new account privileges, Adding New User Accounts to MySQL
new functions, Adding New Functions to MySQL
new user privileges, Adding New User Accounts to MySQL
new users, Installing MySQL 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
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 Fields
for tables, SELECT Syntax
in GROUP BY clauses, GROUP BY and HAVING with Hidden Fields
names, Identifiers
on expressions, SELECT Syntax
ALL, SELECT Syntax, Subqueries with ALL
all-databases option
mysqlcheck, mysqlcheck — A Table Maintenance and Repair Program
mysqldump, mysqldump — A Database Backup Program
all-in-1 option
mysqlcheck, mysqlcheck — A Table Maintenance and Repair Program
all-tablespaces option
mysqldump, mysqldump — A Database Backup Program
allocating local table
thread state, Delayed-Insert Thread States
allow-keywords option
mysqldump, mysqldump — A Database Backup Program
allow-suspicious-udfs option
mysqld, Command Options, Security-Related mysqld Options
allowold option
mysqlhotcopy, mysqlhotcopy — A Database Backup Program
ALLOW_INVALID_DATES SQL mode, SQL Modes
ALTER COLUMN, ALTER TABLE Syntax
ALTER DATABASE, ALTER DATABASE Syntax
ALTER EVENT, ALTER EVENT Syntax
ALTER FUNCTION, ALTER PROCEDURE and ALTER FUNCTION Syntax
ALTER LOGFILE GROUP, ALTER LOGFILE GROUP Syntax
(see also MySQL Cluster Disk Data)
ALTER PROCEDURE, ALTER PROCEDURE and ALTER FUNCTION Syntax
ALTER SCHEMA, ALTER DATABASE Syntax
ALTER SERVER, ALTER SERVER Syntax
ALTER TABLE, ALTER TABLE Syntax, Problems with ALTER TABLE
ALTER TABLESPACE, ALTER TABLESPACE Syntax
(see also MySQL Cluster Disk Data)
ALTER VIEW, ALTER VIEW Syntax
altering
database, ALTER DATABASE Syntax
schema, ALTER DATABASE Syntax
analyze option
myisamchk, Other myisamchk Options
mysqlcheck, mysqlcheck — A Table Maintenance and Repair Program
ANALYZE TABLE, ANALYZE TABLE Syntax
Analyzing
thread state, General Thread States
AND
bitwise, Bit Functions
logical, Logical Operators
angel-pid-file option
mysqlmanager, MySQL Instance Manager Command Options
anonymous user, Securing the Initial MySQL Accounts, Access Control, Stage 1: Connection Verification, Access Control, Stage 2: Request Verification
ANSI mode
running, Running MySQL in ANSI Mode
ansi option
mysqld, Command Options
ANSI SQL mode, SQL Modes
ANSI_QUOTES SQL mode, SQL Modes
answering questions
etiquette, Guidelines for Using the Mailing Lists
ANY, Subqueries with ANY, IN, and SOME
Apache, Using MySQL with Apache
API node (MySQL Cluster)
defined, MySQL Cluster Core Concepts
API nodes (see SQL nodes)
API's
list of, Packages that support MySQL
APIs, APIs and Libraries
Perl, MySQL Perl API
apply_status table (OBSOLETE), Cluster Replication Schema and Tables
(see also MySQL Cluster replication)
approximate-value literals, Precision Math
ArbitrationDelay, Defining the Management Server, Defining SQL and Other API Nodes
ArbitrationRank, Defining the Management Server, Defining SQL and Other API Nodes
ArbitrationTimeout (DEPRECATED), Defining Data Nodes
arbitrator, MySQL 5.1 FAQ — MySQL Cluster
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
asynchronous replication (see MySQL Cluster replication)
ATAN(), Mathematical Functions
ATAN2(), Mathematical Functions
attackers
security against, Making MySQL Secure Against Attackers
auto-generate-sql 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 and Repair Program
autoclose option
mysqld_safe, mysqld_safe — MySQL Server Startup Script
AUTO_INCREMENT, Using AUTO_INCREMENT
and NULL values, Problems with NULL Values
AVG(), GROUP BY (Aggregate) Functions
AVG(DISTINCT), GROUP BY (Aggregate) Functions

B

[index top]
backslash
escape character, Literal Values
backspace (\b), Strings, LOAD DATA INFILE Syntax
backup option
myisamchk, myisamchk Repair Options
myisampack, myisampack — Generate Compressed, Read-Only MyISAM Tables
BACKUP TABLE, BACKUP TABLE Syntax
BackupDataBufferSize, Configuration for Cluster Backup
BackupDataBufferSize (MySQL Cluster configuration parameter), Defining Data Nodes
BackupDataDir, Defining Data Nodes
BackupLogBufferSize, Defining Data Nodes, Configuration for Cluster Backup
BackupMaxWriteSize, Defining Data Nodes, Configuration for Cluster Backup
BackupMemory, Defining Data Nodes, Configuration for Cluster Backup
BackupReportFrequency, Defining Data Nodes
backups, Database Backups
database, BACKUP TABLE Syntax
in MySQL Cluster, On-line Backup of MySQL Cluster, Cluster Backup Concepts, Using The Management Client to Create a Backup, Configuration for Cluster Backup
in MySQL Cluster replication, MySQL Cluster Backups With Replication
backups, troubleshooting
in MySQL Cluster, Backup Troubleshooting
BackupWriteSize, Defining Data Nodes, Configuration for Cluster Backup
base64-output option
mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files
basedir option
mysql.server, mysql.server — MySQL Server Startup Script
mysqld, Command Options
mysqld_safe, mysqld_safe — MySQL Server Startup Script
mysql_upgrade, mysql_upgrade — Check Tables for MySQL Upgrade
batch mode, Using mysql in Batch Mode
batch option
mysql, mysql Options
BatchByteSize, Defining SQL and Other API Nodes
batched updates (MySQL Cluster Replication), Starting Replication (Single Replication Channel)
BatchSize, Defining SQL and Other API Nodes
BatchSizePerLocalScan, Defining Data Nodes
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
big5, MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets
Big5 Chinese character encoding, Case Sensitivity in Searches
BIGINT data type, Overview of Numeric Types
BIN(), String Functions
BINARY, Cast Functions and Operators
BINARY data type, Overview of String Types, The BINARY and VARBINARY Types
binary distributions, MySQL Binaries Compiled by MySQL AB
installing, Installing MySQL from tar.gz Packages on Other Unix-Like Systems
on Linux, Linux Binary Distribution Notes
binary log, The Binary Log
binary logging
and MySQL Cluster, Issues Exclusive to MySQL Cluster
bind-address option
mysqld, Command Options
mysqlmanager, MySQL Instance Manager Command Options
Binlog Dump
thread command, Thread Command Values
binlog-do-db option
mysqld, The Binary Log
binlog-format option
mysqld, Command Options
binlog-ignore-db option
mysqld, The Binary Log
binlog-row-event-max-size option
mysqld, Command Options
binlog_index table (OBSOLETE), Cluster Replication Schema and Tables
(see also MySQL Cluster replication)
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-search option
myisamchk, Other myisamchk Options
BOOL data type, Overview of Numeric Types
BOOLEAN data type, Overview of Numeric Types
bootstrap option
mysqld, Command Options
Borland Builder 4, Using Connector/ODBC with Borland Builder 4
Boundary(), General Geometry Functions
brackets
square, Data Types
brief option
mysqlaccess, mysqlaccess — Client for Checking Access Privileges
buffer sizes
client, APIs and Libraries
mysqld server, Tuning Server Parameters
Buffer(), Spatial Operators
bug reports
criteria for, How to Report Bugs or Problems
bugs
known, Known Issues in MySQL
reporting, How to Report Bugs or Problems
bugs database, How to Report Bugs or Problems
bugs.mysql.com, How to Report Bugs or Problems
building
client programs, Building Client Programs

C

[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
caches
clearing, FLUSH Syntax
calculating
dates, Date Calculations
calendar, What Calendar Is Used By MySQL?
CALL, CALL Statement Syntax
calling sequences for aggregate functions
UDF, UDF Calling Sequences for Aggregate Functions
calling sequences for simple functions
UDF, UDF Calling Sequences for Simple Functions
can't create/write to file, Can't create/write to file
carriage return (\r), Strings, LOAD DATA INFILE Syntax
CASE, Control Flow Functions, CASE Statement
case sensitivity
in access checking, How the Privilege System Works
in identifiers, Identifier Case Sensitivity
in names, Identifier Case Sensitivity
in searches, Case Sensitivity in Searches
in string comparisons, String Comparison Functions
case-sensitivity
of database names, MySQL Extensions to Standard SQL
of table names, MySQL Extensions to Standard SQL
CAST, Cast Functions and Operators
cast functions, Cast Functions and Operators
cast operators, Cast Functions and Operators
casts, Type Conversion in Expression Evaluation, Comparison Functions and Operators, Cast Functions and Operators
CC environment variable, Typical configure Options, Dealing with Problems Compiling MySQL, Environment Variables
cc1plus problems, Dealing with Problems Compiling MySQL
CEILING(), Mathematical Functions
Centroid(), MultiPolygon Functions
CFLAGS environment variable, Typical configure Options, Dealing with Problems Compiling MySQL, Environment Variables
CHANGE MASTER TO, CHANGE MASTER TO Syntax
in MySQL Cluster, Preparing the Cluster for Replication
Change user
thread command, Thread Command Values
ChangeLog, MySQL Change History
changes
log, MySQL Change History
MySQL 5.1, Changes in release 5.1.x (Development)
changes to privileges, Access Control, Stage 2: Request Verification
changing
column, ALTER TABLE Syntax
column order, How to Change the Order of Columns in a Table
field, ALTER TABLE Syntax
table, ALTER TABLE Syntax, Problems with ALTER TABLE
Changing 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
Character sets, Character Set Support
CHARACTER VARYING data type, Overview of String Types
character-set-client-handshake option
mysqld, Command Options
character-set-filesystem option
mysqld, Command Options
character-set-server option
mysqld, Command Options
character-sets-dir option
myisamchk, myisamchk Repair Options
myisampack, myisampack — Generate Compressed, Read-Only MyISAM Tables
mysql, mysql Options
mysqladmin, mysqladmin — Client for Administering a MySQL Server
mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files
mysqlcheck, mysqlcheck — A Table Maintenance and Repair Program
mysqld, Command Options
mysqldump, mysqldump — A Database Backup Program
mysqlimport, mysqlimport — A Data Import Program
mysqlshow, mysqlshow — Display Database, Table, and Column Information
characters
multi-byte, Multi-Byte Character Support
CHARACTER_LENGTH(), String Functions
CHARACTER_SETS
INFORMATION_SCHEMA table, The INFORMATION_SCHEMA CHARACTER_SETS Table
charset option
comp_err, comp_err — Compile MySQL Error Message File
CHARSET(), Information Functions
CHAR_LENGTH(), String Functions
check option
myisamchk, myisamchk Check Options
mysqlcheck, mysqlcheck — A Table Maintenance and Repair Program
check options
myisamchk, myisamchk Check Options
CHECK TABLE, CHECK TABLE Syntax
check-only-changed option
myisamchk, myisamchk Check Options
mysqlcheck, mysqlcheck — A Table Maintenance and Repair Program
check-password-file option
mysqlmanager, MySQL Instance Manager Command Options
check-upgrade option
mysqlcheck, mysqlcheck — A Table Maintenance and Repair Program
checking
tables for errors, How to Check MyISAM Tables for Errors
Checking master version
thread state, Replication Slave I/O Thread States
Checking table
thread state, General Thread States
CHECKPOINT Events (MySQL Cluster), Log Events
checkpoint option
mysqlhotcopy, mysqlhotcopy — A Database Backup Program
Checksum, Cluster TCP/IP Connections
Checksum (MySQL Cluster), Shared-Memory Connections, SCI Transport Connections
checksum errors, Solaris Notes
CHECKSUM TABLE, CHECKSUM TABLE Syntax
Chinese, Case Sensitivity in Searches
Chinese, Japanese, Korean character sets
frequently asked questions, MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets
choosing
a MySQL version, Choosing Which MySQL Distribution to Install
choosing types, Choosing the Right Type for a Column
chroot option
mysqld, Command Options
mysqlhotcopy, mysqlhotcopy — A Database Backup Program
circular replication
in MySQL Cluster, Known Issues in MySQL Cluster Replication
CJK
FAQ, MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets
CJK (Chinese, Japanese, Korean)
Access, PHP, etc., MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets
availability of specific characters, MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets
available character sets, MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets
big5, MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets
character sets available, MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets
characters displayed as question marks, MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets
CJKV, MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets
collations, MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets
conversion problems with Japanese character sets, MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets
data truncation, MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets
Database and table names, MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets
documentation in Chinese, MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets
documentation in Japanese, MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets
documentation in Korean, MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets
gb2312, gbk, MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets
Japanese character sets, MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets
Korean character set, MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets
LIKE and FULLTEXT, MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets
MySQL 4.0 behavior, MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets
ORDER BY treatment, MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets
problems with Access, PHP, etc., MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets
problems with Big5 character sets (Chinese), MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets
problems with data truncation, MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets
problems with euckr character set (Korean), MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets
problems with GB character sets (Chinese), MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets
problems with LIKE and FULLTEXT, MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets
problems with Yen sign (Japanese), MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets
rejected characters, MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets
sort order problems, MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets
sorting problems, MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets
testing availability of characters, MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets
Unicode collations, MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets
Vietnamese, MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets
Yen sign, MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets
clean-password-file option
mysqlmanager, MySQL Instance Manager Command Options
cleaning up
thread state, General Thread States
clear option
mysql_tableinfo, mysql_tableinfo — Generate Database Metadata
clear-only option
mysql_tableinfo, mysql_tableinfo — Generate Database Metadata
Clearing
thread state, Event Scheduler Thread States
clearing
caches, FLUSH Syntax
client programs, Overview of Client and Utility Programs
building, Building Client Programs
client tools, APIs and Libraries
clients
debugging, Debugging a MySQL Client
threaded, How to Make a Threaded Client
CLOSE, Cursor CLOSE Statement
Close stmt
thread command, Thread Command Values
closing
tables, How MySQL Opens and Closes Tables
closing tables
thread state, General Thread States
cluster database (OBSOLETE), Cluster Replication Schema and Tables
(see also MySQL Cluster replication)
cluster logs, Event Reports Generated in MySQL Cluster, Logging Management Commands
cluster.binlog_index table (OBSOLETE) (see MySQL Cluster replication)
Clustering (see MySQL Cluster)
CLUSTERLOG commands (MySQL Cluster), Logging Management Commands
CLUSTERLOG STATISTICS command (MySQL Cluster), Using CLUSTERLOG STATISTICS
cluster_replication database (OBSOLETE) (see MySQL Cluster replication)
CMake, Building MySQL from Source Using CMake and Visual Studio
COALESCE(), Comparison Functions and Operators
COERCIBILITY(), Information Functions
col option
mysql_tableinfo, mysql_tableinfo — Generate Database Metadata
ColdFusion, Using Connector/ODBC with ColdFusion
collating
strings, String Collating Support
COLLATION(), Information Functions
collation-server option
mysqld, Command Options
COLLATIONS
INFORMATION_SCHEMA table, The INFORMATION_SCHEMA COLLATIONS Table
COLLATION_CHARACTER_SET_APPLICABILITY
INFORMATION_SCHEMA table, The INFORMATION_SCHEMA COLLATION_CHARACTER_SET_APPLICABILITY Table
column
changing, ALTER TABLE Syntax
types, Data Types
column comments, CREATE TABLE Syntax
column format, CREATE TABLE Syntax
column names
case sensitivity, Identifier Case Sensitivity
column storage, CREATE TABLE Syntax
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
indexes, Column Indexes
names, Identifiers
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, Command Options
command options (MySQL Cluster), Command Options for MySQL Cluster Processes
mysqld, MySQL Cluster-Related Command Options for mysqld
ndbd, Command Options for ndbd
ndb_mgm, Command Options for ndb_mgm
ndb_mgmd, Command Options for ndb_mgmd
command syntax, Conventions Used in This Manual
command-line history
mysql, mysql Options
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
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
Committing events to binlog
thread state, MySQL Cluster Thread States
compact option
mysqldump, mysqldump — A Database Backup Program
comparison operators, Comparison Functions and Operators
compatibility
between MySQL versions, Upgrading from MySQL 5.0 to 5.1
with mSQL, String Comparison Functions
with ODBC, Identifier Qualifiers, Overview of Numeric Types, Type Conversion in Expression Evaluation, Comparison Functions and Operators, CREATE TABLE Syntax, JOIN Syntax
with Oracle, MySQL Extensions to Standard SQL, GROUP BY (Aggregate) Functions, DESCRIBE Syntax
with PostgreSQL, MySQL Extensions to Standard SQL
with standard SQL, MySQL Standards Compliance
with Sybase, USE Syntax
compatible option
mysqldump, mysqldump — A Database Backup Program
compiler
C++ gcc, Typical configure Options
compiling
on Windows, Compiling MySQL Clients on Windows
optimizing, System Factors and Startup Parameter Tuning
problems, Dealing with Problems Compiling MySQL
speed, How Compiling and Linking Affects the Speed of MySQL
statically, Typical configure Options
user-defined functions, Compiling and Installing User-Defined Functions
complete-insert option
mysqldump, mysqldump — A Database Backup Program
compliance
Y2K, Year 2000 Issues and Date Types
composite partitioning, Subpartitioning
compress option
mysql, mysql Options
mysqladmin, mysqladmin — Client for Administering a MySQL Server
mysqlcheck, mysqlcheck — A Table Maintenance and Repair Program
mysqldump, mysqldump — A Database Backup Program
mysqlimport, mysqlimport — A Data Import Program
mysqlshow, mysqlshow — Display Database, Table, and Column Information
mysqlslap, mysqlslap — Load Emulation Client
COMPRESS(), Encryption and Compression Functions
compressed tables, Compressed Table Characteristics
comp_err, Overview of Server-Side Programs
charset option, comp_err — Compile MySQL Error Message File
debug option, comp_err — Compile MySQL Error Message File
debug-info option, comp_err — Compile MySQL Error Message File
header_file option, comp_err — Compile MySQL Error Message File
help option, comp_err — Compile MySQL Error Message File
in_file option, comp_err — Compile MySQL Error Message File
name_file option, comp_err — Compile MySQL Error Message File
out_dir option, comp_err — Compile MySQL Error Message File
out_file option, comp_err — Compile MySQL Error Message File
statefile option, comp_err — Compile MySQL Error Message File
version option, comp_err — Compile MySQL Error Message File
CONCAT(), String Functions
CONCAT_WS(), String Functions
concurrency option
mysqlslap, mysqlslap — Load Emulation Client
concurrent inserts, Internal Locking Methods, Concurrent Inserts
Conditions, DECLARE Conditions
config-file option
mysqld_multi, mysqld_multi — Manage Multiple MySQL Servers
my_print_defaults, my_print_defaults — Display Options from Option Files
ndb_config, ndb_config — Extract NDB Configuration Information
config.cache, Dealing with Problems Compiling MySQL
config.cache file, Dealing with Problems Compiling MySQL
config.ini (MySQL Cluster), Multi-Computer Configuration, Configuration File, Basic Example Configuration, ndb_mgmd — The Management Server Process
configuration
MySQL Cluster, Overview of Cluster Configuration Parameters
configuration files, Causes of Access denied Errors
configuration options, Typical configure Options
configure
disable-grant-options option, Typical configure Options
enable-thread-safe-client option, Typical configure Options
localstatedir option, Typical configure Options
previx option, Typical configure Options
running after prior invocation, Dealing with Problems Compiling MySQL
with-big-tables option, Typical configure Options
with-charset option, Typical configure Options
with-collation option, Typical configure Options
with-debug option, Typical configure Options
with-embedded-server option, Typical configure Options
with-extra-charsets option, Typical configure Options
with-unix-socket-path option, Typical configure Options
without-server option, Typical configure Options
configure option
--with-low-memory, Dealing with Problems Compiling MySQL
configure script, Typical configure Options
configuring backups
in MySQL Cluster, Configuration for Cluster Backup
configuring MySQL Cluster, Simple Multi-Computer How-To, MySQL Cluster Configuration, MySQL Server Process Usage for MySQL Cluster, ndb_mgmd — The Management Server Process
Configuring MySQL Cluster (concepts), MySQL Cluster Core Concepts
conflict resolution
enabling, MySQL Cluster Replication Conflict Resolution
in MySQL Cluster Replication, MySQL Cluster Replication Conflict Resolution
mysqld startup options, MySQL Cluster Replication Conflict Resolution
Connect
thread command, Thread Command Values
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 Events (MySQL Cluster), Log Events
CONNECTION_ID(), Information Functions
Connector/JDBC, Connectors
Connector/MXJ, Connectors
Connector/NET, Connectors, MySQL Connector/NET
reporting problems, Connector/NET Support
Connector/ODBC, Connectors, MySQL Connector/ODBC
Borland, Using Connector/ODBC with Borland Applications
Borland Database Engine, Using Connector/ODBC with Borland Applications
reporting problems, Connector/ODBC Support
Connectors
MySQL, Connectors
connectstring (see MySQL Cluster)
connect_timeout variable, mysql Options, mysqladmin — Client for Administering a MySQL Server
console option
mysqld, Command Options
constant table, Optimizing Queries with EXPLAIN, WHERE Clause Optimization
constraints, How MySQL Deals with Constraints
CONSTRAINTS
INFORMATION_SCHEMA table, The INFORMATION_SCHEMA TABLE_CONSTRAINTS Table
Contains(), Functions That Test Spatial Relationships Between Geometries
contributing companies
list of, Supporters of MySQL
contributors
list of, Contributors to MySQL
control access, Access Control, Stage 1: Connection Verification
control flow functions, Control Flow Functions
CONV(), String Functions
conventions
typographical, Conventions Used in This Manual
CONVERT, Cast Functions and Operators
CONVERT TO, ALTER TABLE Syntax
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, 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
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 LOGFILE GROUP, CREATE LOGFILE GROUP Syntax
(see also MySQL Cluster Disk Data)
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
CREATE TABLESPACE, CREATE TABLESPACE Syntax
(see also MySQL Cluster Disk Data)
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 table from master dump
thread state, Replication Slave Connection 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
loading into tables, Loading Data into a Table
retrieving, Retrieving Information from a Table
size, Make Your Data as Small as Possible
data node (MySQL Cluster)
defined, MySQL Cluster Core Concepts
Data truncation with CJK characters, MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets
data type
BIGINT, Overview of Numeric Types
BINARY, Overview of String Types, The BINARY and VARBINARY Types
BIT, Overview of Numeric Types
BLOB, Overview of String Types, The BLOB and TEXT Types
BOOL, Overview of Numeric Types, Using Data Types from Other Database Engines
BOOLEAN, Overview of Numeric Types, Using Data Types from Other Database Engines
CHAR, Overview of String Types, String Types
CHAR VARYING, Overview of String Types
CHARACTER, Overview of String Types
CHARACTER VARYING, Overview of String Types
DATE, Overview of Date and Time Types, The DATETIME, DATE, and TIMESTAMP Types
DATETIME, Overview of Date and Time Types, The DATETIME, DATE, and TIMESTAMP Types
DEC, Overview of Numeric Types
DECIMAL, Overview of Numeric Types, Precision Math
DOUBLE, Overview of Numeric Types
DOUBLE PRECISION, Overview of Numeric Types
ENUM, Overview of String Types, The ENUM Type
FIXED, Overview of Numeric Types
FLOAT, Overview of Numeric Types
GEOMETRY, MySQL Spatial Data Types
GEOMETRYCOLLECTION, MySQL Spatial Data Types
INT, Overview of Numeric Types
INTEGER, Overview of Numeric Types
LINESTRING, MySQL Spatial Data Types
LONG, The BLOB and TEXT Types
LONGBLOB, Overview of String Types
LONGTEXT, Overview of String Types
MEDIUMBLOB, Overview of String Types
MEDIUMINT, Overview of Numeric Types
MEDIUMTEXT, Overview of String Types
MULTILINESTRING, MySQL Spatial Data Types
MULTIPOINT, MySQL Spatial Data Types
MULTIPOLYGON, MySQL Spatial Data Types
NATIONAL CHAR, Overview of String Types
NCHAR, Overview of String Types
NUMERIC, Overview of Numeric Types
POINT, MySQL Spatial Data Types
POLYGON, MySQL Spatial Data Types
REAL, Overview of Numeric Types
SET, Overview of String Types, The SET Type
SMALLINT, Overview of Numeric Types
TEXT, Overview of String Types, The BLOB and TEXT Types
TIME, Overview of Date and Time Types, The TIME Type
TIMESTAMP, Overview of Date and Time Types, The DATETIME, DATE, and TIMESTAMP Types
TINYBLOB, Overview of String Types
TINYINT, Overview of Numeric Types
TINYTEXT, Overview of String Types
VARBINARY, Overview of String Types, The BINARY and VARBINARY Types
VARCHAR, Overview of String Types, String Types
VARCHARACTER, Overview of String Types
YEAR, Overview of Date and Time Types, The YEAR Type
data types, Data Types
C API, MySQL C API
overview, Data Type Overview
data-file-length option
myisamchk, myisamchk Repair Options
database
altering, ALTER DATABASE Syntax
creating, CREATE DATABASE Syntax
deleting, DROP DATABASE Syntax
database design, Design Choices
Database information
obtaining, SHOW Syntax
database metadata, The INFORMATION_SCHEMA Database
database names
case sensitivity, Identifier Case Sensitivity
case-sensitivity, MySQL Extensions to Standard SQL
database option
mysql, mysql Options
mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files
DATABASE(), Information Functions
databases
backups, Database Backups
copying, Copying MySQL Databases to Another Machine
creating, Creating and Using a Database
defined, What is MySQL?
information about, Getting Information About Databases and Tables
names, Identifiers
replicating, Replication
selecting, Creating and Selecting a Database
symbolic links, Using Symbolic Links for Databases on Unix
using, Creating and Using a Database
databases option
mysqlcheck, mysqlcheck — A Table Maintenance and Repair Program
mysqldump, mysqldump — A Database Backup Program
DataDir, Defining the Management Server, Defining Data Nodes
datadir option
mysql.server, mysql.server — MySQL Server Startup Script
mysqld, Command Options
mysqld_safe, mysqld_safe — MySQL Server Startup Script
mysql_upgrade, mysql_upgrade — Check Tables for MySQL Upgrade
DataJunction, Using Connector/ODBC with Pervasive Software DataJunction
DataMemory, Defining Data Nodes, Configuring Parameters for Local Checkpoints
DATE, Problems Using DATE Columns
date and time functions, Date and Time Functions
Date and Time types, Date and Time Types
date calculations, Date Calculations
DATE columns
problems, Problems Using DATE Columns
DATE data type, Overview of Date and Time Types, The DATETIME, DATE, and TIMESTAMP Types
date functions
Y2K compliance, Year 2000 Issues and Date Types
date 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
DATE_ADD(), Date and Time Functions
DATE_FORMAT(), Date and Time Functions
DATE_SUB(), Date and Time Functions
DAY(), Date and Time Functions
DAYNAME(), Date and Time Functions
DAYOFMONTH(), Date and Time Functions
DAYOFWEEK(), Date and Time Functions
DAYOFYEAR(), Date and Time Functions
db option
mysqlaccess, mysqlaccess — Client for Checking Access Privileges
db table
sorting, Access Control, Stage 2: Request Verification
DB2 SQL mode, SQL Modes
DBI interface, MySQL Perl API
DBI->quote, Strings
DBI->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
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
mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files
mysqlcheck, mysqlcheck — A Table Maintenance and Repair Program
mysqld, Command Options
mysqldump, mysqldump — A Database Backup Program
mysqlhotcopy, mysqlhotcopy — A Database Backup Program
mysqlimport, mysqlimport — A Data Import Program
mysqlmanager, MySQL Instance Manager Command Options
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-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 and Repair 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 and Repair 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
debugging
client, Debugging a MySQL Client
server, Debugging a MySQL Server
debugging support, Typical configure Options
DEC data type, Overview of Numeric Types
decimal arithmetic, Precision Math
DECIMAL data type, Overview of Numeric Types, Precision Math
decimal point, Data Types
DECLARE, DECLARE Statement Syntax
DECODE(), Encryption and Compression Functions
decode_bits myisamchk variable, myisamchk General Options
DEFAULT
constraint, Constraints on Invalid Data
default
privileges, Securing the Initial MySQL Accounts
default hostname, Connecting to the MySQL Server
default installation location, Installation Layouts
default options, Using Option Files
DEFAULT value clause, Data Type Default Values, CREATE TABLE Syntax
default values, MySQL Design Limitations and Tradeoffs, Data Type Default Values, CREATE TABLE Syntax, INSERT Syntax
BLOB and TEXT columns, The BLOB and TEXT Types
explicit, Data Type Default Values
implicit, Data Type Default Values
suppression, Constraints on Invalid Data
DEFAULT(), Miscellaneous Functions
default-character-set option
mysql, mysql Options
mysqladmin, mysqladmin — Client for Administering a MySQL Server
mysqlcheck, mysqlcheck — A Table Maintenance and Repair Program
mysqld, Command Options
mysqldump, mysqldump — A Database Backup Program
mysqlimport, mysqlimport — A Data Import Program
mysqlshow, mysqlshow — Display Database, Table, and Column Information
default-collation option
mysqld, Command Options
default-mysqld-path option
mysqlmanager, MySQL Instance Manager Command Options
default-storage-engine option
mysqld, Command Options
default-table-type option
mysqld, Command Options
default-time-zone option
mysqld, Command Options
defaults
embedded, Options with the Embedded Server
defaults-extra-file option, Using Option Files
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, Using Option Files
mysqld_multi, mysqld_multi — Manage Multiple MySQL Servers
mysqld_safe, mysqld_safe — MySQL Server Startup Script
mysqlmanager, MySQL Instance Manager Command Options
my_print_defaults, my_print_defaults — Display Options from Option Files
defaults-group-suffix option, Using Option Files
my_print_defaults, my_print_defaults — Display Options from Option Files
DEGREES(), Mathematical Functions
delay-key-write option
mysqld, Command Options, MyISAM Startup Options
DELAYED, INSERT DELAYED Syntax
Delayed insert
thread command, Thread Command Values
delayed inserts
thread states, Delayed-Insert Thread States
delayed-insert option
mysqldump, mysqldump — A Database Backup Program
delayed_insert_limit, INSERT DELAYED Syntax
DELETE, DELETE Syntax
and MySQL Cluster, Limits and Differences from Standard MySQL Limits
delete option
mysqlimport, mysqlimport — A Data Import Program
delete-master-logs option
mysqldump, mysqldump — A Database Backup Program
deleting
database, DROP DATABASE Syntax
foreign key, ALTER TABLE Syntax, FOREIGN KEY Constraints
function, DROP FUNCTION Syntax
index, ALTER TABLE Syntax, DROP INDEX Syntax
primary key, ALTER TABLE Syntax
rows, Deleting Rows from Related Tables
schema, DROP DATABASE Syntax
table, DROP TABLE Syntax
user, Removing User Accounts from MySQL, DROP USER Syntax
users, Removing User Accounts from MySQL, DROP USER Syntax
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 option
mysql, mysql Options
mysqlslap, mysqlslap — Load Emulation Client
ndb_select_all, ndb_select_all — Print Rows from NDB Table
Delphi, Using Connector/ODBC with Delphi
derived tables, Subqueries in the FROM clause
des-key-file option
mysqld, Command Options
DESC, DESCRIBE Syntax
descending option
ndb_select_all, ndb_select_all — Print Rows from NDB Table
DESCRIBE, Getting Information About Databases and Tables, DESCRIBE Syntax
description option
myisamchk, Other myisamchk Options
design
choices, Design Choices
issues, Known Issues in MySQL
limitations, MySQL Design Limitations and Tradeoffs
DES_DECRYPT(), Encryption and Compression Functions
DES_ENCRYPT(), Encryption and Compression Functions
developers
list of, Credits
development source tree, Installing from the Development Source Tree
Difference(), Spatial Operators
digits, Data Types
Dimension(), General Geometry Functions
directory structure
default, Installation Layouts
disable-grant-options option
configure, Typical configure Options
disable-keys option
mysqldump, mysqldump — A Database Backup Program
disable-log-bin option
mysqlbinlog, mysqlbinlog — Utility for Processing Binary Log Files
DISCARD TABLESPACE, ALTER TABLE Syntax, Using Per-Table Tablespaces
discard_or_import_tablespace
thread state, General Thread States
disconnect-slave-event-count option
mysqld, Command Options
disconnecting
from the server, Connecting to and Disconnecting from the Server
Disjoint(), Functions That Test Spatial Relationships Between Geometries
Disk Data tables (MySQL Cluster) (see MySQL Cluster Disk Data)
disk full, How MySQL Handles a Full Disk
disk issues, Disk Issues
disk option
ndb_select_all, ndb_select_all — Print Rows from NDB Table
DiskCheckpointSpeed, Defining Data Nodes
DiskCheckpointSpeedInRestart, Defining Data Nodes
Diskless, Defining Data Nodes
DiskPageBufferMemory, Disk Data Configuration Parameters
disks
splitting data across, Using Symbolic Links for Databases on Windows
DiskSyncSize, Defining Data Nodes
display size, Data Types
display triggers, SHOW TRIGGERS Syntax
display width, Data Types
displaying
information
Cardinality, SHOW INDEX Syntax
Collation, SHOW INDEX Syntax
SHOW, SHOW Syntax, SHOW COLUMNS Syntax, SHOW INDEX Syntax, SHOW OPEN TABLES Syntax, SHOW TABLES Syntax
table status, SHOW TABLE STATUS Syntax
Distance(), Functions That Test Spatial Relationships Between Geometries
DISTINCT, Selecting Particular Columns, DISTINCT Optimization, SELECT Syntax
AVG(), GROUP BY (Aggregate) Functions
COUNT(), GROUP BY (Aggregate) Functions
MAX(), GROUP BY (Aggregate) Functions
MIN(), GROUP BY (Aggregate) Functions
SUM(), GROUP BY (Aggregate) Functions
DISTINCTROW, SELECT Syntax
DIV, Arithmetic Operators
division (/), Arithmetic Operators
DNS, How MySQL Uses DNS
DO, DO Syntax
DocBook XML
documentation source format, About This Manual
Documentation
in Chinese, MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets
in Japanese, MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets
in Korean, MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets
Documenters
list of, Documenters and translators
DOUBLE data type, Overview of Numeric Types
DOUBLE PRECISION data type, Overview of Numeric Types
double quote (\"), Strings
downgrades
MySQL Cluster, Upgrading and Downgrading MySQL Cluster, Performing a Rolling Restart of the Cluster, Cluster Upgrade and Downgrade Compatibility
downgrading, Downgrading MySQL
downloading, How to Get MySQL
drbd
FAQ, MySQL 5.1 FAQ — MySQL, DRBD, and Heartbeat
DRBD, Distributed Replicated Block Device
DRBD licence, Distributed Replicated Block Device
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 LOGFILE GROUP, DROP LOGFILE GROUP Syntax
(see also MySQL Cluster Disk Data)
DROP PREPARE, SQL Syntax for Prepared Statements
DROP PRIMARY KEY, ALTER TABLE Syntax
DROP PROCEDURE, DROP PROCEDURE and DROP FUNCTION Syntax
DROP SCHEMA, DROP DATABASE Syntax
DROP SERVER, DROP SERVER Syntax
DROP TABLE, DROP TABLE Syntax
and MySQL Cluster, Limits and Differences from Standard MySQL Limits
DROP TABLESPACE, DROP TABLESPACE Syntax
(see also MySQL Cluster Disk Data)
DROP TRIGGER, DROP TRIGGER Syntax
DROP USER, DROP USER Syntax
DROP VIEW, DROP VIEW Syntax
drop-user option
mysqlmanager, MySQL Instance Manager Command Options
dropping
user, Removing User Accounts from MySQL, DROP USER Syntax