MySQL in a Nutshell, 2nd Edition

Index

A note on the digital index

A link in an index entry is displayed as the section title in which that entry appears. Because some sections have multiple index markers, it is not unusual for an entry to have several links to the same section. Clicking on any link will take you directly to the place in the text in which the marker appears.

Symbols

% (percent sign) wildcard, Searching Data
* (asterisk) wildcard, ,
; (semicolon), ending SQL statements,
= (equal) operator, using with subquery in a WHERE clause, Single Field Subqueries
\G (G flag), for long layout, ,

A

ABS function,

ACOS function,

ADD COLUMN clause, ALTER TABLE statement, ALTER TABLE: ADD clauses for columns

ADD PARTITION clause, ALTER TABLE, ALTER TABLE: Partition altering clauses

ADDDATE function,

ADDTIME function,

Advanced Encryption Standard (AES) algorithm,

AES_DECRYPT function,

AES_ENCRYPT function,

AFTER INSERT triggers,

AFTER keyword, ALTER TABLE: CHANGE clauses

aggregate functions, Aggregate Functions in Alphabetical Order–

AVG,
BIT_AND,
BIT_OR,
BIT_XOR,
COUNT,
general characteristics of, Aggregate Functions in Alphabetical Order
GROUP_CONCAT,
HAVING clause in SELECT statment, Having SELECT results
MAX,
MIN,
STD,
STDDEV,
STDDEV_POP,
STDDEV_SAMP,
SUM,
VARIANCE,
VAR_POP,
VAR_SAMP,

ALGORITHM parameter, CREATE VIEW statement,

aliases, creating, Selecting Data

ALL operator, Multiple Fields Subqueries

ALL option, REVOKE statement,

ALTER DATABASE statement,

ALTER EVENT statement, Statements in Alphabetical Order

ALTER FUNCTION statement,

ALTER PROCEDURE statement,

ALTER SCHEMA statement,

ALTER SERVER statement, ,

ALTER TABLE statement, –ALTER TABLE: Table options

ADD clauses for foreign keys, ALTER TABLE: ADD clauses for foreign keys
ADD FULLTEXT clause, ALTER TABLE: ADD clause for FULLTEXT indexes
ADD INDEX clause, ALTER TABLE: ADD clause for standard indexes
ADD SPATIAL clause, ALTER TABLE: ADD clause for SPATIAL indexes
CHANGE clauses, ALTER TABLE: CHANGE clauses
changing and setting character sets, Converting and setting character sets
clauses adding columns, ALTER TABLE: ADD clauses for columns
disabling and enabling keys, Disabling and enabling keys
discarding or importing tablespaces, Discarding or importing tablespace
DROP clause, ALTER TABLE: DROP column clause
DROP INDEX clause, ALTER TABLE: DROP index clauses
ORDER BY clause, Reordering rows
partition administration clauses, ALTER TABLE: Partition administration clauses
partition altering clauses, ALTER TABLE: Partition altering clauses
RENAME clause, Renaming a table
table options, setting, ALTER TABLE: Table options

ALTER VIEW statement,

ANALYSE function,

using with SELECT statement, Other SELECT clauses and options

ANALYZE PARTITION clause, ALTER TABLE statement, ALTER TABLE: Partition administration clauses

ANALYZE TABLE statement,

AND CHAIN clause

COMMIT statement,
ROLLBACK statement,

AND operator, bitwise AND,

AND RELEASE clause

COMMIT statement,
ROLLBACK statement,

anonymous users, Postinstallation

deleting after MySQL installation, Postinstallation

ANY clause, using with multiple fields subqueries, Multiple Fields Subqueries

arc cosine (ACOS) function,

AREA function, Creating SPATIAL indexes

arithmetic operators, Arithmetic Operators

AS keyword, Selecting Data

using in SELECT statement, ORDER BY clause, Ordering SELECT results
using with JOIN statements,
using with SELECT statement,

ascending (ASC) order, Reordering rows

index sorting, Creating UNIQUE indexes

ASCII function,

ASIN function,

asterisk (*) wildcard,

ATAN function,

ATAN2 function,

AUTOCOMMIT

disabling for ROLLBACK and START TRANSACTION,
disabling or enabling,

AUTO_INCREMENT columns

changing the starting point, ALTER TABLE: Table options
CREATE TABLE statement, CREATE TABLE: Table options
creating, CREATE TABLE: Column flags
primary key index deletion and, ALTER TABLE: DROP index clauses

AUTO_INCREMENT flag, Creating a Database and Tables

available_drivers function,

AVG function, , Results Set Subqueries

AVG_ROW_LENGTH option

ALTER TABLE statement, ALTER TABLE: Table options
CREATE TABLE statement, CREATE TABLE: Table options

B

BACKUP TABLE statement, ,

BASE TABLE value,

BDB storage engine, Transaction Statements

BEFORE INSERT triggers,

BEGIN statement,

begin_work function,

BEGIN…END statements,

BENCHMARK function,

BIGINT, SERIAL data types,

BIN function,

BINARY data type,

binary distributions of MySQL, Choosing a Distribution,

BINARY function,

binary log files

deleting all on master server,
deleting from master server,
displaying events in,
displaying list of logs created by master server,
formatting display with mysqlbinlog utility,
index file, Replication Process
listing, Replication Process
log-bin.index file, Configuring the Servers
path and filename, Configuring the Servers
preventing writing to,
reading with mysqlbinlog, Replication Process
sample excerpt, Replication Process
status of file currently in use on master,

binary logging

enabling or disabling,
master BinLog dump thread states, Master BinLog Dump Thread States

binary package (PKG) files, installing MySQL on Mac OS X, Macintosh OS X Distributions

bind_col function,

bind_columns function,

bind_param function, ,

bind_param_inout function,

BIT data type,

bitwise operators, Bitwise Operators

BIT_AND function,

BIT_COUNT function,

BIT_LENGTH function,

BIT_OR function,

BIT_XOR function,

BLOB data type,

books and other publications on MySQL, Books and Other Publications

BOOL, BOOLEAN data types,

BTREE index type, CREATE TABLE: Index and key definitions

bugs, reporting,

C

C language

API provided by MySQL, C API–C API Datatypes

connecting to MySQL, Connecting to MySQL
data types, C API Datatypes
functions, Functions in Alphabetical Order–
querying MySQL, Querying MySQL

crypt function,

function calls querying mSQL database,

CACHE INDEX statement,

caching

clearing and reloading temporary caches,
clearing the query results cache,
flushing caches,
query caching on the server, SELECT statement keywords

CALL statement,

callbacks

enabling for LOAD DATA LOCAL INFILE,

can function,

CAs (certificate authorities), GRANT: Type of connection restrictions

requiring specific issuer, GRANT: Type of connection restrictions
SSL variables for master server,

CASCADE keyword, CREATE TABLE: Foreign key references

CASCADED keyword,

CASE function,

CAST function,

CEIL function,

CEILING function,

certificate authorities (see CAs)

CHANGE clause, Creating a Database and Tables

ALTER TABLE statement, ALTER TABLE: CHANGE clauses

CHANGE MASTER TO statement, Configuring the Servers,

changing data in tables, Changing Data

CHAR data type,

CHAR function,

character sets, Unix Source Distributions

changing for a table, Converting and setting character sets
changing for columns, ALTER TABLE: CHANGE clauses
CHARACTER SET clause (ALTER DATABASE),
collation, listing,
CREATE TABLE statement, CHARACTER SET option, CREATE TABLE: Table options
default character set for a database,
mysql_character_set_name function,
setting default of a connection, ,
setting for a table, ALTER TABLE: Table options
showing all character sets installed on a server,
string,
string functions, String Functions Grouped by Type

CHARACTER_LENGTH function, ,

CHARSET function,

CHAR_LENGTH function,

CHECK PARTITION clause, ALTER TABLE statement, ALTER TABLE: Partition administration clauses

CHECK TABLE statement,

CHECKSUM TABLE function,

checksums

ALTER TABLE statement, CHECKSUM option, ALTER TABLE: Table options
CREATE TABLE statement, CHECKSUM option, CREATE TABLE: Table options
MD5,
SHA,

cipher method, requiring user accounts to use, GRANT: Type of connection restrictions

client library version,

clone function,

CLOSE statement,

COALESCE function,

COALESCE PARTITION clause, ALTER TABLE, ALTER TABLE: Partition altering clauses

code examples from this book, Using Code Examples

COERCIBILITY function,

collation

changing for a table, Converting and setting character sets
COLLATE option, ALTER DATABASE statement,
COLLATE option, ALTER TABLE statement, ALTER TABLE: Table options, ALTER TABLE: Table options
CREATE TABLE statement, COLLATE option, CREATE TABLE: Table options, CREATE TABLE: Table options
listing all collation character sets,
string,
string functions for, String Functions Grouped by Type

COLLATION function,

columns

column flags in CREATE TABLE statement, CREATE TABLE: Column flags
displaying for a table,
length, returning,

columns_priv table,

column_info function,

command line, entering SQL statements into MySQL, Command-Line Interface

command-line utilities, Command-Line Utilities–

comp_err,
invocation on Windows, configuring, Windows Distributions
make_binary_distribution,
msql2mysql,
myisamchk, –Global myisamchk options
myisamlog,
myisampack,
myisam_ftdump,
mysqlaccess,
mysqladmin,
mysqlbinlog,
mysqlbug,
mysqlcheck,
mysqldump, –mysqldump --debug options
mysqldumpslow,
mysqlhotcopy,
mysqlimport,
mysqlshow,
mysqlslap,
mysql_convert_table_format,
mysql_find_rows,
mysql_fix_extensions,
mysql_fix_privilege_tables,
mysql_setpermission,
mysql_tableinfo,
mysql_upgrade,
mysql_waitpid,
mysql_zap,
my_print_defaults,
perror,
replace,
resolveip,
resolve_stack_dump,

COMMENT clause

ALTER EVENT statement,
ALTER FUNCTION statement,
ALTER PROCEDURE statement,
CREATE EVENT statement,

COMMENT subclause, CREATE TABLE statement, CREATE TABLE: Partition definitions

comments

COMMENT option, ALTER TABLE statement, ALTER TABLE: Table options
COMMENT option, CREATE TABLE statement, CREATE TABLE: Table options

commit function,

COMMIT statement,

comparison operators, ALL operator and, Multiple Fields Subqueries

COMPRESS function,

compression

row storage by storage engines, ALTER TABLE: Table options
tables packed with myisampack utility,

comp_err utility,

CONCAT function, Selecting Data,

using in date formatting, Analyzing and Manipulating Data

CONCAT_WS function,

conditions, declaring,

configuration

MySQL source files, Unix Source Distributions

connect method,

CONNECTION function,

connections

closing,
CONNECTION option, CREATE TABLE statement, CREATE TABLE: Table options
limiting number for user accounts, GRANT: Time and number of connection limits
mysqld options, Security and connections–Security and connections
restricting users to certain types of connections, GRANT: Type of connection restrictions
terminating current client connection,

connect_cached method,

CONTINUE handler,

CONV function,

conversions

string functions for, Converting

CONVERT function,

CONVERT TO CHARACTER SET clause, ALTER TABLE statement, Converting and setting character sets

CONVERT_TZ function,

correlated subqueries, Results Set Subqueries

COS function,

COT function,

COUNT function,

using in a SELECT statement, Analyzing and Manipulating Data

CRC function,

CREATE DATABASE statement,

CREATE EVENT statement,

CREATE FULLTEXT INDEX statement, Creating FULLTEXT indexes

CREATE FUNCTION statement,

CREATE INDEX statement,

CREATE PROCEDURE statement,

CREATE SCHEMA statement,

CREATE SERVER statement, ,

CREATE SPATIAL INDEX statement, Creating SPATIAL indexes

CREATE TABLE statement, –CREATE TABLE: Based on an existing table

column flags, CREATE TABLE: Column flags
creating a new table based on an existing table, CREATE TABLE: Based on an existing table
index and key definitions, CREATE TABLE: Index and key definitions
partition definition subclauses, CREATE TABLE: Partition definitions
partition options, CREATE TABLE: Partitioning
REFERENCES options, FOREIGN KEY clause, CREATE TABLE: Foreign key references
subpartition definitions, CREATE TABLE: Subpartition definitions
table options, CREATE TABLE: Table options

CREATE TRIGGER statement,

CREATE UNIQUE INDEX statement, Creating UNIQUE indexes

CREATE USER statement, SQL Statements in Alphabetical Order

CREATE VIEW statement,

CROSS keyword, use with JOIN statements,

crypt function (C language),

cryptography

decrypting a string encrypted with a password,
decrypting text encrypted with AES algorithm,
decrypting text encrypted with DES algorithm,
encrypting a given string and storing with a password,
encrypting string with AES algorithm,
encrypting text with triple DES algorithm,
returning encrypted text using crypt function,

CURDATE function, ,

CURRENT_DATE function,

CURRENT_TIME function,

CURRENT_TIMESTAMP function,

CURRENT_USER function,

cursors

declaring,
opening,
retrieving,

CURTIME function,

cyclic redundancy check (CRC),

D

DATA DIRECTORY

ALTER TABLE statement, ALTER TABLE: Table options
CREATE TABLE partition definition subclause, CREATE TABLE: Partition definitions
CREATE TABLE statement option, CREATE TABLE: Table options

Data Encryption Standard (DES) algorithm,

data manipulation, Data Manipulation Statements and Functions–,

(see also transactions)
BEGIN statement,
DELETE statement,
EXLPLAIN statement,
functions, Related Functions, Functions in Alphabetical Order
HELP statement,
INSERT statements,
LOAD DATA INFILE statement,
RELEASE SAVEPOINT statement,
SELECT statement, –Other SELECT clauses and options
SET statement,
SHOW ERRORS statement,
SHOW WARNINGS statement,
statements and clauses for, Data Manipulation Statements
statements for transactions, Transaction Statements
UPDATE statement,
USE statement,

data types, Data Types–

C API, C API Datatypes
column, setting default values, ALTER TABLE: CHANGE clauses
date and time, Date and Time Data Types
INTEGER or INT, Creating a Database and Tables
numeric, Numeric Data Types–
string, String Data Types–
temporal, Date and Time Functions
TEXT, Creating a Database and Tables

DATABASE function, ,

databases

copying for replication, Copying Databases and Starting Replication
creating and modifying, Creating a Database and Tables
creating with mysql_create_db,
deleting,
deleting with mysl_drop_db,
displaying list of all on the server,
granting user privileges for,
listing for current connection,
listing with mysqlshow,
listing with SHOW DATABASES, Show Me
renaming,
searching, Searching Data
selecting different for current connection,
setting default for current session,
SHOW CREATE DATABASE statement,

data_diff function,

data_source function,

data_string_desc function,

data_string_diff function,

DATE data type, Date and Time Functions, Date and Time Data Types

DATE function,

DATEDIFF function,

dates and times

changing for events,

converting a string to a date,

data types, Date and Time Data Types

date functions, Analyzing and Manipulating Data

formats for displaying, Analyzing and Manipulating Data

functions for, Date and Time Functions–

ADDDATE,
ADDTIME,
calculating and modifying date or time, Calculating and Modifying the Date or Time
CONVERT_TZ,
CURDATE,
CURRENT_DATE,
CURRENT_TIME,
CURRENT_TIMESTAMP,
CURTIME,
DATE,
DATEDIFF,
DATE_ADD,
DATE_FORMAT,
DATE_SUB,
DAY,
DAYNAME,
DAYOFMONTH,
DAYOFWEEK,
DAYOFYEAR,
determining date or time, Date and Time Functions Grouped by Type
EXTRACT,
extracting and formatting date or time, Extracting and Formatting the Date or Time
FROM_DAYS,
FROM_UNIXTIME,
HOUR,
LAST_DAY,
LOCALTIME,
LOCALTIMESTAMP,
MAKEDATE,
MAKETIME,
MICROSECOND,
MINUTE,
MONTH,
MONTHNAME,
NOW,
PERIOD_ADD,
PERIOD_DIFF,
QUARTER,
SECOND,
SEC_TO_TIME,
SLEEP,
TIMESTAMP,
TIMESTAMPDIFF,
TO_DAYS,
UNIX_TIMESTAMP,
UTC_DATE,
UTC_TIME,
UTC_TIMESTAMP,
WEEK,
WEEKDAY,
WEEKOFYEAR,
YEAR,
YEARWEEK,

GET_FORMAT function,

DATETIME data type, Date and Time Functions, Date and Time Data Types

DATE_ADD function,

DATE_FORMAT function, Analyzing and Manipulating Data,

format arguments and their results,
format codes and resulting formats,

DATE_SUB function,

DAY function,

DAYNAME function,

DAYOFMONTH function,

DAYOFWEEK function,

DAYOFYEAR function,

DBD drivers,

DBI Data Source Name (DSN),

DEC, DECIMAL data types,

decimal numbers, converting to bits or binary,

DECLARE statement,

DECODE function,

DEFAULT clause, INSERT statements,

DEFINER clause,

ALTER EVENT statement,
CREATE EVENT statement,
CREATE PROCEDURE statement,

DEGREES function,

degrees, converting to radians,

DELAYED keyword

using with INSERT statements,
using with REPLACE statements,

DELAY_KEY_WRITE option

ALTER TABLE statement, ALTER TABLE: Table options
CREATE TABLE statement, CREATE TABLE: Table options

DELETE statements, Deleting Data,

JOIN clause,
trigger execution and,

deleting data, Deleting Data

DELIMITER command,

DELIMITER statement, , ,

DESC flag, Ordering, Limiting, and Grouping

DESC keyword (see DESCRIBE statement)

descending (DESC) order, Reordering rows

index sorting, Creating UNIQUE indexes

DESCRIBE statement, Creating a Database and Tables,

DES_DECRYPT function,

DES_ENCRYPT function,

DES_KEY_FILE option, FLUSH statement,

deterministic functions,

deterministic procedures,

directories

changing default directory for MySQL installation, Unix Source Distributions

dirty read,

DISABLE KEYS clause, ALTER TABLE statement, Disabling and enabling keys

DISABLE keyword,

DISABLE ON SLAVE keyword, using with ALTER EVENT,

disconnect function,

DISTINCT keyword

AVG function,
SUM function,
using with SELECT statement, SELECT statement keywords

DISTINCTROW keyword, using with SELECT statement, SELECT statement keywords

DO clause, ALTER EVENT statement,

do function,

DO statement,

RELEASE_LOCK function,

documentation

online, for compiling MySQL, Unix Source Distributions
upgrades from a previous version to current one, Postinstallation

DOUBLE, DOUBLE PRECISION data types,

DROP COLUMN clause, ALTER TABLE statement, ALTER TABLE: DROP column clause

DROP DATABASE statement,

DROP EVENT statement,

DROP FUNCTION statement,

DROP INDEX clause, ALTER TABLE statement, ALTER TABLE: DROP index clauses

DROP INDEX statement,

DROP PARTITION clause, ALTER TABLE statement, ALTER TABLE: Partition altering clauses

DROP PREPARE statement,

DROP PROCEDURE statement,

DROP SERVER statement,

DROP TABLE statement,

DROP TRIGGER statement,

DROP USER statement,

using REVOKE before,

DROP VIEW statement, ,

dump files, The MySQL Package

copying databases for replication, Using mysqldump
debugging information about current connection,
resolve_stack_dump utility,
SELECT INTO DUMPFILE statement, Exporting SELECT results

dump_results function,

duplicates

caused by inserting data into tables, Changing Data
preventing, Importing Data in Bulk
preventing in indexes,

E

ELT function,

ENABLE KEYS clause, ALTER TABLE statement, Disabling and enabling keys

ENABLE keyword,

ENCLOSED BY clause, LOAD DATA INFILE statement,

ENCODE function,

ENCRYPT function,

ENGINE keyword, CREATE TABLE: Index and key definitions

ALTER TABLE statement, ALTER TABLE: Table options
CREATE TABLE or ALTER TABLE statements,
CREATE TABLE partition definition subclause, CREATE TABLE: Partition definitions
CREATE TABLE statement, CREATE TABLE: Table options

ENUM data type,

environment variables, Server and Environment Variables

err function,

error code numbers,

error logging, turning on, Postinstallation

error messages

displaying,
ignoring in SQL statement execution, Importing Data in Bulk
retrieval with SHOW WARNINGS statement,

errors

checking tables for,
displaying descriptions of system error codes,
mysql_errno function,
mysql_error function,
set_err function,
slave server error.log file, Replication Process

errstr function,

ESCAPED BY clause

LOAD DATA INFILE statement,
SELECT INTO statement, Exporting SELECT results

escaping special characters in strings, ,

events

altering existing scheduled events, Statements in Alphabetical Order,
creating,
deleting,
listing scheduled events on the server,
SHOW CREATE EVENT statement,

EVERY clause

ALTER EVENT statement,
CREATE EVENT statement,

exclusive OR (XOR),

execute function,

EXECUTE statement,

execute_array function,

execute_for_fetch function,

EXISTS keyword, using with WHERE clause, Multiple Fields Subqueries

EXIT handler,

EXP function,

expire_logs_days system variable,

EXPLAIN SELECT statement, Creating SPATIAL indexes

EXPLAIN statement,

analyzing joined statements for indexes, Index hints

EXPORT_SET function,

expressions

ordering SELECT statement results, Ordering SELECT results
string functions, Expressions

EXTENDED keyword

using with CHECK TABLE,
using with CHECKSUM TABLE,
using with REPAIR TABLE,

EXTRACT function,

extracting (string functions), Extracting

F

FEDERATED storage engine

deleting a server,
setting connection parameters,

fetch function,

FETCH statement,

fetchall function,

fetchall_hashref function,

fetchrow_array function,

fetchrow_arrayref function,

fetchrow_hashref function,

FIELD function,

fields

mysql_fetch_field function,
mysql_fetch_fields function,
mysql_fetch_field_direct function,
mysql_field_seek function,
mysql_list_fields function,
mysql_num_fields function,

FIELDS ENCLOSED BY clause, SELECT INTO statement, Exporting SELECT results

FIELDS TERMINATED BY clause

LOAD DATA INFILE statement,
SELECT INTO statement, Exporting SELECT results

FIND_IN_SET function,

finish function,

FIRST keyword, ALTER TABLE: ADD clauses for columns, ALTER TABLE: CHANGE clauses

FLOAT data type,

FLOOR function,

flow control functions, Flow Control Functions–

CASE,
IF,
IFNULL,
ISNULL,
NULLIF,

FLUSH PRIVILEGES statement,

FLUSH statement, ,

options, listed,

FLUSH TABLES WITH READ LOCK statement, , Alternative Methods for Making Copies

FORCE INDEX option, JOIN statements, Index hints

foreign keys

ALTER TABLE statement, ADD clauses for, ALTER TABLE: ADD clauses for foreign keys
deleting, ALTER TABLE: DROP index clauses
FOREIGN KEY index syntax, CREATE TABLE: Index and key definitions
REFERENCES options to FOREIGN KEY clause of CREATE TABLE, CREATE TABLE: Foreign key references

foreign_key_info function,

FORMAT function, ,

formatting (string functions), Formatting

FOUND_ROWS function,

FROM clause, Selecting Data

DELETE statement,
SHOW BINLOG EVENTS statement,
SHOW COLUMNS statement,
SHOW EVENTS statement,
SHOW INDEXES statement,
SHOW TABLE STATUS statement, ,
subqueries in, Results Set Subqueries

FROM_DAYS function,

FROM_UNIXTIME function,

FULL keyword

distinguishing between tables and views,
SHOW COLUMNS statement,
SHOW PROCESSLIST statement,

FULLTEXT indexes, ALTER TABLE: ADD clause for FULLTEXT indexes

creating, Creating FULLTEXT indexes

func function,

functions

C API, Functions in Alphabetical Order–

changing user-defined function characteristics,

changing user-defined functions,

CREATE FUNCTION statement,

data manipulation, Related Functions, Functions in Alphabetical Order

date, Analyzing and Manipulating Data

date and time, Date and Time Functions–

deleting user-defined functions,

displaying information on user-defined functions,

displaying internal code,

flow control, Flow Control Functions–

mathematical, Mathematical Functions–

MySQL, basic C library, Part IV, MySQL API

replication,

security and user accounts, Functions in Alphabetical Order–

server and table administration, Functions in Alphabetical Order

SHOW CREATE FUNCTION statement,

string, String Functions–

grouped by type, String Functions Grouped by Type

user access and security, Statements and Functions

G

G flag (\G), for long layout, ,

GA (Generally Available) release, Choosing a Distribution

gcc, Unix Source Distributions

geographical and global positioning satellite (GPS) data, ALTER TABLE: ADD clause for SPATIAL indexes

GET_FORMAT function,

get_info function,

GET_LOCK function,

global server options, Global–Global

global variables, ,

GNU utilities, Unix Source Distributions

GPL (GNU Public License), Licensing

GPS (global positioning satellite) systems, ALTER TABLE: ADD clause for SPATIAL indexes

GRANT statement, ,

displaying for a user with SHOW GRANTS,
privileges, listed, GRANT: Time and number of connection limits
REQUIRE clause, restricting types of connections, GRANT: Type of connection restrictions
time and number of connection limits, GRANT: Time and number of connection limits

grant tables, Security and User Statements and Functions

GREATEST function,

GROUP BY clause, Ordering, Limiting, and Grouping

SELECT statement, Grouping SELECT results
using with AVG function, Results Set Subqueries
using with COUNT function,
using with GROUP_CONCAT function,
using with MAX function,
using with STDDEV function,
using with VARIANCE function,

GROUP_CONCAT function,

gunzip utility, Unix Source Distributions

H

HANDLER statement,

handlers, declaring,

HASH subclause, PARTITION BY clause, CREATE TABLE: Partitioning

HASH subpartition definitions with CREATE TABLE, CREATE TABLE: Subpartition definitions

HAVING clause, SELECT statement, Having SELECT results

HELP statement,

HEX function,

hexadecimal numbers, converting to character equivalent,

HIGH_PRIORITY keyword

INSERT statements,
using with SELECT statement, SELECT statement keywords

hosts

accessing MySQL,
changing for a user account,
mysql_get_host_info function,
specifying in CREATE SERVER statement,

HOSTS option, FLUSH statement,

HOUR function,

I

IDENTIFIED BY clause,

GRANT statement,

IF EXISTS flag

DROP DATABASE statement,
DROP SERVER statement,
DROP TABLE statement,
DROP VIEW statement,

IF function,

IFNULL function,

IGNORE clause, Importing Data in Bulk

DELETE statement,
INSERT statement,
INSERT statement, multiple-row insertions, Multiple-row insertions
UPDATE statement, Multiple table UPDATE

IGNORE INDEX option, JOIN statements, Index hints

IGNORE LINES clause, LOAD DATA INFILE,

IGNORE SELECT statement, CREATE TABLE: Based on an existing table

ignoring unwanted data in older versions of MySQL, Importing Data in Bulk

importing data in bulk, Importing Data in Bulk

IN clause

SHOW BINLOG EVENTS statement,
using with multiple fields subqueries, Multiple Fields Subqueries

INDEX DIRECTORY option

CREATE TABLE partition definition subclause, CREATE TABLE: Partition definitions
CREATE TABLE statement, CREATE TABLE: Table options

index hints, Index hints

INDEX keyword,

indexes

adding to a table, ALTER TABLE: ADD clause for standard indexes
caching,
CREATE INDEX statement,
CREATE UNIQUE INDEX statement, Creating UNIQUE indexes
creating FULLTEXT indexes, Creating FULLTEXT indexes
creating SPATIAL indexes, Creating SPATIAL indexes
creating, using CREATE TABLE, CREATE TABLE: Index and key definitions
delaying updating until table is closed, ALTER TABLE: Table options
deleting from tables, ALTER TABLE: DROP index clauses
deleting with DROP INDEX,
displaying for a given table,
FULLTEXT, adding to tables, ALTER TABLE: ADD clause for FULLTEXT indexes
INDEX DIRECTORY option, ALTER TABLE, ALTER TABLE: Table options
listing for a table, ALTER TABLE: DROP index clauses
LOAD INDEX INTO CACHE statement,
nonunique, enabling or disabling on MyISAM tables, Disabling and enabling keys
PACK_KEYS option, ALTER TABLE statement, ALTER TABLE: Table options
SPATIAL index, adding to a table, ALTER TABLE: ADD clause for SPATIAL indexes
types of table key indexes, CREATE TABLE: Index and key definitions

INDEXES keyword,

INET_ATON function,

INET_NTOA function,

INNER keyword, use in JOIN statements,

inner query, Subqueries

InnoDB storage engine, Transaction Statements

foreign keys linking table columns, CREATE TABLE: Index and key definitions
master server configuration file, Configuring the Servers
mysqld server options, InnoDB
row compression with COMPACT, ALTER TABLE: Table options

INSERT DATA INFILE statement,

ROLLBACK issued to remove imported data,

INSERT function,

INSERT statements, Inserting Data,

duplicates and, Changing Data
insertion of rows based on a SELECT, Inserting rows based on a SELECT
LOW_PRIORITY keyword,
multiple-row insertions, Multiple-row insertions
single-row insertion with SET clause, Single-row insertion with the SET clause
trigger execution and,

INSERT_METHOD option

ALTER TABLE statement, ALTER TABLE: Table options
CREATE TABLE statement, CREATE TABLE: Table options

installation of MySQL, Installing MySQL–Postinstallation

choosing a distribution, Choosing a Distribution
Linux RPM distributions, Linux RPM Distributions
Mac OS X distributions, Macintosh OS X Distributions
Novell NetWare distributions, Novell NetWare Distributions
postinstallation tasks, Postinstallation
Unix binary distributions, Unix Binary Distributions
Windows distributions, Windows Distributions

installed_drivers function,

installed_versions function,

INSTR function,

INT, INTEGER data types,

INTERVAL function,

INTERVAL keyword,

intervals

adding to date or datetime,
formats, listed,

INTO clause

INSERT statement,
REPLACE statement,
SELECT statement, Exporting SELECT results

INTO DUMPFILE clause, SELECT statement, Exporting SELECT results

INTO OUTFILE clause, SELECT statement, Exporting SELECT results

INVOKER parameter, CREATE VIEW statement,

I/O threads, slave server, Replication Process, Slave I/O Thread States

IP addresses, resolving hostnames to,

ISNULL function,

isolation level, setting for a transaction,

IS_FREE_LOCK function,

IS_USED_LOCK function,

J

Java, interfacing to MySQL, Books and Other Publications

JOIN clause, Selecting Data

joining three tables, Analyzing and Manipulating Data
using with UPDATE statement, Multiple table UPDATE

JOIN statements,

USE INDEX clause, Index hints

K

KEY

index type, CREATE TABLE: Index and key definitions

PARTITION BY clause

ALTER TABLE statement, ALTER TABLE: Partition altering clauses
CREATE TABLE statement, CREATE TABLE: Partitioning

subpartition definitions with CREATE TABLE, CREATE TABLE: Subpartition definitions

keys

KEYS keyword,
PRIMARY of UNIQUE key columns, CREATE TABLE: Column flags

KEY_BLOCK_SIZE option, CREATE TABLE: Index and key definitions

ALTER TABLE statement, ALTER TABLE: Table options
CREATE TABLE statement, CREATE TABLE: Table options

KILL statement,

Knowledge Base, Books and Other Publications

L

LAST clause

HANDLER…READ statements,

LAST_DAY function,

LAST_INSERT_ID function, Inserting Data,

last_insert_id function,

LCASE function,

LEAST function,

LEFT function,

LEFT keyword, using with JOIN statements,

LENGTH function,

licensing, MySQL, Licensing

LIKE clause

DELETE statement,
SHOW CHARACTER SET statement,
SHOW COLUMNS statement,
SHOW DATABASES statement,
SHOW EVENTS statement,
SHOW OPEN TABLES statement,
SHOW STATUS statement,
SHOW TABLE STATUS statement, ,
SHOW TABLES statement,
SHOW TRIGGER STATUS statment,
SHOW VARIABLES statement,

LIKE operator, Searching Data

LIMIT clause, Ordering, Limiting, and Grouping,

DELETE statement,
SELECT statement, Limiting SELECT results
SHOW BINLOG EVENTS statement,
UPDATE statement, Single table UPDATE

LINEAR keyword, CREATE TABLE: Partitioning

LINES STARTED BY clause

LOAD DATA INFILE statement,

LINES STARTING BY clause

SELECT INTO statement, Exporting SELECT results

LINES TERMINATED BY clause

LOAD DATA INFILE statement,
SELECT INTO statement, Exporting SELECT results

Linux

installing MySQL through RPM, Linux RPM Distributions

LIST subclause, PARTITION BY clause, CREATE TABLE: Partitioning

LN function,

LOAD DATA FROM MASTER statement (deprecated),

LOAD DATA INFILE statement, Importing Data in Bulk,

execution on slave server, Configuring the Servers

LOAD DATA LOCAL INFILE statement,

LOAD INDEX INTO CACHE statement,

LOAD TABLE…FROM MASTER statement (deprecated),

LOAD_FILE function,

LOCAL keyword,

LOAD DATA INFILE statements,

LOCAL option

OPTIMIZE TABLE statement,

local variables,

declaring,

locales,

LOCALTIME function,

LOCALTIMESTAMP function,

LOCATE function,

location optons, mysqld, Location

LOCK IN SHARE MODE option, SELECT statement, Other SELECT clauses and options

LOCK TABLES statement,

locking

external table locking on Novell NetWare, Novell NetWare Distributions

locks

determining if lock name is already in use,
free and available lock names, checking,
GET_LOCK function,
information provided by SHOW ENGINE statement,
read-only lock on tables for replication, Alternative Methods for Making Copies
releasing,
TABLES WITH READ LOCK, FLUSH statement,
unlocking tables, ,

log files, listing on master server,

LOG function,

log position identification number, Replication Process

log-bin.index file, Configuring the Servers

LOG2 function,

LOG10 function,

logging into MySQL, The mysql Client

logging, mysqld options, Logs

logical operators, Logical Operators

long form, mysqld options,

LONGBLOB data type,

LONGTEXT data type,

looks_like_number function,

lower case (LCASE) function,

LOWER function,

LOW_PRIORITY keyword

DELETE statement,
INSERT statements,
LOCK TABLES statement,
REPLACE statement,
UPDATE statement, Single table UPDATE, Multiple table UPDATE

LPAD function,

LTRIM function,

M

MAC (Media Access Control) address,

Mac OS X, installing MySQL, Macintosh OS X Distributions

mailing lists, MySQL community, Mailing Lists

main query, Subqueries

MAKEDATE function,

MAKETIME function,

make_binary_distribution utility,

MAKE_SET function,

MASTER option

FLUSH statement, deprecated,
RESET statement, ,

master server, Merits of Replication

BinLog Dump thread states, Master BinLog Dump Thread States
configuration file, Configuring the Servers
log files, naming and providing position to slave server,
server identification number, Configuring the Servers

master.info file, Replication Process

deleting on slave server,
SSL variables,
variables on slave server for connection with master, Configuring the Servers

MASTER_POS_WAIT function,

MATCH function,

mathematical functions, Mathematical Functions–

ABS,
ACOS,
ASIN,
ATAN,
ATAN2,
BIT_COUNT,
CEIL,
CEILING,
CONV,
COS,
COT,
DEGREES,
EXP,
FLOOR,
FORMAT,
GREATEST,
INET_ATON,
INET_NTOA,
LEAST,
LN,
LOG,
LOG2,
LOG10,
MOD,
OCT,
PI,
POW,
POWER,
RADIANS,
RAND,
ROUND,
SIGN,
SIN,
SQRT,
TAN,
TRUNCATE,

MAX function,

MAX_QUERIES_PER_HOUR option, GRANT: Time and number of connection limits

MAX_ROWS

CREATE TABLE partition definition subclause, CREATE TABLE: Partition definitions
CREATE TABLE statement option, CREATE TABLE: Table options

MAX_ROWS option

ALTER TABLE statement, ALTER TABLE: Table options

MBRContains function, Creating SPATIAL indexes

MD5 function,

Media Access Control (MAC) address,

MEDIUMBLOB data tpe,

MEDIUMINT data type,

MEDIUMTEXT data type,

memory

allocated by a function, freeing,
query results, storing, Querying MySQL

MEMORY storage engine, mysqld server options, Other storage engine options

Message-Digest algorithm 5,

MICROSECOND function,

MID function,

MIN function,

MINUTE function,

MIN_ROWS

CREATE TABLE partition definition subclause, CREATE TABLE: Partition definitions
CREATE TABLE statement option, CREATE TABLE: Table options

MIN_ROWS option

ALTER TABLE statement, ALTER TABLE: Table options

MOD function,

MODIFY clause, ALTER TABLE, ALTER TABLE: CHANGE clauses

MONTH function,

MONTHNAME function,

msql2mysql utility,

multiple fields subqueries, Multiple Fields Subqueries

MUTEX option, SHOW ENGINE statement,

myisamchk utility, –Global myisamchk options

--analyze option,
check options,
compacting table after deletion of rows,
global options, Global myisamchk options
other options, Other myisamchk options
repair options, myisamchk repair options

myisamlog utility,

myisampack utility,

row storage format, ALTER TABLE: Table options

myisam_ftdump utility,

MylSAM storage engine

mysqld server options, MyISAM

MySQL

programs included in package, The MySQL Package
resources for further information, Books and Other Publications
versions 5.0, 5.1, and 6.0, Preface

mysql client, The MySQL Package, The mysql Client,

-e option,
command-line options, Command-Line Interface, –,
executing dump files on slave server, Using mysqldump
terminal and monitor modes,

mysql user accounts

creating for Unix binary distributions, Unix Binary Distributions
creating for Unix source distributions, Unix Source Distributions
creating on Mac OS X, Macintosh OS X Distributions
deleting anonymous users, Postinstallation

mysqlaccess utility, The MySQL Package,

mysqladmin utility,

commands, mysqladmin commands

mysqlbinlog utility, Replication Process,

working with large binary log files,

mysqlbug utility,

mysqlcheck utility,

mysqld daemon, The MySQL Package, –

listing options for your version,
location options, Location
logging options, Logs
options grouped by use,
options syntax,
performance optimization options, Performance optimization–Performance optimization
replication options, Replication–Replication
security and connection options, Security and connections–Security and connections
starting for Unix binary distributions, Unix Binary Distributions
storage engine options, Storage engine specific options–Other storage engine options

mysqldump utility, The MySQL Package, –mysqldump --debug options

backups of replicated databases on slave server, Backups with Replication
debugging options, mysqldump --debug options
options,
setting up replication, Using mysqldump

mysqldumpslow utility,

mysqld_multi option,

mysqld_safe utility, The MySQL Package, Unix Binary Distributions,

mysqlhotcopy utility,

mysqlimport utility,

mysqlshow utility,

--keys option, ,

mysqlslap utility,

mysql_affected_rows function, ,

mysql_autocommit function,

mysql_change_user function, ,

mysql_character_set_name function,

mysql_client_encoding function,

mysql_close function, ,

mysql_commit function,

mysql_connect function, ,

mysql_convert_table_format utility,

mysql_create_db function, ,

mysql_data_seek function, ,

mysql_db_name function,

mysql_db_query function,

mysql_debug function,

mysql_drop_db function, ,

mysql_dump_debug_info function,

mysql_eof function,

mysql_errno function, ,

mysql_error function, ,

mysql_escape_string function, ,

mysql_fetch_array function,

mysql_fetch_assoc function,

mysql_fetch_field function, ,

mysql_fetch_fields function,

mysql_fetch_field_direct function,

mysql_fetch_lengths function, ,

mysql_fetch_object function,

mysql_fetch_row function, ,

mysql_field_count function,

mysql_field_flags function,

mysql_field_len function,

mysql_field_name function,

mysql_field_seek function, ,

mysql_field_table function,

mysql_field_tell function,

mysql_field_type function,

mysql_find_rows utility,

mysql_fix_extensions utility,

mysql_fix_privilege_tables utility,

mysql_free_result function, ,

mysql_get_character_set_info function,

mysql_get_client function,

mysql_get_client_info function,

mysql_get_client_version function,

mysql_get_host_info function, ,

mysql_get_proto_info function, ,

mysql_get_server_info function, ,

mysql_get_server_version function,

mysql_get_ssl_cipher function,

mysql_hex_string function,

mysql_info function, ,

mysql_init function,

mysql_insert_id function, ,

mysql_install_db utility, Novell NetWare Distributions

mysql_kill function,

mysql_library_end function,

mysql_library_init function,

mysql_list_dbs function, ,

mysql_list_fields function, ,

mysql_list_processes function, ,

mysql_list_tables function, ,

mysql_more_results function,

mysql_next_result function,

mysql_num_fields function, ,

mysql_num_rows function, ,

mysql_options function,

mysql_pconnect function,

mysql_ping function, ,

mysql_query function, ,

mysql_real_connection function,

mysql_real_escape_string function, ,

mysql_real_query function,

mysql_refresh function,

mysql_reload function,

mysql_result function,

mysql_rollback function,

mysql_row_seek function,

mysql_row_tell function,

mysql_select_db function, ,

mysql_setpermission utility,

mysql_set_character_set function,

mysql_set_charset function,

mysql_set_local_infile_default function,

mysql_set_local_infile_handler function,

mysql_set_server_option function,

mysql_shutdown function,

mysql_sqlstate function,

mysql_ssl_set function,

mysql_stat function, ,

mysql_store_result function,

mysql_tableinfo utility,

mysql_tablename function,

mysql_thread_end function,

mysql_thread_id function,

mysql_thread_init function,

mysql_thread_safe function,

mysql_unbuffered_query function,

mysql_upgrade utility,

mysql_use_result function,

mysql_waitpid utility,

mysql_warning_count function,

mysql_zap utility,

my_print_defaults utility,

N

NATURAL keyword, using with JOIN statements,

NDB storage engine, Transaction Statements

mysqld server options, Other storage engine options

neat function,

neat_list function,

NetWare (Novell), installing MySQL, Novell NetWare Distributions

NetWare Loadable Modules (NLMs), Novell NetWare Distributions

NEXT clause

HANDLER READ NEXT statment,
HANDLER…READ statements,

NLMs (NetWare Loadable Modules), Novell NetWare Distributions

NO ACTION setting, CREATE TABLE: Foreign key references

NO keyword, COMMIT statement,

NODEGROUP subclause, CREATE TABLE statement, CREATE TABLE: Partition definitions

NOT PRESERVE keyword,

Novell NetWare, installing MySQL, Novell NetWare Distributions

NOW function,

NO_WRITE_TO_BINLOG flag,

NO_WRITE_TO_BINLOG option

ANALYZE TABLE statement,
FLUSH statement,
OPTIMIZE TABLE statement,
REPAIR TABLE statement,

NULL values, changing data in related columns to, CREATE TABLE: Foreign key references

NULLIF function,

numeric data types, Numeric Data Types–

O

OCT function,

OCTET_LENGTH function,

OFFSET keyword, LIMIT clause and,

OLD_PASSWORD function,

ON COMPLETION clause, ALTER EVENT statement,

ON DELETE CASCADE clause, CREATE TABLE: Index and key definitions

ON DELETE clause, CREATE TABLE: Foreign key references

ON DUPLICATE KEY UPDATE clause, INSERT statement,

ON keyword, JOIN clause,

ON SCHEDULE AT clause, ALTER EVENT statement,

ON SCHEDULE AT clause, CREATE EVENT statement,

ON UPDATE clause, CREATE TABLE: Foreign key references

OPEN clause

HANDLER statement,

OPEN statement,

operating systems

MySQL distributions, Installing MySQL

operators, Operators–Regular Expressions

arithmetic, Arithmetic Operators
bitwise, Bitwise Operators
logical, Logical Operators
regular expression, Regular Expressions
relational, Relational Operators

OPTIMIZE PARTITION clause, ALTER TABLE statement, ALTER TABLE: Partition administration clauses

OPTIMIZE TABLE statement,

compacting tables after row deletion,

OPTIONALLY keyword

ENCLOSED BY clause,

OR operator

bitwise OR,

OR REPLACE parameter, CREATE VIEW statement,

ORD function,

ORDER BY clause, Ordering, Limiting, and Grouping

ALTER TABLE statement, Reordering rows
GROUP_CONCAT function,
SELECT statement, Ordering SELECT results
UPDATE statement, Single table UPDATE

OUTER keyword

use with LEFT and RIGHT JOINs,

outer query, Subqueries

P

PACK_KEYS option

ALTER TABLE statement, ALTER TABLE: Table options
CREATE TABLE statement, CREATE TABLE: Table options

parser for FULLTEXT indexes, ALTER TABLE: ADD clause for FULLTEXT indexes

parsers

plugin for an index, CREATE TABLE: Index and key definitions

parse_dsn function,

parse_trace_flag function,

parse_trace_flags function,

PARTITION BY clause

ALTER TABLE statement, ALTER TABLE: Partition altering clauses
CREATE TABLE statement, CREATE TABLE: Partitioning

partitions

adding or removing with ALTER TABLE statements, ALTER TABLE: Partition altering clauses
administration clauses, ALTER TABLE statement, ALTER TABLE: Partition administration clauses
CREATE TABLE partition clauses, CREATE TABLE: Partitioning
CREATE TABLE partition definitions, CREATE TABLE: Partition definitions
CREATE TABLE subpartition definitions, CREATE TABLE: Subpartition definitions

PASSWORD function,

passwords

changing on user accounts,
decrypting contents of pwd column,
encrypting a given string with,
encryption method used prior to MySQL 4.1,
providing for user account privileges,
server access,
setting up for user accounts,

paths

MySQL installation on Windows, Windows Distributions
PATH environment variable, The mysql Client

percent sign (%) wildcard, Searching Data

performance optimization options, mysqld, Performance optimization–Performance optimization

PERIOD_ADD function,

PERIOD_DIFF function,

Perl, , Perl API–DBI Dynamic Attributes

attributes for handles, Attributes for Handles

all handles, Attributes for All Handles
database handles, Attributes Only for Database Handles
dynamic attributes, DBI Dynamic Attributes
statement handles, Attributes Only for Statement Handles

DBI module mailing list, Mailing Lists

DBI reference, Perl DBI Reference–

interfacing to MySQL, books on, Books and Other Publications

using DBI with MySQL, Using Perl DBI with MySQL–Temporarily Storing Results

capturing data, Capturing Data
connecting to MySQL, Connecting to MySQL
disconnecting from MySQL, Disconnecting from MySQL
executing SQL statement, Executing an SQL Statement
storing results temporarily, Temporarily Storing Results

PerlDBI module, Part IV, MySQL API

perror utility,

PHP, PHP API–

development with MySQL, resources for information, Books and Other Publications

functions used to query and manipulate MySQL, Part IV, MySQL API

MySQL functions, PHP MySQL Functions in Alphabetical Order–

using with MySQL

connecting to MySQL, Connecting to MySQL
querying MySQL, Querying MySQL

PI function,

ping function,

pinging connections, ,

PKG (binary package) files for installing MySQL on Mac OS X, Macintosh OS X Distributions

placeholders,

in prepared statements,

plugins

parser for FULLTEXT indexes, ALTER TABLE: ADD clause for FULLTEXT indexes
SHOW PLUGINS statement,

point-in-time recovery methods, Replication Process

PORT option, CREATE SERVER statement,

POSITION function,

position identification number, master.info file, Replication Process

postinstallation tasks, Postinstallation

POW function,

POWER function,

powers-of-two algorithm, linear, CREATE TABLE: Partitioning

prepare function,

PREPARE statement,

prepared statements, deleting,

prepare_cached function,

PRESERVE keyword

ON COMPETITION clause, CREATE EVENT,
using with ON COMPLETION clause, ALTER EVENT,

PREV clause, HANDLER…READ statements,

PRIMARY KEY column, Creating a Database and Tables

primary keys

deleting primary key index of a table, ALTER TABLE: DROP index clauses
ID number of last record inserted,
PRIMARY KEY columns, CREATE TABLE: Column flags

primary_key function,

private_attribute_info function,

privileges

replication user account, The Replication User Account
revoking,

PRIVILEGES option, FLUSH statement,

privileges or grant tables, Security and User Statements and Functions

generating, Unix Binary Distributions
setting up for Novell NetWare, Novell NetWare Distributions

PROCEDURE clause, SELECT statement, Other SELECT clauses and options

procedures (see stored procedures)

processes

listing server processes,
terminating based on a given pattern,
terminating by given pid,

programming languages, C, Perl, and PHP, The MySQL Package

protocol version for current connection, ,

PURGE MASTER LOGS statement,

Python, articles on MySQL APIs, Books and Other Publications

Q

QUARTER function, ,

QUERY CACHE option

FLUSH statement,
RESET statement, ,

QUERY keyword, KILL statement,

QUICK keyword

DELETE statement,
using with REPAIR TABLE statement,

quotation marks

neat function,
OPTIONALLY keyword, ENCLOSED BY clause,
QUOTE function,
SQL_SHOW_CREATE variable,
strings for column name patterns,

quote function,

quote_identifier function,

R

RADIANS function,

radians, converting to degrees,

RAID_TYPE option

ALTER TABLE statement, ALTER TABLE: Table options
CREATE TABLE statement, CREATE TABLE: Table options

RAND function,

RANGE subclause, PARTITION BY clause, CREATE TABLE: Partitioning

READ clause, HANDLER statements,

READ COMMITTED isolation level,

READ LOCAL lock,

READ UNCOMMITTED isolation level,

REBUILD PARTITION option, ALTER TABLE statement, ALTER TABLE: Partition administration clauses

Redundant Arrays of Independent Disks (RAID), ALTER TABLE: Table options

REFERENCES keyword, CREATE TABLE: Index and key definitions

REFERENCES option, FOREIGN KEY clause of CREATE TABLE, CREATE TABLE: Foreign key references

regular expressions, Regular Expressions

relational operators, Relational Operators

relay log files

comparison of data to slave server database, Replication Process
controlling processing of, Starting Replication
creation of, Replication Process
deleting on slave server,

relay-log.index file, Replication Process

relay-log.info file, Replication Process

deleting on slave server,

relay.log files, Replication Process

RELEASE SAVEPOINT statement,

RELEASE_LOCK function,

REMOVE PARTITIONING clause, ALTER TABLE statement, ALTER TABLE: Partition altering clauses

RENAME clause, ALTER TABLE statement, Renaming a table

RENAME DATABASE statement,

RENAME TABLE statement,

RENAME USER statement,

REORGANIZE PARTITION clause, ALTER TABLE statement, ALTER TABLE: Partition altering clauses

REPAIR PARTITION clause, ALTER TABLE statement, ALTER TABLE: Partition administration clauses

REPAIR TABLE statement,

REPEAT function,

REPEATABLE READ isolation level,

REPLACE flag, Importing Data in Bulk

REPLACE function, ,

REPLACE keyword, replacing duplicate rows in new table, CREATE TABLE: Based on an existing table

REPLACE statement, Changing Data,

trigger execution and,

replace utility,

replication, Replication Statements and Functions–Slave SQL Thread States

backups of replicated databases on slave server, Backups with Replication

CHANGE MASTER TO statement,

configuring servers, Configuring the Servers

copying databases, Copying Databases and Starting Replication

alternative methods for, Alternative Methods for Making Copies
using mysqldump, Using mysqldump

LOAD DATA FROM MASTER statement (deprecated),

master binary log dump thread states, Master BinLog Dump Thread States

MASTER_POS_WAIT function,

mysqld server options, Replication–Replication

process of, Replication Process–Replication Process

RESET MASTER statement,

RESET SLAVE statement,

server states, Replication States

SET GLOBAL SQL_SLAVE_SKIP_COUNTER statement,

SET SQL_LOG_BIN statement,

SHOW BINARY LOGS statement,

SHOW BINLOG EVENTS statement,

SHOW MASTER LOGS statement,

SHOW MASTER STATUS statement,

SHOW SLAVE HOSTS statement,

SHOW SLAVE STATUS statement,

slave I/O thread states, Slave I/O Thread States

slave SQL thread states, Slave SQL Thread States

START SLAVE statement,

starting, Starting Replication

STOP SLAVE statement,

user account, The Replication User Account

REQUIRE clause, GRANT statement, GRANT: Type of connection restrictions

RESET MASTER option, FLUSH statement,

RESET MASTER statement,

RESET SLAVE option, FLUSH statement,

RESET SLAVE statement,

RESET statement, ,

resolveip utility,

resolve_stack_dump utility,

resources for further information, Books and Other Publications

RESTORE TABLE statement,

RESTRICT keyword, CREATE TABLE: Foreign key references

results set, generating with a subquery, Results Set Subqueries

REVERSE function,

REVOKE statement, ,

privileges, listed, GRANT: Time and number of connection limits

RIGHT function,

RIGHT JOIN statement, ,

rollback function,

ROLLBACK statement,

ROLLBACK TO SAVEPOINT statement,

root user, changing password, Postinstallation

ROUND function,

routines, Stored Routines Statements

rows

setting average row length in a table, ALTER TABLE: Table options
setting minimum and maximum in a table, ALTER TABLE: Table options

rows function,

ROW_COUNT function,

ROW_FORMAT option

ALTER TABLE statement, ALTER TABLE: Table options
CREATE TABLE statement, CREATE TABLE: Table options

RPAD function,

RPM distributions, Linux, Linux RPM Distributions

RTREE index type, CREATE TABLE: Index and key definitions

RTRIM function,

S

savepoints

identifying with SAVEPOINT statement,
releasing,
ROLLBACK TO SAVEPOINT statement,

scalar values returned by subqueries, Single Field Subqueries

SCHEMA function,

SCHEMA keyword, SHOW CREATE SCHEMA,

schemas

database and table, statements and clauses related to, Statements and Clauses in Alphabetical Order–
SHOW SCHEMAS statement,

searching data, Searching Data

SECOND function,

Secure Hash Algorithm (SHA),

security, Security and User Statements and Functions–

functions for, Functions in Alphabetical Order–

mysqld options, Security and connections–Security and connections

user access and privileges, Security and User Statements and Functions

CREATE USER statement,
DROP USER statement,
GRANT statement,
statements and functions, Statements and Functions

user accounts and privileges

FLUSH statement,
statements for, SQL Statements in Alphabetical Order–

SEC_TO_TIME function,

SELECT statements, Selecting Data, –Other SELECT clauses and options

AS clause, Selecting Data
containing a COUNT function, Analyzing and Manipulating Data
EXPLAIN SELECT statement, Creating SPATIAL indexes
FROM clause, Selecting Data
GROUP BY clause, Grouping SELECT results
IGNORE SELECT, CREATE TABLE: Based on an existing table
INTO clause, exporting SELECT results, Exporting SELECT results
JOIN clause, Selecting Data,
LIMIT clause, , Limiting SELECT results
ORDER BY clause, Ordering SELECT results
RELEASE_LOCK function,
subqueries, Subqueries
in subqueries, Deleting Data
UNION keyword,
using with INSERT statement, Inserting rows based on a SELECT
WHERE clause, Selecting Data

selectall_arrayref function,

selectall_hashref function,

selectcol_array function,

selectrow_array function,

selectrow_arrayref function,

selectrow_hashref function,

semicolon (;), ending SQL statements,

SEPARATOR keyword,

SERIAL data type,

SERIALIZABLE isolation level,

server identification number (master server), Configuring the Servers

servers,

(see also mysqld daemon)
changing connection parameters,
enabling or disabling an option,
global server options, Global–Global
mysqld daemon, The MySQL Package
mysql_get_server_info function,
mysql_get_server_version function,
replicated, Merits of Replication
shutting down,
states of master and slave replication servers, Replication States

session variables, ,

SESSION_USER function,

SET CHARACTER SET statement,

SET clause

INSERT statement, Single-row insertion with the SET clause
LOAD DATA INFILE statement,
UPDATE statement, Single table UPDATE, Multiple table UPDATE

SET data type,

SET GLOBAL SQL_SLAVE_SKIP_COUNTER statement,

SET NULL clause, CREATE TABLE statement, CREATE TABLE: Foreign key references

SET PASSWORD statement, ,

SET SQL_LOG_BIN statement,

SET statement, ,

SET statements, Deleting Data

SET TRANSACTION statement,

set_err function,

SHA function,

shell prompts, logging into MySQL, The mysql Client

shell, entering SQL statements into MySQL, Command-Line Interface

short form, mysqld options,

SHOW BINARY LOGS statement,

SHOW BINLOG EVENTS statement,

SHOW CHARACTER SET statement,

SHOW COLLATION statement,

SHOW COLUMNS statement,

SHOW CREATE DATABASE statement,

SHOW CREATE EVENT statement,

SHOW CREATE FUNCTION statement,

SHOW CREATE PROCEDURE statement,

SHOW CREATE TABLE statement, ALTER TABLE: Table options,

SHOW CREATE VIEW statement,

SHOW DATABASES statement, Show Me,

SHOW ENGINE statement,

SHOW ENGINES statement,

SHOW ERRORS statement,

SHOW EVENTS statement,

SHOW FULL COLUMNS statement, CREATE TABLE: Column flags

SHOW FULL TABLES WHERE statement,

SHOW FUNCTION CODE statement,

SHOW FUNCTION STATUS statement,

SHOW GRANTS statement,

SHOW INDEXES statement, ALTER TABLE: ADD clause for standard indexes,

SHOW MASTER LOGS statement, Replication Process,

SHOW MASTER STATUS statement,

SHOW OPEN TABLES statement,

SHOW PLUGINS statement,

SHOW PRIVILEGES statement,

SHOW PROCEDURE CODE statement,

SHOW PROCEDURE STATUS statement,

SHOW PROCESSLIST statement, , Replication States

using with KILL statement,

SHOW SCHEMAS statement,

SHOW SLAVE HOSTS statement,

SHOW SLAVE STATUS statement,

SHOW STATUS statement,

SHOW TABLE STATUS statement, ALTER TABLE: ADD clauses for foreign keys, ,

SHOW TABLES statement, Show Me,

SHOW TRIGGERS statement,

SHOW VARIABLES LIKE statement

server query caching, determining, SELECT statement keywords

SHOW VARIABLES statement,

viewing default character set,

SHOW WARNINGS statement,

SIGN function,

SIN function,

single field subqueries, Single Field Subqueries

SLAVE option

FLUSH statement, deprecated,
RESET statement, ,

slave servers, Merits of Replication

changing settings for master server and replication,
configuration file, Configuring the Servers
displaying information on slave thread,
displaying list for master server,
I/O thread states, Slave I/O Thread States
separation of change entries and their application, Replication Process
SQL thread states, Slave SQL Thread States
starting, Starting Replication

SLEEP function,

SMALLINT data type,

SOME clause, using with multiple fields subqueries, Multiple Fields Subqueries

sorting

data output with ORDER BY clause, Ordering, Limiting, and Grouping
GROUP BY clause, SELECT statement, Grouping SELECT results

SOUNDEX function,

source distributions (MySQL), Choosing a Distribution

source files, configuring to build binary programs, Unix Source Distributions

SPACE function,

SPATIAL indexes, ALTER TABLE: ADD clause for SPATIAL indexes

creating, Creating SPATIAL indexes

SQL SECURITY clause,

SQL SECURITY keyword,

SQL threads, slave server, Replication Process, Slave SQL Thread States

SQL_BUFFER_RESULT keyword, SELECT statement, SELECT statement keywords

SQL_CACHE keyword, SELECT statement, SELECT statement keywords

SQL_CALC_FOUND_ROWS option, SELECT statement, SELECT statement keywords,

SQL_NO_CACHE keyword, SELECT statement, SELECT statement keywords

SQL_QUOTE_SHOW_CREATE variable

SHOW CREATE DATABASE,
SHOW CREATE TABLE,

SQL_SMALL_RESULT keyword, SELECT statement, SELECT statement keywords

SQRT function,

SSL

cipher name,
DES_ENCRYPT function and,
encrypted connections, GRANT: Type of connection restrictions
mysql_ssl_set function,
setting variables with CHANGE MASTER TO,
variables in master.info file, Replication Process

START SLAVE statement, Starting Replication,

START TRANSACTION statement,

unlocking tables,

state method,

statements

data manipulation, Data Manipulation Statements
delimiter, changing,
executing with Perl DBI, Executing an SQL Statement
related to database and table schema, Statements and Clauses in Alphabetical Order–
replication, SQL Statements and Functions in Alphabetical Order–Replication States
restricting user privileges to,
security and user, Statements and Functions
semicolon ending,
stored routines, Stored Routines Statements

statistics_info method,

status information for tables,

STATUS option

FLUSH statement,

STD function,

STDDEV function,

STDDEV_POP function,

STDDEV_SAMP function,

STOP SLAVE statement, Backups with Replication,

storage engines

changing for a table, CREATE TABLE: Table options

changing with ALTER TABLE, ENGINE option, ALTER TABLE: Table options

converting database tables for,

index types, ALTER TABLE: ADD clause for standard indexes

instructing how to store rows of data, ALTER TABLE: Table options

mysqld server options, Storage engine specific options–Other storage engine options

InnoDB, InnoDB
MEMORY and NDB, Other storage engine options
MylSAM, MyISAM

SHOW ENGINE statement,

supporting transactions,

transaction support, Transaction Statements

stored procedures

ALTER PROCEDURE statement,
calling,
CASE statement,
creating,
cursors,
deleting,
displaying information on,
displaying internal code,
IF statement,
SHOW CREATE PROCEDURE statement,
starting and ending,
use of FLUSH statement,
user-defined functions versus,

stored routines, Stored Routines Statements

ALTER EVENT statement, Statements in Alphabetical Order

STRAIGHT_JOIN keyword,

STRCMP function,

string functions, String Functions–

ASCII,
BIN,
BINARY,
BIT_LENGTH,
CAST,
CHAR,
character sets and collation, String Functions Grouped by Type
CHARACTER_LENGTH,
CHARSET,
CHAR_LENGTH,
COALESCE,
COERCIBILITY,
COLLATION,
COMPRESS,
CONCAT,
CONCAT_WS,
conversions, Converting
CONVERT,
CRC,
ELT,
EXPORT_SET,
expressions, Expressions
extraction, Extracting
FIELD,
FIND_IN_SET,
formatting, Formatting
grouped by type, String Functions Grouped by Type
HEX,
INSERT,
INSTR,
INTERVAL,
LCASE,
LEFT,
LENGTH,
LOAD_FILE,
LOCATE,
LOWER,
LPAD,
LTRIM,
MAKE_SET,
manipulating strings, Manipulating
MATCH,
MID,
OCTET_LENGTH,
ORD,
POSITION,
QUOTE,
REPEAT,
REPLACE,
REVERSE,
RIGHT,
RPAD,
RTRIM,
SOUNDEX,
SPACE,
STRCMP,
SUBSTR,
SUBSTRING,
SUBSTRING_INDEX,
TRIM,
UCASE,
UNCOMPRESS,
UNCOMPRESSED_LENGTH,
UNHEX,
UPPER,

strings

character set and collation,
CONCAT function, Selecting Data
data types, String Data Types–

STR_TO_DATE function,

subject, requiring for X.509 certificate, GRANT: Type of connection restrictions

subpartitions, CREATE TABLE: Partitioning

defining with CREATE TABLE, CREATE TABLE: Subpartition definitions

subqueries, Deleting Data, Subqueries–Results Set Subqueries

multiple fields, Multiple Fields Subqueries
results set, Results Set Subqueries
sales data example,
SELECT statement inner query, Subqueries
single field, Single Field Subqueries
using with MAX function,

SUBSTR function,

SUBSTRING function,

SUBSTRING_INDEX function,

SUM function,

Sun Solaris systems, installing MySQL binary distribution, Unix Binary Distributions

swap_inner_handle method,

system variables, ,

SYSTEM_USER function,

T

TABLE option, FLUSH statement,

tables

altering with ALTER TABLE, –ALTER TABLE: Table options
creating in a database, Creating a Database and Tables
deleting with DROP TABLE,
displaying a list of tables and views,
listing for a database, Show Me,
listing in current database,
listing with mysqlshow,
renaming,
revoking user privileges for,
SHOW CREATE TABLE statement,
SHOW TABLE STATUS statement,
user access privileges,

tables function,

TABLES option, FLUSH statement,

TABLES WITH READ LOCK option, FLUSH statement,

tablespaces

discarding or importing, Discarding or importing tablespace
TABLESPACE subclause of CREATE TABLE statement, CREATE TABLE: Partition definitions

table_info function,

take_imp_data method,

TAN function,

TAR package, MySQL installation on Mac OS X, Macintosh OS X Distributions

tar utility, Unix Source Distributions

TEMPORARY flag, DROP TABLE statement,

TEXT data type, Creating a Database and Tables,

TEXT_FIELDS, Importing Data in Bulk

threads

mysql_thread_end function,
mysql_thread_id function,
mysql_thread_init function,
mysql_thread_safe function,

TIME data type, Date and Time Functions, Date and Time Data Types

time zones, converting dates and times between,

TIMESTAMP data type, Date and Time Functions, Date and Time Data Types

TIMESTAMP function,

TIMESTAMPDIFF function,

timestamps, changing time for events,

TINYBLOB data type,

TINYINT data type,

TINYTEXT data type,

TO clause, GRANT statement,

TO keyword (RENAME DATABASE TO),

TO_DAYS function,

trace method,

trace_msg function,

transactions

BEGIN statement,
COMMIT statement,
committing with mysql_commit,
distributed, using XA statement,
ROLLBACK statement,
ROLLBACK TO SAVEPOINT statement,
rolling back with mysql_rollback,
setting isolation level,
START TRANSACTION statement,
statements causing commitment of,
statements for, Transaction Statements

triggers

altering,
creating,
deleting,
displaying on a server,
FLUSH statement and,
starting and ending steps in,
tables renamed and moved to another database,

trimming strings

LTRIM function,
RTRIM function,
TRIM function,

TRUNCATE function,

TRUNCATE statement, ,

TYPE clause, CREATE TABLE: Index and key definitions

TYPE keyword, Creating UNIQUE indexes

type_info method,

type_info_all function,

U

UCASE function,

UNCOMPRESS function,

UNCOMPRESSED_LENGTH function,

UNDO handler,

UNHEX function,

UNION keyword, using with SELECT statements,

UNION option

ALTER TABLE statement, ALTER TABLE: Table options
CREATE TABLE statement, CREATE TABLE: Table options

UNIQUE columns, Changing Data

UNIQUE flag, using to prevent index duplicates,

UNIQUE key columns, CREATE TABLE: Column flags

Universal Time, Coordinated (UTC),

Universal Unique Identifier (UUID),

Unix operating systems

replication server configuration file, Configuring the Servers

Unix systems

entering SQL statements into MySQL through the shell, Command-Line Interface
installing binary distributions of MySQL, Unix Binary Distributions
installing source distributions of MySQL, Unix Source Distributions
main configuration file for MySQL, Postinstallation
server options file,

Unix time,

UNIX_TIMESTAMP function,

UNLOCK TABLES statement, ,

UNTIL clause, START SLAVE statement, Starting Replication

UPDATE statements, Changing Data,

JOIN clause,
MAX_UPDATES_PER_HOUR option, GRANT: Time and number of connection limits
multiple table updates, Multiple table UPDATE
priority over SELECT statements, SELECT statement keywords
SET clause, Single table UPDATE
trigger execution and,

upper case (UCASE) function,

UPPER function,

USAGE keyword, GRANT: Time and number of connection limits

USE INDEX clause, using with JOIN, Index hints

USE statement,

user accounts

changing password,
creating, SQL Statements in Alphabetical Order
creating and setting privileges, The MySQL Package
deleting from MySQL server,
dropped tables and user privileges,
flushing and reloading privileges,
functions for maintenance of, Functions in Alphabetical Order–
granting user privileges,
listing available privileges,
mysql group and system accounts, Unix Source Distributions
replication account, The Replication User Account
revoking privileges,
setting up a user for general use, Postinstallation
statements for maintenance of, SQL Statements in Alphabetical Order–

USER function,

user variables,

user-defined functions,

changing,
deleting,
displaying information on,

user-defined variables, Deleting Data

username,

changing,
specifying in CREATE SERVER statement,

USER_RESOURCES option, FLUSH statement,

USE_FRM option, REPAIR TABLE statement,

USING keyword

DELETE statement,
specifying index type, Creating UNIQUE indexes
using with JOIN,

USING subclause, ALTER TABLE: ADD clause for standard indexes

UTC_DATE function,

UTC_TIME function,

UTC_TIMESTAMP function,

utilities (see command-line utilities)

UUID function,

V

VALUES keyword

CREATE TABLE subclause, CREATE TABLE: Partition definitions
using with REPLACE statement,

VARBINARY data type,

VARCHAR data type,

variables

displaying system variables for MySQL server,
server and environment variables, Server and Environment Variables
setting,
setting for global or session use,
setting for slave server,
user-defined, Deleting Data

VARIANCE function,

VAR_POP function,

VAR_SAMP function,

VERSION function,

vertical bar (|), changing statement delimiter to,

views

creating,
deleting,
displaying a list for the current database,
displaying list of, using SHOW TABLES,
SHOW CREATE VIEW statement,
SHOW TABLE STATUS used with,

W

warning messages, ,

web page for this book, Request for Comments

web sites for MySQL information, Books and Other Publications

WEEK function,

modes,

WEEKDAY function,

WEEKOFYEAR function,

WHERE clause

DELETE statement,

HANDLER…READ statement,

MATCH function,

ORDER BY clause and, Ordering, Limiting, and Grouping

SELECT statement, Selecting Data

SHOW COLUMNS statement,

SHOW DATABASES statement,

SHOW EVENTS statement,

SHOW OPEN TABLES statement,

SHOW PROCEDURE STATUS statement,

SHOW STATUS statement,

SHOW TABLE STATUS statement,

SHOW TABLES statement,

SHOW VARIABLES statement,

single field subquery used with = operator, Single Field Subqueries

UPDATE statement, Single table UPDATE

multiple table updates, Multiple table UPDATE

using with SELECT statements, SELECT statement keywords

using with UPDATE statement, Changing Data

WHERE EXISTS clause, Multiple Fields Subqueries

Widenius, Michael (Monty), Introduction to MySQL

wildcards

asterisk (*),

using with SELECT statements,

percent sign (%), Searching Data

percent sign (%) and _, using with DESCRIBE statement,

using with LIKE clause of SHOW CHARACTER SET,

Windows Essential package, Windows Distributions

Windows systems

installing MySQL, Windows Distributions
main configuration file for MySQL, Postinstallation
replication server configuration file, Configuring the Servers
server options file,

WITH CHECK OPTION clause,

WITH CONSISTENT SNAPSHOT clause,

WITH GRANT OPTION clause,

WITH PARSER clause

ALTER TABLE statement, ALTER TABLE: ADD clause for FULLTEXT indexes
CREATE TABLE statement, CREATE TABLE: Index and key definitions

WITH ROLLUP keyword, GROUP BY clause of SELECT, Grouping SELECT results

WORK keyword

COMMIT statement,
ROLLBACK statement,

WRITE lock,

X

X.509 certificates, GRANT: Type of connection restrictions
XA statement,
XOR, bitwise exclusive OR,

Y

YEAR data type, Date and Time Functions, Date and Time Data Types
YEAR function,
YEARWEEK function,

Previous Chapter

C. Server and Environment Variables

Next Chapter

About the Author

Table of Contents for MySQL in a Nutshell, 2nd Edition

Index

A note on the digital index

Symbols

A

B

C

D

E

F

G

H

I

J

K

L

M

N

O

P

Q

R

S

T

U

V

W

X

Y

Table of Contents for
MySQL in a Nutshell, 2nd Edition