Concept Index
*************
Errors / Aborted Connection''.
access control:
See ``Access Control, Stage 1: Connection Verification''.
access denied errors:
See ```Access denied' Error''.
access privileges:
See ``General Security Issues and the MySQL Access Privilege System''.
Access program:
See ``Programs Known to Work with MyODBC''.
ACID <1> Perl:
See ``Installing ActiveState Perl on Windows''.
adding, character sets:
See ``Adding a New Character Set''.
adding, native functions:
See ``Adding a New Native Function''.
adding, new functions:
See ``Adding New Functions to MySQL''.
adding, new user privileges:
See ``Adding New Users to MySQL''.
adding, new users:
See ``Installing a MySQL Binary Distribution''.
adding, procedures:
See ``Adding New Procedures to MySQL''.
adding, user-definable functions:
See ``Adding a New User-definable Function''.
administration, server:
See ```mysqladmin', Administrating a MySQL Server''.
ADO program:
See ``Programs Known to Work with MyODBC''.
age, calculating:
See ``Date Calculations''.
alias names, case-sensitivity:
See ``Case Sensitivity in Names''.
aliases, for expressions:
See ```GROUP BY' with Hidden Fields''.
aliases, for tables:
See ```SELECT' Syntax''.
aliases, in GROUP BY clauses:
See ```GROUP BY' with Hidden Fields''.
aliases, in ORDER BY clauses:
See ```GROUP BY' with Hidden Fields''.
aliases, names:
See ``Database, Table, Index, Column, and Alias Names''.
aliases, on expressions:
See ```SELECT' Syntax''.
anonymous user <1>:
See ``Setting Up the Initial MySQL Privileges''.
anonymous user <2> in ANSI Mode''.
answering questions, etiquette:
See ``Guidelines for Answering Questions on the Mailing List''.
Apache:
See ``Using MySQL with Apache''.
APIs:
See ``MySQL APIs''.
APIs, Perl:
See ``MySQL Perl API''.
applying, patches:
See ``Applying Patches''.
argument processing:
See ``Argument Processing''.
arithmetic expressions:
See ``Arithmetic Operations''.
AUTO-INCREMENT, ODBC:
See ``How to Get the Value of an `AUTO_INCREMENT' Column in ODBC''.
AUTO_INCREMENT:
See ``Using `AUTO_INCREMENT'''.
AUTO_INCREMENT, and NULL values:
See ``Problems with `NULL' Values''.
backing up, databases <1> See ``Literals: How to Write Strings and Numbers''.
backups:
See ``Database Backups''.
backups, database:
See ```BACKUP TABLE' Syntax''.
batch mode:
See ``Using `mysql' in Batch Mode''.
batch, mysql option:
See ```mysql', The Command-line Tool''.
BDB table type:
See ``MySQL Table Types''.
BDB tables:
See ``Transactions and Atomic Operations''.
benchmark suite:
See ``The MySQL Benchmark Suite''.
benchmarks:
See ``Using Your Own Benchmarks''.
BerkeleyDB table type:
See ``MySQL Table Types''.
Big5 Chinese character encoding:
See ``Case-Sensitivity in Searches''.
binary distributions:
See ``MySQL Binaries Compiled by MySQL AB''.
binary distributions, installing:
See ``Installing a MySQL Binary Distribution''.
binary distributions, on HP-UX:
See ``HP-UX Notes for Binary Distributions''.
binary distributions, on Linux:
See ``Linux Notes for Binary Distributions''.
binary log:
See ``The Binary Log''.
bit_functions, example:
See ``Calculating Visits Per Day''.
BitKeeper tree:
See ``Installing from the Development Source Tree''.
BLOB columns, default values:
See ``The `BLOB' and `TEXT' Types''.
BLOB columns, indexing:
See ```CREATE TABLE' Syntax''.
BLOB, inserting binary data:
See ``Strings''.
BLOB, size:
See ``Column Type Storage Requirements''.
Borland Builder 4 program:
See ``Programs Known to Work with MyODBC''.
Borland C++ compiler:
See ``Borland C++''.
brackets, square:
See ``Column Types''.
buffer sizes, client:
See ``MySQL APIs''.
buffer sizes, mysqld server:
See ``Tuning Server Parameters''.
bug reports, criteria for:
See ``How to Report Bugs or Problems''.
bugs database:
See ``How to Report Bugs or Problems''.
bugs, known:
See ``Known Errors and Design Deficiencies in MySQL''.
bugs, reporting:
See ``How to Report Bugs or Problems''.
bugs.mysql.com:
See ``How to Report Bugs or Problems''.
building, client programs:
See ``Building Client Programs''.
C API, datatypes:
See ``MySQL C API''.
C API, functions:
See ``C API Function Overview''.
C API, linking problems:
See ``Problems Linking with the C API''.
C Prepared statement API, functions:
See ``C API Prepared Statement Function Overview''.
C++:
See ``APIs''.
C++ APIs:
See ``MySQL C++ API''.
C++ Builder:
See ``Programs Known to Work with MyODBC''.
C++ compiler cannot create executables:
See ``Problems Compiling MySQL?''.
C++ compiler, gcc:
See ``Typical `configure' Options''.
caches, clearing:
See ```FLUSH' Syntax''.
calculating, dates:
See ``Date Calculations''.
calling sequences for aggregate functions, UDF:
See ``UDF Calling Sequences for aggregate functions''.
calling sequences for simple functions, UDF:
See ``UDF Calling Sequences for simple functions''.
can't create/write to file:
See ```Can't create/write to file' Error''.
case-sensitivity, in access checking:
See ``How the Privilege System Works''.
case-sensitivity, in names:
See ``Case Sensitivity in Names''.
case-sensitivity, in searches:
See ``Case-Sensitivity in Searches''.
case-sensitivity, in string comparisons:
See ``String Comparison Functions''.
case-sensitivity, of database names:
See ``MySQL Extensions to the SQL-92 Standard''.
case-sensitivity, of table names:
See ``MySQL Extensions to the SQL-92 Standard''.
cast operators:
See ``Case-Sensitivity''.
casts:
See ``Comparison Operators''.
cc1plus problems:
See ``Problems Compiling MySQL?''.
certification:
See ``Training and Certification''.
ChangeLog:
See ``MySQL Change History''.
changes to privileges:
See ``Access Control, Stage 2: Request Verification''.
changes, log:
See ``MySQL Change History''.
changes, version 3.19:
See ``Changes in release 3.19.x''.
changes, version 3.20:
See ``Changes in release 3.20.x''.
changes, version 3.21:
See ``Changes in release 3.21.x''.
changes, version 3.22:
See ``Changes in release 3.22.x (Old; discontinued)''.
changes, version 3.23:
See ``Changes in release 3.23.x (Recent; still supported)''.
changes, version 4.0:
See ``Changes in release 4.0.x (Production)''.
changes, version 4.1:
See ``Changes in release 4.1.x (Alpha)''.
changes, version 5.0:
See ``Changes in release 5.0.0 (Development)''.
changing socket location <1>:
See ``How to Protect or Change the MySQL Socket File `/tmp/mysql.sock'''.
changing socket location <2> column order:
See ``How To Change the Order of Columns in a Table''.
changing, field:
See ```ALTER TABLE' Syntax''.
changing, table <1><1>:
See ``The Character Set Used for Data and Sorting''.
character sets:
See ``Typical `configure' Options''.
character sets, adding:
See ``Adding a New Character Set''.
character-sets-dir, mysql option:
See ```mysql', The Command-line Tool''.
characters, multi-byte:
See ``Multi-byte Character Support''.
check options, myisamchk:
See ``Check Options for `myisamchk'''.
checking, tables for errors:
See ``How to Check Tables for Errors''.
checksum errors:
See ``Solaris Notes''.
Chinese:
See ``Case-Sensitivity in Searches''.
choosing types:
See ``Choosing the Right Type for a Column''.
choosing, a MySQL version:
See ``Which MySQL Version to Use''.
clearing, caches:
See ```FLUSH' Syntax''.
client programs, building:
See ``Building Client Programs''.
client tools:
See ``MySQL APIs''.
clients, debugging:
See ``Debugging a MySQL client''.
clients, threaded:
See ``How to Make a Threaded Client''.
closing, tables:
See ``How MySQL Opens and Closes Tables''.
ColdFusion program:
See ``Programs Known to Work with MyODBC''.
collating, strings:
See ``String Collating Support''.
column comments:
See ```CREATE TABLE' Syntax''.
column names, case-sensitivity:
See ``Case Sensitivity in Names''.
column, changing:
See ```ALTER TABLE' Syntax''.
columns, changing:
See ``How To Change the Order of Columns in a Table''.
columns, displaying:
See ```mysqlshow', Showing Databases, Tables, and Columns''.
columns, indexes:
See ``Column Indexes''.
columns, names:
See ``Database, Table, Index, Column, and Alias Names''.
columns, other types:
See ``Using Column Types from Other Database Engines''.
columns, selecting:
See ``Selecting Particular Columns''.
columns, storage requirements:
See ``Column Type Storage Requirements''.
columns, types:
See ``Column Types''.
command syntax:
See ``Conventions Used in This Manual''.
command-line history:
See ``Overview of the Client-Side Scripts and Utilities''.
command-line options, mysql:
See ```mysql', The Command-line Tool''.
command-line tool:
See ```mysql', The Command-line Tool''.
commands out of sync:
See ```Commands out of sync' Error in Client''.
commands, for binary distribution:
See ``Installing a MySQL Binary Distribution''.
commands, list of:
See ```mysql', The Command-line Tool''.
commands, replication masters:
See ``SQL Statements for Controlling Master Servers''.
commands, replication slaves:
See ``SQL Statements for Controlling Slave Servers''.
comments, adding:
See ``Comment Syntax''.
comments, starting:
See ```--' as the Start of a Comment''.
commercial support, types:
See ``Support Offered by MySQL AB''.
compatibility, between MySQL versions <1>:
See ``Upgrading from Version 3.21 to 3.22''.
compatibility, between MySQL versions <2>:
See ``Upgrading From Version 3.22 to 3.23''.
compatibility, between MySQL versions <3>:
See ``Upgrading From Version 3.23 to 4.0''.
compatibility, between MySQL versions:
See ``Upgrading From Version 4.0 to 4.1''.
compatibility, with mSQL:
See ``String Comparison Functions''.
compatibility, with ODBC <1>:
See ``Changes in release 3.21.15''.
compatibility, with ODBC <2>:
See ```CREATE TABLE' Syntax''.
compatibility, with ODBC <3>:
See ```JOIN' Syntax''.
compatibility, with ODBC <4>:
See ``Comparison Operators''.
compatibility, with ODBC <5>:
See ``Column Types''.
compatibility, with ODBC:
See ``Database, Table, Index, Column, and Alias Names''.
compatibility, with Oracle <1>:
See ```DESCRIBE' Syntax (Get Information About Columns)''.
compatibility, with Oracle <2> the SQL-92 Standard''.
compatibility, with standard SQL:
See ``MySQL Standards Compliance''.
compatibility, with Sybase:
See ```USE' Syntax''.
compiler, C++ gcc:
See ``Typical `configure' Options''.
compiling, on Windows:
See ``Compiling MySQL Clients on Windows''.
compiling, optimising:
See ``System/Compile Time and Startup Parameter Tuning''.
compiling, problems:
See ``Problems Compiling MySQL?''.
compiling, speed:
See ``How Compiling and Linking Affects the Speed of MySQL''.
compiling, statically:
See ``Typical `configure' Options''.
compiling, user-defined functions:
See ``Compiling and Installing User-definable Functions''.
compliance, Y2K:
See ``Year 2000 Compliance''.
compress, mysql option:
See ```mysql', The Command-line Tool''.
compressed tables <1> A Program for Managing Multiple MySQL Servers''.
config.cache:
See ``Problems Compiling MySQL?''.
config.cache file:
See ``Problems Compiling MySQL?''.
configuration files:
See ``Causes of `Access denied' Errors''.
configuration options:
See ``Typical `configure' Options''.
configure option, -with-low-memory:
See ``Problems Compiling MySQL?''.
configure script:
See ``Typical `configure' Options''.
configure, running after prior invocation:
See ``Problems Compiling MySQL?''.
connect_timeout variable:
See ```mysql', The Command-line Tool''.
connecting, remotely with SSH:
See ``Connecting to MySQL Remotely from Windows with SSH''.
connecting, to the server <1> Stage 1: Connection Verification''.
connection, aborted:
See ``Communication Errors / Aborted Connection''.
Connector/J:
See ``MySQL Java Connectivity (JDBC)''.
Connector/ODBC:
See ``MySQL ODBC Support''.
constant table <1>
See ``Contact Information''.
contributed programs:
See ``Contributed Programs''.
contributing companies, list of:
See ``Supporters to MySQL''.
contributors, list of:
See ``Contributors to MySQL''.
control access:
See ``Access Control, Stage 1: Connection Verification''.
conventions, typographical:
See ``Conventions Used in This Manual''.
converters:
See ``Converters''.
copying tables:
See ```CREATE TABLE' Syntax''.
copyrights:
See ``Copyrights and Licenses Used by MySQL''.
costs, support:
See ``Support Offered by MySQL AB''.
counting, table rows:
See ``Counting Rows''.
crackers, security against:
See ``How to Make MySQL Secure Against Crackers''.
crash:
See ``Debugging a MySQL server''.
crash, recovery:
See ``Using `myisamchk' for Crash Recovery''.
crash, repeated:
See ``What To Do If MySQL Keeps Crashing''.
crash-me:
See ``The MySQL Benchmark Suite''.
crash-me program <1>:
See ``The MySQL Benchmark Suite''.
crash-me program:
See ``Portability''.
creating, bug reports:
See ``How to Report Bugs or Problems''.
creating, databases:
See ``Creating and Using a Database''.
creating, default startup options:
See ```my.cnf' Option Files''.
creating, tables:
See ``Creating a Table''.
customer support, mailing address:
See ``How to Report Bugs or Problems''.
customers, of MySQL:
See ``What Have We Used MySQL For?''.
CVS tree:
See ``Installing from the Development Source Tree''.
data, character sets:
See ``The Character Set Used for Data and Sorting''.
data, importing:
See ```mysqlimport', Importing Data from Text Files''.
data, loading into tables:
See ``Loading Data into a Table''.
data, retrieving:
See ``Retrieving Information from a Table''.
data, size:
See ``Get Your Data as Small as Possible''.
database design:
See ``Design Choices''.
database names, case-sensitivity <1>:
See ``Case Sensitivity in Names''.
database names, case-sensitivity:
See ``MySQL Extensions to the SQL-92 Standard''.
database, deleting:
See ```DROP DATABASE' Syntax''.
database, mysql option:
See ```mysql', The Command-line Tool''.
databases, backups:
See ``Database Backups''.
databases, creating:
See ``Creating and Using a Database''.
databases, defined:
See ``What Is MySQL?''.
databases, displaying:
See ```mysqlshow', Showing Databases, Tables, and Columns''.
databases, dumping <1>:
See ```mysqlhotcopy', Copying MySQL Databases and Tables''.
databases, dumping:
See ```mysqldump', Dumping Table Structure and Data''.
databases, information about:
See ``Getting Information About Databases and Tables''.
databases, names:
See ``Database, Table, Index, Column, and Alias Names''.
databases, replicating:
See ``Replication in MySQL''.
databases, selecting:
See ``Creating and Selecting a Database''.
databases, symbolic links:
See ``Using Symbolic Links for Databases''.
databases, using:
See ``Creating and Using a Database''.
DataJunction:
See ``Programs Known to Work with MyODBC''.
datatypes, C API:
See ``MySQL C API''.
Date and Time types:
See ``Date and Time Types''.
date calculations:
See ``Date Calculations''.
DATE columns, problems:
See ``Problems Using `DATE' Columns''.
date functions, Y2K compliance:
See ``Year 2000 Compliance''.
date types:
See ``Column Type Storage Requirements''.
date types, Y2K issues:
See ``Y2K Issues and Date Types''.
date values, problems:
See ``The `DATETIME', `DATE', and `TIMESTAMP' Types''.
db table, sorting:
See ``Access Control, Stage 2: Request Verification''.
DBI interface:
See ```DBI' with `DBD::mysql'''.
DBI Perl module:
See ``The `DBI' Interface''.
DBI/DBD:
See ``More `DBI'/`DBD' Information''.
DBUG package:
See ``The DBUG Package''.
debug, mysql option:
See ```mysql', The Command-line Tool''.
debug-info, mysql option:
See ```mysql', The Command-line Tool''.
debugging, client:
See ``Debugging a MySQL client''.
debugging, server:
See ``Debugging a MySQL server''.
decimal point:
See ``Column Types''.
default hostname:
See ``Connecting to the MySQL Server''.
default installation location:
See ``Installation Layouts''.
default options:
See ```my.cnf' Option Files''.
default values <1>:
See ```CREATE TABLE' Syntax''.
default values <2>:
See ```INSERT' Syntax''.
default values:
See ``MySQL Design Limitations/Tradeoffs''.
default values, BLOB and TEXT columns:
See ``The `BLOB' and `TEXT' Types''.
default values, suppression <1>:
See ``Typical `configure' Options''.
default values, suppression:
See ``Constraint `NOT NULL' and `DEFAULT' values''.
default, privileges:
See ``Setting Up the Initial MySQL Privileges''.
default-character-set, mysql option:
See ```mysql', The Command-line Tool''.
defaults, embedded:
See ``Using Option Files with the Embedded Server''.
delayed_insert_limit:
See ```INSERT DELAYED' Syntax''.
deleting, database:
See ```DROP DATABASE' Syntax''.
deleting, function:
See ```CREATE FUNCTION/DROP FUNCTION' Syntax''.
deleting, index <1>:
See ```DROP INDEX' Syntax''.
deleting, index:
See ```ALTER TABLE' Syntax''.
deleting, primary key:
See ```ALTER TABLE' Syntax''.
deleting, rows:
See ``Deleting Rows from Related Tables''.
deleting, table:
See ```DROP TABLE' Syntax''.
deleting, user:
See ``Deleting Users from MySQL''.
deleting, users:
See ``Deleting Users from MySQL''.
deletion, mysql.sock:
See ``How to Protect or Change the MySQL Socket File `/tmp/mysql.sock'''.
Delphi:
See ``APIs''.
Delphi program:
See ``Programs Known to Work with MyODBC''.
design, choices:
See ``Design Choices''.
design, issues:
See ``Known Errors and Design Deficiencies in MySQL''.
design, limitations:
See ``MySQL Design Limitations/Tradeoffs''.
developers, list of:
See ``Credits''.
development source tree:
See ``Installing from the Development Source Tree''.
digits:
See ``Column Types''.
directory structure, default:
See ``Installation Layouts''.
disconnecting, from the server:
See ``Connecting to and Disconnecting from the Server''.
disk full:
See ``How MySQL Handles a Full Disk''.
disk issues:
See ``Disk Issues''.
disks, splitting data across:
See ``Distributing Data Across Different Disks on Windows''.
display size:
See ``Column Types''.
displaying, database information:
See ```mysqlshow', Showing Databases, Tables, and Columns''.
displaying, information, SHOW:
See ``Retrieving information about Database, Tables, Columns, and Indexes''.
displaying, table status:
See ```SHOW TABLE STATUS'''.
DNS:
See ``How MySQL uses DNS''.
downgrading:
See ``Upgrading/Downgrading MySQL''.
downloading:
See ``How to Get MySQL''.
dropping, user:
See ``Deleting Users from MySQL''.
dumping, databases <1> See ``Dynamic Table Characteristics''.
e-mail lists:
See ``The MySQL Mailing Lists''.
Eiffel Wrapper:
See ``MySQL Eiffel Wrapper''.
embedded MySQL server library:
See ``libmysqld, the Embedded MySQL Server Library''.
employment with MySQL:
See ``Contact Information''.
employment, contact information:
See ``Contact Information''.
enable-named-commands, mysql option:
See ```mysql', The Command-line Tool''.
entering, queries:
See ``Entering Queries''.
ENUM, size:
See ``Column Type Storage Requirements''.
environment variables <1>:
See ``Overview of the Client-Side Scripts and Utilities''.
environment variables <2>:
See ``Overview of the Server-Side Scripts and Utilities''.
environment variables <3>
See ```perror', Explaining Error Codes''.
errno:
See ```perror', Explaining Error Codes''.
error mesaages, can't find file:
See ``Problems with File Permissions''.
error messages, displaying:
See ```perror', Explaining Error Codes''.
error messages, languages:
See ``Non-English Error Messages''.
errors, access denied:
See ```Access denied' Error''.
errors, checking tables for:
See ``How to Check Tables for Errors''.
errors, common:
See ``Problems and Common Errors''.
errors, directory checksum:
See ``Solaris Notes''.
errors, handling for UDFs:
See ``Return Values and Error Handling''.
errors, known:
See ``Known Errors and Design Deficiencies in MySQL''.
errors, linking:
See ``Problems When Linking with the MySQL Client Library''.
errors, list of:
See ``Common Errors When Using MySQL''.
errors, reporting <1>:
See ``How to Report Bugs or Problems''.
errors, reporting <2> performance:
See ``Estimating Query Performance''.
example option:
See ```mysqld_multi', A Program for Managing Multiple MySQL Servers''.
examples, compressed tables:
See ```myisampack', The MySQL Compressed Read-only Table Generator''.
examples, myisamchk output:
See ``Getting Information About a Table''.
examples, queries:
See ``Examples of Common Queries''.
Excel:
See ``Programs Known to Work with MyODBC''.
execute, mysql option:
See ```mysql', The Command-line Tool''.
expression aliases <1>:
See ```SELECT' Syntax''.
expression aliases:
See ```GROUP BY' with Hidden Fields''.
expressions, extended:
See ``Pattern Matching''.
extensions, to standard SQL:
See ``MySQL Standards Compliance''.
extracting, dates:
See ``Date Calculations''.
fatal signal 11:
See ``Problems Compiling MySQL?''.
features of MySQL:
See ``The Main Features of MySQL''.
field, changing:
See ```ALTER TABLE' Syntax''.
files, binary log:
See ``The Binary Log''.
files, config.cache:
See ``Problems Compiling MySQL?''.
files, error messages:
See ``Non-English Error Messages''.
files, log <1>
See ``Problems with File Permissions''.
files, query log:
See ``The General Query Log''.
files, repairing:
See ``Repair Options for myisamchk''.
files, script:
See ``Using `mysql' in Batch Mode''.
files, size limits:
See ``How Big Can MySQL Tables Be?''.
files, slow query log:
See ``The Slow Query Log''.
files, text:
See ```mysqlimport', Importing Data from Text Files''.
files, tmp:
See ``Problems Running `mysql_install_db'''.
files, update log:
See ``The Update Log''.
files,my.cnf:
See ``Replication Features and Known Problems''.
floating-point number:
See ``Column Types''.
floats:
See ``Numbers''.
flush tables:
See ```mysqladmin', Administrating a MySQL Server''.
force, mysql option:
See ```mysql', The Command-line Tool''.
foreign key, constraint:
See ``Constraint PRIMARY KEY / UNIQUE''.
foreign keys <1>:
See ```ALTER TABLE' Syntax''.
foreign keys <2> See ``Problems Compiling MySQL?''.
full disk:
See ``How MySQL Handles a Full Disk''.
full-text search:
See ``MySQL Full-text Search''.
FULLTEXT:
See ``MySQL Full-text Search''.
function, deleting:
See ```CREATE FUNCTION/DROP FUNCTION' Syntax''.
functions for SELECT and WHERE clauses:
See ``Functions for Use in `SELECT' and `WHERE' Clauses''.
functions, C API:
See ``C API Function Overview''.
functions, C Prepared statement API:
See ``C API Prepared Statement Function Overview''.
functions, grouping:
See ``Parentheses''.
functions, native, adding:
See ``Adding a New Native Function''.
functions, new:
See ``Adding New Functions to MySQL''.
functions, user-definable, adding:
See ``Adding a New User-definable Function''.
functions, user-defined:
See ``Adding New Functions to MySQL''.
gcc:
See ``Typical `configure' Options''.
gdb, using:
See ``Debugging mysqld under gdb''.
general information:
See ``General Information''.
General Public License:
See ``What Is MySQL?''.
General Public License, MySQL:
See ``MySQL Licenses''.
geographic feature:
See ``Introduction''.
geometry:
See ``Introduction''.
geospatial feature:
See ``Introduction''.
getting MySQL:
See ``How to Get MySQL''.
GIS <1>
GPL, General Public License:
See ``GNU General Public License''.
GPL, GNU General Public License:
See ``GNU General Public License''.
GPL, MySQL:
See ``MySQL Licenses''.
grant tables:
See ``Access Control, Stage 2: Request Verification''.
grant tables, re-creating:
See ``Setting Up the Initial MySQL Privileges''.
grant tables, sorting <1> ``Upgrading the Grant Tables''.
granting, privileges:
See ```GRANT' and `REVOKE' Syntax''.
GROUP BY, aliases in:
See ```GROUP BY' with Hidden Fields''.
GROUP BY, extensions to standard SQL <1>
See ``Return Values and Error Handling''.
HEAP table type:
See ``MySQL Table Types''.
help option:
See ```mysqld_multi', A Program for Managing Multiple MySQL Servers''.
help, mysql option:
See ```mysql', The Command-line Tool''.
hints <1>:
See ```JOIN' Syntax''.
hints <2> MySQL:
See ``History of MySQL''.
host table:
See ``Access Control, Stage 2: Request Verification''.
host table, sorting:
See ``Access Control, Stage 2: Request Verification''.
host, mysql option:
See ```mysql', The Command-line Tool''.
hostname caching:
See ``How MySQL uses DNS''.
hostname, default:
See ``Connecting to the MySQL Server''.
HP-UX, binary distribution:
See ``HP-UX Notes for Binary Distributions''.
html, mysql option:
See ```mysql', The Command-line Tool''.
ID, unique:
See ``How Can I Get the Unique ID for the Last Inserted Row?''.
ignore-space, mysql option:
See ```mysql', The Command-line Tool''.
importing, data:
See ```mysqlimport', Importing Data from Text Files''.
increasing, performance:
See ``Replication FAQ''.
increasing, speed:
See ``Replication in MySQL''.
index, deleting <1>:
See ```DROP INDEX' Syntax''.
index, deleting:
See ```ALTER TABLE' Syntax''.
indexes:
See ```CREATE INDEX' Syntax''.
indexes, and BLOB columns:
See ```CREATE TABLE' Syntax''.
indexes, and IS NULL:
See ``How MySQL Uses Indexes''.
indexes, and LIKE:
See ``How MySQL Uses Indexes''.
indexes, and NULL values:
See ```CREATE TABLE' Syntax''.
indexes, and TEXT columns:
See ```CREATE TABLE' Syntax''.
indexes, block size:
See ```SHOW VARIABLES'''.
indexes, columns:
See ``Column Indexes''.
indexes, leftmost prefix of:
See ``How MySQL Uses Indexes''.
indexes, multi-column:
See ``Multiple-Column Indexes''.
indexes, multi-part:
See ```CREATE INDEX' Syntax''.
indexes, names:
See ``Database, Table, Index, Column, and Alias Names''.
indexes, use of:
See ``How MySQL Uses Indexes''.
InnoDB table type:
See ``MySQL Table Types''.
InnoDB tables:
See ``Transactions and Atomic Operations''.
INSERT DELAYED:
See ```INSERT DELAYED' Syntax''.
inserting, speed of:
See ``Speed of `INSERT' Queries''.
installation layouts:
See ``Installation Layouts''.
installation overview:
See ``Installing a MySQL Source Distribution''.
installing, binary distribution:
See ``Installing a MySQL Binary Distribution''.
installing, Linux RPM packages:
See ``Installing MySQL on Linux''.
installing, Mac OS X PKG packages:
See ``Installing MySQL on Mac OS X''.
installing, overview:
See ``Installing MySQL''.
installing, Perl:
See ``Perl Installation Comments''.
installing, Perl on Windows:
See ``Installing ActiveState Perl on Windows''.
installing, source distribution:
See ``Installing a MySQL Source Distribution''.
installing, user-defined functions:
See ``Compiling and Installing User-definable Functions''.
integers:
See ``Numbers''.
internal compiler errors:
See ``Problems Compiling MySQL?''.
internal locking:
See ``How MySQL Locks Tables''.
internals:
See ``MySQL Internals''.
Internet Relay Chat:
See ``MySQL Community Support on IRC (Internet Relay Chat)''.
Internet Service Providers:
See ``Using the MySQL Software for Free Under GPL''.
IRC:
See ``MySQL Community Support on IRC (Internet Relay Chat)''.
ISAM table type:
See ``MySQL Table Types''.
ISP services:
See ``Using the MySQL Software for Free Under GPL''.
Java connectivity:
See ``MySQL Java Connectivity (JDBC)''.
JDBC:
See ``MySQL Java Connectivity (JDBC)''.
jobs at MySQL:
See ``Contact Information''.
key space, MyISAM:
See ``Space Needed for Keys''.
keys:
See ``Column Indexes''.
keys, foreign <1>:
See ``Using Foreign Keys''.
keys, foreign:
See ``Foreign Keys''.
keys, multi-column:
See ``Multiple-Column Indexes''.
keys, searching on two:
See ``Searching on Two Keys''.
keywords:
See ``Is MySQL Picky About Reserved Words?''.
known errors:
See ``Known Errors and Design Deficiencies in MySQL''.
language support:
See ``Non-English Error Messages''.
last row, unique ID:
See ``How Can I Get the Unique ID for the Last Inserted Row?''.
layout of installation:
See ``Installation Layouts''.
leftmost prefix of indexes:
See ``How MySQL Uses Indexes''.
legal names:
See ``Database, Table, Index, Column, and Alias Names''.
LGPL, GNU Lesser General Public License:
See ``GNU Lesser General Public License''.
LGPL, GNU Library General Public License:
See ``GNU Lesser General Public License''.
LGPL, Lesser General Public License:
See ``GNU Lesser General Public License''.
LGPL, Library General Public License:
See ``GNU Lesser General Public License''.
libmysqld:
See ``libmysqld, the Embedded MySQL Server Library''.
library, mysqlclient:
See ``MySQL APIs''.
licenses:
See ``Copyrights and Licenses Used by MySQL''.
licensing costs:
See ``Support Offered by MySQL AB''.
licensing policy:
See ``MySQL Licenses''.
licensing terms:
See ``MySQL Support and Licensing''.
licensing, contact information:
See ``Contact Information''.
licensing, examples:
See ``MySQL Licenses''.
licensing, free:
See ``Using the MySQL Software for Free Under GPL''.
limitations, design:
See ``MySQL Design Limitations/Tradeoffs''.
limits, file-size:
See ``How Big Can MySQL Tables Be?''.
linking:
See ``Building Client Programs''.
linking, errors:
See ``Problems When Linking with the MySQL Client Library''.
linking, problems:
See ``Problems Linking with the C API''.
linking, speed:
See ``How Compiling and Linking Affects the Speed of MySQL''.
links, symbolic:
See ``Using Symbolic Links''.
Linux, binary distribution:
See ``Linux Notes for Binary Distributions''.
literals:
See ``Literals: How to Write Strings and Numbers''.
loading, tables:
See ``Loading Data into a Table''.
locking:
See ``System/Compile Time and Startup Parameter Tuning''.
locking methods:
See ``Locking methods''.
locking, row-level:
See ``Transactions and Atomic Operations''.
locking, tables:
See ``How MySQL Locks Tables''.
Log files:
See ``The MySQL Log Files''.
log files:
See ``Typical `configure' Options''.
log files, maintaining:
See ``Log File Maintenance''.
log files, names:
See ``Database Backups''.
log option:
See ```mysqld_multi', A Program for Managing Multiple MySQL Servers''.
log, changes:
See ``MySQL Change History''.
logos:
See ``MySQL AB Logos and Trademarks''.
Mac OS X, installation:
See ``Installing MySQL on Mac OS X''.
mailing address, for customer support:
See ``How to Report Bugs or Problems''.
mailing list address:
See ``General Information''.
mailing lists:
See ``The MySQL Mailing Lists''.
mailing lists, archive location:
See ``Asking Questions or Reporting Bugs''.
mailing lists, guidelines:
See ``Guidelines for Answering Questions on the Mailing List''.
main features of MySQL:
See ``The Main Features of MySQL''.
maintaining, log files:
See ``Log File Maintenance''.
maintaining, tables:
See ``Setting Up a Table Maintenance Regimen''.
make_binary_distribution:
See ``Overview of the Server-Side Scripts and Utilities''.
manual, available formats:
See ``About This Manual''.
manual, online location:
See ``About This Manual''.
manual, typographical conventions:
See ``Conventions Used in This Manual''.
master/slave setup:
See ``Replication Implementation Overview''.
matching, patterns:
See ``Pattern Matching''.
max memory used:
See ```mysqladmin', Administrating a MySQL Server''.
max_allowed_packet:
See ```mysql', The Command-line Tool''.
max_join_size:
See ```mysql', The Command-line Tool''.
MBR:
See ``Relations On Geometry Minimal Bounding Rectangles (MBRs)''.
memory usage, myisamchk:
See ```myisamchk' Memory Usage''.
memory use <1>
See ```MERGE' Tables''.
messages, languages:
See ``Non-English Error Messages''.
methods, locking:
See ``Locking methods''.
Minimum Bounding Rectangle:
See ``Relations On Geometry Minimal Bounding Rectangles (MBRs)''.
mirror sites:
See ``How to Get MySQL''.
MIT-pthreads:
See ``MIT-pthreads Notes''.
modes, batch:
See ``Using `mysql' in Batch Mode''.
modules, list of:
See ``How Stable Is MySQL?''.
monitor, terminal:
See ``MySQL Tutorial''.
mSQL compatibility:
See ``String Comparison Functions''.
msql2mysql:
See ``Overview of the Client-Side Scripts and Utilities''.
multi mysqld:
See ```mysqld_multi', A Program for Managing Multiple MySQL Servers''.
multi-byte character sets:
See ```Can't initialize character set xxx' error''.
multi-byte characters:
See ``Multi-byte Character Support''.
multi-column indexes:
See ``Multiple-Column Indexes''.
multi-part index:
See ```CREATE INDEX' Syntax''.
multiple servers:
See ``Running Multiple MySQL Servers on the Same Machine''.
My, derivation:
See ``History of MySQL''.
my.cnf file:
See ``Replication Features and Known Problems''.
MyISAM table type:
See ``MySQL Table Types''.
MyISAM, compressed tables <1> Type Storage Requirements''.
myisamchk <1>:
See ``Overview of the Server-Side Scripts and Utilities''.
myisamchk:
See ``Typical `configure' Options''.
myisamchk, example output:
See ``Getting Information About a Table''.
myisamchk, options:
See ``General Options for `myisamchk'''.
myisampack <1>:
See ``Compressed Table Characteristics''.
myisampack <2>
MyODBC, reporting problems:
See ``Reporting Problems with MyODBC''.
mysql <1> distribution:
See ``Which MySQL Version to Use''.
MySQL certification:
See ``Training and Certification''.
mysql command-line options:
See ```mysql', The Command-line Tool''.
MySQL consulting:
See ``Consulting''.
MySQL Dolphin name:
See ``History of MySQL''.
MySQL history:
See ``History of MySQL''.
MySQL mailing lists:
See ``MySQL Mailing Lists''.
MySQL name:
See ``History of MySQL''.
MySQL source distribution:
See ``Which MySQL Version to Use''.
MySQL table types:
See ``MySQL Table Types''.
MySQL training:
See ``Training and Certification''.
MySQL version:
See ``How to Get MySQL''.
MySQL, defined:
See ``What Is MySQL?''.
MySQL, introduction:
See ``What Is MySQL?''.
MySQL, pronunciation:
See ``What Is MySQL?''.
mysql.sock, changing location of:
See ``Typical `configure' Options''.
mysql.sock, protection:
See ``How to Protect or Change the MySQL Socket File `/tmp/mysql.sock'''.
mysql_fix_privilege_tables:
See ``Causes of `Access denied' Errors''.
mysql_install_db:
See ``Overview of the Server-Side Scripts and Utilities''.
mysql_install_db script:
See ``Problems Running `mysql_install_db'''.
mysqlaccess:
See ``Overview of the Client-Side Scripts and Utilities''.
mysqladmin <1>:
See ```DROP DATABASE' Syntax''.
mysqladmin <2>:
See ```CREATE DATABASE' Syntax''.
mysqladmin <3>:
See ```mysqladmin', Administrating a MySQL Server''.
mysqladmin <4>:
See ``Overview of the Client-Side Scripts and Utilities''.
mysqladmin <5>:
See ```SHOW STATUS'''.
mysqladmin <6><1> the Server-Side Scripts and Utilities''.
mysqlbug script:
See ``How to Report Bugs or Problems''.
mysqlbug script, location:
See ``General Information''.
mysqlclient library:
See ``MySQL APIs''.
mysqld:
See ``Overview of the Server-Side Scripts and Utilities''.
mysqld option:
See ```mysqld_multi', A Program for Managing Multiple MySQL Servers''.
mysqld options <1>
See ``How to Run MySQL As a Normal User''.
mysqld-max:
See ```mysqld-max', An Extended `mysqld' Server''.
mysqld_multi:
See ```mysqld_multi', A Program for Managing Multiple MySQL Servers''.
mysqld_safe:
See ```mysqld_safe', The Wrapper Around `mysqld'''.
mysqldump <1>:
See ```mysqldump', Dumping Table Structure and Data''.
mysqldump <2>:
See ``Overview of the Client-Side Scripts and Utilities''.
mysqldump:
See ``Upgrading to Another Architecture''.
mysqlimport <1>:
See ```LOAD DATA INFILE' Syntax''.
mysqlimport <2>:
See ```mysqlimport', Importing Data from Text Files''.
mysqlimport <3> and Utilities''.
mysqltest, MySQL Test Suite:
See ``MySQL Test Suite''.
named pipes:
See ``Running MySQL on Windows''.
names:
See ``Database, Table, Index, Column, and Alias Names''.
names, case-sensitivity:
See ``Case Sensitivity in Names''.
names, variables:
See ``User Variables''.
naming, releases of MySQL:
See ``Which MySQL Version to Use''.
native functions, adding:
See ``Adding a New Native Function''.
native thread support:
See ``Operating Systems Supported by MySQL''.
negative values:
See ``Numbers''.
net etiquette <1> Tool''.
netmask notation, in mysql.user table:
See ``Access Control, Stage 1: Connection Verification''.
NetWare <1> See ``Installing a MySQL Binary Distribution''.
no matching rows:
See ``Solving Problems with No Matching Rows''.
no-auto-rehash, mysql option:
See ```mysql', The Command-line Tool''.
no-beep, mysql option:
See ```mysql', The Command-line Tool''.
no-log option:
See ```mysqld_multi', A Program for Managing Multiple MySQL Servers''.
no-named-commands, mysql option:
See ```mysql', The Command-line Tool''.
no-pager, mysql option:
See ```mysql', The Command-line Tool''.
no-tee, mysql option:
See ```mysql', The Command-line Tool''.
non-delimited strings:
See ``The `DATETIME', `DATE', and `TIMESTAMP' Types''.
Non-transactional tables:
See ```Some non-transactional changed tables couldn't be rolled back' Error''.
NOT NULL, constraint:
See ``Constraint `NOT NULL' and `DEFAULT' values''.
Novell NetWare <1> columns:
See ``Problems with `NULL' Values''.
NULL values, and indexes:
See ```CREATE TABLE' Syntax''.
NULL values, and TIMESTAMP columns:
See ``Problems with `NULL' Values''.
NULL values, vs. empty values:
See ``Problems with `NULL' Values''.
NULL, testing for null <1>:
See ``Control Flow Functions''.
NULL, testing for null:
See ``Comparison Operators''.
numbers:
See ``Numbers''.
numeric types:
See ``Column Type Storage Requirements''.
ODBC:
See ``MySQL ODBC Support''.
ODBC compatibility <1>:
See ``Changes in release 3.21.15''.
ODBC compatibility <2>:
See ```CREATE TABLE' Syntax''.
ODBC compatibility <3>:
See ```JOIN' Syntax''.
ODBC compatibility <4>:
See ``Comparison Operators''.
ODBC compatibility <5> ODBC Administrator Program''.
odbcadmin program:
See ``Programs Known to Work with MyODBC''.
OLEDB:
See ``APIs''.
one-database, mysql option:
See ```mysql', The Command-line Tool''.
online location of manual:
See ``About This Manual''.
Open Source, defined:
See ``What Is MySQL?''.
open tables <1>:
See ``Why So Many Open tables?''.
open tables:
See ```mysqladmin', Administrating a MySQL Server''.
OpenGIS:
See ``Introduction''.
opening, tables:
See ``How MySQL Opens and Closes Tables''.
opens:
See ```mysqladmin', Administrating a MySQL Server''.
OpenSSL:
See ``Using Secure Connections''.
operating systems, file-size limits:
See ``How Big Can MySQL Tables Be?''.
operating systems, supported:
See ``Operating Systems Supported by MySQL''.
operating systems, Windows versus Unix:
See ``MySQL for Windows Compared to Unix MySQL''.
operations, arithmetic:
See ``Arithmetic Operations''.
operators, cast <1> MySQL Optimises `WHERE' Clauses''.
optimising, DISTINCT:
See ``How MySQL Optimises `DISTINCT'''.
optimising, LEFT JOIN:
See ``How MySQL Optimises `LEFT JOIN' and `RIGHT JOIN'''.
optimising, LIMIT:
See ``How MySQL Optimises `LIMIT'''.
optimising, tables:
See ``Table Optimisation''.
option files:
See ```my.cnf' Option Files''.
options, command-line:
See ```mysqld' Command-line Options''.
options, command-line, mysql:
See ```mysql', The Command-line Tool''.
options, configure:
See ``Typical `configure' Options''.
options, myisamchk:
See ``General Options for `myisamchk'''.
options, provided by MySQL:
See ``MySQL Tutorial''.
options, replication:
See ``Replication Features and Known Problems''.
Oracle compatibility <1>:
See ```DESCRIBE' Syntax (Get Information About Columns)''.
Oracle compatibility <2>:
See ```GROUP BY' Functions''.
Oracle compatibility:
See ``MySQL Extensions to the SQL-92 Standard''.
ORDER BY, aliases in:
See ```GROUP BY' with Hidden Fields''.
overview:
See ``General Information''.
pack_isam:
See ```myisampack', The MySQL Compressed Read-only Table Generator''.
pager, mysql option:
See ```mysql', The Command-line Tool''.
parameters, server:
See ``Tuning Server Parameters''.
partnering with MySQL AB:
See ``Partnering''.
password encryption, reversibility of:
See ``Miscellaneous Functions''.
password option:
See ```mysqld_multi', A Program for Managing Multiple MySQL Servers''.
password, mysql option:
See ```mysql', The Command-line Tool''.
password, root user:
See ``Setting Up the Initial MySQL Privileges''.
passwords, for users:
See ``MySQL User Names and Passwords''.
passwords, forgotten:
See ``How to Reset a Forgotten Root Password''.
passwords, resetting:
See ``How to Reset a Forgotten Root Password''.
passwords, security:
See ``What the Privilege System Does''.
passwords, setting <1>:
See ```SET' Syntax''.
passwords, setting <2> ``Pattern Matching''.
performance, benchmarks:
See ``Using Your Own Benchmarks''.
performance, disk issues:
See ``Disk Issues''.
performance, estimating:
See ``Estimating Query Performance''.
performance, improving <1>:
See ``Get Your Data as Small as Possible''.
performance, improving:
See ``Replication FAQ''.
Perl API:
See ``MySQL Perl API''.
Perl DBI/DBD, installation problems:
See ``Problems Using the Perl `DBI'/`DBD' Interface''.
Perl, installing:
See ``Perl Installation Comments''.
Perl, installing on Windows:
See ``Installing ActiveState Perl on Windows''.
Perl, modules:
See ``APIs''.
permission checks, effect on speed:
See ``Optimising `SELECT's and Other Queries''.
perror:
See ```perror', Explaining Error Codes''.
PHP API:
See ``MySQL PHP API''.
port, mysql option:
See ```mysql', The Command-line Tool''.
portability:
See ``Portability''.
portability, types:
See ``Using Column Types from Other Database Engines''.
porting, to other systems:
See ``Porting to Other Systems''.
post-install, multiple servers:
See ``Running Multiple MySQL Servers on the Same Machine''.
post-installation, setup and testing:
See ``Post-installation Setup and Testing''.
PostgreSQL compatibility:
See ``MySQL Extensions to the SQL-92 Standard''.
prices, support:
See ``Support Offered by MySQL AB''.
PRIMARY KEY, constraint:
See ``Constraint PRIMARY KEY / UNIQUE''.
primary key, deleting:
See ```ALTER TABLE' Syntax''.
privilege information, location:
See ``Privileges Provided by MySQL''.
privilege system:
See ``What the Privilege System Does''.
privilege system, described:
See ``How the Privilege System Works''.
privilege, changes:
See ``Access Control, Stage 2: Request Verification''.
privileges, access:
See ``General Security Issues and the MySQL Access Privilege System''.
privileges, adding:
See ``Adding New Users to MySQL''.
privileges, default:
See ``Setting Up the Initial MySQL Privileges''.
privileges, deleting:
See ``Deleting Users from MySQL''.
privileges, display:
See ```SHOW GRANTS'''.
privileges, dropping:
See ``Deleting Users from MySQL''.
privileges, granting:
See ```GRANT' and `REVOKE' Syntax''.
privileges, revoking:
See ```GRANT' and `REVOKE' Syntax''.
problems, access denied errors:
See ```Access denied' Error''.
problems, common errors:
See ``Problems and Common Errors''.
problems, compiling:
See ``Problems Compiling MySQL?''.
problems, DATE columns:
See ``Problems Using `DATE' Columns''.
problems, date values:
See ``The `DATETIME', `DATE', and `TIMESTAMP' Types''.
problems, installing on IBM-AIX:
See ``IBM-AIX notes''.
problems, installing on Solaris:
See ``Solaris Notes''.
problems, installing Perl:
See ``Problems Using the Perl `DBI'/`DBD' Interface''.
problems, linking:
See ``Problems When Linking with the MySQL Client Library''.
problems, ODBC:
See ``Reporting Problems with MyODBC''.
problems, reporting:
See ``How to Report Bugs or Problems''.
problems, starting the server:
See ``Problems Starting the MySQL Server''.
problems, table locking:
See ``Table Locking Issues''.
problems, timezone:
See ``Time Zone Problems''.
procedures, adding:
See ``Adding New Procedures to MySQL''.
procedures, stored:
See ``Stored Procedures and Triggers''.
process support:
See ``Operating Systems Supported by MySQL''.
processes, display:
See ```SHOW PROCESSLIST'''.
processing, arguments:
See ``Argument Processing''.
products, selling:
See ``MySQL Licenses''.
programs, client:
See ``Building Client Programs''.
programs, contributed:
See ``Contributed Programs''.
programs, crash-me:
See ``Portability''.
programs, list of <1>:
See ``Overview of the Client-Side Scripts and Utilities''.
programs, list of:
See ``Overview of the Server-Side Scripts and Utilities''.
prompt command:
See ```mysql', The Command-line Tool''.
prompt, mysql option:
See ```mysql', The Command-line Tool''.
prompts, meanings:
See ``Entering Queries''.
pronunciation, MySQL:
See ``What Is MySQL?''.
Protocol mismatch:
See ``Upgrading from Version 3.20 to 3.21''.
protocol, mysql option <1> entering:
See ``Entering Queries''.
queries, estimating performance:
See ``Estimating Query Performance''.
queries, examples:
See ``Examples of Common Queries''.
queries, speed of:
See ``Optimising `SELECT's and Other Queries''.
queries, Twin Studies project:
See ``Queries from the Twin Project''.
Query Cache:
See ``MySQL Query Cache''.
query log:
See ``The General Query Log''.
questions:
See ```mysqladmin', Administrating a MySQL Server''.
questions, answering:
See ``Guidelines for Answering Questions on the Mailing List''.
quick, mysql option:
See ```mysql', The Command-line Tool''.
quotes, in strings:
See ``Strings''.
quoting:
See ``Strings''.
quoting binary data:
See ``Strings''.
quoting strings:
See ``The `DBI' Interface''.
RAID, compile errors:
See ``Problems Compiling MySQL?''.
RAID, table type:
See ```CREATE TABLE' Syntax''.
raw, mysql option:
See ```mysql', The Command-line Tool''.
re-creating, grant tables:
See ``Setting Up the Initial MySQL Privileges''.
reconfiguring:
See ``Problems Compiling MySQL?''.
reconnect, mysql option:
See ```mysql', The Command-line Tool''.
recovery, from crash:
See ``Using `myisamchk' for Crash Recovery''.
reducing, data size:
See ``Get Your Data as Small as Possible''.
references:
See ```ALTER TABLE' Syntax''.
regex:
See ``MySQL Regular Expressions''.
regular expression syntax, described:
See ``MySQL Regular Expressions''.
relational databases, defined:
See ``What Is MySQL?''.
release numbers:
See ``Which MySQL Version to Use''.
releases, naming scheme:
See ``Which MySQL Version to Use''.
releases, testing:
See ``Which MySQL Version to Use''.
releases, updating:
See ``How and When Updates Are Released''.
reordering, columns:
See ``How To Change the Order of Columns in a Table''.
repair options, myisamchk:
See ``Repair Options for myisamchk''.
repairing, tables:
See ``How to Repair Tables''.
replace:
See ``Overview of the Client-Side Scripts and Utilities''.
replication:
See ``Replication in MySQL''.
replication masters, commands:
See ``SQL Statements for Controlling Master Servers''.
replication slaves, commands:
See ``SQL Statements for Controlling Slave Servers''.
reporting, bugs:
See ``How to Report Bugs or Problems''.
reporting, errors <1>
See ``Is MySQL Picky About Reserved Words?''.
restarting, the server:
See ``Post-installation Setup and Testing''.
retrieving, data from tables:
See ``Retrieving Information from a Table''.
return values, UDFs:
See ``Return Values and Error Handling''.
revoking, privileges:
See ```GRANT' and `REVOKE' Syntax''.
root password:
See ``Setting Up the Initial MySQL Privileges''.
root user, password resetting:
See ``How to Reset a Forgotten Root Password''.
rounding errors <1> Tables''.
rows, locking:
See ``Transactions and Atomic Operations''.
rows, matching problems:
See ``Solving Problems with No Matching Rows''.
rows, selecting:
See ``Selecting Particular Rows''.
rows, sorting:
See ``Sorting Rows''.
RPM file:
See ``Installing MySQL on Linux''.
RPM Package Manager:
See ``Installing MySQL on Linux''.
RTS-threads:
See ``Comments about RTS threads''.
running a web server:
See ``Using the MySQL Software for Free Under GPL''.
running configure after prior invocation:
See ``Problems Compiling MySQL?''.
running, ANSI mode:
See ``Running MySQL in ANSI Mode''.
running, batch mode:
See ``Using `mysql' in Batch Mode''.
running, multiple servers:
See ``Running Multiple MySQL Servers on the Same Machine''.
running, queries:
See ``Entering Queries''.
safe-mode command:
See ```mysql', The Command-line Tool''.
safe-updates, mysql option:
See ```mysql', The Command-line Tool''.
safe_mysqld:
See ```mysqld_safe', The Wrapper Around `mysqld'''.
Sakila:
See ``History of MySQL''.
script files:
See ``Using `mysql' in Batch Mode''.
scripts <1>:
See ```mysql', The Command-line Tool''.
scripts <2>:
See ```mysqld_multi', A Program for Managing Multiple MySQL Servers''.
scripts:
See ```mysqld_safe', The Wrapper Around `mysqld'''.
scripts, mysql_install_db:
See ``Problems Running `mysql_install_db'''.
scripts, mysqlbug:
See ``How to Report Bugs or Problems''.
searching, and case-sensitivity:
See ``Case-Sensitivity in Searches''.
searching, full-text:
See ``MySQL Full-text Search''.
searching, MySQL web pages:
See ``Asking Questions or Reporting Bugs''.
searching, two keys:
See ``Searching on Two Keys''.
security system:
See ``General Security Issues and the MySQL Access Privilege System''.
security, against crackers:
See ``How to Make MySQL Secure Against Crackers''.
SELECT, Query Cache:
See ``MySQL Query Cache''.
select_limit:
See ```mysql', The Command-line Tool''.
selecting, databases:
See ``Creating and Selecting a Database''.
selling products:
See ``MySQL Licenses''.
sequence emulation:
See ``Miscellaneous Functions''.
server administration:
See ```mysqladmin', Administrating a MySQL Server''.
server, connecting <1>:
See ``Connecting to the MySQL Server''.
server, connecting:
See ``Connecting to and Disconnecting from the Server''.
server, debugging:
See ``Debugging a MySQL server''.
server, disconnecting:
See ``Connecting to and Disconnecting from the Server''.
server, restart:
See ``Post-installation Setup and Testing''.
server, shutdown:
See ``Post-installation Setup and Testing''.
server, starting:
See ``Post-installation Setup and Testing''.
server, starting and stopping:
See ``Starting and Stopping MySQL Automatically''.
server, starting problems:
See ``Problems Starting the MySQL Server''.
servers, multiple:
See ``Running Multiple MySQL Servers on the Same Machine''.
services, ISP:
See ``Using the MySQL Software for Free Under GPL''.
services, web:
See ``Using the MySQL Software for Free Under GPL''.
SET, size:
See ``Column Type Storage Requirements''.
set-variable, mysql option:
See ```mysql', The Command-line Tool''.
setting, passwords:
See ``Setting Up Passwords''.
setup, post-installation:
See ``Post-installation Setup and Testing''.
shell syntax:
See ``Conventions Used in This Manual''.
showing, database information:
See ```mysqlshow', Showing Databases, Tables, and Columns''.
shutting down, the server:
See ``Post-installation Setup and Testing''.
silent column changes:
See ``Silent Column Specification Changes''.
silent, mysql option:
See ```mysql', The Command-line Tool''.
size of tables:
See ``How Big Can MySQL Tables Be?''.
sizes, display:
See ``Column Types''.
skip-column-names, mysql option:
See ```mysql', The Command-line Tool''.
skip-line-numbers, mysql option:
See ```mysql', The Command-line Tool''.
slow queries:
See ```mysqladmin', Administrating a MySQL Server''.
slow query log:
See ``The Slow Query Log''.
socket location, changing:
See ``Typical `configure' Options''.
socket, mysql option:
See ```mysql', The Command-line Tool''.
Solaris installation problems:
See ``Solaris Notes''.
Solaris troubleshooting:
See ``Problems Compiling MySQL?''.
sorting, character sets:
See ``The Character Set Used for Data and Sorting''.
sorting, data:
See ``Sorting Rows''.
sorting, grant tables <1> Rows''.
source distribution, installing:
See ``Installing a MySQL Source Distribution''.
Spatial Extensions in MySQL:
See ``Introduction''.
speed, compiling:
See ``How Compiling and Linking Affects the Speed of MySQL''.
speed, increasing:
See ``Replication in MySQL''.
speed, inserting:
See ``Speed of `INSERT' Queries''.
speed, linking:
See ``How Compiling and Linking Affects the Speed of MySQL''.
speed, of queries <1>:
See ``Speed of `SELECT' Queries''.
speed, of queries:
See ``Optimising `SELECT's and Other Queries''.
SQL commands, replication masters:
See ``SQL Statements for Controlling Master Servers''.
SQL commands, replication slaves:
See ``SQL Statements for Controlling Slave Servers''.
SQL, defined:
See ``What Is MySQL?''.
SQL-92, extensions to:
See ``MySQL Standards Compliance''.
sql_yacc.cc problems:
See ``Problems Compiling MySQL?''.
square brackets:
See ``Column Types''.
SSH:
See ``Connecting to MySQL Remotely from Windows with SSH''.
SSL and X509 Basics:
See ``Using Secure Connections''.
SSL command-line options:
See ``SSL Command-line Options''.
SSL related options:
See ``SSL `GRANT' Options''.
stability:
See ``How Stable Is MySQL?''.
Standard SQL, differences from:
See ```GRANT' and `REVOKE' Syntax''.
standards compatibility:
See ``MySQL Standards Compliance''.
Starting many servers:
See ``Running Multiple MySQL Servers on the Same Machine''.
starting, comments:
See ```--' as the Start of a Comment''.
starting, mysqld:
See ``How to Run MySQL As a Normal User''.
starting, the server:
See ``Post-installation Setup and Testing''.
starting, the server automatically:
See ``Starting and Stopping MySQL Automatically''.
startup options, default:
See ```my.cnf' Option Files''.
startup parameters:
See ``Tuning Server Parameters''.
startup parameters, mysql:
See ```mysql', The Command-line Tool''.
startup parameters, tuning:
See ``System/Compile Time and Startup Parameter Tuning''.
statically, compiling:
See ``Typical `configure' Options''.
status command:
See ```mysql', The Command-line Tool''.
status command, results:
See ```mysqladmin', Administrating a MySQL Server''.
status, tables:
See ```SHOW TABLE STATUS'''.
stopping, the server:
See ``Starting and Stopping MySQL Automatically''.
storage of data:
See ``Design Choices''.
storage requirements, column type:
See ``Column Type Storage Requirements''.
storage space, minimising:
See ``Get Your Data as Small as Possible''.
stored procedures and triggers, defined:
See ``Stored Procedures and Triggers''.
string collating:
See ``String Collating Support''.
string comparisons, case-sensitivity:
See ``String Comparison Functions''.
string types:
See ``String Types''.
strings, defined:
See ``Literals: How to Write Strings and Numbers''.
strings, escaping characters:
See ``Literals: How to Write Strings and Numbers''.
strings, non-delimited:
See ``The `DATETIME', `DATE', and `TIMESTAMP' Types''.
strings, quoting:
See ``The `DBI' Interface''.
striping, defined:
See ``Disk Issues''.
subqueries:
See ``Subqueries''.
subselects:
See ``Subqueries''.
superuser:
See ``Setting Up the Initial MySQL Privileges''.
support costs:
See ``Support Offered by MySQL AB''.
support terms:
See ``MySQL Support and Licensing''.
support, for operating systems:
See ``Operating Systems Supported by MySQL''.
support, licensing:
See ``MySQL Licenses''.
support, mailing address:
See ``How to Report Bugs or Problems''.
support, types:
See ``Support Offered by MySQL AB''.
suppression, default values <1> links <1>
system optimisation:
See ``System/Compile Time and Startup Parameter Tuning''.
system table:
See ```EXPLAIN' Syntax (Get Information About a `SELECT')''.
system variables:
See ``System Variables''.
system, privilege:
See ``What the Privilege System Does''.
system, security:
See ``General Security Issues and the MySQL Access Privilege System''.
table aliases:
See ```SELECT' Syntax''.
table cache:
See ``How MySQL Opens and Closes Tables''.
table is full <1>:
See ```The table is full' Error''.
table is full:
See ```SET' Syntax''.
table names, case-sensitivity <1>
table, changing <1>:
See ``Problems with `ALTER TABLE'.''.
table, changing:
See ```ALTER TABLE' Syntax''.
table, deleting:
See ```DROP TABLE' Syntax''.
table, mysql option:
See ```mysql', The Command-line Tool''.
tables, BDB:
See ```BDB' or `BerkeleyDB' Tables''.
tables, Berkeley DB:
See ```BDB' or `BerkeleyDB' Tables''.
tables, changing column order:
See ``How To Change the Order of Columns in a Table''.
tables, checking:
See ``Check Options for `myisamchk'''.
tables, closing:
See ``How MySQL Opens and Closes Tables''.
tables, compressed:
See ```myisampack', The MySQL Compressed Read-only Table Generator''.
tables, compressed format:
See ``Compressed Table Characteristics''.
tables, constant <1>
tables, counting rows:
See ``Counting Rows''.
tables, creating:
See ``Creating a Table''.
tables, defragment <1>
tables, deleting rows:
See ``Deleting Rows from Related Tables''.
tables, displaying:
See ```mysqlshow', Showing Databases, Tables, and Columns''.
tables, displaying status:
See ```SHOW TABLE STATUS'''.
tables, dumping <1>:
See ```mysqlhotcopy', Copying MySQL Databases and Tables''.
tables, dumping:
See ```mysqldump', Dumping Table Structure and Data''.
tables, dynamic:
See ``Dynamic Table Characteristics''.
tables, error checking:
See ``How to Check Tables for Errors''.
tables, flush:
See ```mysqladmin', Administrating a MySQL Server''.
tables, fragmentation:
See ```OPTIMIZE TABLE' Syntax''.
tables, grant:
See ``Access Control, Stage 2: Request Verification''.
tables, HEAP:
See ```HEAP' Tables''.
tables, host:
See ``Access Control, Stage 2: Request Verification''.
tables, improving performance:
See ``Get Your Data as Small as Possible''.
tables, information:
See ``Getting Information About a Table''.
tables, information about:
See ``Getting Information About Databases and Tables''.
tables, ISAM:
See ```ISAM' Tables''.
tables, loading data:
See ``Loading Data into a Table''.
tables, locking:
See ``How MySQL Locks Tables''.
tables, maintenance regimen:
See ``Setting Up a Table Maintenance Regimen''.
tables, maximum size:
See ``How Big Can MySQL Tables Be?''.
tables, merging:
See ```MERGE' Tables''.
tables, multiple:
See ``Using More Than one Table''.
tables, names:
See ``Database, Table, Index, Column, and Alias Names''.
tables, open:
See ``Why So Many Open tables?''.
tables, opening:
See ``How MySQL Opens and Closes Tables''.
tables, optimising:
See ``Table Optimisation''.
tables, RAID:
See ```CREATE TABLE' Syntax''.
tables, repairing:
See ``How to Repair Tables''.
tables, retrieving data:
See ``Retrieving Information from a Table''.
tables, selecting columns:
See ``Selecting Particular Columns''.
tables, selecting rows:
See ``Selecting Particular Rows''.
tables, sorting rows:
See ``Sorting Rows''.
tables, symbolic links:
See ``Using Symbolic Links for Tables''.
tables, system:
See ```EXPLAIN' Syntax (Get Information About a `SELECT')''.
tables, too many:
See ``Drawbacks to Creating Large Numbers of Tables in the Same Database''.
tables, unique ID for last row:
See ``How Can I Get the Unique ID for the Last Inserted Row?''.
tables, updating:
See ``Transactions and Atomic Operations''.
tar, problems on Solaris:
See ``Solaris Notes''.
Tcl API:
See ``MySQL Tcl API''.
tcp-ip option:
See ```mysqld_multi', A Program for Managing Multiple MySQL Servers''.
TCP/IP:
See ``Running MySQL on Windows''.
technical support, licensing:
See ``MySQL Licenses''.
technical support, mailing address:
See ``How to Report Bugs or Problems''.
tee, mysql option:
See ```mysql', The Command-line Tool''.
temporary file, write access:
See ``Problems Running `mysql_install_db'''.
temporary tables, problems:
See ``TEMPORARY TABLE problems''.
terminal monitor, defined:
See ``MySQL Tutorial''.
testing mysqld, mysqltest:
See ``MySQL Test Suite''.
testing, connection to the server:
See ``Access Control, Stage 1: Connection Verification''.
testing, installation:
See ``Post-installation Setup and Testing''.
testing, of MySQL releases:
See ``Which MySQL Version to Use''.
testing, post-installation:
See ``Post-installation Setup and Testing''.
testing, the server:
See ``Post-installation Setup and Testing''.
Texinfo:
See ``About This Manual''.
TEXT columns, default values:
See ``The `BLOB' and `TEXT' Types''.
TEXT columns, indexing:
See ```CREATE TABLE' Syntax''.
text files, importing:
See ```mysqlimport', Importing Data from Text Files''.
TEXT, size:
See ``Column Type Storage Requirements''.
thread packages, differences between:
See ``Differences between different thread packages''.
thread support:
See ``Operating Systems Supported by MySQL''.
thread support, non-native:
See ``MIT-pthreads Notes''.
threaded clients:
See ``How to Make a Threaded Client''.
threads <1>:
See ``MySQL Internals''.
threads:
See ```mysqladmin', Administrating a MySQL Server''.
threads, display:
See ```SHOW PROCESSLIST'''.
threads, RTS:
See ``Comments about RTS threads''.
time types:
See ``Column Type Storage Requirements''.
timeout <1>:
See ```INSERT DELAYED' Syntax''.
timeout <2> values:
See ``Problems with `NULL' Values''.
timezone problems:
See ``Time Zone Problems''.
tips, optimisation:
See ``Other Optimisation Tips''.
ToDo list for MySQL:
See ``MySQL and the Future (The TODO)''.
TODO, embedded server:
See ``Things left to do in Embedded Server (TODO)''.
TODO, symlinks:
See ``Using Symbolic Links for Tables''.
tools, command-line:
See ```mysql', The Command-line Tool''.
tools, mysqld_multi:
See ```mysqld_multi', A Program for Managing Multiple MySQL Servers''.
tools, mysqld_safe:
See ```mysqld_safe', The Wrapper Around `mysqld'''.
tools, safe_mysqld:
See ```mysqld_safe', The Wrapper Around `mysqld'''.
trademarks:
See ``MySQL AB Logos and Trademarks''.
training:
See ``Training and Certification''.
transaction-safe tables <1>:
See ``InnoDB Tables Overview''.
transaction-safe tables:
See ``Transactions and Atomic Operations''.
transactions, support <1> FreeBSD:
See ``Problems Compiling MySQL?''.
troubleshooting, Solaris:
See ``Problems Compiling MySQL?''.
tutorial:
See ``MySQL Tutorial''.
Twin Studies, queries:
See ``Queries from the Twin Project''.
type conversions:
See ``Comparison Operators''.
types of support:
See ``Support Offered by MySQL AB''.
types, columns <1> See ``Date and Time Types''.
types, numeric:
See ``Column Type Storage Requirements''.
types, of tables:
See ``MySQL Table Types''.
types, portability:
See ``Using Column Types from Other Database Engines''.
types, strings:
See ``String Types''.
types, time:
See ``Column Type Storage Requirements''.
typographical conventions:
See ``Conventions Used in This Manual''.
UCS-2:
See ``National Character Sets and Unicode''.
UDFs, compiling:
See ``Compiling and Installing User-definable Functions''.
UDFs, defined:
See ``Adding New Functions to MySQL''.
UDFs, return values:
See ``Return Values and Error Handling''.
unbuffered, mysql option:
See ```mysql', The Command-line Tool''.
Unicode:
See ``National Character Sets and Unicode''.
unique ID:
See ``How Can I Get the Unique ID for the Last Inserted Row?''.
UNIQUE, constraint:
See ``Constraint PRIMARY KEY / UNIQUE''.
unloading, tables:
See ``Retrieving Information from a Table''.
update log:
See ``The Update Log''.
updating, releases of MySQL:
See ``How and When Updates Are Released''.
updating, tables:
See ``Transactions and Atomic Operations''.
upgrading:
See ``Upgrading/Downgrading MySQL''.
upgrading, 3.20 to 3.21:
See ``Upgrading from Version 3.20 to 3.21''.
upgrading, 3.21 to 3.22:
See ``Upgrading from Version 3.21 to 3.22''.
upgrading, 3.22 to 3.23:
See ``Upgrading From Version 3.22 to 3.23''.
upgrading, 3.23 to 4.0:
See ``Upgrading From Version 3.23 to 4.0''.
upgrading, 4.0 to 4.1:
See ``Upgrading From Version 4.0 to 4.1''.
upgrading, different architecture:
See ``Upgrading to Another Architecture''.
upgrading, grant tables:
See ``Upgrading the Grant Tables''.
uptime:
See ```mysqladmin', Administrating a MySQL Server''.
URLs for downloading MySQL:
See ``How to Get MySQL''.
user names, and passwords:
See ``MySQL User Names and Passwords''.
user option:
See ```mysqld_multi', A Program for Managing Multiple MySQL Servers''.
user privileges, adding:
See ``Adding New Users to MySQL''.
user privileges, deleting:
See ``Deleting Users from MySQL''.
user privileges, dropping:
See ``Deleting Users from MySQL''.
user table, sorting:
See ``Access Control, Stage 1: Connection Verification''.
user variables:
See ``User Variables''.
user, mysql option:
See ```mysql', The Command-line Tool''.
user-defined functions, adding <1>:
See ``Adding a New User-definable Function''.
user-defined functions, adding:
See ``Adding New Functions to MySQL''.
users, adding:
See ``Installing a MySQL Binary Distribution''.
users, deleting:
See ``Deleting Users from MySQL''.
users, root:
See ``Setting Up the Initial MySQL Privileges''.
uses, of MySQL:
See ``What Have We Used MySQL For?''.
using multiple disks to start data:
See ``Distributing Data Across Different Disks on Windows''.
UTF-8:
See ``National Character Sets and Unicode''.
utilities:
See ``Utilities''.
valid numbers, examples:
See ``Numbers''.
VARCHAR, size:
See ``Column Type Storage Requirements''.
variables, mysqld:
See ``Tuning Server Parameters''.
variables, status:
See ```SHOW STATUS'''.
variables, System:
See ``System Variables''.
variables, user:
See ``User Variables''.
variables, values:
See ```SHOW VARIABLES'''.
verbose, mysql option:
See ```mysql', The Command-line Tool''.
version option:
See ```mysqld_multi', A Program for Managing Multiple MySQL Servers''.
version, choosing:
See ``Which MySQL Version to Use''.
version, latest:
See ``How to Get MySQL''.
version, mysql option:
See ```mysql', The Command-line Tool''.
vertical, mysql option:
See ```mysql', The Command-line Tool''.
views:
See ``Views''.
virtual memory, problems while compiling:
See ``Problems Compiling MySQL?''.
Visual Basic:
See ``Programs Known to Work with MyODBC''.
wait, mysql option:
See ```mysql', The Command-line Tool''.
web server, running:
See ``Using the MySQL Software for Free Under GPL''.
Well-Known Binary format:
See ``Well-Known Binary (WKB) Format''.
Well-Known Text format:
See ``Well-Known Text (WKT) Format''.
What is an X509/Certificate?:
See ``Basics''.
What is encryption:
See ``Basics''.
wildcards, and LIKE:
See ``How MySQL Uses Indexes''.
wildcards, in mysql.columns_priv table:
See ``Access Control, Stage 2: Request Verification''.
wildcards, in mysql.db table:
See ``Access Control, Stage 2: Request Verification''.
wildcards, in mysql.host table:
See ``Access Control, Stage 2: Request Verification''.
wildcards, in mysql.tables_priv table:
See ``Access Control, Stage 2: Request Verification''.
wildcards, in mysql.user table:
See ``Access Control, Stage 1: Connection Verification''.
Windows:
See ``MySQL ODBC Support''.
Windows, compiling on:
See ``Compiling MySQL Clients on Windows''.
Windows, open issues:
See ``MySQL for Windows Compared to Unix MySQL''.
Windows, upgrading:
See ``Upgrading MySQL under Windows''.
Windows, versus Unix:
See ``MySQL for Windows Compared to Unix MySQL''.
WKB:
See ``Well-Known Binary (WKB) Format''.
WKT:
See ``Well-Known Text (WKT) Format''.
Word program:
See ``Programs Known to Work with MyODBC''.
wrappers, Eiffel:
See ``MySQL Eiffel Wrapper''.
write access, tmp:
See ``Problems Running `mysql_install_db'''.
xml, mysql option:
See ```mysql', The Command-line Tool''.
Year 2000 compliance:
See ``Year 2000 Compliance''.
Year 2000 issues:
See ``Y2K Issues and Date Types''.
[Назад] [Содержание]
| Главная |