O'Reilly logo

MySQL Reference Manual by Kaj Arno, David Axmark, Michael Widenius

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Index

Symbols

!= (not equal), Comparison operators
", Database, Table, Index, Column, and Alias Names
% (modulo), Mathematical functions
% (wildcard character), Strings
& (bitwise AND), Bit functions
&& (logical AND), Logical operators
( ) (parentheses), Parentheses
(Control-Z) \z, Strings
* (multiplication), Arithmetic operations
- (subtraction), Arithmetic operations
-password option, Keeping Your Password Secure
/ (division), Arithmetic operations
/etc/passwd , How to Make MySQL Secure Against Crackers, SELECT Syntax
< (less than), Comparison operators
<<, Calculating Visits per Day
<< (left shift), Bit functions
<= (less than or equal), Comparison operators
<=> (Equal to), Comparison operators
<> (not equal), Comparison operators
> (greater than), Comparison operators
>= (greater than or equal), Comparison operators
>> (right shift), Bit functions
\' (single quote), Strings
\b (backspace), Strings
\n (newline), Strings
\r (carriage return), Strings
\t (tab), Strings
\z (Control-Z) ASCII(26), Strings
\\ (escape), Strings
\” (double quote), Strings
_ (wildcard character), Strings
`, Database, Table, Index, Column, and Alias Names
|| (logical OR), Logical operators
~, Bit functions

A

aborted clients, Communication Error/ Aborted Connection
aborted connection, Communication Error/ Aborted Connection
ABS( ), Mathematical functions
access control, Access Control, Stage 1: Connection Verification
access denied errors, Access denied Error
access privileges, General Security Issues and the MySQL Access Privilege System
ACID, Transactions and atomic operations, InnoDB Tables Overview
ACLs, General Security Issues and the MySQL Access Privilege System
ACOS( ), Mathematical functions
ActiveState Perl, Installing ActiveState Perl on Windows
ADDDATE( ), Date and Time Functions
adding
character sets, Adding a New Character Set
native functions, Adding a New Native Function
new functions, Adding New Functions to MySQL
new user privileges, Adding New Users to MySQL
new users, Installing a MySQL Binary Distribution
procedures, Adding New Procedures to MySQL
administration
server, mysqladmin, Administrating a MySQL Server
ADO program, Programs Known to Work with MyODBC
advertising
contact information, Contact Information
age
calculating, Date calculations
alias, Problems with alias
alias names
case sensitivity, Case Sensitivity in Names
aliases
for expressions, Functions for Use with GROUP BY Clauses
for tables, SELECT Syntax
in GROUP BY clauses, Functions for Use with GROUP BY Clauses
in ORDER BY clauses, Functions for Use with GROUP BY Clauses
names, Database, Table, Index, Column, and Alias Names
on expressions, SELECT Syntax
ALTER COLUMN, ALTER TABLE Syntax
ALTER TABLE, ALTER TABLE Syntax, Problems with ALTER TABLE
ANALYZE TABLE, ANALYZE TABLE Syntax
AND
bitwise, Bit functions
logical, Logical operators
anonymous user, Access Control, Stage 1: Connection Verification, Access Control, Stage 2: Request Verification, Setting Up the Initial MySQL Privileges
ANSI mode
running, Running MySQL in ANSI Mode
ANSI SQL
differences from, GRANT and REVOKE Syntax
ANSI SQL92
extensions to, How Standards-Compatible Is MySQL?
answering questions
etiquette, Guidelines for answering questions on the mailing list
Apache, Using MySQL with Apache
APIs, MySQL APIs
Perl, MySQL Perl API
applying
patches, Applying Patches
argument processing, Argument processing
arithmetic expressions, Arithmetic operations
arithmetic functions, Bit functions
AS, SELECT Syntax, JOIN syntax
ASIN( ), Mathematical functions
ATAN( ), Mathematical functions
ATAN2( ), Mathematical functions
AUTO-INCREMENT
ODBC, How to Get the Value of an AUTO_INCREMENT Column in ODBC
AUTO_INCREMENT, Using AUTO_INCREMENT
and NULL values, Problems with NULL Values
AVG( ), Functions for Use with GROUP BY Clauses

B

backing up
databases, mysqldump, Dumping Table Structure and Data, mysqlhotcopy, Copying MySQL Databases and Tables
backslash
escape character, Literals: How to Write Strings and Numbers
backspace (\b), Strings
BACKUP TABLE, BACKUP TABLE Syntax
backups, Database Backups
database, BACKUP TABLE Syntax
batch
mysql option, The Command-Line Tool
batch mode, Using mysql in Batch Mode
BDB table type, MySQL Table Types
BDB tables, Transactions and atomic operations
BEGIN, BEGIN/COMMIT/ROLLBACK Syntax
benchmark suite, The MySQL Benchmark Suite
BENCHMARK( ), Miscellaneous functions
benchmarks, Using Your Own Benchmarks
Berkeley_db table type, MySQL Table Types
BETWEEN ... AND, Comparison operators
Big5 Chinese character encoding, Case Sensitivity in Searches
BIGINT, Column Types
BIN( ), String Functions
binary distributions, MySQL Binaries Compiled by MySQL AB
installing, Installing a MySQL Binary Distribution
on HP-UX, HP-UX notes for binary distributions
on Linux, Linux notes for binary distributions
binary log, The Binary Update Log
Binlog_Dump, Replication FAQ
BIT, Column Types
bit functions, Bit functions
BitKeeper tree, Installing from the Development Source Tree
BIT_AND( ), Functions for Use with GROUP BY Clauses
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( ), Functions for Use with GROUP BY Clauses
BLOB, Column Types, The BLOB and TEXT types
inserting binary data, Strings
size, Storage requirements for string types
BLOB columns
default values, The BLOB and TEXT types
indexing, CREATE TABLE Syntax
books
about MySQL, MySQL Portals
BOOL, Column Types
Borland Builder 4 program, Programs Known to Work with MyODBC
Borland C++ compiler, Borland C++
buffer sizes
client, MySQL APIs
mysqld server, Tuning Server Parameters
bug reports
criteria for, How to report bugs or problems
email address, How to report bugs or problems
bugs
known, Known Errors and Design Deficiencies in MySQL
reporting, How to report bugs or problems
building
client programs, Building Client Programs

C

C API
datatypes, MySQL C API
functions, C API Function Overview
linking problems, Problems linking with the C API
C++, APIs
C++ APIs, MySQL C++ APIs
C++ Builder, Programs Known to Work with MyODBC
C++ compiler
gcc, Typical configure Options
C++ compiler cannot create executables, Problems Compiling?
caches
clearing, FLUSH Syntax
calculating
dates, Date calculations
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 Error
carriage return (\r), Strings
CASE, Control flow functions
case sensitivity
in access checking, How the Privilege System Works
in searches, Case Sensitivity in Searches
in string comparisons, String comparison functions
of database names, MySQL Extensions to ANSI SQL92
of table names, MySQL Extensions to ANSI SQL92
case-sensitivity
in names, Case Sensitivity in Names
CAST, Cast Functions
cast operators, Case sensitivity
casts, Comparison operators, Case sensitivity
CC environment variable, Typical configure Options, Problems Compiling?
cc1plus problems, Problems Compiling?
CEILING( ), Mathematical functions
certification, Training and certification
CFLAGS environment variable, Problems Compiling?
changes to privileges, Access Control, Stage 2: Request Verification
changing
column order, How to Change the Order of Columns in a Table
changing socket location, Typical configure Options, Starting and Stopping MySQL Automatically, How to Protect or Change the MySQL Socket File /tmp/mysql.sock
CHAR, Column Types, String Types
CHAR VARYING, Column Types
CHAR( ), String Functions
CHARACTER, Column Types
character sets, Typical configure Options, The Character Set Used for Data and Sorting
adding, Adding a New Character Set
CHARACTER VARYING, Column Types
character-sets-dir
mysql option, The Command-Line Tool
characters
multi-byte, Multi-Byte Character Support
CHARACTER_LENGTH( ), String Functions
CHAR_LENGTH( ), String Functions
check options
myisamchk, Check options for myisamchk
CHECK TABLE, CHECK TABLE Syntax
checking
tables for errors, How to check tables for errors
checksum errors, Solaris Notes
Chinese, Case Sensitivity in Searches
choosing
a MySQL version, Which MySQL Version to Use
choosing types, Choosing the Right Type for a Column
ChopBlanks DBI method, Portable DBI methods
clearing
caches, FLUSH Syntax
client programs
building, Building Client Programs
client tools, MySQL APIs
clients
debugging, Debugging a MySQL Client
threaded, How to Make a Threaded Client
closing
tables, How MySQL Opens and Closes Tables
COALESCE( ), Comparison operators
ColdFusion program, Programs Known to Work with MyODBC
collating
strings, String Collating Support
column names
case sensitivity, Case Sensitivity in Names
columns
changing, How to Change the Order of Columns in a Table
displaying, Showing Databases, Tables, and Columns
indexes, Column Indexes
names, Database, Table, Index, Column, and Alias Names
other types, Using Column Types from Other Database Engines
selecting, Selecting particular columns
storage requirements, Column Type Storage Requirements
types, Column Types
command syntax, Conventions Used in This Manual
command-line history, Overview of the Server-Side Scripts and Utilities, Overview of the Client-Side Scripts and Utilities
command-line options, mysqld Command-Line Options
mysql, The Command-Line Tool
command-line tool, The Command-Line Tool
commands
for binary distribution, Installing a MySQL Binary Distribution
list of, The Command-Line Tool
replication, SQL Commands Related to Replication
commands out of sync, Commands out of sync Error in Client
Comment syntax, Comment Syntax
comments
adding, Comment Syntax
starting, -- as the start of a comment
commercial support
types, Support Offered by MySQL AB
COMMIT, Transactions and atomic operations, BEGIN/COMMIT/ROLLBACK Syntax
communications protocols, How mSQL and MySQL client/server communications protocols differ
comparison operators, Comparison operators
comparisons
MySQL vs. others, How MySQL Compares to Other Databases
compatibility
between MySQL versions, Upgrading from Version 3.22 to Version 3.23, Upgrading from Version 3.21 to Version 3.22
with ANSI SQL, How Standards-Compatible Is MySQL?
with mSQL, String comparison functions
with ODBC, Database, Table, Index, Column, and Alias Names, Column Types, Comparison operators, JOIN syntax, CREATE TABLE Syntax
with Oracle, MySQL Extensions to ANSI SQL92, Functions for Use with GROUP BY Clauses, DESCRIBE Syntax (Get Information About Columns)
with PostgreSQL, MySQL Extensions to ANSI SQL92
with Sybase, USE Syntax
compiler
C++ gcc, Typical configure Options
compiling
on Windows, Compiling MySQL clients on Windows
optimising, System/Compile Time and Startup Parameter Tuning
problems, Problems Compiling?
speed, How Compiling and Linking Affects the Speed of MySQL
statically, Typical configure Options
user-defined functions, Compiling and installing user-definable functions
compliance
Y2K, Year 2000 Compliance
compress
mysql option, The Command-Line Tool
compressed tables, myisampack, the MySQL Compressed Read-Only Table Generator
CONCAT( ), String Functions
CONCAT_WS( ), String Functions
config.cache file, Problems Compiling?
configuration files, Causes of Access denied Errors
configuration options, Typical configure Options
configure option
--with-charset, Typical configure Options
--with-extra-charset, Typical configure Options
--with-low-memory, Problems Compiling?
configure script, Typical configure Options
connecting
remotely with SSH, Connecting to a remote MySQL from Windows with SSH
to the server, Connecting to and Disconnecting from the Server, Connecting to the MySQL server
verification, Access Control, Stage 1: Connection Verification
connection
aborted, Communication Error/ Aborted Connection
CONNECTION_ID( ), Miscellaneous functions
constant table, EXPLAIN Syntax (Get Information About a SELECT), How MySQL Optimises WHERE Clauses
consultants
list of, MySQL Portals
consulting, Consulting
contact information, Contact Information
Contrib directory, MySQL Portals
contributed programs, Contributed Programs
contributing companies
list of, Supporters to MySQL
contributors
list of, Contributors to MySQL
control access, Access Control, Stage 1: Connection Verification
control flow functions, Control flow functions
CONV( ), String Functions
CONVERT, Cast Functions
converting
tools, How to convert mSQL tools for MySQL
copyrights, Copyrights and Licenses Used by MySQL
COS( ), Mathematical functions
costs
support, Support Offered by MySQL AB
COT( ), Mathematical functions
COUNT(DISTINCT), Functions for Use with GROUP BY Clauses
counting
table rows, Counting rows
crackers
security against, How to Make MySQL Secure Against Crackers
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, Portability, The MySQL Benchmark Suite
CREATE DATABASE, CREATE DATABASE Syntax
CREATE FUNCTION, CREATE FUNCTION/DROP FUNCTION Syntax
CREATE INDEX, CREATE INDEX Syntax
CREATE TABLE, CREATE TABLE Syntax
creating
bug reports, How to report bugs or problems
databases, Creating and Using a Database
default startup options, my.cnf Option Files
tables, Creating a Table
CROSS JOIN, JOIN syntax
CURDATE( ), Date and Time Functions
CURRENT_DATE, Date and Time Functions
CURRENT_TIME, Date and Time Functions
CURRENT_TIMESTAMP, Date and Time Functions
CURTIME( ), Date and Time Functions
customer support
mailing address, How to report bugs or problems
customers
of MySQL, What Have We Used MySQL for?
cvs tree, Installing from the Development Source Tree
CXX environment variable, Typical configure Options, Problems Compiling?
CXXFLAGS environment variable, Typical configure Options, Problems Compiling?

D

data
character sets, The Character Set Used for Data and Sorting
importing, mysqlimport, Importing Data from Text Files
loading into tables, Loading Data into a Table
retrieving, Retrieving Information from a Table
size, Get Your Data as Small as Possible
database
mysql option, The Command-Line Tool
database design, Design Choices
database names
case sensitivity, MySQL Extensions to ANSI SQL92, Case Sensitivity in Names
databases
backups, Database Backups
creating, Creating and Using a Database
defined, What Is MySQL?
displaying, Showing Databases, Tables, and Columns
dumping, mysqldump, Dumping Table Structure and Data, mysqlhotcopy, Copying MySQL Databases and Tables
information about, Getting Information About Databases and Tables
MySQL vs. others, How MySQL Compares to Other Databases
names, Database, Table, Index, Column, and Alias Names
replicating, Replication in MySQL
selecting, Creating and Selecting a Database
symbolic links, Using symbolic links for tables
using, Creating and Using a Database
DataJunction, Programs Known to Work with MyODBC
datatypes
C API, MySQL C API
data_sources( ) DBI method, Portable DBI methods
DATE, Column Types, The DATETIME, DATE, and TIMESTAMP types, 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 functions
Y2K compliance, Year 2000 Compliance
date types, Storage requirements for numeric types
Y2K issues, Y2K issues and datetypes
date values
problems, The DATETIME, DATE, and TIMESTAMP types
DATETIME, Column 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
DAYNAME( ), Date and Time Functions
DAYOFMONTH( ), Date and Time Functions
DAYOFYEAR( ), Date and Time Functions
db table
sorting, Access Control, Stage 2: Request Verification
DBI interface, DBI with DBD::mysql
DBI->data_sources( ), Portable DBI methods
DBI->disconnect, Portable DBI methods
DBI->do( ), Portable DBI methods
DBI->execute, Portable DBI methods
DBI->fetchall_arrayref, Portable DBI methods
DBI->fetchrow_array, Portable DBI methods
DBI->fetchrow_arrayref, Portable DBI methods
DBI->fetchrow_hashref, Portable DBI methods
DBI->finish, Portable DBI methods
DBI->prepare( ), Portable DBI methods
DBI->quote, Strings
DBI->quote( ), Portable DBI methods
DBI->rows, Portable DBI methods
DBI->trace, Portable DBI methods, Debugging mysqld under gdb
DBI->{ChopBlanks}, Portable DBI methods
DBI->{is_blob}, MySQL-specific methods
DBI->{is_key}, MySQL-specific methods
DBI->{is_not_null}, MySQL-specific methods
DBI->{is_num}, MySQL-specific methods
DBI->{is_pri_key}, MySQL-specific methods
DBI->{length}, MySQL-specific methods
DBI->{max_length}, MySQL-specific methods
DBI->{NAME}, MySQL-specific methods
DBI->{NULLABLE}, Portable DBI methods
DBI->{NUM_OF_FIELDS}, Portable DBI methods
DBI->{table}, MySQL-specific methods
DBI->{type}, MySQL-specific methods
DBI/DBD, More DBI/DBD Information
DBI_TRACE environment variable, Portable DBI methods, Debugging mysqld under gdb
DBUG package, The DBUG Package
debug
mysql option, The Command-Line Tool
debug-info
mysql option, The Command-Line Tool
debugging
client, Debugging a MySQL Client
server, Debugging a MySQL Server
DEC, Column Types
DECIMAL, Column Types
DECODE( ), Miscellaneous functions
default
privileges, Setting Up the Initial MySQL Privileges
default hostname, Connecting to the MySQL server
default installation location, Installation Layouts
default options, my.cnf Option Files
default values, The Main Features of MySQL, INSERT Syntax, CREATE TABLE Syntax
BLOB and TEXT columns, The BLOB and TEXT types
suppression, Typical configure Options
default-character-set
mysql option, The Command-Line Tool
defaults
embedded, Using option files with the embedded server
DEGREES( ), Mathematical functions
DELAYED, INSERT DELAYED Syntax
delayed_insert_limit, INSERT DELAYED Syntax
DELETE, DELETE Syntax
deleting
rows, Deleting Rows from Related Tables
deletion
mysql.sock, How to Protect or Change the MySQL Socket File /tmp/mysql.sock
Delphi, APIs
Delphi program, Programs Known to Work with MyODBC
DESC, DESCRIBE Syntax (Get Information About Columns)
DESCRIBE, Getting Information About Databases and Tables, DESCRIBE Syntax (Get Information About Columns)
design
choices, Design Choices
issues, Known Errors and Design Deficiencies in MySQL
limitations, MySQL Design Limitations/Tradeoffs
DES_DECRYPT( ), Miscellaneous functions
DES_ENCRYPT( ), Miscellaneous functions
developers
list of, Credits
development source tree, Installing from the Development Source Tree
directory structure
default, Installation Layouts
disconnect DBI method, Portable DBI methods
disconnecting
from the server, Connecting to and Disconnecting from the Server
disk full, How MySQL Handles a Full Disk
disks
splitting data across, Splitting data across different disks on windows
displaying
database information, Showing Databases, Tables, and Columns
information, SHOW, Retrieving information about databases, tables, columns, and indexes
table status, SHOW TABLE STATUS
DISTINCT, Selecting particular columns, How MySQL Optimises DISTINCT, Functions for Use with GROUP BY Clauses
division (/), Arithmetic operations
DNS, How MySQL Uses DNS
DO, DO Syntax
do( ) DBI method, Portable DBI methods
DOUBLE, Column Types
DOUBLE PRECISION, Column Types
double quote (\”), Strings
downgrading, Upgrading/Downgrading MySQL
downloading, How to Get MySQL
DROP DATABASE, DROP DATABASE Syntax
DROP FUNCTION, CREATE FUNCTION/DROP FUNCTION Syntax
DROP INDEX, ALTER TABLE Syntax, DROP INDEX Syntax
DROP PRIMARY KEY, ALTER TABLE Syntax
DROP TABLE, DROP TABLE Syntax
DUMPFILE, SELECT Syntax
dumping
databases, mysqldump, Dumping Table Structure and Data, mysqlhotcopy, Copying MySQL Databases and Tables
dynamic table characteristics, Dynamic table characteristics

E

Eiffel Wrapper, MySQL Eiffel Wrapper
ELT( ), String Functions
email lists, The MySQL Mailing Lists
employment
contact information, Contact Information
employment with MySQL, Contact Information
enable-named-commands
mysql option, The Command-Line Tool
ENCODE( ), Miscellaneous functions
ENCRYPT( ), Miscellaneous functions
entering
queries, Entering Queries
ENUM, Column Types, The ENUM type
size, Storage requirements for string types
environment variable
CC, Typical configure Options, Problems Compiling?
CFLAGS, Problems Compiling?
CXX, Typical configure Options, Problems Compiling?
CXXFLAGS, Typical configure Options, Problems Compiling?
DBI_TRACE, Portable DBI methods
HOME, Overview of the Server-Side Scripts and Utilities, Overview of the Client-Side Scripts and Utilities
LD_RUN_PATH, Linux Notes (All Linux Versions)
MYSQL_HISTFILE, Overview of the Server-Side Scripts and Utilities, Overview of the Client-Side Scripts and Utilities
MYSQL_HOST, Connecting to the MySQL server
MYSQL_PWD, Connecting to the MySQL server
MYSQL_TCP_PORT, Installing Many Servers on the Same Machine, Running Multiple MySQL Servers on the Same Machine
MYSQL_UNIX_PORT, Installing Many Servers on the Same Machine, Running Multiple MySQL Servers on the Same Machine
PATH, Installing a MySQL Binary Distribution
USER, Connecting to the MySQL server
Environment variable
CXX, Problems Compiling?
DBI_TRACE, Debugging mysqld under gdb
LD_RUN_PATH, Solaris Notes, Problems Using the Perl DBI/DBD Interface
MYSQL_DEBUG, Debugging a MySQL Client
MYSQL_UNIX_PORT, Problems Running mysql_install_db
TMPDIR, Problems Running mysql_install_db
TZ, Time Zone Problems
UMASK, Problems with File Permissions
UMASK_DIR, Problems with File Permissions
Environment variables
CXX, Problems Compiling?
environment variables, my.cnf Option Files, Causes of Access denied Errors, Overview of the Server-Side Scripts and Utilities, Overview of the Client-Side Scripts and Utilities
list of, Environment Variables
Errcode, perror, Explaining Error Codes
errno, perror, Explaining Error Codes
error mesaages
can’t find file, Problems with File Permissions
error messages
displaying, perror, Explaining Error Codes
languages, Non-English Error Messages
errors
access denied, Access denied Error
checking tables for, How to check tables for errors
common, Problems and Common Errors
directory checksum, Solaris Notes
handling for UDFs, Return values and error handling
known, Known Errors and Design Deficiencies in MySQL
linking, Problems When Linking with the MySQL Client Library
list of, Common Errors When Using MySQL
reporting, MySQL Mailing Lists, How to report bugs or problems
escape (\\), Strings
estimating
query performance, Estimating Query Performance
example option, mysqld_multi, Program for Managing Multiple MySQL servers
examples
compressed tables, myisampack, the MySQL Compressed Read-Only Table Generator
myisamchk output, Getting Information About a Table
queries, Examples of Common Queries
Excel, Programs Known to Work with MyODBC
execute
mysql option, The Command-Line Tool
execute DBI method, Portable DBI methods
EXP( ), Mathematical functions
EXPLAIN, EXPLAIN Syntax (Get Information About a SELECT)
EXPORT_SET( ), String Functions
expression aliases, Functions for Use with GROUP BY Clauses, SELECT Syntax
expressions
extended, Pattern matching
extensions
to ANSI SQL, How Standards-Compatible Is MySQL?
EXTRACT( ), Date and Time Functions
extracting
dates, Date calculations

F

fatal signal 11, Problems Compiling?
features of MySQL, The Main Features of MySQL
fetchall_arrayref DBI method, Portable DBI methods
fetchrow_array DBI method, Portable DBI methods
fetchrow_arrayref DBI method, Portable DBI methods
fetchrow_hashref DBI method, Portable DBI methods
FIELD( ), String Functions
FILE, String Functions
files
binary log, The Binary Update Log
config.cache, Problems Compiling?
error messages, Non-English Error Messages
log, Typical configure Options, Log File Maintenance
not found message, Problems with File Permissions
permissions, Problems with File Permissions
query log, The General Query Log
repairing, Repair options for myisamchk
script, Using mysql in Batch Mode
size limits, How Big Can MySQL Tables Be?
slow query log, The Slow Query Log
text, mysqlimport, Importing Data from Text Files
tmp, Problems Running mysql_install_db
update log, The Update Log
files,my.cnf , Replication Features and Known Problems
FIND_IN_SET( ), String Functions
finish DBI method, Portable DBI methods
FLOAT, Column Types
FLOAT(M,D), Column Types
FLOAT(precision), Column Types
floating-point number, Column Types
floats, Numbers
FLOOR( ), Mathematical functions
FLUSH, FLUSH Syntax
flush tables, mysqladmin, Administrating a MySQL Server
force
mysql option, The Command-Line Tool
foreign keys, Foreign keys, Using Foreign Keys, ALTER TABLE Syntax
FORMAT( ), Miscellaneous functions
FOUND_ROWS( ), Miscellaneous functions
free licensing, Using the MySQL software for free under GPL
FreeBSD troubleshooting, Problems Compiling?
FROM_DAYS( ), Date and Time Functions
FROM_UNIXTIME( ), Date and Time Functions
full-text search, MySQL Full-Text Search
FULLTEXT, MySQL Full-Text Search
functions
arithmetic, Bit functions
bit, Bit functions
C API, C API Function Overview
control flow, Control flow functions
date and time, Date and Time Functions
GROUP BY, Functions for Use with GROUP BY Clauses
grouping, Parentheses
mathematical, Mathematical functions
miscellaneous, Miscellaneous functions
native, adding, Adding a New Native Function
new, Adding New Functions to MySQL
string, String Functions
string comparison, String comparison functions
user-definable, adding, Adding a New User-Definable Function
user-defined, Adding New Functions to MySQL
Functions
logical, Logical operators
user-defined, CREATE FUNCTION/DROP FUNCTION Syntax
functions for SELECT and WHERE clauses, Functions for Use in SELECT and WHERE Clauses

I

ID
unique, How can I get the unique ID for the last inserted row?
identifiers
quoting, Database, Table, Index, Column, and Alias Names
IF( ), Control flow functions
IGNORE INDEX, SELECT Syntax, JOIN syntax
IGNORE KEY, SELECT Syntax, JOIN syntax
ignore-space
mysql option, The Command-Line Tool
importing
data, mysqlimport, Importing Data from Text Files
IN, Comparison operators
increasing
performance, Replication FAQ
speed, Replication in MySQL
indexes, CREATE INDEX Syntax
and BLOB columns, CREATE TABLE Syntax
and IS NULL, How MySQL Uses Indexes
and LIKE, How MySQL Uses Indexes
and NULL values, CREATE TABLE Syntax
and TEXT columns, CREATE TABLE Syntax
block size, SHOW VARIABLES
columns, Column Indexes
leftmost prefix of, How MySQL Uses Indexes
multi-column, Multiple-Column Indexes
multi-part, CREATE INDEX Syntax
names, Database, Table, Index, Column, and Alias Names
use of, How MySQL Uses Indexes
INET_ATON( ), Miscellaneous functions
INET_NTOA( ), Miscellaneous functions
INNER JOIN, JOIN syntax
InnoDB table type, MySQL Table Types
InnoDB tables, Transactions and atomic operations
INSERT, Speed of INSERT Queries, INSERT Syntax
INSERT DELAYED, INSERT DELAYED Syntax
INSERT statement
grant privileges, Adding New Users to MySQL
INSERT( ), String Functions
inserting
speed of, Speed of INSERT Queries
installation layouts, Installation Layouts
installation overview, Installing a MySQL Source Distribution
installing
binary distribution, Installing a MySQL Binary Distribution
overview, MySQL Installation
Perl on Windows, Installing ActiveState Perl on Windows
source distribution, Installing a MySQL Source Distribution
user-defined functions, Compiling and installing user-definable functions
Installing many servers, Installing Many Servers on the Same Machine
INSTR( ), String Functions
INT, Column Types
INTEGER, Column Types
integers, Numbers
internal compiler errors, Problems Compiling?
internal locking, How MySQL Locks Tables
internals, MySQL Internals
Internet Service Providers, Using the MySQL software for free under GPL
INTERVAL( ), Comparison operators
IS NOT NULL, Comparison operators
IS NULL, Comparison operators
and indexes, How MySQL Uses Indexes
ISAM table type, MySQL Table Types
ISNULL( ), Comparison operators
ISOLATION LEVEL, SET TRANSACTION Syntax
ISP services, Using the MySQL software for free under GPL
is_blob DBI method, MySQL-specific methods
is_key DBI method, MySQL-specific methods
is_not_null DBI method, MySQL-specific methods
is_num DBI method, MySQL-specific methods
is_pri_key DBI method, MySQL-specific methods

L

language support, Non-English Error Messages
last row
unique ID, How can I get the unique ID for the last inserted row?
LAST_INSERT_ID( ), Transactions and atomic operations
LAST_INSERT_ID([expr]), Miscellaneous functions
layout of installation, Installation Layouts
LCASE( ), String Functions
LD_RUN_PATH environment variable, Linux Notes (All Linux Versions), Solaris Notes, Problems Using the Perl DBI/DBD Interface
LEAST( ), Mathematical functions
LEFT JOIN, How MySQL Optimises LEFT JOIN and RIGHT JOIN, JOIN syntax
LEFT OUTER JOIN, JOIN syntax
LEFT( ), String Functions
leftmost prefix of indexes, How MySQL Uses Indexes
legal names, Database, Table, Index, Column, and Alias Names
length DBI method, MySQL-specific methods
LENGTH( ), String Functions
less than (<), Comparison operators
less than or equal (<=), Comparison operators
library
mysqlclient, MySQL APIs
licenses, Copyrights and Licenses Used by MySQL
licensing
contact information, Contact Information
examples, MySQL Licenses
free, Using the MySQL software for free under GPL
licensing costs, Support Offered by MySQL AB
licensing policy, MySQL Licenses
licensing terms, MySQL Support and Licensing
LIKE
and indexes, How MySQL Uses Indexes
and wildcards, How MySQL Uses Indexes
LIMIT, How MySQL Optimises LIMIT, Miscellaneous functions
limitations
design, MySQL Design Limitations/Tradeoffs
limits
file-size, How Big Can MySQL Tables Be?
linking, Building Client Programs
errors, Problems When Linking with the MySQL Client Library
problems, Problems linking with the C API
speed, How Compiling and Linking Affects the Speed of MySQL
links
symbolic, Using Symbolic Links
Linux
binary distribution, Linux notes for binary distributions
LOAD DATA INFILE, LOAD DATA INFILE Syntax, Problems with NULL Values
loading
tables, Loading Data into a Table
LOAD_FILE( ), String Functions
LOCATE( ), String Functions
LOCK TABLES, LOCK TABLES/UNLOCK TABLES Syntax
locking, System/Compile Time and Startup Parameter Tuning
row-level, Transactions and atomic operations
tables, How MySQL Locks Tables
locking methods, Locking Methods
log files, Typical configure Options
maintaining, Log File Maintenance
names, Database Backups
Log files, The MySQL Log Files
log option, mysqld_multi, Program for Managing Multiple MySQL servers
LOG( ), Mathematical functions
LOG10( ), Mathematical functions
Logical functions, Logical operators
logos, MySQL AB Logos and Trademarks
LONGBLOB, Column Types
LONGTEXT, Column Types
LOWER( ), String Functions
LPAD( ), String Functions
LTRIM( ), String Functions

M

magazines
online, MySQL Portals
mailing address
for customer support, How to report bugs or problems
mailing lists, The MySQL Mailing Lists
archive location, Asking questions or reporting bugs
guidelines, Guidelines for answering questions on the mailing list
main features of MySQL, The Main Features of MySQL
maintaining
log files, Log File Maintenance
tables, Setting Up a Table Maintenance Regimen
make_binary_distribution, Overview of the Server-Side Scripts and Utilities, Overview of the Client-Side Scripts and Utilities
MAKE_SET( ), String Functions
manual
available formats, About This Manual
online location, About This Manual
manuals
about MySQL, MySQL Portals
master-slave setup, Replication Implementation Overview
MASTER_POS_WAIT( ), Miscellaneous functions
MATCH ... AGAINST( ), String comparison functions
matching
patterns, Pattern matching
mathematical functions, Mathematical functions
max memory used, mysqladmin, Administrating a MySQL Server
MAX( ), Functions for Use with GROUP BY Clauses
max_length DBI method, MySQL-specific methods
MD5( ), Miscellaneous functions
MEDIUMBLOB, Column Types
MEDIUMINT, Column Types
MEDIUMTEXT, Column Types
memory usage
myisamchk, myisamchk memory usage
memory use, mysqladmin, Administrating a MySQL Server, How MySQL Uses Memory
MERGE table type, MySQL Table Types
MERGE tables
defined, MERGE Tables
messages
languages, Non-English Error Messages
methods
locking, Locking Methods
MID( ), String Functions
MIN( ), Functions for Use with GROUP BY Clauses
MINUTE( ), Date and Time Functions
mirror sites, How to Get MySQL
miscellaneous functions, Miscellaneous functions
MIT-pthreads, MIT-pthreads Notes
MOD( ), Mathematical functions
modes
batch, Using mysql in Batch Mode
modulo (%), Mathematical functions
monitor
terminal, Tutorial Introduction
MONTH( ), Date and Time Functions
MONTHNAME( ), Date and Time Functions
mSQL compatibility, String comparison functions
mSQL vs. MySQL
protocol, How mSQL and MySQL client/server communications protocols differ
msql2mysql, Overview of the Server-Side Scripts and Utilities, Overview of the Client-Side Scripts and Utilities
multi mysqld, mysqld_multi, Program for Managing Multiple MySQL servers
multi-byte characters, Multi-Byte Character Support
multi-column indexes, Multiple-Column Indexes
multi-part index, CREATE INDEX Syntax
multibyte character sets, Can't initialize character set xxx error
multiple servers, Running Multiple MySQL Servers on the Same Machine
multiplication (*), Arithmetic operations
My
derivation, History of MySQL
.my.cnf file, MySQL-Windows compared to Unix MySQL, my.cnf Option Files, Running Multiple MySQL Servers on the Same Machine, Connecting to the MySQL server, Causes of Access denied Errors, Keeping Your Password Secure
my.cnf file, Replication Features and Known Problems
MyISAM
compressed tables, myisampack, the MySQL Compressed Read-Only Table Generator
MyISAM table type, MySQL Table Types
myisamchk, Typical configure Options
example output, Getting Information About a Table
options, General options for myisamchk
myisampack, myisampack, the MySQL Compressed Read-Only Table Generator, Silent column specification changes
MyODBC, MySQL ODBC Support
reporting problems, Reporting Problems with MyODBC
mysladmn, mysqladmin, Administrating a MySQL Server
MySQL
defined, What Is MySQL?
introduction, What Is MySQL?
pronunciation, What Is MySQL?
mysql, The Command-Line Tool
MySQL AB
defined, What Is MySQL AB?
MySQL binary distribution, Which MySQL Version to Use
MySQL certification, Training and certification
mysql command-line options, The Command-Line Tool
MySQL consulting, Consulting
MySQL history, History of MySQL
MySQL mailing lists, MySQL Mailing Lists
MySQL name, History of MySQL
MySQL Portals, MySQL Portals
MySQL related information URLs, MySQL Portals
MySQL source distribution, Which MySQL Version to Use
MySQL table types, MySQL Table Types
MySQL Testimonials, MySQL Portals
MySQL tools
conversion, How to convert mSQL tools for MySQL
MySQL training, Training and certification
MySQL version, How to Get MySQL
mysql.sock
changing location of, Typical configure Options
protection, How to Protect or Change the MySQL Socket File /tmp/mysql.sock
mysqlaccess, Overview of the Server-Side Scripts and Utilities, Overview of the Client-Side Scripts and Utilities
mysqladmin, FLUSH Syntax, KILL Syntax, SHOW STATUS, Overview of the Server-Side Scripts and Utilities, Overview of the Client-Side Scripts and Utilities, CREATE DATABASE Syntax, DROP DATABASE Syntax
mysqladmin option, mysqld_multi, Program for Managing Multiple MySQL servers
mysqlbug, Overview of the Server-Side Scripts and Utilities, Overview of the Client-Side Scripts and Utilities
mysqlbug script, How to report bugs or problems
mysqlclient library, MySQL APIs
mysqld, Overview of the Server-Side Scripts and Utilities, Overview of the Client-Side Scripts and Utilities
starting, How to Run MySQL as a Normal User
mysqld option, mysqld_multi, Program for Managing Multiple MySQL servers
mysqld options, mysqld Command-Line Options, Tuning Server Parameters
mysqld server
buffer sizes, Tuning Server Parameters
mysqld-max, mysqld-max, an Extended mysqld Server
mysqldump, Upgrading to Another Architecture, Overview of the Server-Side Scripts and Utilities, Overview of the Client-Side Scripts and Utilities, mysqldump, Dumping Table Structure and Data
mysqld_multi, mysqld_multi, Program for Managing Multiple MySQL servers
mysqlimport, Upgrading to Another Architecture, Overview of the Server-Side Scripts and Utilities, Overview of the Client-Side Scripts and Utilities, mysqlimport, Importing Data from Text Files, LOAD DATA INFILE Syntax
mysqlshow, Overview of the Server-Side Scripts and Utilities, Overview of the Client-Side Scripts and Utilities
mysqltest
MySQL Test Suite, MySQL Test Suite
mysql_affected_rows( ), mysql_affected_rows( )
mysql_change_user( ), mysql_change_user( )
mysql_character_set_name( ), mysql_character_set_name( )
mysql_close( ), mysql_close( )
mysql_connect( ), mysql_connect( )
mysql_create_db( ), mysql_create_db( )
mysql_data_seek( ), mysql_data_seek( )
MYSQL_DEBUG environment variable, Debugging a MySQL Client
mysql_debug( ), mysql_debug( )
mysql_drop_db( ), mysql_drop_db( )
mysql_dump_debug_info( ), mysql_dump_debug_info( )
mysql_eof( ), mysql_eof( )
mysql_errno( ), mysql_errno( )
mysql_error( ), mysql_error( )
mysql_escape_string( ), mysql_escape_string( )
mysql_fetch_field( ), mysql_fetch_field( )
mysql_fetch_fields( ), mysql_fetch_fields( )
mysql_fetch_field_direct( ), mysql_fetch_field_direct( )
mysql_fetch_lengths( ), mysql_fetch_lengths( )
mysql_fetch_row( ), mysql_fetch_row( )
MYSQL_FIELD C type, C API Datatypes
mysql_field_count( ), mysql_field_count( ), mysql_num_fields( )
MYSQL_FIELD_OFFSET C type, C API Datatypes
mysql_field_seek( ), mysql_field_seek( )
mysql_field_tell( ), mysql_field_tell( )
mysql_fix_privilege_tables, Causes of Access denied Errors
mysql_free_result( ), mysql_free_result( )
mysql_get_client_info( ), mysql_get_client_info( )
mysql_get_host_info( ), mysql_get_host_info( )
mysql_get_proto_info( ), mysql_get_proto_info( )
mysql_get_server_info( ), mysql_get_server_info( )
MYSQL_HISTFILE environment variable, Overview of the Server-Side Scripts and Utilities, Overview of the Client-Side Scripts and Utilities
.mysql_history file, Overview of the Server-Side Scripts and Utilities, Overview of the Client-Side Scripts and Utilities
MYSQL_HOST environment variable, Connecting to the MySQL server
mysql_info( ), INSERT Syntax, UPDATE Syntax, LOAD DATA INFILE Syntax, ALTER TABLE Syntax, mysql_info( )
mysql_init( ), mysql_init( )
mysql_insert_id( ), Transactions and atomic operations, mysql_insert_id( )
mysql_install_db, Overview of the Server-Side Scripts and Utilities, Overview of the Client-Side Scripts and Utilities
mysql_install_db script, Problems Running mysql_install_db
mysql_kill( ), mysql_kill( )
mysql_list_dbs( ), mysql_list_dbs( )
mysql_list_fields( ), mysql_list_fields( )
mysql_list_processes( ), mysql_list_processes( )
mysql_list_tables( ), mysql_list_tables( )
mysql_num_fields( ), mysql_num_fields( )
mysql_num_rows( ), mysql_num_rows( )
mysql_options( ), mysql_options( )
mysql_ping( ), mysql_ping( )
MYSQL_PWD environment variable, Connecting to the MySQL server
mysql_query( ), mysql_query( )
mysql_real_connect( ), mysql_real_connect( )
mysql_real_escape_string( ), Strings, mysql_real_escape_string( )
mysql_real_query( ), mysql_real_query( )
mysql_reload( ), mysql_reload( )
MYSQL_RES C type, C API Datatypes
MYSQL_ROW C type, C API Datatypes
mysql_row_seek( ), mysql_row_seek( )
mysql_row_tell( ), mysql_row_tell( )
mysql_select_db( ), mysql_select_db( )
mysql_server_end( ), mysql_server_end( )
mysql_server_init( ), mysql_server_init( )
mysql_shutdown( ), mysql_shutdown( )
mysql_stat( ), mysql_stat( )
mysql_store_result( ), mysql_store_result( )
MYSQL_TCP_PORT environment variable, Installing Many Servers on the Same Machine, Running Multiple MySQL Servers on the Same Machine
mysql_thread_end( ), mysql_thread_end( )
mysql_thread_id( ), mysql_thread_id( )
mysql_thread_init( ), mysql_thread_init( )
mysql_thread_safe( ), mysql_thread_safe( )
MYSQL_UNIX_PORT environment variable, Problems Running mysql_install_db, Installing Many Servers on the Same Machine, Running Multiple MySQL Servers on the Same Machine
mysql_use_result( ), mysql_use_result( )
my_init( ), my_init( )
my_ulonglong C type, C API Datatypes
my_ulonglong values
printing, C API Datatypes

N

NAME DBI method, MySQL-specific methods
named pipes, Running MySQL on Windows
names, Database, Table, Index, Column, and Alias Names
case-sensitivity, Case Sensitivity in Names
variables, User Variables
naming
releases of MySQL, Which MySQL Version to Use
NATIONAL CHAR, Column Types
native functions
adding, Adding a New Native Function
native thread support, Operating Systems Supported by MySQL
NATURAL LEFT JOIN, JOIN syntax
NATURAL LEFT OUTER JOIN, JOIN syntax
NATURAL RIGHT JOIN, JOIN syntax
NATURAL RIGHT OUTER JOIN, JOIN syntax
NCHAR, Column Types
negative values, Numbers
net etiquette, Asking questions or reporting bugs, Guidelines for answering questions on the mailing list
netmask notation
in mysql.user table, Access Control, Stage 1: Connection Verification
new procedures
adding, Adding New Procedures to MySQL
new users
adding, Installing a MySQL Binary Distribution
newline (\n), Strings
news sites, MySQL Portals
no matching rows, Solving Problems with No Matching Rows
no-auto-rehash
mysql option, The Command-Line Tool
no-log option, mysqld_multi, Program for Managing Multiple MySQL servers
no-named-commands
mysql option, The Command-Line Tool
no-pager
mysql option, The Command-Line Tool
no-tee
mysql option, The Command-Line Tool
non-delimited strings, The DATETIME, DATE, and TIMESTAMP types
Non-transactional tables, Some non-transactional changed tables couldn't be rolled back Error
NOT BETWEEN, Comparison operators
not equal (!=), Comparison operators
not equal (<>), Comparison operators
NOT IN, Comparison operators
NOT LIKE, String comparison functions
NOT REGEXP, String comparison functions
NOW( ), Date and Time Functions
NULL, Working with NULL values, Problems with NULL Values
testing for null, Comparison operators
NULL value, Working with NULL values, NULL values
NULL values
and AUTO_INCREMENT columns, Problems with NULL Values
and indexes, CREATE TABLE Syntax
and TIMESTAMP columns, Problems with NULL Values
vs. empty values, Problems with NULL Values
NULLABLE DBI method, Portable DBI methods
NULLIF( ), Control flow functions
numbers, Numbers
NUMERIC, Column Types
NUM_OF_FIELDS DBI method, Portable DBI methods

O

OCT( ), String Functions
OCTET_LENGTH( ), String Functions
ODBC, MySQL ODBC Support
administrator, How to Fill in the Various Fields in the ODBC Administrator Program
ODBC compatibility, Database, Table, Index, Column, and Alias Names, Column Types, Comparison operators, JOIN syntax, CREATE TABLE Syntax
odbcadmin program, Programs Known to Work with MyODBC
OLEDB, APIs
one-database
mysql option, The Command-Line Tool
online location of manual, About This Manual
online magazines, MySQL Portals
open source
defined, What Is MySQL?
open tables, mysqladmin, Administrating a MySQL Server, Why So Many Open tables?
opening
tables, How MySQL Opens and Closes Tables
opens, mysqladmin, Administrating a MySQL Server
operating systems
file-size limits, How Big Can MySQL Tables Be?
supported, Operating Systems Supported by MySQL
Windows versus Unix, MySQL-Windows compared to Unix MySQL
operations
arithmetic, Arithmetic operations
operators
cast, Case sensitivity, Arithmetic operations
optimisation
tips, Other Optimisation Tips
optimisations, How MySQL Optimises WHERE Clauses
optimising
DISTINCT, How MySQL Optimises DISTINCT
LEFT JOIN, How MySQL Optimises LEFT JOIN and RIGHT JOIN
LIMIT, How MySQL Optimises LIMIT
tables, Table optimisation
OPTIMIZE TABLE, OPTIMIZE TABLE Syntax
option files, my.cnf Option Files
options
command-line, mysqld Command-Line Options
command-line, mysql, The Command-Line Tool
configure, Typical configure Options
myisamchk, General options for myisamchk
provided by MySQL, Tutorial Introduction
replication, Replication Features and Known Problems
OR
logical, Logical operators
Oracle compatibility, MySQL Extensions to ANSI SQL92, Functions for Use with GROUP BY Clauses, DESCRIBE Syntax (Get Information About Columns)
ORD( ), String Functions
ORDER BY, ALTER TABLE Syntax
aliases in, Functions for Use with GROUP BY Clauses
overview, General Information

P

-p option, Keeping Your Password Secure
pack_isam, myisampack, the MySQL Compressed Read-Only Table Generator
pager
mysql option, The Command-Line Tool
parameters
server, Tuning Server Parameters
parentheses ( and ), Parentheses
partnering with MySQL AB, Partnering
password
mysql option, The Command-Line Tool
root user, Setting Up the Initial MySQL Privileges
password encryption
reversibility of, Miscellaneous functions
password option, mysqld_multi, Program for Managing Multiple MySQL servers
PASSWORD( ), Access Control, Stage 1: Connection Verification, Setting Up Passwords, Miscellaneous functions, Ignoring user Error
passwords
for users, MySQL Usernames and Passwords
forgotten, How to Reset a Forgotten Password
resetting, How to Reset a Forgotten Password
security, What the Privilege System Does
setting, GRANT and REVOKE Syntax, Setting Up Passwords, SET Syntax
patches
applying, Applying Patches
PATH environment variable, Installing a MySQL Binary Distribution
pattern matching, Pattern matching
performance
benchmarks, Using Your Own Benchmarks
estimating, Estimating Query Performance
improving, Replication FAQ, Get Your Data as Small as Possible
PERIOD_ADD( ), Date and Time Functions
PERIOD_DIFF( ), Date and Time Functions
Perl
installing on Windows, Installing ActiveState Perl on Windows
Perl API, MySQL Perl API
Perl DBI/DBD
installation problems, Problems Using the Perl DBI/DBD Interface
permission checks
effect on speed, Optimising SELECTs and Other Queries
perror, perror, Explaining Error Codes
PHP
web sites, MySQL Portals
PHP API, MySQL PHP API
PI( ), Mathematical functions
.pid (process ID) file, Setting Up a Table Maintenance Regimen
port
mysql option, The Command-Line Tool
portability, Portability
types, Using Column Types from Other Database Engines
porting
to other systems, Porting to Other Systems
POSITION( ), String Functions
post-install
many servers, Installing Many Servers on the Same Machine
post-installation
setup and testing, Post-Installation Setup and Testing
PostgreSQL compatibility, MySQL Extensions to ANSI SQL92
PostgreSQL vs. MySQL
benchmarks, Benchmarking MySQL and PostgreSQL
features, Featurewise comparison of MySQL and PostgreSQL
overview, How MySQL Compares to PostgreSQL
strategies, MySQL and PostgreSQL development strategies
POW( ), Mathematical functions
POWER( ), Mathematical functions
prepare( ) DBI method, Portable DBI methods
prices
support, Support Offered by MySQL AB
PRIMARY KEY, CREATE TABLE Syntax, ALTER TABLE Syntax
privilege
changes, Access Control, Stage 2: Request Verification
privilege information
location, Privileges Provided by MySQL
privilege system, What the Privilege System Does
described, How the Privilege System Works
privileges
access, General Security Issues and the MySQL Access Privilege System
adding, Adding New Users to MySQL
default, Setting Up the Initial MySQL Privileges
display, SHOW GRANTS FOR
granting, GRANT and REVOKE Syntax
revoking, GRANT and REVOKE Syntax
problems
access denied errors, Access denied Error
common errors, Problems and Common Errors
compiling, Problems Compiling?
DATE columns, Problems Using DATE Columns
date values, The DATETIME, DATE, and TIMESTAMP types
installing on IBM-AIX, IBM-AIX notes
installing on Solaris, Solaris Notes
installing Perl, Problems Using the Perl DBI/DBD Interface
linking, Problems When Linking with the MySQL Client Library
ODBC, Reporting Problems with MyODBC
reporting, How to report bugs or problems
starting the server, Problems Starting the MySQL server
table locking, Table Locking Issues
timezone, Time Zone Problems
procedures
adding, Adding New Procedures to MySQL
stored, Stored procedures and triggers
process support, Operating Systems Supported by MySQL
processes
display, SHOW PROCESSLIST
processing
arguments, Argument processing
PROCESSLIST, SHOW PROCESSLIST
products
selling, MySQL Licenses
programs
client, Building Client Programs
contributed, Contributed Programs
crash-me, Portability
list of, Overview of the Server-Side Scripts and Utilities, Overview of the Client-Side Scripts and Utilities
pronunciation
MySQL, What Is MySQL?
Protocol mismatch, Upgrading from Version 3.20 to Version 3.21
Python APIs, MySQL Python APIs

R

RADIANS( ), Mathematical functions
RAND( ), Mathematical functions
raw
mysql option, The Command-Line Tool
re-creating
grant tables, Setting Up the Initial MySQL Privileges
REAL, Column Types
reconfiguring, Problems Compiling?
recovery
from crash, Using myisamchk for crash recovery
RedHat Package Manager, Installing MySQL on Linux, Installing a MySQL Binary Distribution
reducing
data size, Get Your Data as Small as Possible
references, ALTER TABLE Syntax
regex, MySQL Regular Expressions
REGEXP, String comparison functions
regular expression syntax
described, MySQL Regular Expressions
relational databases
defined, What Is MySQL?
release numbers, Which MySQL Version to Use
releases
naming scheme, Which MySQL Version to Use
testing, Which MySQL Version to Use
updating, How and When Updates Are Released
RELEASE_LOCK( ), Miscellaneous functions
RENAME TABLE, RENAME TABLE Syntax
reordering
columns, How to Change the Order of Columns in a Table
repair options
myisamchk, Repair options for myisamchk
REPAIR TABLE, REPAIR TABLE Syntax
repairing
tables, How to repair tables
REPEAT( ), String Functions
replace, Overview of the Server-Side Scripts and Utilities, Overview of the Client-Side Scripts and Utilities
REPLACE, REPLACE Syntax
REPLACE( ), String Functions
replication, Replication in MySQL
commands, SQL Commands Related to Replication
two-way, Replication FAQ
reporting
bugs, How to report bugs or problems
errors, MySQL Mailing Lists
MyODBC problems, Reporting Problems with MyODBC
REQUIRE GRANT option, GRANT options
reserved words
exceptions, Is MySQL Picky About Reserved Words?
restarting
the server, Post-Installation Setup and Testing
RESTORE TABLE, RESTORE TABLE Syntax
retrieving
data from tables, Retrieving Information from a Table
return (\r), Strings
return values
UDFs, Return values and error handling
REVERSE( ), String Functions
REVOKE, GRANT and REVOKE Syntax
revoking
privleges, GRANT and REVOKE Syntax
RIGHT JOIN, JOIN syntax
RIGHT OUTER JOIN, JOIN syntax
RIGHT( ), String Functions
RLIKE, String comparison functions
ROLLBACK, Transactions and atomic operations, BEGIN/COMMIT/ROLLBACK Syntax
root password, Setting Up the Initial MySQL Privileges
root user
password resetting, How to Reset a Forgotten Password
ROUND( ), Mathematical functions
rounding errors, Column Types, Mathematical functions
rows
counting, Counting rows
deleting, Deleting Rows from Related Tables
locking, Transactions and atomic operations
matching problems, Solving Problems with No Matching Rows
selecting, Selecting particular rows
sorting, Sorting rows
rows DBI method, Portable DBI methods
RPAD( ), String Functions
RPM
defined, Installing a MySQL Binary Distribution
RPM file, Installing MySQL on Linux
RTRIM( ), String Functions
RTS-threads, Comments About RTS Threads
running
ANSI mode, Running MySQL in ANSI Mode
batch mode, Using mysql in Batch Mode
multiple servers, Running Multiple MySQL Servers on the Same Machine
queries, Entering Queries
running a web server, Using the MySQL software for free under GPL

S

safe-mode command, The Command-Line Tool
safe-updates
mysql option, The Command-Line Tool
safe_mysqld, safe_mysqld, the Wrapper Around mysqld
script files, Using mysql in Batch Mode
scripts, safe_mysqld, the Wrapper Around mysqld, mysqld_multi, Program for Managing Multiple MySQL servers, The Command-Line Tool
mysqlbug, How to report bugs or problems
mysql_install_db, Problems Running mysql_install_db
search engines
web, MySQL Portals
searching
and case-sensitivity, Case Sensitivity in Searches
full-text, MySQL Full-Text Search
MySQL web pages, Asking questions or reporting bugs
two keys, Searching on Two Keys
SECOND( ), Date and Time Functions
security
against crackers, How to Make MySQL Secure Against Crackers
security system, General Security Issues and the MySQL Access Privilege System
SEC_TO_TIME( ), Date and Time Functions
SELECT, SELECT Syntax
optimising, EXPLAIN Syntax (Get Information About a SELECT)
Query Cache, MySQL Query Cache
SELECT INTO TABLE, SELECT INTO TABLE
SELECT speed, Speed of SELECT Queries
selecting
databases, Creating and Selecting a Database
selling products, MySQL Licenses
sequence emulation, Miscellaneous functions
server
connecting, Connecting to and Disconnecting from the Server, Connecting to the MySQL server
debugging, Debugging a MySQL Server
disconnecting, Connecting to and Disconnecting from the Server
restart, Post-Installation Setup and Testing
shutdown, Post-Installation Setup and Testing
starting, Post-Installation Setup and Testing
starting and stopping, Starting and Stopping MySQL Automatically
starting problems, Problems Starting the MySQL server
server administration, mysqladmin, Administrating a MySQL Server
servers
multiple, Running Multiple MySQL Servers on the Same Machine
services, MySQL Portals
ISP, Using the MySQL software for free under GPL
web, Using the MySQL software for free under GPL
SESSION_USER( ), Miscellaneous functions
SET, Column Types, The SET type
size, Storage requirements for string types
SET OPTION, SET Syntax
SET PASSWORD statement, Setting Up Passwords
SET TRANSACTION, SET TRANSACTION Syntax
set-variable
mysql option, The Command-Line Tool
setting
passwords, Setting Up Passwords
setup
post-installation, Post-Installation Setup and Testing
shell syntax, Conventions Used in This Manual
SHOW COLUMNS, SHOW Syntax
SHOW CREATE TABLE, SHOW Syntax
SHOW DATABASE INFO, SHOW Syntax
SHOW DATABASES, SHOW Syntax
SHOW FIELDS, SHOW Syntax
SHOW GRANTS, SHOW Syntax
SHOW INDEX, SHOW Syntax
SHOW KEYS, SHOW Syntax
SHOW MASTER LOGS, SHOW Syntax
SHOW MASTER STATUS, SHOW Syntax
SHOW PROCESSLIST, SHOW Syntax
SHOW SLAVE STATUS, SHOW Syntax
SHOW STATUS, SHOW Syntax
SHOW TABLE STATUS, SHOW Syntax
SHOW TABLES, SHOW Syntax
SHOW VARIABLES, SHOW Syntax
showing
database information, Showing Databases, Tables, and Columns
shutting down
the server, Post-Installation Setup and Testing
SIGN( ), Mathematical functions
silent
mysql option, The Command-Line Tool
silent column changes, Silent column specification changes
SIN( ), Mathematical functions
single quote (\'), Strings
size of tables, How Big Can MySQL Tables Be?
skip-column-names
mysql option, The Command-Line Tool
skip-line-numbers
mysql option, The Command-Line Tool
slow queries, mysqladmin, Administrating a MySQL Server
slow query log, The Slow Query Log
SMALLINT, Column Types
socket
mysql option, The Command-Line Tool
socket location
changing, Typical configure Options
Solaris installation problems, Solaris Notes
Solaris troubleshooting, Problems Compiling?
sorting
character sets, The Character Set Used for Data and Sorting
data, Sorting rows
grant tables, Access Control, Stage 1: Connection Verification, Access Control, Stage 2: Request Verification
table rows, Sorting rows
SOUNDEX( ), String Functions
source distribution
installing, Installing a MySQL Source Distribution
SPACE( ), String Functions
speed
compiling, How Compiling and Linking Affects the Speed of MySQL
increasing, Replication in MySQL
inserting, Speed of INSERT Queries
linking, How Compiling and Linking Affects the Speed of MySQL
of queries, Optimising SELECTs and Other Queries, Speed of SELECT Queries
SQL
defined, What Is MySQL?
SQL commands
replication, SQL Commands Related to Replication
sql_yacc.cc problems, Problems Compiling?
SQRT( ), Mathematical functions
SSH, Connecting to a remote MySQL from Windows with SSH
SSL related options, GRANT options
stability, How Stable Is MySQL?
standards compatibility, How Standards-Compatible Is MySQL?
starting
comments, -- as the start of a comment
mysqld, How to Run MySQL as a Normal User
the server, Post-Installation Setup and Testing
the server automatically, Starting and Stopping MySQL Automatically
Starting many servers, Installing Many Servers on the Same Machine
startup options
default, my.cnf Option Files
startup parameters, Tuning Server Parameters
mysql, The Command-Line Tool
tuning, System/Compile Time and Startup Parameter Tuning
statements
GRANT, Adding New Users to MySQL
INSERT, Adding New Users to MySQL
statically
compiling, Typical configure Options
status
tables, SHOW TABLE STATUS
status command, The Command-Line Tool
results, mysqladmin, Administrating a MySQL Server
STD( ), Functions for Use with GROUP BY Clauses
STDDEV( ), Functions for Use with GROUP BY Clauses
stopping
the server, Starting and Stopping MySQL Automatically
storage of data, Design Choices
storage requirements
column type, Column Type Storage Requirements
storage space
minimising, Get Your Data as Small as Possible
stored procedures and triggers
defined, Stored procedures and triggers
STRAIGHT_JOIN, JOIN syntax
STRCMP( ), String comparison functions
string collating, String Collating Support
string comparison functions, String comparison functions
string comparisons
case sensitivity, String comparison functions
string functions, String Functions
string types, String Types
strings
non-delimited, The DATETIME, DATE, and TIMESTAMP types
quoting, Portable DBI methods
striping
defined, Disk Issues
sub-selects, Sub-SELECTs
SUBDATE( ), Date and Time Functions
SUBSTRING( ), String Functions
SUBSTRING_INDEX( ), String Functions
subtraction (-), Arithmetic operations
SUM( ), Functions for Use with GROUP BY Clauses
superuser, Setting Up the Initial MySQL Privileges
support
for operating systems, Operating Systems Supported by MySQL
licensing, MySQL Licenses
mailing address, How to report bugs or problems
types, Support Offered by MySQL AB
support costs, Support Offered by MySQL AB
support terms, MySQL Support and Licensing
suppression
default values, Typical configure Options
Sybase compatibility, USE Syntax
symbolic links, Splitting data across different disks on windows, Using Symbolic Links
syntax
regular expression, MySQL Regular Expressions
SYSDATE( ), Date and Time Functions
system
privilege, What the Privilege System Does
security, General Security Issues and the MySQL Access Privilege System
system optimisation, System/Compile Time and Startup Parameter Tuning
SYSTEM_USER( ), Miscellaneous functions

T

tab (\t), Strings
table
mysql option, The Command-Line Tool
table aliases, SELECT Syntax
table cache, How MySQL Opens and Closes Tables
table DBI method, MySQL-specific methods
table is full, SET Syntax, The table is full Error
table names
case sensitivity, MySQL Extensions to ANSI SQL92, Case Sensitivity in Names
table types
choosing, MySQL Table Types
tables
changing column order, How to Change the Order of Columns in a Table
checking, Check options for myisamchk
closing, How MySQL Opens and Closes Tables
compressed, myisampack, the MySQL Compressed Read-Only Table Generator
compressed format, Compressed table characteristics
constant, EXPLAIN Syntax (Get Information About a SELECT), How MySQL Optimises WHERE Clauses
counting rows, Counting rows
creating, Creating a Table
defragment, Setting Up a Table Maintenance Regimen, Dynamic table characteristics
defragmenting, OPTIMIZE TABLE Syntax
deleting rows, Deleting Rows from Related Tables
displaying, Showing Databases, Tables, and Columns
displaying status, SHOW TABLE STATUS
dumping, mysqldump, Dumping Table Structure and Data, mysqlhotcopy, Copying MySQL Databases and Tables
dynamic, Dynamic table characteristics
error checking, How to check tables for errors
flush, mysqladmin, Administrating a MySQL Server
fragmentation, OPTIMIZE TABLE Syntax
grant, Access Control, Stage 2: Request Verification
HEAP, HEAP Tables
host, Access Control, Stage 2: Request Verification
improving performance, Get Your Data as Small as Possible
information, Getting Information About a Table
information about, Getting Information About Databases and Tables
ISAM, ISAM Tables
loading data, Loading Data into a Table
locking, How MySQL Locks Tables
maintenance regimen, Setting Up a Table Maintenance Regimen
maximum size, How Big Can MySQL Tables Be?
merging, MERGE Tables
multiple, Using more than one table
names, Database, Table, Index, Column, and Alias Names
open, Why So Many Open tables?
opening, How MySQL Opens and Closes Tables
optimising, Table optimisation
repairing, How to repair tables
retrieving data, Retrieving Information from a Table
selecting columns, Selecting particular columns
selecting rows, Selecting particular rows
sorting rows, Sorting rows
too many, Drawbacks to Creating Large Numbers of Tables in the Same Database
unique ID for last row, How can I get the unique ID for the last inserted row?
updating, Transactions and atomic operations
table_cache, How MySQL Opens and Closes Tables
TAN( ), Mathematical functions
tar
problems on Solaris, Solaris Notes
Tcl APIs, MySQL Tcl APIs
tcp-ip option, mysqld_multi, Program for Managing Multiple MySQL servers
TCP/IP, Running MySQL on Windows
technical support
licensing, MySQL Licenses
mailing address, How to report bugs or problems
tee
mysql option, The Command-Line Tool
temporary file
write access, Problems Running mysql_install_db
temporary tables
problems, TEMPORARY TABLES Problems
terminal monitor
defined, Tutorial Introduction
testing
connection to the server, Access Control, Stage 1: Connection Verification
installation, Post-Installation Setup and Testing
of MySQL releases, Which MySQL Version to Use
post-installation, Post-Installation Setup and Testing
the server, Post-Installation Setup and Testing
testing mysqld
mysqltest, MySQL Test Suite
Texinfo, About This Manual
TEXT, Column Types, The BLOB and TEXT types
size, Storage requirements for string types
TEXT columns
default values, The BLOB and TEXT types
indexing, CREATE TABLE Syntax
text files
importing, mysqlimport, Importing Data from Text Files
thread packages
differences between, Differences Between Different Thread Packages
thread support, Operating Systems Supported by MySQL
non-native, MIT-pthreads Notes
threaded clients, How to Make a Threaded Client
threads, SHOW PROCESSLIST, mysqladmin, Administrating a MySQL Server, MySQL Internals
display, SHOW PROCESSLIST
RTS, Comments About RTS Threads
TIME, Column Types, The TIME type
time types, Storage requirements for numeric types
timeout, SHOW VARIABLES, Miscellaneous functions, INSERT DELAYED Syntax
TIMESTAMP, Column Types, The DATETIME, DATE, and TIMESTAMP types
and NULL values, Problems with NULL Values
timezone problems, Time Zone Problems
TIME_FORMAT( ), Date and Time Functions
TIME_TO_SEC( ), Date and Time Functions
TINYBLOB, Column Types
TINYTEXT, Column Types
tips
optimisation, Other Optimisation Tips
TMPDIR environment variable, Problems Running mysql_install_db
TODO
embedded server, Things left to do in embedded server (TODO)
symlinks, Using symbolic links for tables
ToDo list for MySQL, MySQL and the Future (the TODO)
tools
command-line, The Command-Line Tool
converting, How to convert mSQL tools for MySQL
mysqld_multi, mysqld_multi, Program for Managing Multiple MySQL servers
safe_mysqld, safe_mysqld, the Wrapper Around mysqld
TO_DAYS( ), Date and Time Functions
trace DBI method, Portable DBI methods, Debugging mysqld under gdb
trademarks, MySQL AB Logos and Trademarks
training, Training and certification
transaction-safe tables, Transactions and atomic operations, InnoDB Tables Overview
transactions
support, Transactions and atomic operations, InnoDB Tables Overview
triggers
stored, Stored procedures and triggers
TRIM( ), String Functions
troubleshooting
FreeBSD, Problems Compiling?
Solaris, Problems Compiling?
TRUNCATE, TRUNCATE Syntax
TRUNCATE( ), Mathematical functions
tutorial, Tutorial Introduction
Twin Studies
queries, Queries from Twin Project
type conversions, Comparison operators
type DBI method, MySQL-specific methods
types
columns, Column Types, Choosing the Right Type for a Column
date, Storage requirements for numeric types
of tables, MySQL Table Types
portability, Using Column Types from Other Database Engines
strings, String Types
time, Storage requirements for numeric types
Types, Column Types
types of support, Support Offered by MySQL AB
TZ environment variable, Time Zone Problems

U

UCASE( ), String Functions
UDF functions, CREATE FUNCTION/DROP FUNCTION Syntax
UDFs
compiling, Compiling and installing user-definable functions
defined, Adding New Functions to MySQL
return values, Return values and error handling
ulimit, File Not Found
UMASK environment variable, Problems with File Permissions
UMASK_DIR environment variable, Problems with File Permissions
unbuffered
mysql option, The Command-Line Tool
UNION, Searching on Two Keys, UNION syntax
UNIQUE, ALTER TABLE Syntax
unique ID, How can I get the unique ID for the last inserted row?
UNIX_TIMESTAMP( ), Date and Time Functions
unloading
tables, Retrieving Information from a Table
UNLOCK TABLES, LOCK TABLES/UNLOCK TABLES Syntax
UPDATE, UPDATE Syntax
update log, The Update Log
updating
releases of MySQL, How and When Updates Are Released
tables, Transactions and atomic operations
upgrading, Upgrading/Downgrading MySQL
3.20 to 3.21, Upgrading from Version 3.20 to Version 3.21
3.21 to 3.22, Upgrading from Version 3.21 to Version 3.22
3.22 to 3.23, Upgrading from Version 3.22 to Version 3.23
different architecture, Upgrading to Another Architecture
UPPER( ), String Functions
URLS for downloading MySQL, How to Get MySQL
URLs to MySQL information, MySQL Portals
USE, USE Syntax
USE INDEX, SELECT Syntax, JOIN syntax
USE KEY, SELECT Syntax, JOIN syntax
user
mysql option, The Command-Line Tool
USER environment variable, Connecting to the MySQL server
user option, mysqld_multi, Program for Managing Multiple MySQL servers
user privileges
adding, Adding New Users to MySQL
user table
sorting, Access Control, Stage 1: Connection Verification
user variables, User Variables
USER( ), Miscellaneous functions
user-defined functions
adding, Adding New Functions to MySQL
User-defined functions, CREATE FUNCTION/DROP FUNCTION Syntax
usernames
and passwords, MySQL Usernames and Passwords
users
adding, Installing a MySQL Binary Distribution
of MySQL, MySQL Portals
root, Setting Up the Initial MySQL Privileges
uses
of MySQL, What Have We Used MySQL for?
using multiple disks to start data, Splitting data across different disks on windows

V

valid numbers
examples, Numbers
VARCHAR, Column Types, String Types
size, Storage requirements for string types
variables
mysqld, Tuning Server Parameters
status, SHOW STATUS
user, User Variables
values, SHOW VARIABLES
verbose
mysql option, The Command-Line Tool
version
choosing, Which MySQL Version to Use
latest, How to Get MySQL
mysql option, The Command-Line Tool
version option, mysqld_multi, Program for Managing Multiple MySQL servers
VERSION( ), Miscellaneous functions
vertical
mysql option, The Command-Line Tool
views, Views
virtual memory
problems while compiling, Problems Compiling?
Visual Basic, Programs Known to Work with MyODBC

W

wait
mysql option, The Command-Line Tool
Web clients, Clients
web pages
miscellaneous, MySQL Portals
web search engines, MySQL Portals
web server
running, Using the MySQL software for free under GPL
web sites, MySQL Portals
WEEK( ), Date and Time Functions
WEEKDAY( ), Date and Time Functions
What is encryption, Basics
What is X509/Certificate?, Basics
WHERE, How MySQL Optimises WHERE Clauses
Wildcard character (%), Strings
Wildcard character (_), Strings
wildcards
and LIKE, How MySQL Uses Indexes
in mysql.columns_priv table, Access Control, Stage 2: Request Verification
in mysql.db table, Access Control, Stage 2: Request Verification
in mysql.host table, Access Control, Stage 2: Request Verification
in mysql.tables_priv table, Access Control, Stage 2: Request Verification
in mysql.user table, Access Control, Stage 1: Connection Verification
Windows, MySQL ODBC Support
compiling on, Compiling MySQL clients on Windows
open issues, MySQL-Windows compared to Unix MySQL
versus Unix, MySQL-Windows compared to Unix MySQL
without-server option, Typical configure Options
Word program, Programs Known to Work with MyODBC
wrappers
Eiffel, MySQL Eiffel Wrapper
write access
tmp, Problems Running mysql_install_db

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required