Statement/Syntax Index

A | B | C | D | E | F | G | H | I | K | L | O | P | R | S | T | U

A

[index top]

ALTER DATABASE

Section 12.1.1, “ALTER DATABASE Syntax”
Section 14.8.4, “Binary Log Options and Variables”
Section C.1.26, “Changes in MySQL 4.1.0 (2003-04-03, Alpha)”
Section C.1.24, “Changes in MySQL 4.1.2 (2004-05-28)”
Section C.1.18, “Changes in MySQL 4.1.8 (2004-12-14)”
Section 9.1.3.2, “Database Character Set and Collation”
Section 14.9.1, “Evaluation of Database-Level Replication and Binary Logging Options”
Section 1.9.4, “MySQL Extensions to Standard SQL”
Section 4.6.6, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 14.8.3, “Replication Slave Options and Variables”

ALTER TABLE

Section 12.1.2, “ALTER TABLE Syntax”
Section 13.2.5.3, “AUTO_INCREMENT Handling in InnoDB”
Section C.1.16, “Changes in MySQL 4.1.10 (2005-02-12)”
Section C.1.15, “Changes in MySQL 4.1.11 (2005-04-01)”
Section C.1.14, “Changes in MySQL 4.1.12 (2005-05-13)”
Section C.1.13, “Changes in MySQL 4.1.13 (2005-07-15)”
Section C.1.12, “Changes in MySQL 4.1.14 (2005-08-17)”
Section C.1.11, “Changes in MySQL 4.1.15 (2005-10-13)”
Section C.1.10, “Changes in MySQL 4.1.16 (2005-11-29)”
Section C.1.24, “Changes in MySQL 4.1.2 (2004-05-28)”
Section C.1.5, “Changes in MySQL 4.1.21 (2006-07-19)”
Section C.1.4, “Changes in MySQL 4.1.22 (2006-11-02)”
Section C.1.3, “Changes in MySQL 4.1.23 (2007-06-12)”
Section C.1.2, “Changes in MySQL 4.1.24 (2008-03-01)”
Section C.1.23, “Changes in MySQL 4.1.3 (2004-06-28, Beta)”
Section C.1.20, “Changes in MySQL 4.1.6 (2004-10-10)”
Section C.1.19, “Changes in MySQL 4.1.7 (2004-10-23, Production)”
Section C.1.18, “Changes in MySQL 4.1.8 (2004-12-14)”
Section C.4.3, “Changes in MySQL/InnoDB-4.1.3, June 28, 2004”
Section C.3.44, “Changes in Release 3.23.17 (07 June 2000)”
Section C.3.38, “Changes in Release 3.23.23 (01 September 2000)”
Section C.3.28, “Changes in Release 3.23.33 (09 February 2001)”
Section C.3.27, “Changes in Release 3.23.34 (10 March 2001)”
Section C.3.23, “Changes in Release 3.23.37 (17 April 2001)”
Section C.3.19, “Changes in Release 3.23.41 (11 August 2001)”
Section C.3.18, “Changes in Release 3.23.42 (08 September 2001)”
Section C.3.15, “Changes in Release 3.23.45 (22 November 2001)”
Section C.3.12, “Changes in Release 3.23.48 (07 February 2002)”
Section C.3.56, “Changes in Release 3.23.5 (20 October 1999)”
Section C.3.10, “Changes in Release 3.23.50 (21 April 2002)”
Section C.3.8, “Changes in Release 3.23.52 (14 August 2002)”
Section C.3.7, “Changes in Release 3.23.53 (09 October 2002)”
Section C.3.6, “Changes in Release 3.23.54 (05 December 2002)”
Section C.2.32, “Changes in Release 4.0.0 (October 2001: Alpha)”
Section C.2.31, “Changes in Release 4.0.1 (23 December 2001)”
Section C.2.19, “Changes in Release 4.0.13 (16 May 2003)”
Section C.2.17, “Changes in Release 4.0.15 (03 September 2003)”
Section C.2.15, “Changes in Release 4.0.17 (14 December 2003)”
Section C.2.14, “Changes in Release 4.0.18 (12 February 2004)”
Section C.2.30, “Changes in Release 4.0.2 (01 July 2002)”
Section C.2.11, “Changes in Release 4.0.21 (06 September 2004)”
Section C.2.10, “Changes in Release 4.0.22 (27 October 2004)”
Section C.2.9, “Changes in Release 4.0.23 (18 December 2004)”
Section C.2.7, “Changes in Release 4.0.25 (05 July 2005)”
Section C.2.5, “Changes in Release 4.0.27 (06 May 2006)”
Section C.2.24, “Changes in Release 4.0.8 (07 January 2003)”
Section 12.4.2.3, “CHECK TABLE Syntax”
Section 9.1.3.4, “Column Character Set and Collation”
Section 13.2.9.2, “Consistent Nonlocking Reads”
Section 9.1.11.2, “Converting 4.0 Character Columns to 4.1 Format”
Section 13.2.5.2, “Converting Tables from Other Storage Engines to InnoDB”
Section 12.1.4, “CREATE INDEX Syntax”
Section 12.1.5, “CREATE TABLE Syntax”
Section 3.3.2, “Creating a Table”
Section 16.4.3, “Creating Spatial Columns”
Section 16.6.1, “Creating Spatial Indexes”
Section 15.3.2.5, “Defining MySQL Cluster Data Nodes”
Section 13.2.12.3, “Defragmenting a Table”
Section 12.1.7, “DROP INDEX Syntax”
Section 7.2.2, “EXPLAIN Output Format”
Section 11.9.6, “Fine-Tuning MySQL Full-Text Search”
Section 13.2.7.2, “Forcing InnoDB Recovery”
Section 13.2.5.4, “FOREIGN KEY Constraints”
Section 11.9, “Full-Text Search Functions”
Section 7.11.2, “General Thread States”
Section 12.4.1.2, “GRANT Syntax”
Section B.5.4.3, “How MySQL Handles a Full Disk”
Section 7.5.3.1, “How the Query Cache Operates”
Section 6.6.3, “How to Repair MyISAM Tables”
Section 13.2.5.5, “InnoDB and MySQL Replication”
Section 12.2.4.2, “INSERT DELAYED Syntax”
Section 15.1.4.8, “Issues Exclusive to MySQL Cluster”
Section 12.4.6.3, “KILL Syntax”
Section 15.1.4.9, “Limitations Relating to Multiple MySQL Cluster Nodes”
Section 15.1.4.2, “Limits and Differences of MySQL Cluster from Standard MySQL Limits”
Section 15.1.4.3, “Limits Relating to Transaction Handling in MySQL Cluster”
Section 15.2.4, “Loading Sample Data into MySQL Cluster and Performing Queries”
Section 12.3.5, “LOCK TABLES and UNLOCK TABLES Syntax”
Section 13.3.2, “MERGE Table Problems”
Section 7.4.4, “MyISAM Index Statistics Collection”
Section 13.1.1, “MyISAM Startup Options”
Section 13.1.3, “MyISAM Table Storage Formats”
Section 4.6.2.1, “myisamchk General Options”
Section 15.6, “MySQL 4.1 FAQ: MySQL Cluster”
Section 15.3.2.1, “MySQL Cluster Configuration: Basic Example”
Section 15.2.2, “MySQL Cluster Multi-Computer Configuration”
Section 1.9.4, “MySQL Extensions to Standard SQL”
Section 17.6.6.33, “mysql_info()”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section B.5.8.4, “Open Issues in MySQL”
Section 12.4.2.5, “OPTIMIZE TABLE Syntax”
Section 10.2.5, “Out-of-Range and Overflow Handling”
Section 5.5.1, “Privileges Provided by MySQL”
Section B.5.7.1, “Problems with ALTER TABLE”
Section 2.11.4, “Rebuilding or Repairing Tables or Indexes”
Section 12.1.9, “RENAME TABLE Syntax”
Section 14.7.1, “Replication and AUTO_INCREMENT”
Section 14.7.15, “Replication and Reserved Words”
Section 13.2.15, “Restrictions on InnoDB Tables”
Section 5.1.2, “Server Command Options”
Section 5.1.3, “Server System Variables”
Section 12.4.5.9, “SHOW ENGINE Syntax”
Section 12.4.5.26, “SHOW WARNINGS Syntax”
Section 12.1.5.2, “Silent Column Specification Changes”
Section 12.3.3, “Statements That Cause an Implicit Commit”
Chapter 13, Storage Engines
Section 10.1.3, “String Type Overview”
Section 9.1.3.3, “Table Character Set and Collation”
Section B.5.7.2, “TEMPORARY Table Problems”
Section 13.10, “The ISAM Storage Engine”
Section 13.4, “The MEMORY (HEAP) Storage Engine”
Section 13.1, “The MyISAM Storage Engine”
Section 5.3.5, “The Slow Query Log”
Section B.5.2.12, “The table is full”
Section 10.3.1.1, “TIMESTAMP Properties Prior to MySQL 4.1”
Section 13.2.14.4, “Troubleshooting InnoDB Data Dictionary Operations”
Section 15.1.4.6, “Unsupported or Missing Features in MySQL Cluster”
Section 2.11.1.2, “Upgrading from MySQL 3.23 to 4.0”
Section 2.11.1.1, “Upgrading from MySQL 4.0 to 4.1”
Section 3.6.9, “Using AUTO_INCREMENT”
Section 13.2.3.1, “Using Per-Table Tablespaces”
Section 7.10.2, “Using Symbolic Links for Tables on Unix”
Section B.5.4.2, “What to Do If MySQL Keeps Crashing”
Section B.5.4.4, “Where MySQL Stores Temporary Files”
Section D.3.3, “Windows Platform Limitations”

ALTER TABLE ... AUTO_INCREMENT = n

Section C.1.14, “Changes in MySQL 4.1.12 (2005-05-13)”

ALTER TABLE ... ENABLE/DISABLE KEYS

Section C.2.18, “Changes in Release 4.0.14 (18 July 2003)”

ALTER TABLE DISABLE KEYS

Section C.1.3, “Changes in MySQL 4.1.23 (2007-06-12)”

ALTER TABLE ENABLE KEYS

Section C.1.3, “Changes in MySQL 4.1.23 (2007-06-12)”

ANALYZE TABLE

Section 12.4.2.1, “ANALYZE TABLE Syntax”
Section C.1.25, “Changes in MySQL 4.1.1 (2003-12-01)”
Section C.1.13, “Changes in MySQL 4.1.13 (2005-07-15)”
Section C.1.10, “Changes in MySQL 4.1.16 (2005-11-29)”
Section C.1.24, “Changes in MySQL 4.1.2 (2004-05-28)”
Section C.1.5, “Changes in MySQL 4.1.21 (2006-07-19)”
Section C.1.23, “Changes in MySQL 4.1.3 (2004-06-28, Beta)”
Section C.1.18, “Changes in MySQL 4.1.8 (2004-12-14)”
Section C.1.17, “Changes in MySQL 4.1.9 (2005-01-11)”
Section C.4.16, “Changes in MySQL/InnoDB-4.0.13, May 20, 2003”
Section C.4.3, “Changes in MySQL/InnoDB-4.1.3, June 28, 2004”
Section C.3.38, “Changes in Release 3.23.23 (01 September 2000)”
Section C.3.32, “Changes in Release 3.23.29 (16 December 2000)”
Section C.3.29, “Changes in Release 3.23.32 (22 January 2001)”
Section C.3.14, “Changes in Release 3.23.46 (29 November 2001)”
Section C.2.19, “Changes in Release 4.0.13 (16 May 2003)”
Section C.2.13, “Changes in Release 4.0.19 (04 May 2004)”
Section C.2.8, “Changes in Release 4.0.24 (04 March 2005)”
Section C.2.7, “Changes in Release 4.0.25 (05 July 2005)”
Section 13.5.4, “Characteristics of BDB Tables”
Section 7.2.2, “EXPLAIN Output Format”
Section 11.9.6, “Fine-Tuning MySQL Full-Text Search”
Section 7.11.2, “General Thread States”
Section 13.3.2, “MERGE Table Problems”
Section 7.4.4, “MyISAM Index Statistics Collection”
Section 6.6, “MyISAM Table Maintenance and Crash Recovery”
Section 4.6.2.1, “myisamchk General Options”
Section 1.9.4, “MySQL Extensions to Standard SQL”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section B.5.8.4, “Open Issues in MySQL”
Section 12.4.2.5, “OPTIMIZE TABLE Syntax”
Section 7.2.1, “Optimizing Queries with EXPLAIN”
Section 5.5.1, “Privileges Provided by MySQL”
Section 14.7.5, “Replication and FLUSH”
Section 13.2.15, “Restrictions on InnoDB Tables”
Section 5.1.2, “Server Command Options”
Section 12.4.5.13, “SHOW INDEX Syntax”
Section 7.3.1.1, “Speed of SELECT Statements”
Section 13.10, “The ISAM Storage Engine”
Section 5.3.5, “The Slow Query Log”

B

[index top]

BACKUP TABLE

Section 12.4.2.2, “BACKUP TABLE Syntax”
Section C.3.36, “Changes in Release 3.23.25 (29 September 2000)”
Section C.3.29, “Changes in Release 3.23.32 (22 January 2001)”
Section C.3.4, “Changes in Release 3.23.56 (13 March 2003)”
Section C.2.20, “Changes in Release 4.0.12 (15 March 2003: Production)”
Section 12.4.2.7, “RESTORE TABLE Syntax”
Section 13.10, “The ISAM Storage Engine”
Section 7.10.2, “Using Symbolic Links for Tables on Unix”

BEGIN

Section C.1.25, “Changes in MySQL 4.1.1 (2003-12-01)”
Section C.1.3, “Changes in MySQL 4.1.23 (2007-06-12)”
Section C.1.18, “Changes in MySQL 4.1.8 (2004-12-14)”
Section C.3.44, “Changes in Release 3.23.17 (07 June 2000)”
Section C.3.42, “Changes in Release 3.23.19”
Section C.3.8, “Changes in Release 3.23.52 (14 August 2002)”
Section C.2.21, “Changes in Release 4.0.11 (20 February 2003)”
Section C.2.9, “Changes in Release 4.0.23 (18 December 2004)”
Section 13.5.4, “Characteristics of BDB Tables”
Section 13.2.5.1, “How to Use Transactions in InnoDB with Different APIs”
Section 13.2.13, “InnoDB Error Handling”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 14.7.19, “Replication and Transactions”
Section 5.1.3, “Server System Variables”
Section 12.3.1, “START TRANSACTION, COMMIT, and ROLLBACK Syntax”
Section 12.3.3, “Statements That Cause an Implicit Commit”
Section 13.2.9, “The InnoDB Transaction Model and Locking”

BEGIN WORK

Section C.3.42, “Changes in Release 3.23.19”
Section 12.3.1, “START TRANSACTION, COMMIT, and ROLLBACK Syntax”

C

[index top]

CACHE INDEX

Section 12.4.6.1, “CACHE INDEX Syntax”
Section 7.5.1.4, “Index Preloading”
Section 12.4.6.4, “LOAD INDEX INTO CACHE Syntax”
Section 7.5.1.2, “Multiple Key Caches”

CHANGE MASTER TO

Section 12.5.2.1, “CHANGE MASTER TO Syntax”
Section C.1.18, “Changes in MySQL 4.1.8 (2004-12-14)”
Section C.3.38, “Changes in Release 3.23.23 (01 September 2000)”
Section C.3.36, “Changes in Release 3.23.25 (29 September 2000)”
Section C.3.33, “Changes in Release 3.23.28 (22 November 2000: Gamma)”
Section C.3.3, “Changes in Release 3.23.57 (06 June 2003)”
Section C.2.19, “Changes in Release 4.0.13 (16 May 2003)”
Section C.2.18, “Changes in Release 4.0.14 (18 July 2003)”
Section C.2.17, “Changes in Release 4.0.15 (03 September 2003)”
Section C.2.15, “Changes in Release 4.0.17 (14 December 2003)”
Section C.2.29, “Changes in Release 4.0.3 (26 August 2002: Beta)”
Section C.2.26, “Changes in Release 4.0.6 (14 December 2002: Gamma)”
Section 12.4.1.2, “GRANT Syntax”
Section 14.4, “How to Set Up Replication”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 5.5.1, “Privileges Provided by MySQL”
Section 14.7.10, “Replication and Master or Slave Shutdowns”
Section 14.10, “Replication FAQ”
Section 14.2, “Replication Implementation Overview”
Section 7.11.7, “Replication Slave Connection Thread States”
Section 7.11.5, “Replication Slave I/O Thread States”
Section 14.8.3, “Replication Slave Options and Variables”
Section 12.4.5.21, “SHOW SLAVE STATUS Syntax”
Section 14.3.3, “The Slave Status Files”

CHECK TABLE

Section 13.2.7, “Backing Up and Recovering an InnoDB Database”
Section C.1.14, “Changes in MySQL 4.1.12 (2005-05-13)”
Section C.1.7, “Changes in MySQL 4.1.19 (2006-04-29)”
Section C.1.24, “Changes in MySQL 4.1.2 (2004-05-28)”
Section C.1.5, “Changes in MySQL 4.1.21 (2006-07-19)”
Section C.1.3, “Changes in MySQL 4.1.23 (2007-06-12)”
Section C.1.2, “Changes in MySQL 4.1.24 (2008-03-01)”
Section C.1.23, “Changes in MySQL 4.1.3 (2004-06-28, Beta)”
Section C.1.22, “Changes in MySQL 4.1.4 (2004-08-26, Gamma)”
Section C.4.47, “Changes in MySQL/InnoDB-3.23.39, June 13, 2001”
Section C.4.13, “Changes in MySQL/InnoDB-4.0.15, September 10, 2003”
Section C.4.1, “Changes in MySQL/InnoDB-4.0.21, September 10, 2004”
Section C.4.2, “Changes in MySQL/InnoDB-4.1.4, August 31, 2004”
Section C.3.48, “Changes in Release 3.23.13 (14 March 2000)”
Section C.3.46, “Changes in Release 3.23.15 (08 May 2000)”
Section C.3.45, “Changes in Release 3.23.16 (16 May 2000)”
Section C.3.38, “Changes in Release 3.23.23 (01 September 2000)”
Section C.3.36, “Changes in Release 3.23.25 (29 September 2000)”
Section C.3.35, “Changes in Release 3.23.26 (18 October 2000)”
Section C.3.30, “Changes in Release 3.23.31 (17 January 2001: Production)”
Section C.3.29, “Changes in Release 3.23.32 (22 January 2001)”
Section C.3.27, “Changes in Release 3.23.34 (10 March 2001)”
Section C.3.22, “Changes in Release 3.23.38 (09 May 2001)”
Section C.3.20, “Changes in Release 3.23.40 (18 July 2001)”
Section C.3.16, “Changes in Release 3.23.44 (31 October 2001)”
Section C.3.12, “Changes in Release 3.23.48 (07 February 2002)”
Section C.2.7, “Changes in Release 4.0.25 (05 July 2005)”
Section C.2.27, “Changes in Release 4.0.5 (13 November 2002)”
Section 12.4.2.3, “CHECK TABLE Syntax”
Section 2.11.3, “Checking Whether Tables or Indexes Must Be Rebuilt”
Section 13.1.4.1, “Corrupted MyISAM Tables”
Section 7.6.4, “External Locking”
Section 6.6.3, “How to Repair MyISAM Tables”
Section 1.8, “How to Report Bugs or Problems”
Section 13.2.14.3, “InnoDB General Troubleshooting”
Section 2.7, “Installing MySQL on NetWare”
Section 12.4.6.3, “KILL Syntax”
Section 7.4.4, “MyISAM Index Statistics Collection”
Section 6.6, “MyISAM Table Maintenance and Crash Recovery”
Section 4.6.2, “myisamchk — MyISAM Table-Maintenance Utility”
Section 1.9.4, “MySQL Extensions to Standard SQL”
Section B.5.2.9, “MySQL server has gone away”
Section 17.6.6.67, “mysql_store_result()”
Section 17.6.6.69, “mysql_use_result()”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section 13.1.4.2, “Problems from Tables Not Being Closed Properly”
Section 6.6.5, “Setting Up a MyISAM Table Maintenance Schedule”
Section 13.10, “The ISAM Storage Engine”

CHECK TABLE ... EXTENDED

Section C.3.30, “Changes in Release 3.23.31 (17 January 2001: Production)”
Section 12.4.2.3, “CHECK TABLE Syntax”

CHECKSUM TABLE

Section C.1.25, “Changes in MySQL 4.1.1 (2003-12-01)”
Section C.1.11, “Changes in MySQL 4.1.15 (2005-10-13)”
Section 12.4.2.4, “CHECKSUM TABLE Syntax”
Section 12.1.5, “CREATE TABLE Syntax”

COMMIT

Section C.1.22, “Changes in MySQL 4.1.4 (2004-08-26, Gamma)”
Section C.1.19, “Changes in MySQL 4.1.7 (2004-10-23, Production)”
Section C.1.18, “Changes in MySQL 4.1.8 (2004-12-14)”
Section C.4.32, “Changes in MySQL/InnoDB-3.23.52, August 16, 2002”
Section C.3.8, “Changes in Release 3.23.52 (14 August 2002)”
Section C.2.20, “Changes in Release 4.0.12 (15 March 2003: Production)”
Section C.2.11, “Changes in Release 4.0.21 (06 September 2004)”
Section C.2.10, “Changes in Release 4.0.22 (27 October 2004)”
Section C.2.9, “Changes in Release 4.0.23 (18 December 2004)”
Section C.2.27, “Changes in Release 4.0.5 (13 November 2002)”
Section 13.5.4, “Characteristics of BDB Tables”
Section 13.2.5.1, “How to Use Transactions in InnoDB with Different APIs”
Section 13.2.9.7, “Implicit Transaction Commit and Rollback”
Section 13.2.13, “InnoDB Error Handling”
Section 13.2.14.1, “InnoDB Performance Tuning Tips”
Section 12.3, “MySQL Transactional and Locking Statements”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section B.5.8.4, “Open Issues in MySQL”
Section 14.7.19, “Replication and Transactions”
Section 13.2.15, “Restrictions on InnoDB Tables”
Section 12.3.4, “SAVEPOINT and ROLLBACK TO SAVEPOINT Syntax”
Section 5.1.5, “Server Status Variables”
Section 5.1.3, “Server System Variables”
Section 7.3.2.1, “Speed of INSERT Statements”
Section 12.3.1, “START TRANSACTION, COMMIT, and ROLLBACK Syntax”
Section 12.3.3, “Statements That Cause an Implicit Commit”
Chapter 13, Storage Engines
Section 13.5, “The BDB (BerkeleyDB) Storage Engine”
Section 5.3.4, “The Binary Log”
Section 13.2.9, “The InnoDB Transaction Model and Locking”
Section 1.9.5.4, “Transactions and Atomic Operations”

CREATE DATABASE

Section 6.1, “Backup and Recovery Types”
Section 14.8.4, “Binary Log Options and Variables”
Section 17.6.5, “C API Function Overview”
Section C.1.13, “Changes in MySQL 4.1.13 (2005-07-15)”
Section C.1.11, “Changes in MySQL 4.1.15 (2005-10-13)”
Section C.1.24, “Changes in MySQL 4.1.2 (2004-05-28)”
Section C.1.3, “Changes in MySQL 4.1.23 (2007-06-12)”
Section C.1.18, “Changes in MySQL 4.1.8 (2004-12-14)”
Section C.1.17, “Changes in MySQL 4.1.9 (2005-01-11)”
Section C.3.49, “Changes in Release 3.23.12 (07 March 2000)”
Section C.3.40, “Changes in Release 3.23.21 (04 July 2000)”
Section C.2.16, “Changes in Release 4.0.16 (17 October 2003)”
Section 9.1.5, “Configuring the Character Set and Collation for Applications”
Section 6.4.5.2, “Copy a Database from one Server to Another”
Section 12.1.3, “CREATE DATABASE Syntax”
Section 9.1.3.2, “Database Character Set and Collation”
Section 6.4.1, “Dumping Data in SQL Format with mysqldump”
Section 14.9.1, “Evaluation of Database-Level Replication and Binary Logging Options”
Section 8.2.2, “Identifier Case Sensitivity”
Section 15.1.4.8, “Issues Exclusive to MySQL Cluster”
Section 1.9.4, “MySQL Extensions to Standard SQL”
Section 17.6.6.8, “mysql_create_db()”
Section 4.6.6, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 6.4.2, “Reloading SQL-Format Backups”
Section 14.8.3, “Replication Slave Options and Variables”
Section 9.1.3.1, “Server Character Set and Collation”
Section 12.4.5.6, “SHOW CREATE DATABASE Syntax”
Section 9.1.8.3, “SHOW Statements and INFORMATION_SCHEMA”
Section 12.3.3, “Statements That Cause an Implicit Commit”

CREATE DATABASE dbx

Section 14.9, “How Servers Evaluate Replication Filtering Rules”

CREATE FUNCTION

Section 18.2, “Adding New Functions to MySQL”
Section C.1.16, “Changes in MySQL 4.1.10 (2005-02-12)”
Section C.2.8, “Changes in Release 4.0.24 (04 March 2005)”
Section 18.2.2.5, “Compiling and Installing User-Defined Functions”
Section 1.10.1, “Contributors to MySQL”
Section 12.4.3.1, “CREATE FUNCTION Syntax for User-Defined Functions”
Section 12.4.3.2, “DROP FUNCTION Syntax”
Section 8.2.3, “Function Name Parsing and Resolution”
Section 18.2.2.1, “UDF Calling Sequences for Simple Functions”
Section 2.11.1, “Upgrading MySQL”
Section 18.2.2.6, “User-Defined Function Security Precautions”

CREATE INDEX

Section C.1.15, “Changes in MySQL 4.1.11 (2005-04-01)”
Section C.1.3, “Changes in MySQL 4.1.23 (2007-06-12)”
Section C.3.32, “Changes in Release 3.23.29 (16 December 2000)”
Section C.2.17, “Changes in Release 4.0.15 (03 September 2003)”
Section 12.1.4, “CREATE INDEX Syntax”
Section 16.6.1, “Creating Spatial Indexes”
Section 13.2.5.4, “FOREIGN KEY Constraints”
Section 11.9, “Full-Text Search Functions”
Section 15.1.4.8, “Issues Exclusive to MySQL Cluster”
Section 5.1.3, “Server System Variables”
Section 12.3.3, “Statements That Cause an Implicit Commit”
Section 15.1.4.6, “Unsupported or Missing Features in MySQL Cluster”

CREATE SCHEMA

Section 15.1.4.8, “Issues Exclusive to MySQL Cluster”

CREATE TABLE

Section 12.1.2, “ALTER TABLE Syntax”
Section 13.2.5.3, “AUTO_INCREMENT Handling in InnoDB”
Section 6.1, “Backup and Recovery Types”
Section C.1.26, “Changes in MySQL 4.1.0 (2003-04-03, Alpha)”
Section C.1.16, “Changes in MySQL 4.1.10 (2005-02-12)”
Section C.1.15, “Changes in MySQL 4.1.11 (2005-04-01)”
Section C.1.13, “Changes in MySQL 4.1.13 (2005-07-15)”
Section C.1.11, “Changes in MySQL 4.1.15 (2005-10-13)”
Section C.1.10, “Changes in MySQL 4.1.16 (2005-11-29)”
Section C.1.8, “Changes in MySQL 4.1.18 (2006-01-27)”
Section C.1.7, “Changes in MySQL 4.1.19 (2006-04-29)”
Section C.1.24, “Changes in MySQL 4.1.2 (2004-05-28)”
Section C.1.3, “Changes in MySQL 4.1.23 (2007-06-12)”
Section C.1.19, “Changes in MySQL 4.1.7 (2004-10-23, Production)”
Section C.1.18, “Changes in MySQL 4.1.8 (2004-12-14)”
Section C.4.16, “Changes in MySQL/InnoDB-4.0.13, May 20, 2003”
Section C.4.14, “Changes in MySQL/InnoDB-4.0.14, July 22, 2003”
Section C.4.13, “Changes in MySQL/InnoDB-4.0.15, September 10, 2003”
Section C.4.1, “Changes in MySQL/InnoDB-4.0.21, September 10, 2004”
Section C.4.3, “Changes in MySQL/InnoDB-4.1.3, June 28, 2004”
Section C.3.61, “Changes in Release 3.23.0 (05 July 1999: Alpha)”
Section C.3.58, “Changes in Release 3.23.3 (13 September 1999)”
Section C.2.19, “Changes in Release 4.0.13 (16 May 2003)”
Section C.2.18, “Changes in Release 4.0.14 (18 July 2003)”
Section C.2.17, “Changes in Release 4.0.15 (03 September 2003)”
Section C.2.14, “Changes in Release 4.0.18 (12 February 2004)”
Section C.2.10, “Changes in Release 4.0.22 (27 October 2004)”
Section 9.1.3.4, “Column Character Set and Collation”
Section 7.4.1, “Column Indexes”
Section 12.1.4, “CREATE INDEX Syntax”
Section 12.1.5.1, “CREATE TABLE ... SELECT Syntax”
Section 12.1.5, “CREATE TABLE Syntax”
Section 3.3.2, “Creating a Table”
Section 13.2.5, “Creating and Using InnoDB Tables”
Section 16.4.3, “Creating Spatial Columns”
Section 16.6.1, “Creating Spatial Indexes”
Section 6.2, “Database Backup Methods”
Section 9.1.3.2, “Database Character Set and Collation”
Section 12.7.1, “DESCRIBE Syntax”
Section 6.4.3, “Dumping Data in Delimited-Text Format with mysqldump”
Section 13.2.5.4, “FOREIGN KEY Constraints”
Section 1.9.5.6, “Foreign Keys”
Section 11.9, “Full-Text Search Functions”
Section 3.4, “Getting Information About Databases and Tables”
Section 12.7.3, “HELP Syntax”
Section 7.7.4, “How MySQL Uses Internal Temporary Tables”
Section 8.2.2, “Identifier Case Sensitivity”
Section 13.2.5.5, “InnoDB and MySQL Replication”
Section 13.2.14.3, “InnoDB General Troubleshooting”
Section 13.2.14.1, “InnoDB Performance Tuning Tips”
Section 15.1.4.8, “Issues Exclusive to MySQL Cluster”
Section B.5.8.2, “Issues in MySQL 4.0 Fixed in a Later Version”
Section 15.1.4.9, “Limitations Relating to Multiple MySQL Cluster Nodes”
Section 15.1.4.3, “Limits Relating to Transaction Handling in MySQL Cluster”
Section 3.3.3, “Loading Data into a Table”
Section 7.7.1, “Make Your Data as Small as Possible”
Section 13.1.3, “MyISAM Table Storage Formats”
Section 15.6, “MySQL 4.1 FAQ: MySQL Cluster”
Section 15.3.2.1, “MySQL Cluster Configuration: Basic Example”
Section 15.2.2, “MySQL Cluster Multi-Computer Configuration”
Section 1.9.4, “MySQL Extensions to Standard SQL”
Section 4.5.1.1, “mysql Options”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 5.5.1, “Privileges Provided by MySQL”
Section 6.4.4, “Reloading Delimited-Text Format Backups”
Section 14.7.1, “Replication and AUTO_INCREMENT”
Section 14.7.2, “Replication and Character Sets”
Section 14.7.3, “Replication and DIRECTORY Table Options”
Section 7.11.7, “Replication Slave Connection Thread States”
Section 13.2.15, “Restrictions on InnoDB Tables”
Section 5.1.2, “Server Command Options”
Section 5.1.3, “Server System Variables”
Section 12.4.5.5, “SHOW COLUMNS Syntax”
Section 12.4.5.7, “SHOW CREATE TABLE Syntax”
Section 13.2.14.2, “SHOW ENGINE INNODB STATUS and the InnoDB Monitors”
Section 12.4.5.9, “SHOW ENGINE Syntax”
Section 9.1.8.3, “SHOW Statements and INFORMATION_SCHEMA”
Section 12.4.5.23, “SHOW TABLE STATUS Syntax”
Section 12.4.5.26, “SHOW WARNINGS Syntax”
Section 12.1.5.2, “Silent Column Specification Changes”
Section B.1, “Sources of Error Information”
Section 7.3.2.1, “Speed of INSERT Statements”
Section 12.3.3, “Statements That Cause an Implicit Commit”
Chapter 13, Storage Engines
Section 10.1.3, “String Type Overview”
Section 9.1.3.3, “Table Character Set and Collation”
Section 10.4.4, “The ENUM Type”
Section 13.4, “The MEMORY (HEAP) Storage Engine”
Section 13.1, “The MyISAM Storage Engine”
Section 12.2.8.1, “The Subquery as Scalar Operand”
Section B.5.2.12, “The table is full”
Section 10.3.1.2, “TIMESTAMP Properties as of MySQL 4.1”
Section 13.2.14.4, “Troubleshooting InnoDB Data Dictionary Operations”
Section 15.1.4.6, “Unsupported or Missing Features in MySQL Cluster”
Section 2.11.1.1, “Upgrading from MySQL 4.0 to 4.1”
Section 3.6.9, “Using AUTO_INCREMENT”
Section 3.3.4.9, “Using More Than one Table”
Section 6.4, “Using mysqldump for Backups”
Section 7.10.2, “Using Symbolic Links for Tables on Unix”
Section D.3.3, “Windows Platform Limitations”

CREATE TABLE .. SELECT

Section C.1.18, “Changes in MySQL 4.1.8 (2004-12-14)”

CREATE TABLE ... AS ...

Section C.1.9, “Changes in MySQL 4.1.17 (Not released)”

CREATE TABLE ... AUTO_INCREMENT = n

Section C.1.14, “Changes in MySQL 4.1.12 (2005-05-13)”

CREATE TABLE ... CHECKSUM = 1

Section C.1.25, “Changes in MySQL 4.1.1 (2003-12-01)”

CREATE TABLE ... LIKE

Section C.1.16, “Changes in MySQL 4.1.10 (2005-02-12)”
Section C.1.14, “Changes in MySQL 4.1.12 (2005-05-13)”

CREATE TABLE ... LIKE ...

Section C.1.24, “Changes in MySQL 4.1.2 (2004-05-28)”

CREATE TABLE ... SELECT

Section C.1.26, “Changes in MySQL 4.1.0 (2003-04-03, Alpha)”
Section C.1.13, “Changes in MySQL 4.1.13 (2005-07-15)”
Section C.2.8, “Changes in Release 4.0.24 (04 March 2005)”
Section C.2.7, “Changes in Release 4.0.25 (05 July 2005)”
Section 12.1.5.1, “CREATE TABLE ... SELECT Syntax”
Section B.5.8.4, “Open Issues in MySQL”
Section 1.9.5.2, “SELECT INTO TABLE”
Section 5.1.3, “Server System Variables”

CREATE TABLE ... SELECT ...

Section C.1.10, “Changes in MySQL 4.1.16 (2005-11-29)”
Section C.1.8, “Changes in MySQL 4.1.18 (2006-01-27)”
Section 13.2.9.6, “Locks Set by Different SQL Statements in InnoDB”

CREATE TABLE ... SELECT FROM table

Section C.1.13, “Changes in MySQL 4.1.13 (2005-07-15)”

CREATE TABLE ... SELECT ROUND()

Section C.1.14, “Changes in MySQL 4.1.12 (2005-05-13)”

CREATE TABLE ... TYPE=HEAP ... AS SELECT...

Section C.1.22, “Changes in MySQL 4.1.4 (2004-08-26, Gamma)”

CREATE TABLE created_table

Section C.1.18, “Changes in MySQL 4.1.8 (2004-12-14)”

CREATE TABLE db_name.tbl_name LIKE ...

Section C.1.13, “Changes in MySQL 4.1.13 (2005-07-15)”

CREATE TABLE foo ()

Section C.1.26, “Changes in MySQL 4.1.0 (2003-04-03, Alpha)”

CREATE TABLE t AS SELECT UUID()

Section C.1.13, “Changes in MySQL 4.1.13 (2005-07-15)”

CREATE TABLE table2 ()

Section C.1.25, “Changes in MySQL 4.1.1 (2003-12-01)”

CREATE TABLE tbl_name ()

Section C.1.25, “Changes in MySQL 4.1.1 (2003-12-01)”
Section C.1.10, “Changes in MySQL 4.1.16 (2005-11-29)”

CREATE TEMPORARY TABLE

Section C.1.10, “Changes in MySQL 4.1.16 (2005-11-29)”
Section C.3.45, “Changes in Release 3.23.16 (16 May 2000)”
Section C.3.59, “Changes in Release 3.23.2 (09 August 1999)”
Section 12.4.1.2, “GRANT Syntax”
Section 15.6, “MySQL 4.1 FAQ: MySQL Cluster”
Section 4.6.6, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 6.5, “Point-in-Time (Incremental) Recovery Using the Binary Log”
Section 12.3.3, “Statements That Cause an Implicit Commit”

D

[index top]

DEALLOCATE PREPARE

Section 12.6.3, “DEALLOCATE PREPARE Syntax”
Section 12.6.1, “PREPARE Syntax”
Section 5.1.5, “Server Status Variables”
Section 12.6, “SQL Syntax for Prepared Statements”

DELETE

Section 5.6.2, “Adding User Accounts”
Section 14.8.4, “Binary Log Options and Variables”
Section 17.6.5, “C API Function Overview”
Section 17.6.9, “C API Prepared Statement Function Overview”
Section 5.5.7, “Causes of Access-Denied Errors”
Section C.1.25, “Changes in MySQL 4.1.1 (2003-12-01)”
Section C.1.14, “Changes in MySQL 4.1.12 (2005-05-13)”
Section C.1.11, “Changes in MySQL 4.1.15 (2005-10-13)”
Section C.1.10, “Changes in MySQL 4.1.16 (2005-11-29)”
Section C.1.9, “Changes in MySQL 4.1.17 (Not released)”
Section C.1.7, “Changes in MySQL 4.1.19 (2006-04-29)”
Section C.1.24, “Changes in MySQL 4.1.2 (2004-05-28)”
Section C.1.5, “Changes in MySQL 4.1.21 (2006-07-19)”
Section C.1.4, “Changes in MySQL 4.1.22 (2006-11-02)”
Section C.1.3, “Changes in MySQL 4.1.23 (2007-06-12)”
Section C.1.2, “Changes in MySQL 4.1.24 (2008-03-01)”
Section C.1.23, “Changes in MySQL 4.1.3 (2004-06-28, Beta)”
Section C.1.20, “Changes in MySQL 4.1.6 (2004-10-10)”
Section C.1.18, “Changes in MySQL 4.1.8 (2004-12-14)”
Section C.4.12, “Changes in MySQL/InnoDB-3.23.58, September 15, 2003”
Section C.4.14, “Changes in MySQL/InnoDB-4.0.14, July 22, 2003”
Section C.4.7, “Changes in MySQL/InnoDB-4.0.18, February 13, 2004”
Section C.3.49, “Changes in Release 3.23.12 (07 March 2000)”
Section C.3.46, “Changes in Release 3.23.15 (08 May 2000)”
Section C.3.23, “Changes in Release 3.23.37 (17 April 2001)”
Section C.3.3, “Changes in Release 3.23.57 (06 June 2003)”
Section C.2.32, “Changes in Release 4.0.0 (October 2001: Alpha)”
Section C.2.14, “Changes in Release 4.0.18 (12 February 2004)”
Section C.2.13, “Changes in Release 4.0.19 (04 May 2004)”
Section C.2.30, “Changes in Release 4.0.2 (01 July 2002)”
Section C.2.10, “Changes in Release 4.0.22 (27 October 2004)”
Section C.2.9, “Changes in Release 4.0.23 (18 December 2004)”
Section C.2.8, “Changes in Release 4.0.24 (04 March 2005)”
Section C.2.7, “Changes in Release 4.0.25 (05 July 2005)”
Section C.2.29, “Changes in Release 4.0.3 (26 August 2002: Beta)”
Section C.2, “Changes in Release 4.0.x (Lifecycle Support Ended)”
Section 13.5.4, “Characteristics of BDB Tables”
Section 15.3.2.11, “Configuring MySQL Cluster Parameters for Local Checkpoints”
Section 12.2.1, “DELETE Syntax”
Section B.5.5.6, “Deleting Rows from Related Tables”
Section 13.2.7.2, “Forcing InnoDB Recovery”
Section 13.2.5.4, “FOREIGN KEY Constraints”
Section 1.9.5.6, “Foreign Keys”
Chapter 11, Functions and Operators
Section 7.11.2, “General Thread States”
Section 12.4.1.2, “GRANT Syntax”
Section 7.5.3.1, “How the Query Cache Operates”
Section 13.2.5.5, “InnoDB and MySQL Replication”
Section 13.2.4, “InnoDB Startup Options and System Variables”
Section 7.6.1, “Internal Locking Methods”
Section B.5.8.2, “Issues in MySQL 4.0 Fixed in a Later Version”
Section 12.2.7.1, “JOIN Syntax”
Section 12.4.6.3, “KILL Syntax”
Section 15.1.4.2, “Limits and Differences of MySQL Cluster from Standard MySQL Limits”
Section 13.2.9.6, “Locks Set by Different SQL Statements in InnoDB”
Section 13.3.2, “MERGE Table Problems”
Section 1.5, “MySQL 4.0 in a Nutshell”
Section 15.5.9.3, “MySQL Cluster and MySQL Security Procedures”
Section 1.9.4, “MySQL Extensions to Standard SQL”
Section 4.5.1.1, “mysql Options”
Section 17.6.6.1, “mysql_affected_rows()”
Section 17.6.6.42, “mysql_list_tables()”
Section 17.6.10.10, “mysql_stmt_execute()”
Section 17.6.10.13, “mysql_stmt_field_count()”
Section 17.6.10.17, “mysql_stmt_num_rows()”
Section 15.4.6, “ndb_delete_all — Delete All Rows from an NDB Table”
Section B.5.8.4, “Open Issues in MySQL”
Section 14.7.21, “Other Replication Features”
Section 15.2.6.1, “Performing a Rolling Restart of a MySQL Cluster”
Section 5.5.2, “Privilege System Grant Tables”
Section 5.5.1, “Privileges Provided by MySQL”
Section 5.6.3, “Removing User Accounts”
Section 14.7.7, “Replication and LIMIT”
Section 14.7.11, “Replication and MEMORY Tables”
Section 14.8.3, “Replication Slave Options and Variables”
Section 8.3, “Reserved Words”
Section D.1, “Restrictions on Subqueries”
Section 12.4.1.3, “REVOKE Syntax”
Section 12.2.8.11, “Rewriting Subqueries as Joins for Earlier MySQL Versions”
Section 2.10.3, “Securing the Initial MySQL Accounts”
Section 3.3.4.1, “Selecting All Data”
Section 5.1.2, “Server Command Options”
Section 5.1.5, “Server Status Variables”
Section 5.1.3, “Server System Variables”
Section 12.3.6, “SET TRANSACTION Syntax”
Section 7.3.2.1, “Speed of INSERT Statements”
Section 12.2.8.9, “Subquery Errors”
Section 12.2.8, “Subquery Syntax”
Section 7.6.2, “Table Locking Issues”
Section 13.7, “The ARCHIVE Storage Engine”
Section 5.3.4, “The Binary Log”
Section 1.3.2, “The Main Features of MySQL”
Section 13.4, “The MEMORY (HEAP) Storage Engine”
Section 13.3, “The MERGE Storage Engine”
Section 5.5, “The MySQL Access Privilege System”
Section 5.3.3, “The Update Log”
Section 12.1.10, “TRUNCATE TABLE Syntax”
Section 2.11.1.1, “Upgrading from MySQL 4.0 to 4.1”
Section 4.5.1.6.2, “Using the --safe-updates Option”
Section 17.6.13.2, “What Results You Can Get from a Query”
Section 5.5.6, “When Privilege Changes Take Effect”
Section 7.3.1.2, “WHERE Clause Optimization”
Section 17.6.13.1, “Why mysql_store_result() Sometimes Returns NULL After mysql_query() Returns Success”

DELETE FROM ... WHERE ...

Section 13.2.9.6, “Locks Set by Different SQL Statements in InnoDB”

DESCRIBE

Section 17.6.4, “C API Data Structures”
Section 17.6.5, “C API Function Overview”
Section 13.5.4, “Characteristics of BDB Tables”
Section 12.1.5, “CREATE TABLE Syntax”
Section 3.3.2, “Creating a Table”
Section 12.7.1, “DESCRIBE Syntax”
Section 12.7.2, “EXPLAIN Syntax”
Section 3.4, “Getting Information About Databases and Tables”
Section 7.3.1.10, “LIMIT Optimization”
Section 17.6.10.27, “mysql_stmt_store_result()”
Section 17.6.6.67, “mysql_store_result()”
Section 17.6.6.69, “mysql_use_result()”
Section 7.2.1, “Optimizing Queries with EXPLAIN”
Section 12.4.5.5, “SHOW COLUMNS Syntax”
Section 12.1.5.2, “Silent Column Specification Changes”
Section 10.3.1.1, “TIMESTAMP Properties Prior to MySQL 4.1”
Section 3.6.6, “Using Foreign Keys”
Section 9.1.10, “UTF-8 for Metadata”

DESCRIBE tbl_name

Section 7.2.1, “Optimizing Queries with EXPLAIN”

DO

Section C.1.24, “Changes in MySQL 4.1.2 (2004-05-28)”
Section C.1.18, “Changes in MySQL 4.1.8 (2004-12-14)”
Section 12.2.2, “DO Syntax”
Section 11.14, “Miscellaneous Functions”
Section 1.9.4, “MySQL Extensions to Standard SQL”
Section D.1, “Restrictions on Subqueries”
Section 12.2.8, “Subquery Syntax”

DROP DATABASE

Section 14.8.4, “Binary Log Options and Variables”
Section 17.6.5, “C API Function Overview”
Section C.1.13, “Changes in MySQL 4.1.13 (2005-07-15)”
Section C.1.11, “Changes in MySQL 4.1.15 (2005-10-13)”
Section C.1.24, “Changes in MySQL 4.1.2 (2004-05-28)”
Section C.1.23, “Changes in MySQL 4.1.3 (2004-06-28, Beta)”
Section C.1.18, “Changes in MySQL 4.1.8 (2004-12-14)”
Section C.4.36, “Changes in MySQL/InnoDB-3.23.49, February 17, 2002”
Section C.4.6, “Changes in MySQL/InnoDB-4.0.19, May 4, 2004”
Section C.3.40, “Changes in Release 3.23.21 (04 July 2000)”
Section C.3.32, “Changes in Release 3.23.29 (16 December 2000)”
Section C.3.28, “Changes in Release 3.23.33 (09 February 2001)”
Section C.3.16, “Changes in Release 3.23.44 (31 October 2001)”
Section C.3.9, “Changes in Release 3.23.51 (31 May 2002)”
Section C.3.8, “Changes in Release 3.23.52 (14 August 2002)”
Section C.3.4, “Changes in Release 3.23.56 (13 March 2003)”
Section C.2.32, “Changes in Release 4.0.0 (October 2001: Alpha)”
Section C.2.21, “Changes in Release 4.0.11 (20 February 2003)”
Section C.2.16, “Changes in Release 4.0.16 (17 October 2003)”
Section C.2.15, “Changes in Release 4.0.17 (14 December 2003)”
Section C.2.14, “Changes in Release 4.0.18 (12 February 2004)”
Section C.2.13, “Changes in Release 4.0.19 (04 May 2004)”
Section C.2.30, “Changes in Release 4.0.2 (01 July 2002)”
Section C.2.12, “Changes in Release 4.0.20 (17 May 2004)”
Section C.2.11, “Changes in Release 4.0.21 (06 September 2004)”
Section C.2.7, “Changes in Release 4.0.25 (05 July 2005)”
Section C.2.29, “Changes in Release 4.0.3 (26 August 2002: Beta)”
Section C.2.25, “Changes in Release 4.0.7 (20 December 2002)”
Section 12.1.6, “DROP DATABASE Syntax”
Section 6.4.1, “Dumping Data in SQL Format with mysqldump”
Section 14.9.1, “Evaluation of Database-Level Replication and Binary Logging Options”
Section 7.5.3.1, “How the Query Cache Operates”
Section 13.2.11, “InnoDB Table and Index Structures”
Section 15.1.4.8, “Issues Exclusive to MySQL Cluster”
Section 1.9.4, “MySQL Extensions to Standard SQL”
Section 17.6.6.11, “mysql_drop_db()”
Section 4.6.6, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 6.5, “Point-in-Time (Incremental) Recovery Using the Binary Log”
Section 14.8.3, “Replication Slave Options and Variables”
Section 5.1.3, “Server System Variables”
Section 12.3.3, “Statements That Cause an Implicit Commit”
Section 13.2.14.4, “Troubleshooting InnoDB Data Dictionary Operations”
Section 2.11.1.2, “Upgrading from MySQL 3.23 to 4.0”
Section D.3.3, “Windows Platform Limitations”

DROP FUNCTION

Section 18.2, “Adding New Functions to MySQL”
Section 18.2.2.5, “Compiling and Installing User-Defined Functions”
Section 1.10.1, “Contributors to MySQL”
Section 12.4.3.1, “CREATE FUNCTION Syntax for User-Defined Functions”
Section 12.4.3.2, “DROP FUNCTION Syntax”
Section 8.2.3, “Function Name Parsing and Resolution”
Section 2.11.1, “Upgrading MySQL”
Section 18.2.2.6, “User-Defined Function Security Precautions”

DROP INDEX

Section 12.1.2, “ALTER TABLE Syntax”
Section C.1.15, “Changes in MySQL 4.1.11 (2005-04-01)”
Section C.1.3, “Changes in MySQL 4.1.23 (2007-06-12)”
Section C.3.32, “Changes in Release 3.23.29 (16 December 2000)”
Section 16.6.1, “Creating Spatial Indexes”
Section 12.1.7, “DROP INDEX Syntax”
Section 1.9.4, “MySQL Extensions to Standard SQL”
Section 12.3.3, “Statements That Cause an Implicit Commit”

DROP SCHEMA

Section 15.1.4.8, “Issues Exclusive to MySQL Cluster”

DROP TABLE

Section 12.1.2, “ALTER TABLE Syntax”
Section C.1.16, “Changes in MySQL 4.1.10 (2005-02-12)”
Section C.1.11, “Changes in MySQL 4.1.15 (2005-10-13)”
Section C.1.7, “Changes in MySQL 4.1.19 (2006-04-29)”
Section C.1.5, “Changes in MySQL 4.1.21 (2006-07-19)”
Section C.1.22, “Changes in MySQL 4.1.4 (2004-08-26, Gamma)”
Section C.1.20, “Changes in MySQL 4.1.6 (2004-10-10)”
Section C.4.1, “Changes in MySQL/InnoDB-4.0.21, September 10, 2004”
Section C.4.3, “Changes in MySQL/InnoDB-4.1.3, June 28, 2004”
Section C.3.47, “Changes in Release 3.23.14 (09 April 2000)”
Section C.3.38, “Changes in Release 3.23.23 (01 September 2000)”
Section C.3.32, “Changes in Release 3.23.29 (16 December 2000)”
Section C.3.10, “Changes in Release 3.23.50 (21 April 2002)”
Section C.3.4, “Changes in Release 3.23.56 (13 March 2003)”
Section C.2.32, “Changes in Release 4.0.0 (October 2001: Alpha)”
Section C.2.21, “Changes in Release 4.0.11 (20 February 2003)”
Section C.2.20, “Changes in Release 4.0.12 (15 March 2003: Production)”
Section C.2.18, “Changes in Release 4.0.14 (18 July 2003)”
Section C.2.11, “Changes in Release 4.0.21 (06 September 2004)”
Section 13.2.9.2, “Consistent Nonlocking Reads”
Section 12.1.8, “DROP TABLE Syntax”
Section 13.2.5.4, “FOREIGN KEY Constraints”
Section 7.5.3.1, “How the Query Cache Operates”
Section 13.2.14.1, “InnoDB Performance Tuning Tips”
Section 15.1.4.8, “Issues Exclusive to MySQL Cluster”
Section B.5.8.1, “Issues in MySQL 3.23 Fixed in a Later MySQL Version”
Section 15.1.4.2, “Limits and Differences of MySQL Cluster from Standard MySQL Limits”
Section 12.3.5, “LOCK TABLES and UNLOCK TABLES Syntax”
Section 13.3.2, “MERGE Table Problems”
Section 1.9.4, “MySQL Extensions to Standard SQL”
Section 4.5.1.1, “mysql Options”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 15.4.8, “ndb_drop_index — Drop Index from an NDB Table”
Section 15.4.9, “ndb_drop_table — Drop an NDB Table”
Section B.5.8.4, “Open Issues in MySQL”
Section 5.1.3, “Server System Variables”
Section 12.4.5.21, “SHOW SLAVE STATUS Syntax”
Section 12.4.5.26, “SHOW WARNINGS Syntax”
Section 12.5.2.7, “START SLAVE Syntax”
Section 12.3.3, “Statements That Cause an Implicit Commit”
Section 13.4, “The MEMORY (HEAP) Storage Engine”
Section 13.3, “The MERGE Storage Engine”
Section 13.2.14.4, “Troubleshooting InnoDB Data Dictionary Operations”
Section D.3.3, “Windows Platform Limitations”

DROP TEMPORARY TABLE

Section C.1.24, “Changes in MySQL 4.1.2 (2004-05-28)”

DROP TEMPORARY TABLE IF EXISTS

Section C.1.24, “Changes in MySQL 4.1.2 (2004-05-28)”

DROP USER

Section C.1.9, “Changes in MySQL 4.1.17 (Not released)”
Section 12.4.1.1, “DROP USER Syntax”
Section 12.4.1.2, “GRANT Syntax”
Section 5.6.3, “Removing User Accounts”
Section 14.7.13, “Replication and User Privileges”
Section 12.4.1.3, “REVOKE Syntax”

E

[index top]

EXECUTE

Section C.1.14, “Changes in MySQL 4.1.12 (2005-05-13)”
Section C.1.12, “Changes in MySQL 4.1.14 (2005-08-17)”
Section 12.6.2, “EXECUTE Syntax”
Section 12.6.1, “PREPARE Syntax”
Section 5.1.5, “Server Status Variables”
Section 12.6, “SQL Syntax for Prepared Statements”

EXPLAIN

Section 12.1.2, “ALTER TABLE Syntax”
Section 17.6.4, “C API Data Structures”
Section 17.6.5, “C API Function Overview”
Section C.1.25, “Changes in MySQL 4.1.1 (2003-12-01)”
Section C.1.16, “Changes in MySQL 4.1.10 (2005-02-12)”
Section C.1.15, “Changes in MySQL 4.1.11 (2005-04-01)”
Section C.1.13, “Changes in MySQL 4.1.13 (2005-07-15)”
Section C.1.24, “Changes in MySQL 4.1.2 (2004-05-28)”
Section C.1.5, “Changes in MySQL 4.1.21 (2006-07-19)”
Section C.1.3, “Changes in MySQL 4.1.23 (2007-06-12)”
Section C.1.23, “Changes in MySQL 4.1.3 (2004-06-28, Beta)”
Section C.2.22, “Changes in Release 4.0.10 (29 January 2003)”
Section C.2.17, “Changes in Release 4.0.15 (03 September 2003)”
Section C.2.15, “Changes in Release 4.0.17 (14 December 2003)”
Section C.2.30, “Changes in Release 4.0.2 (01 July 2002)”
Section C.2.8, “Changes in Release 4.0.24 (04 March 2005)”
Section C.2.27, “Changes in Release 4.0.5 (13 November 2002)”
Section 18.4.1, “Debugging a MySQL Server”
Section 7.3.1.9, “DISTINCT Optimization”
Section 7.2.2, “EXPLAIN Output Format”
Section 12.7.2, “EXPLAIN Syntax”
Section 7.7.4, “How MySQL Uses Internal Temporary Tables”
Section 7.3.1.11, “How to Avoid Table Scans”
Section 12.2.7.2, “Index Hint Syntax”
Section 7.3.1.4, “IS NULL Optimization”
Section 4.6.12, “mysql_explain_log — Use EXPLAIN on Statements in Query Log”
Section 17.6.10.27, “mysql_stmt_store_result()”
Section 17.6.6.67, “mysql_store_result()”
Section 17.6.6.69, “mysql_use_result()”
Section B.5.6, “Optimizer-Related Issues”
Section 7.2.1, “Optimizing Queries with EXPLAIN”
Section 12.2.8.10, “Optimizing Subqueries”
Section 7.3.1.7, “ORDER BY Optimization”
Section 7.3.3, “Other Optimization Tips”
Section 4.1, “Overview of MySQL Programs”
Section 12.2.7, “SELECT Syntax”
Section B.5.5.7, “Solving Problems with No Matching Rows”
Section 7.3.1.1, “Speed of SELECT Statements”
Section 12.2.8.8, “Subqueries in the FROM Clause”
Section 1.3.2, “The Main Features of MySQL”
Section 7.3.1.3.2, “The Range Access Method for Multiple-Part Indexes”
Section 16.6.2, “Using a Spatial Index”
Section 18.4.1.5, “Using Server Logs to Find Causes of Errors in mysqld”

EXPLAIN EXTENDED

Section C.1.3, “Changes in MySQL 4.1.23 (2007-06-12)”
Section 12.7.2, “EXPLAIN Syntax”

EXPLAIN SELECT

Section C.1.26, “Changes in MySQL 4.1.0 (2003-04-03, Alpha)”
Section C.1.24, “Changes in MySQL 4.1.2 (2004-05-28)”
Section C.3.17, “Changes in Release 3.23.43 (04 October 2001)”
Section 7.2.2, “EXPLAIN Output Format”
Section 13.2.9.9, “How to Cope with Deadlocks”
Section 1.8, “How to Report Bugs or Problems”
Section 1.9.4, “MySQL Extensions to Standard SQL”
Section 12.2.8.8, “Subqueries in the FROM Clause”

EXPLAIN SELECT ...

Section C.3.46, “Changes in Release 3.23.15 (08 May 2000)”

EXPLAIN SELECT ... ORDER BY

Section 7.3.1.7, “ORDER BY Optimization”

EXPLAIN tbl_name

Section 12.7.2, “EXPLAIN Syntax”
Section 7.2.1, “Optimizing Queries with EXPLAIN”

F

[index top]

FLUSH

Section C.1.25, “Changes in MySQL 4.1.1 (2003-12-01)”
Section C.3.23, “Changes in Release 3.23.37 (17 April 2001)”
Section 6.3.1, “Establishing a Backup Policy”
Section 12.4.6.2, “FLUSH Syntax”
Section 12.4.1.2, “GRANT Syntax”
Section 1.9.4, “MySQL Extensions to Standard SQL”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 5.5.1, “Privileges Provided by MySQL”
Section 14.7.5, “Replication and FLUSH”
Section 12.4.6.5, “RESET Syntax”
Section B.5.4.1.3, “Resetting the Root Password: Generic Instructions”
Section B.5.4.1.2, “Resetting the Root Password: Unix Systems”
Section B.5.4.1.1, “Resetting the Root Password: Windows Systems”
Section 2.10.3, “Securing the Initial MySQL Accounts”
Section 5.1.5, “Server Status Variables”

FLUSH DES_KEY_FILE

Section C.2.31, “Changes in Release 4.0.1 (23 December 2001)”
Section 11.12, “Encryption and Compression Functions”

FLUSH HOSTS

Section B.5.2.6, “Host 'host_name' is blocked”
Section 7.8.5, “How MySQL Uses DNS”
Section 17.6.6.53, “mysql_refresh()”
Section 5.1.3, “Server System Variables”

FLUSH LOGS

Section 6.3.3, “Backup Strategy Summary”
Section C.1.25, “Changes in MySQL 4.1.1 (2003-12-01)”
Section C.3.36, “Changes in Release 3.23.25 (29 September 2000)”
Section C.2.19, “Changes in Release 4.0.13 (16 May 2003)”
Section C.2.18, “Changes in Release 4.0.14 (18 July 2003)”
Section C.2.28, “Changes in Release 4.0.4 (29 September 2002)”
Section 13.5.4, “Characteristics of BDB Tables”
Section 6.2, “Database Backup Methods”
Section 6.3.1, “Establishing a Backup Policy”
Section 12.4.6.2, “FLUSH Syntax”
Section 5.3, “MySQL Server Logs”
Section 17.6.6.53, “mysql_refresh()”
Section 14.7.5, “Replication and FLUSH”
Section 14.7.8, “Replication and LOAD Operations”
Section 5.3.6, “Server Log Maintenance”
Section 5.1.8, “Server Response to Signals”
Section 5.3.1, “The Error Log”
Section 14.3.2, “The Slave Relay Log”

FLUSH MASTER

Section C.1.25, “Changes in MySQL 4.1.1 (2003-12-01)”
Section C.3.42, “Changes in Release 3.23.19”
Section C.3.36, “Changes in Release 3.23.25 (29 September 2000)”
Section C.3.35, “Changes in Release 3.23.26 (18 October 2000)”
Section 12.4.6.2, “FLUSH Syntax”
Section 14.7.5, “Replication and FLUSH”
Section 12.5.1.2, “RESET MASTER Syntax”
Section 12.4.6.5, “RESET Syntax”

FLUSH PRIVILEGES

Section 5.6.2, “Adding User Accounts”
Section 5.6.5, “Assigning Account Passwords”
Section 5.5.7, “Causes of Access-Denied Errors”
Section C.1.13, “Changes in MySQL 4.1.13 (2005-07-15)”
Section C.1.11, “Changes in MySQL 4.1.15 (2005-10-13)”
Section C.1.24, “Changes in MySQL 4.1.2 (2004-05-28)”
Section C.2.22, “Changes in Release 4.0.10 (29 January 2003)”
Section C.2.17, “Changes in Release 4.0.15 (03 September 2003)”
Section B.5.2.4, “Client does not support authentication protocol”
Section 12.4.6.2, “FLUSH Syntax”
Section 7.8.4, “How MySQL Uses Memory”
Section 15.5.9.3, “MySQL Cluster and MySQL Security Procedures”
Section 17.6.6.53, “mysql_refresh()”
Section 17.6.6.54, “mysql_reload()”
Section 5.5.2, “Privilege System Grant Tables”
Section 14.7.5, “Replication and FLUSH”
Section 5.4.4, “Security-Related mysqld Options”
Section 5.1.2, “Server Command Options”
Section 5.1.8, “Server Response to Signals”
Section 5.6.4, “Setting Account Resource Limits”
Section 1.2, “Typographical and Syntax Conventions”
Section 5.5.6, “When Privilege Changes Take Effect”

FLUSH QUERY CACHE

Section C.2.16, “Changes in Release 4.0.16 (17 October 2003)”
Section C.2.30, “Changes in Release 4.0.2 (01 July 2002)”
Section 12.4.6.2, “FLUSH Syntax”
Section 7.5.3.4, “Query Cache Status and Maintenance”

FLUSH SLAVE

Section C.1.25, “Changes in MySQL 4.1.1 (2003-12-01)”
Section C.3.42, “Changes in Release 3.23.19”
Section C.3.35, “Changes in Release 3.23.26 (18 October 2000)”
Section 12.4.6.2, “FLUSH Syntax”
Section 14.7.5, “Replication and FLUSH”
Section 12.5.2.5, “RESET SLAVE Syntax”
Section 12.4.6.5, “RESET Syntax”

FLUSH STATUS

Section 17.6.6.53, “mysql_refresh()”

FLUSH TABLE

Section 12.4.6.2, “FLUSH Syntax”
Section 7.3.2.1, “Speed of INSERT Statements”

FLUSH TABLES

Section C.1.24, “Changes in MySQL 4.1.2 (2004-05-28)”
Section C.1.3, “Changes in MySQL 4.1.23 (2007-06-12)”
Section C.3.46, “Changes in Release 3.23.15 (08 May 2000)”
Section C.3.33, “Changes in Release 3.23.28 (22 November 2000: Gamma)”
Section C.3.24, “Changes in Release 3.23.36 (27 March 2001)”
Section C.3.21, “Changes in Release 3.23.39 (12 June 2001)”
Section C.3.17, “Changes in Release 3.23.43 (04 October 2001)”
Section C.3.5, “Changes in Release 3.23.55 (23 January 2003)”
Section C.2.10, “Changes in Release 4.0.22 (27 October 2004)”
Section C.2.28, “Changes in Release 4.0.4 (29 September 2002)”
Section 6.2, “Database Backup Methods”
Section 12.4.6.2, “FLUSH Syntax”
Section 7.11.2, “General Thread States”
Section 12.2.3, “HANDLER Syntax”
Section 7.7.2, “How MySQL Opens and Closes Tables”
Section 7.8.4, “How MySQL Uses Memory”
Section 14.4, “How to Set Up Replication”
Section 12.2.4.2, “INSERT DELAYED Syntax”
Section 15.1.4.8, “Issues Exclusive to MySQL Cluster”
Section 15.2.4, “Loading Sample Data into MySQL Cluster and Performing Queries”
Section 13.3.2, “MERGE Table Problems”
Section 4.6.2, “myisamchk — MyISAM Table-Maintenance Utility”
Section 17.6.6.53, “mysql_refresh()”
Section 4.6.8, “mysqlhotcopy — A Database Backup Program”
Section 13.1.4.2, “Problems from Tables Not Being Closed Properly”
Section 7.5.3.4, “Query Cache Status and Maintenance”
Section 14.7.5, “Replication and FLUSH”
Section 5.1.3, “Server System Variables”
Section 7.3.2.1, “Speed of INSERT Statements”
Section D.3.3, “Windows Platform Limitations”

FLUSH TABLES WITH READ LOCK

Section C.1.25, “Changes in MySQL 4.1.1 (2003-12-01)”
Section C.1.15, “Changes in MySQL 4.1.11 (2005-04-01)”
Section C.1.14, “Changes in MySQL 4.1.12 (2005-05-13)”
Section C.1.12, “Changes in MySQL 4.1.14 (2005-08-17)”
Section C.1.10, “Changes in MySQL 4.1.16 (2005-11-29)”
Section C.1.22, “Changes in MySQL 4.1.4 (2004-08-26, Gamma)”
Section C.1.19, “Changes in MySQL 4.1.7 (2004-10-23, Production)”
Section C.1.18, “Changes in MySQL 4.1.8 (2004-12-14)”
Section C.3.43, “Changes in Release 3.23.18 (11 June 2000)”
Section C.2.32, “Changes in Release 4.0.0 (October 2001: Alpha)”
Section C.2.11, “Changes in Release 4.0.21 (06 September 2004)”
Section C.2.10, “Changes in Release 4.0.22 (27 October 2004)”
Section C.2.9, “Changes in Release 4.0.23 (18 December 2004)”
Section C.2.7, “Changes in Release 4.0.25 (05 July 2005)”
Section 6.2, “Database Backup Methods”
Section 6.3.1, “Establishing a Backup Policy”
Section 12.4.6.2, “FLUSH Syntax”
Section 7.11.2, “General Thread States”
Section 14.4, “How to Set Up Replication”
Section 12.3.5.1, “Interaction of Table Locking and Transactions”
Section B.5.8.2, “Issues in MySQL 4.0 Fixed in a Later Version”
Section 12.3.5, “LOCK TABLES and UNLOCK TABLES Syntax”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section B.5.8.4, “Open Issues in MySQL”
Section 14.7.5, “Replication and FLUSH”
Section 12.3.1, “START TRANSACTION, COMMIT, and ROLLBACK Syntax”
Section 12.3.3, “Statements That Cause an Implicit Commit”
Section 14.6.1, “Upgrading Replication to 4.0 or 4.1”

FLUSH USER_RESOURCES

Section 12.4.6.2, “FLUSH Syntax”
Section 5.6.4, “Setting Account Resource Limits”

G

[index top]

GRANT

Section 5.5.5, “Access Control, Stage 2: Request Verification”
Section 5.6.2, “Adding User Accounts”
Section 5.4.2.1, “Administrator Guidelines for Password Security”
Section 5.6.5, “Assigning Account Passwords”
Section 5.5.7, “Causes of Access-Denied Errors”
Section C.1.25, “Changes in MySQL 4.1.1 (2003-12-01)”
Section C.1.15, “Changes in MySQL 4.1.11 (2005-04-01)”
Section C.1.11, “Changes in MySQL 4.1.15 (2005-10-13)”
Section C.1.24, “Changes in MySQL 4.1.2 (2004-05-28)”
Section C.1.3, “Changes in MySQL 4.1.23 (2007-06-12)”
Section C.3.57, “Changes in Release 3.23.4 (28 September 1999)”
Section C.3.9, “Changes in Release 3.23.51 (31 May 2002)”
Section C.3.7, “Changes in Release 3.23.53 (09 October 2002)”
Section C.3.52, “Changes in Release 3.23.9 (29 January 2000)”
Section C.2.31, “Changes in Release 4.0.1 (23 December 2001)”
Section C.2.19, “Changes in Release 4.0.13 (16 May 2003)”
Section C.2.17, “Changes in Release 4.0.15 (03 September 2003)”
Section C.2.7, “Changes in Release 4.0.25 (05 July 2005)”
Section C.2.29, “Changes in Release 4.0.3 (26 August 2002: Beta)”
Section C.2.28, “Changes in Release 4.0.4 (29 September 2002)”
Section C.2.26, “Changes in Release 4.0.6 (14 December 2002: Gamma)”
Section C.2, “Changes in Release 4.0.x (Lifecycle Support Ended)”
Section 12.4.1.1, “DROP USER Syntax”
Section 5.4.2.2, “End-User Guidelines for Password Security”
Section 12.4.6.2, “FLUSH Syntax”
Section 5.4.1, “General Security Guidelines”
Section 12.4.1.2, “GRANT Syntax”
Section 7.8.4, “How MySQL Uses Memory”
Section 14.4, “How to Set Up Replication”
Section 5.4.3, “Making MySQL Secure Against Attackers”
Section 15.5.9.2, “MySQL Cluster and MySQL Privileges”
Section 7.3.1, “Optimizing SELECT Statements”
Section 5.4.2.3, “Password Hashing in MySQL”
Section 5.5.2, “Privilege System Grant Tables”
Section 5.5.1, “Privileges Provided by MySQL”
Section 2.10.2.1, “Problems Running mysql_install_db”
Section 14.7.5, “Replication and FLUSH”
Section 14.7.13, “Replication and User Privileges”
Section 12.4.1.3, “REVOKE Syntax”
Section 5.4.4, “Security-Related mysqld Options”
Section 5.1.2, “Server Command Options”
Section 12.4.1.4, “SET PASSWORD Syntax”
Section 5.6.4, “Setting Account Resource Limits”
Section 12.4.5.12, “SHOW GRANTS Syntax”
Section 5.5.3, “Specifying Account Names”
Section 5.6.6.3, “SSL Command Options”
Section 5.5, “The MySQL Access Privilege System”
Section 2.11.1.2, “Upgrading from MySQL 3.23 to 4.0”
Section 5.6.1, “User Names and Passwords”
Section 5.6.6.2, “Using SSL Connections”
Section 5.6.6, “Using SSL for Secure Connections”
Section 5.5.6, “When Privilege Changes Take Effect”

GRANT ALL

Section 12.4.1.2, “GRANT Syntax”

GRANT USAGE

Section 5.6.2, “Adding User Accounts”
Section 5.6.5, “Assigning Account Passwords”
Section 12.4.1.2, “GRANT Syntax”
Section 5.6.4, “Setting Account Resource Limits”

H

[index top]

HANDLER

Section C.4.31, “Changes in MySQL/InnoDB-4.0.3, August 28, 2002”
Section C.2.32, “Changes in Release 4.0.0 (October 2001: Alpha)”
Section C.2.31, “Changes in Release 4.0.1 (23 December 2001)”
Section C.2.22, “Changes in Release 4.0.10 (29 January 2003)”
Section C.2.18, “Changes in Release 4.0.14 (18 July 2003)”
Section C.2.15, “Changes in Release 4.0.17 (14 December 2003)”
Section C.2.14, “Changes in Release 4.0.18 (12 February 2004)”
Section C.2.10, “Changes in Release 4.0.22 (27 October 2004)”
Section 17.6.14, “Controlling Automatic Reconnection Behavior”
Section 12.2.3, “HANDLER Syntax”
Section 1.9, “MySQL Standards Compliance”
Section 17.6.6.3, “mysql_change_user()”

HANDLER ... CLOSE

Section 12.4.5.17, “SHOW OPEN TABLES Syntax”

HANDLER ... OPEN

Section 12.4.5.17, “SHOW OPEN TABLES Syntax”

HELP

Section C.1, “Changes in Release 4.1.x (Lifecycle Support Ended)”
Section 12.7.3, “HELP Syntax”
Section 1.6, “MySQL 4.1 in a Nutshell”
Section 5.1.7, “Server-Side Help”

I

[index top]

INSERT

Section 5.5.5, “Access Control, Stage 2: Request Verification”
Section 5.6.2, “Adding User Accounts”
Section 5.6.5, “Assigning Account Passwords”
Section 13.2.5.3, “AUTO_INCREMENT Handling in InnoDB”
Section 6.1, “Backup and Recovery Types”
Section 17.6.5, “C API Function Overview”
Section 17.6.9, “C API Prepared Statement Function Overview”
Section 17.6.15, “C API Support for Multiple Statement Execution”
Section 5.5.7, “Causes of Access-Denied Errors”
Section C.1.25, “Changes in MySQL 4.1.1 (2003-12-01)”
Section C.1.13, “Changes in MySQL 4.1.13 (2005-07-15)”
Section C.1.10, “Changes in MySQL 4.1.16 (2005-11-29)”
Section C.1.9, “Changes in MySQL 4.1.17 (Not released)”
Section C.1.24, “Changes in MySQL 4.1.2 (2004-05-28)”
Section C.1.5, “Changes in MySQL 4.1.21 (2006-07-19)”
Section C.1.4, “Changes in MySQL 4.1.22 (2006-11-02)”
Section C.1.3, “Changes in MySQL 4.1.23 (2007-06-12)”
Section C.1.23, “Changes in MySQL 4.1.3 (2004-06-28, Beta)”
Section C.1.20, “Changes in MySQL 4.1.6 (2004-10-10)”
Section C.1.18, “Changes in MySQL 4.1.8 (2004-12-14)”
Section C.1.17, “Changes in MySQL 4.1.9 (2005-01-11)”
Section C.4.14, “Changes in MySQL/InnoDB-4.0.14, July 22, 2003”
Section C.4.7, “Changes in MySQL/InnoDB-4.0.18, February 13, 2004”
Section C.3.50, “Changes in Release 3.23.11 (16 February 2000)”
Section C.3.40, “Changes in Release 3.23.21 (04 July 2000)”
Section C.3.35, “Changes in Release 3.23.26 (18 October 2000)”
Section C.3.33, “Changes in Release 3.23.28 (22 November 2000: Gamma)”
Section C.3.20, “Changes in Release 3.23.40 (18 July 2001)”
Section C.3.3, “Changes in Release 3.23.57 (06 June 2003)”
Section C.3.54, “Changes in Release 3.23.7 (10 December 1999)”
Section C.2.32, “Changes in Release 4.0.0 (October 2001: Alpha)”
Section C.2.18, “Changes in Release 4.0.14 (18 July 2003)”
Section C.2.17, “Changes in Release 4.0.15 (03 September 2003)”
Section C.2.14, “Changes in Release 4.0.18 (12 February 2004)”
Section C.2.10, “Changes in Release 4.0.22 (27 October 2004)”
Section C.2.8, “Changes in Release 4.0.24 (04 March 2005)”
Section C.2.7, “Changes in Release 4.0.25 (05 July 2005)”
Section C.2.4, “Changes in Release 4.0.28 (Not released)”
Section C.2.29, “Changes in Release 4.0.3 (26 August 2002: Beta)”
Section C.2.28, “Changes in Release 4.0.4 (29 September 2002)”
Section C.2, “Changes in Release 4.0.x (Lifecycle Support Ended)”
Section 7.6.3, “Concurrent Inserts”
Section 15.3.2.11, “Configuring MySQL Cluster Parameters for Local Checkpoints”
Section 1.9.6.2, “Constraints on Invalid Data”
Section 12.1.4, “CREATE INDEX Syntax”
Section 10.1.2, “Date and Time Type Overview”
Section 12.2.1, “DELETE Syntax”
Section 6.3.1, “Establishing a Backup Policy”
Section 13.2.7.2, “Forcing InnoDB Recovery”
Section 13.2.5.4, “FOREIGN KEY Constraints”
Section 1.9.5.6, “Foreign Keys”
Section 7.11.2, “General Thread States”
Section 12.4.1.2, “GRANT Syntax”
Section 7.5.3.1, “How the Query Cache Operates”
Section 17.6.13.3, “How to Get the Unique ID for the Last Inserted Row”
Section 13.2.5.1, “How to Use Transactions in InnoDB with Different APIs”
Section 11.13, “Information Functions”
Section 13.2.13.1, “InnoDB Error Codes”
Section 13.2.14.1, “InnoDB Performance Tuning Tips”
Section 13.2.9.4, “InnoDB Record, Gap, and Next-Key Locks”
Section 13.2.4, “InnoDB Startup Options and System Variables”
Section 12.2.4.3, “INSERT ... ON DUPLICATE KEY UPDATE Syntax”
Section 12.2.4.1, “INSERT ... SELECT Syntax”
Section 12.2.4.2, “INSERT DELAYED Syntax”
Section 12.2.4, “INSERT Syntax”
Section 7.6.1, “Internal Locking Methods”
Section 12.2.5, “LOAD DATA INFILE Syntax”
Section 3.3.3, “Loading Data into a Table”
Section 15.2.4, “Loading Sample Data into MySQL Cluster and Performing Queries”
Section 12.3.5, “LOCK TABLES and UNLOCK TABLES Syntax”
Section 13.2.9.6, “Locks Set by Different SQL Statements in InnoDB”
Section 13.3.2, “MERGE Table Problems”
Section 11.14, “Miscellaneous Functions”
Section 1.5, “MySQL 4.0 in a Nutshell”
Section 7.1.1, “MySQL Design Limitations and Tradeoffs”
Section 1.9.4, “MySQL Extensions to Standard SQL”
Section 4.5.1.1, “mysql Options”
Section B.5.2.9, “MySQL server has gone away”
Section 17.6.6.1, “mysql_affected_rows()”
Section 17.6.6.35, “mysql_insert_id()”
Section 17.6.6.42, “mysql_list_tables()”
Section 17.6.10.10, “mysql_stmt_execute()”
Section 17.6.10.13, “mysql_stmt_field_count()”
Section 17.6.10.16, “mysql_stmt_insert_id()”
Section 17.6.10.17, “mysql_stmt_num_rows()”
Section 17.6.10.20, “mysql_stmt_prepare()”
Section 17.6.6.67, “mysql_store_result()”
Section 4.6.6, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 12.4.2.5, “OPTIMIZE TABLE Syntax”
Section 7.3.3, “Other Optimization Tips”
Section 10.2.5, “Out-of-Range and Overflow Handling”
Section 15.2.6.1, “Performing a Rolling Restart of a MySQL Cluster”
Section 16.4.4, “Populating Spatial Columns”
Section 1.9.6.1, “PRIMARY KEY and UNIQUE Index Constraints”
Section 5.5.2, “Privilege System Grant Tables”
Section 12.2.6, “REPLACE Syntax”
Section 14.7.6, “Replication and System Functions”
Section 14.9.3, “Replication Rule Application”
Section D.1, “Restrictions on Subqueries”
Section 5.1.2, “Server Command Options”
Section 5.1.5, “Server Status Variables”
Section 5.1.3, “Server System Variables”
Section 12.4.5.26, “SHOW WARNINGS Syntax”
Section 7.3.2.1, “Speed of INSERT Statements”
Section 11.5, “String Functions”
Section 12.2.8, “Subquery Syntax”
Section 7.6.2, “Table Locking Issues”
Section 9.1.7.6, “The _bin and binary Collations”
Section 13.7, “The ARCHIVE Storage Engine”
Section 5.3.4, “The Binary Log”
Section 1.3.2, “The Main Features of MySQL”
Section 13.3, “The MERGE Storage Engine”
Section 13.1, “The MyISAM Storage Engine”
Section 5.5, “The MySQL Access Privilege System”
Section 7.5.3, “The MySQL Query Cache”
Section 5.1.9, “The Shutdown Process”
Section 10.3.1.1, “TIMESTAMP Properties Prior to MySQL 4.1”
Section 17.6.13.2, “What Results You Can Get from a Query”
Section 5.5.6, “When Privilege Changes Take Effect”
Section 17.6.13.1, “Why mysql_store_result() Sometimes Returns NULL After mysql_query() Returns Success”
Section D.3.3, “Windows Platform Limitations”

INSERT ... ON DUPLICATE KEY UPDATE

Section C.1.14, “Changes in MySQL 4.1.12 (2005-05-13)”
Section C.1.13, “Changes in MySQL 4.1.13 (2005-07-15)”
Section C.1.24, “Changes in MySQL 4.1.2 (2004-05-28)”
Section C.1.4, “Changes in MySQL 4.1.22 (2006-11-02)”
Section C.1.23, “Changes in MySQL 4.1.3 (2004-06-28, Beta)”
Section C.1.18, “Changes in MySQL 4.1.8 (2004-12-14)”
Section 11.13, “Information Functions”
Section 12.2.4.3, “INSERT ... ON DUPLICATE KEY UPDATE Syntax”
Section 12.2.4.2, “INSERT DELAYED Syntax”
Section 12.2.4, “INSERT Syntax”
Section 13.2.9.6, “Locks Set by Different SQL Statements in InnoDB”
Section 13.3.2, “MERGE Table Problems”
Section 11.14, “Miscellaneous Functions”
Section 17.6.6.1, “mysql_affected_rows()”
Section 12.2.6, “REPLACE Syntax”

INSERT ... SELECT

Section C.1.16, “Changes in MySQL 4.1.10 (2005-02-12)”
Section C.1.13, “Changes in MySQL 4.1.13 (2005-07-15)”
Section C.1.9, “Changes in MySQL 4.1.17 (Not released)”
Section C.1.24, “Changes in MySQL 4.1.2 (2004-05-28)”
Section C.1.23, “Changes in MySQL 4.1.3 (2004-06-28, Beta)”
Section C.1.18, “Changes in MySQL 4.1.8 (2004-12-14)”
Section C.3.24, “Changes in Release 3.23.36 (27 March 2001)”
Section C.3.1, “Changes in Release 3.23.59 (Not released)”
Section C.2.20, “Changes in Release 4.0.12 (15 March 2003: Production)”
Section C.2.18, “Changes in Release 4.0.14 (18 July 2003)”
Section C.2.17, “Changes in Release 4.0.15 (03 September 2003)”
Section C.2.15, “Changes in Release 4.0.17 (14 December 2003)”
Section C.2.30, “Changes in Release 4.0.2 (01 July 2002)”
Section C.2.11, “Changes in Release 4.0.21 (06 September 2004)”
Section C.2.5, “Changes in Release 4.0.27 (06 May 2006)”
Section 7.6.3, “Concurrent Inserts”
Section 12.2.4.1, “INSERT ... SELECT Syntax”
Section 12.2.4.2, “INSERT DELAYED Syntax”
Section 12.2.4, “INSERT Syntax”
Section 13.2.9.6, “Locks Set by Different SQL Statements in InnoDB”
Section B.5.8.4, “Open Issues in MySQL”
Section 14.7.7, “Replication and LIMIT”
Section 5.1.3, “Server System Variables”
Section 5.3.4, “The Binary Log”

INSERT ... SET

Section 12.2.4, “INSERT Syntax”

INSERT ... VALUES

Section 12.2.4, “INSERT Syntax”
Section 17.6.6.33, “mysql_info()”

INSERT DELAYED

Section 12.1.2, “ALTER TABLE Syntax”
Section C.1.14, “Changes in MySQL 4.1.12 (2005-05-13)”
Section C.1.24, “Changes in MySQL 4.1.2 (2004-05-28)”
Section C.1.3, “Changes in MySQL 4.1.23 (2007-06-12)”
Section C.1.17, “Changes in MySQL 4.1.9 (2005-01-11)”
Section C.3.46, “Changes in Release 3.23.15 (08 May 2000)”
Section C.3.44, “Changes in Release 3.23.17 (07 June 2000)”
Section C.3.27, “Changes in Release 3.23.34 (10 March 2001)”
Section C.3.23, “Changes in Release 3.23.37 (17 April 2001)”
Section C.3.21, “Changes in Release 3.23.39 (12 June 2001)”
Section C.3.18, “Changes in Release 3.23.42 (08 September 2001)”
Section C.3.17, “Changes in Release 3.23.43 (04 October 2001)”
Section C.3.14, “Changes in Release 3.23.46 (29 November 2001)”
Section C.3.54, “Changes in Release 3.23.7 (10 December 1999)”
Section C.3.53, “Changes in Release 3.23.8 (02 January 2000)”
Section C.3.52, “Changes in Release 3.23.9 (29 January 2000)”
Section C.2.20, “Changes in Release 4.0.12 (15 March 2003: Production)”
Section C.2.18, “Changes in Release 4.0.14 (18 July 2003)”
Section C.2.13, “Changes in Release 4.0.19 (04 May 2004)”
Section C.2.7, “Changes in Release 4.0.25 (05 July 2005)”
Section C.2.27, “Changes in Release 4.0.5 (13 November 2002)”
Section 7.11.3, “Delayed-Insert Thread States”
Section 12.2.4.2, “INSERT DELAYED Syntax”
Section 12.2.4, “INSERT Syntax”
Section 12.4.6.3, “KILL Syntax”
Section 2.12.1.3, “Linux Source Distribution Notes”
Section 13.3.2, “MERGE Table Problems”
Section 18.1.1, “MySQL Threads”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section B.5.8.4, “Open Issues in MySQL”
Section 7.3.3, “Other Optimization Tips”
Section 5.1.5, “Server Status Variables”
Section 5.1.3, “Server System Variables”
Section 7.3.2.1, “Speed of INSERT Statements”
Section 7.6.2, “Table Locking Issues”
Section 12.3.5.2, “Table-Locking Restrictions and Conditions”
Section 13.7, “The ARCHIVE Storage Engine”
Section 13.4, “The MEMORY (HEAP) Storage Engine”
Section 1.9.5.4, “Transactions and Atomic Operations”

INSERT IGNORE

Section C.1.18, “Changes in MySQL 4.1.8 (2004-12-14)”
Section C.2.9, “Changes in Release 4.0.23 (18 December 2004)”
Section 11.13, “Information Functions”
Section 12.2.4, “INSERT Syntax”
Section 4.5.4, “mysqldump — A Database Backup Program”

INSERT INTO ... SELECT

Section 5.5.5, “Access Control, Stage 2: Request Verification”
Section C.1.14, “Changes in MySQL 4.1.12 (2005-05-13)”
Section C.1.1, “Changes in MySQL 4.1.25 (2008-12-01)”
Section C.3.61, “Changes in Release 3.23.0 (05 July 1999: Alpha)”
Section C.2.31, “Changes in Release 4.0.1 (23 December 2001)”
Section 1.9.6.2, “Constraints on Invalid Data”
Section 12.2.4, “INSERT Syntax”
Section 1.9.5.2, “SELECT INTO TABLE”
Section 5.1.3, “Server System Variables”
Section 13.4, “The MEMORY (HEAP) Storage Engine”
Section 2.11.1.2, “Upgrading from MySQL 3.23 to 4.0”

INSERT INTO ... SELECT ...

Section 17.6.6.33, “mysql_info()”
Section 17.6.13.2, “What Results You Can Get from a Query”

K

[index top]

KILL

Section C.1.22, “Changes in MySQL 4.1.4 (2004-08-26, Gamma)”
Section C.3.44, “Changes in Release 3.23.17 (07 June 2000)”
Section C.3.4, “Changes in Release 3.23.56 (13 March 2003)”
Section C.2.20, “Changes in Release 4.0.12 (15 March 2003: Production)”
Section C.2.11, “Changes in Release 4.0.21 (06 September 2004)”
Section 7.11.2, “General Thread States”
Section 12.4.1.2, “GRANT Syntax”
Section B.5.8.1, “Issues in MySQL 3.23 Fixed in a Later MySQL Version”
Section 12.4.6.3, “KILL Syntax”
Section B.5.2.9, “MySQL server has gone away”
Section 17.6.6.36, “mysql_kill()”
Section 4.6.18, “mysql_zap — Kill Processes That Match a Pattern”
Section 5.5.1, “Privileges Provided by MySQL”
Section 12.4.5.19, “SHOW PROCESSLIST Syntax”
Section 12.3.5.2, “Table-Locking Restrictions and Conditions”

L

[index top]

LOAD DATA

Section C.1.25, “Changes in MySQL 4.1.1 (2003-12-01)”
Section C.1.3, “Changes in MySQL 4.1.23 (2007-06-12)”
Section C.1.2, “Changes in MySQL 4.1.24 (2008-03-01)”
Section C.3.22, “Changes in Release 3.23.38 (09 May 2001)”
Section C.2.22, “Changes in Release 4.0.10 (29 January 2003)”
Section C.2.20, “Changes in Release 4.0.12 (15 March 2003: Production)”
Section C.2.18, “Changes in Release 4.0.14 (18 July 2003)”
Section C.2.16, “Changes in Release 4.0.16 (17 October 2003)”
Section C.2.14, “Changes in Release 4.0.18 (12 February 2004)”
Section C.2.30, “Changes in Release 4.0.2 (01 July 2002)”
Section C.2.11, “Changes in Release 4.0.21 (06 September 2004)”
Section 7.6.3, “Concurrent Inserts”
Section 13.2.5.4, “FOREIGN KEY Constraints”
Section 12.2.5, “LOAD DATA INFILE Syntax”
Section 3.3.3, “Loading Data into a Table”
Section 5.4.3, “Making MySQL Secure Against Attackers”
Section B.5.8.4, “Open Issues in MySQL”
Section 5.4.5, “Security Issues with LOAD DATA LOCAL”
Section 5.4.4, “Security-Related mysqld Options”
Section 3.3.4.1, “Selecting All Data”
Section 10.4.4, “The ENUM Type”
Section 8.4, “User-Defined Variables”

LOAD DATA FROM MASTER

Section 7.11.7, “Replication Slave Connection Thread States”

LOAD DATA INFILE

Section 6.1, “Backup and Recovery Types”
Section 5.5.7, “Causes of Access-Denied Errors”
Section C.1.14, “Changes in MySQL 4.1.12 (2005-05-13)”
Section C.1.11, “Changes in MySQL 4.1.15 (2005-10-13)”
Section C.1.10, “Changes in MySQL 4.1.16 (2005-11-29)”
Section C.1.7, “Changes in MySQL 4.1.19 (2006-04-29)”
Section C.1.24, “Changes in MySQL 4.1.2 (2004-05-28)”
Section C.1.3, “Changes in MySQL 4.1.23 (2007-06-12)”
Section C.1.22, “Changes in MySQL 4.1.4 (2004-08-26, Gamma)”
Section C.1.18, “Changes in MySQL 4.1.8 (2004-12-14)”
Section C.3.61, “Changes in Release 3.23.0 (05 July 1999: Alpha)”
Section C.3.46, “Changes in Release 3.23.15 (08 May 2000)”
Section C.3.38, “Changes in Release 3.23.23 (01 September 2000)”
Section C.3.36, “Changes in Release 3.23.25 (29 September 2000)”
Section C.3.27, “Changes in Release 3.23.34 (10 March 2001)”
Section C.3.23, “Changes in Release 3.23.37 (17 April 2001)”
Section C.3.18, “Changes in Release 3.23.42 (08 September 2001)”
Section C.3.56, “Changes in Release 3.23.5 (20 October 1999)”
Section C.3.10, “Changes in Release 3.23.50 (21 April 2002)”
Section C.3.8, “Changes in Release 3.23.52 (14 August 2002)”
Section C.3.4, “Changes in Release 3.23.56 (13 March 2003)”
Section C.3.54, “Changes in Release 3.23.7 (10 December 1999)”
Section C.3.52, “Changes in Release 3.23.9 (29 January 2000)”
Section C.2.22, “Changes in Release 4.0.10 (29 January 2003)”
Section C.2.20, “Changes in Release 4.0.12 (15 March 2003: Production)”
Section C.2.19, “Changes in Release 4.0.13 (16 May 2003)”
Section C.2.18, “Changes in Release 4.0.14 (18 July 2003)”
Section C.2.17, “Changes in Release 4.0.15 (03 September 2003)”
Section C.2.16, “Changes in Release 4.0.16 (17 October 2003)”
Section C.2.15, “Changes in Release 4.0.17 (14 December 2003)”
Section C.2.14, “Changes in Release 4.0.18 (12 February 2004)”
Section C.2.13, “Changes in Release 4.0.19 (04 May 2004)”
Section C.2.11, “Changes in Release 4.0.21 (06 September 2004)”
Section C.2.9, “Changes in Release 4.0.23 (18 December 2004)”
Section C.2.29, “Changes in Release 4.0.3 (26 August 2002: Beta)”
Section C.2.28, “Changes in Release 4.0.4 (29 September 2002)”
Section C.2.23, “Changes in Release 4.0.9 (09 January 2003)”
Section 7.6.3, “Concurrent Inserts”
Section 6.2, “Database Backup Methods”
Section B.5.4.3, “How MySQL Handles a Full Disk”
Section 15.1.4.3, “Limits Relating to Transaction Handling in MySQL Cluster”
Section 12.2.5, “LOAD DATA INFILE Syntax”
Section 13.1.1, “MyISAM Startup Options”
Section 1.9.4, “MySQL Extensions to Standard SQL”
Section 4.5.1.1, “mysql Options”
Section 4.6.6, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.5.5, “mysqlimport — A Data Import Program”
Section 15.4.17, “ndb_show_tables — Display List of NDB Tables”
Section 8.1.6, “NULL Values”
Section B.5.8.4, “Open Issues in MySQL”
Section 7.3.3, “Other Optimization Tips”
Section 10.2.5, “Out-of-Range and Overflow Handling”
Section 4.1, “Overview of MySQL Programs”
Section 15.2.6.1, “Performing a Rolling Restart of a MySQL Cluster”
Section 5.5.1, “Privileges Provided by MySQL”
Section B.5.5.3, “Problems with NULL Values”
Section 6.4.4, “Reloading Delimited-Text Format Backups”
Section 14.7.8, “Replication and LOAD Operations”
Section 14.8.3, “Replication Slave Options and Variables”
Section 7.11.6, “Replication Slave SQL Thread States”
Section D.2, “Restrictions on Character Sets”
Section 12.2.7, “SELECT Syntax”
Section 5.1.2, “Server Command Options”
Section 5.1.3, “Server System Variables”
Section 12.4.5.26, “SHOW WARNINGS Syntax”
Section 7.3.2.1, “Speed of INSERT Statements”
Section 5.3.4, “The Binary Log”
Section 13.4, “The MEMORY (HEAP) Storage Engine”
Section 5.5, “The MySQL Access Privilege System”
Section 12.2.8.1, “The Subquery as Scalar Operand”
Section 10.3.1.1, “TIMESTAMP Properties Prior to MySQL 4.1”
Section 2.11.1.1, “Upgrading from MySQL 4.0 to 4.1”
Section B.5.4.4, “Where MySQL Stores Temporary Files”
Section D.3.3, “Windows Platform Limitations”

LOAD DATA INFILE ...

Section 17.6.6.33, “mysql_info()”
Section 17.6.13.2, “What Results You Can Get from a Query”

LOAD DATA LOCAL

Section C.1.5, “Changes in MySQL 4.1.21 (2006-07-19)”
Section C.2.17, “Changes in Release 4.0.15 (03 September 2003)”
Section 17.6.6.47, “mysql_options()”
Section 17.6.6.50, “mysql_real_connect()”
Section 4.6.6, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 5.4.5, “Security Issues with LOAD DATA LOCAL”

LOAD DATA LOCAL INFILE

Section 17.6.5, “C API Function Overview”
Section C.1.22, “Changes in MySQL 4.1.4 (2004-08-26, Gamma)”
Section C.3.11, “Changes in Release 3.23.49 (14 February 2002)”
Section C.2.20, “Changes in Release 4.0.12 (15 March 2003: Production)”
Section 12.2.5, “LOAD DATA INFILE Syntax”
Section 17.6.6.61, “mysql_set_local_infile_handler()”
Section 4.6.6, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 14.7.8, “Replication and LOAD Operations”

LOAD INDEX

Section C.1.16, “Changes in MySQL 4.1.10 (2005-02-12)”

LOAD INDEX INTO CACHE

Section 12.4.6.1, “CACHE INDEX Syntax”
Section C.1.13, “Changes in MySQL 4.1.13 (2005-07-15)”
Section 7.5.1.4, “Index Preloading”
Section 12.4.6.4, “LOAD INDEX INTO CACHE Syntax”

LOAD TABLE FROM MASTER

Section 13.2.5.5, “InnoDB and MySQL Replication”
Section 7.11.7, “Replication Slave Connection Thread States”
Section 13.2.15, “Restrictions on InnoDB Tables”

LOCK TABLE

Section C.1.19, “Changes in MySQL 4.1.7 (2004-10-23, Production)”
Section C.4.5, “Changes in MySQL/InnoDB-4.0.20, May 18, 2004”
Section C.3.48, “Changes in Release 3.23.13 (14 March 2000)”
Section C.3.22, “Changes in Release 3.23.38 (09 May 2001)”
Section C.3.21, “Changes in Release 3.23.39 (12 June 2001)”
Section C.3.4, “Changes in Release 3.23.56 (13 March 2003)”
Section C.2.20, “Changes in Release 4.0.12 (15 March 2003: Production)”
Section 7.6.3, “Concurrent Inserts”
Section 7.11.2, “General Thread States”
Section B.5.8.1, “Issues in MySQL 3.23 Fixed in a Later MySQL Version”
Section B.5.7.1, “Problems with ALTER TABLE”
Section 2.11.1.1, “Upgrading from MySQL 4.0 to 4.1”

LOCK TABLES

Section 12.4.2.2, “BACKUP TABLE Syntax”
Section C.1.15, “Changes in MySQL 4.1.11 (2005-04-01)”
Section C.1.12, “Changes in MySQL 4.1.14 (2005-08-17)”
Section C.1.7, “Changes in MySQL 4.1.19 (2006-04-29)”
Section C.1.19, “Changes in MySQL 4.1.7 (2004-10-23, Production)”
Section C.1.17, “Changes in MySQL 4.1.9 (2005-01-11)”
Section C.4.12, “Changes in MySQL/InnoDB-3.23.58, September 15, 2003”
Section C.4.14, “Changes in MySQL/InnoDB-4.0.14, July 22, 2003”
Section C.4.1, “Changes in MySQL/InnoDB-4.0.21, September 10, 2004”
Section C.4.3, “Changes in MySQL/InnoDB-4.1.3, June 28, 2004”
Section C.3.51, “Changes in Release 3.23.10 (30 January 2000)”
Section C.3.59, “Changes in Release 3.23.2 (09 August 1999)”
Section C.3.31, “Changes in Release 3.23.30 (04 January 2001)”
Section C.3.18, “Changes in Release 3.23.42 (08 September 2001)”
Section C.3.12, “Changes in Release 3.23.48 (07 February 2002)”
Section C.3.7, “Changes in Release 3.23.53 (09 October 2002)”
Section C.2.16, “Changes in Release 4.0.16 (17 October 2003)”
Section C.2.14, “Changes in Release 4.0.18 (12 February 2004)”
Section C.2.10, “Changes in Release 4.0.22 (27 October 2004)”
Section C.2.8, “Changes in Release 4.0.24 (04 March 2005)”
Section C.2.7, “Changes in Release 4.0.25 (05 July 2005)”
Section C.2.6, “Changes in Release 4.0.26 (08 September 2005)”
Section C.2.28, “Changes in Release 4.0.4 (29 September 2002)”
Section C.2.26, “Changes in Release 4.0.6 (14 December 2002: Gamma)”
Section 13.5.4, “Characteristics of BDB Tables”
Section 6.2, “Database Backup Methods”
Section 11.7, “Date and Time Functions”
Section 13.2.9.8, “Deadlock Detection and Rollback”
Section 12.4.6.2, “FLUSH Syntax”
Section 12.4.1.2, “GRANT Syntax”
Section 12.7.3, “HELP Syntax”
Section 13.2.9.9, “How to Cope with Deadlocks”
Section 13.2.4, “InnoDB Startup Options and System Variables”
Section 12.3.5.1, “Interaction of Table Locking and Transactions”
Section 7.6.1, “Internal Locking Methods”
Section 15.1.4.9, “Limitations Relating to Multiple MySQL Cluster Nodes”
Section 12.3.5, “LOCK TABLES and UNLOCK TABLES Syntax”
Section 13.2.9.6, “Locks Set by Different SQL Statements in InnoDB”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 4.6.8, “mysqlhotcopy — A Database Backup Program”
Section 5.5.1, “Privileges Provided by MySQL”
Section 13.1.4.2, “Problems from Tables Not Being Closed Properly”
Section 13.2.15, “Restrictions on InnoDB Tables”
Section 5.1.3, “Server System Variables”
Section 7.3.2.1, “Speed of INSERT Statements”
Section 12.3.1, “START TRANSACTION, COMMIT, and ROLLBACK Syntax”
Section 12.3.3, “Statements That Cause an Implicit Commit”
Section 7.8.1, “System Factors and Startup Parameter Tuning”
Section 7.6.2, “Table Locking Issues”
Section 12.3.5.2, “Table-Locking Restrictions and Conditions”
Section 1.9.5.4, “Transactions and Atomic Operations”
Section 2.11.1.2, “Upgrading from MySQL 3.23 to 4.0”
Section 2.11.1.1, “Upgrading from MySQL 4.0 to 4.1”

O

[index top]

OPTIMIZE TABLE

Section C.1.26, “Changes in MySQL 4.1.0 (2003-04-03, Alpha)”
Section C.1.25, “Changes in MySQL 4.1.1 (2003-12-01)”
Section C.1.15, “Changes in MySQL 4.1.11 (2005-04-01)”
Section C.1.13, “Changes in MySQL 4.1.13 (2005-07-15)”
Section C.1.10, “Changes in MySQL 4.1.16 (2005-11-29)”
Section C.1.24, “Changes in MySQL 4.1.2 (2004-05-28)”
Section C.1.4, “Changes in MySQL 4.1.22 (2006-11-02)”
Section C.1.2, “Changes in MySQL 4.1.24 (2008-03-01)”
Section C.1.23, “Changes in MySQL 4.1.3 (2004-06-28, Beta)”
Section C.1.21, “Changes in MySQL 4.1.5 (2004-09-16)”
Section C.1.18, “Changes in MySQL 4.1.8 (2004-12-14)”
Section C.1.17, “Changes in MySQL 4.1.9 (2005-01-11)”
Section C.4.3, “Changes in MySQL/InnoDB-4.1.3, June 28, 2004”
Section C.3.36, “Changes in Release 3.23.25 (29 September 2000)”
Section C.3.32, “Changes in Release 3.23.29 (16 December 2000)”
Section C.3.28, “Changes in Release 3.23.33 (09 February 2001)”
Section C.3.22, “Changes in Release 3.23.38 (09 May 2001)”
Section C.3.15, “Changes in Release 3.23.45 (22 November 2001)”
Section C.3.14, “Changes in Release 3.23.46 (29 November 2001)”
Section C.3.8, “Changes in Release 3.23.52 (14 August 2002)”
Section C.3.7, “Changes in Release 3.23.53 (09 October 2002)”
Section C.3.6, “Changes in Release 3.23.54 (05 December 2002)”
Section C.2.32, “Changes in Release 4.0.0 (October 2001: Alpha)”
Section C.2.13, “Changes in Release 4.0.19 (04 May 2004)”
Section C.2.8, “Changes in Release 4.0.24 (04 March 2005)”
Section C.2.5, “Changes in Release 4.0.27 (06 May 2006)”
Section C.2.28, “Changes in Release 4.0.4 (29 September 2002)”
Section C.2.26, “Changes in Release 4.0.6 (14 December 2002: Gamma)”
Section C.2.23, “Changes in Release 4.0.9 (09 January 2003)”
Section 13.5.4, “Characteristics of BDB Tables”
Section 18.4.1, “Debugging a MySQL Server”
Section 12.2.1, “DELETE Syntax”
Section 13.1.3.2, “Dynamic Table Characteristics”
Section 11.9.6, “Fine-Tuning MySQL Full-Text Search”
Section 7.11.2, “General Thread States”
Section B.5.4.3, “How MySQL Handles a Full Disk”
Section 12.4.6.3, “KILL Syntax”
Section 13.3.2, “MERGE Table Problems”
Section 6.6, “MyISAM Table Maintenance and Crash Recovery”
Section 6.6.4, “MyISAM Table Optimization”
Section 4.6.2.1, “myisamchk General Options”
Section 1.9.4, “MySQL Extensions to Standard SQL”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section B.5.8.4, “Open Issues in MySQL”
Section 12.4.2.5, “OPTIMIZE TABLE Syntax”
Section 7.3.3, “Other Optimization Tips”
Section 5.5.1, “Privileges Provided by MySQL”
Section 14.7.5, “Replication and FLUSH”
Section 5.1.2, “Server Command Options”
Section 6.6.5, “Setting Up a MyISAM Table Maintenance Schedule”
Section 7.3.2.2, “Speed of UPDATE Statements”
Section 13.1.3.1, “Static (Fixed-Length) Table Characteristics”
Section 13.7, “The ARCHIVE Storage Engine”
Section 13.10, “The ISAM Storage Engine”
Section 5.1.9, “The Shutdown Process”
Section 5.3.5, “The Slow Query Log”
Section 2.11.1.1, “Upgrading from MySQL 4.0 to 4.1”
Section 7.10.2, “Using Symbolic Links for Tables on Unix”

P

[index top]

PREPARE

Section C.1.14, “Changes in MySQL 4.1.12 (2005-05-13)”
Section C.1.12, “Changes in MySQL 4.1.14 (2005-08-17)”
Section 12.6.3, “DEALLOCATE PREPARE Syntax”
Section 12.6.2, “EXECUTE Syntax”
Section 12.6.1, “PREPARE Syntax”
Section 5.1.5, “Server Status Variables”
Section 12.6, “SQL Syntax for Prepared Statements”
Section 8.4, “User-Defined Variables”

PURGE BINARY LOGS

Section C.1.25, “Changes in MySQL 4.1.1 (2003-12-01)”
Section 6.3.1, “Establishing a Backup Policy”
Section 12.4.1.2, “GRANT Syntax”
Section 5.5.1, “Privileges Provided by MySQL”
Section 12.5.1.1, “PURGE BINARY LOGS Syntax”
Section 12.5.1.2, “RESET MASTER Syntax”
Section 5.3.6, “Server Log Maintenance”
Section 5.1.3, “Server System Variables”
Section 5.3.4, “The Binary Log”

PURGE MASTER LOGS

Section C.1.25, “Changes in MySQL 4.1.1 (2003-12-01)”
Section C.1.10, “Changes in MySQL 4.1.16 (2005-11-29)”
Section C.2.18, “Changes in Release 4.0.14 (18 July 2003)”

R

[index top]

RENAME TABLE

Section 12.1.2, “ALTER TABLE Syntax”
Section C.1.14, “Changes in MySQL 4.1.12 (2005-05-13)”
Section C.1.9, “Changes in MySQL 4.1.17 (Not released)”
Section C.1.3, “Changes in MySQL 4.1.23 (2007-06-12)”
Section C.1.2, “Changes in MySQL 4.1.24 (2008-03-01)”
Section C.1.18, “Changes in MySQL 4.1.8 (2004-12-14)”
Section C.4.7, “Changes in MySQL/InnoDB-4.0.18, February 13, 2004”
Section C.3.38, “Changes in Release 3.23.23 (01 September 2000)”
Section C.3.32, “Changes in Release 3.23.29 (16 December 2000)”
Section C.3.18, “Changes in Release 3.23.42 (08 September 2001)”
Section C.3.10, “Changes in Release 3.23.50 (21 April 2002)”
Section C.3.7, “Changes in Release 3.23.53 (09 October 2002)”
Section C.2.30, “Changes in Release 4.0.2 (01 July 2002)”
Section C.2.9, “Changes in Release 4.0.23 (18 December 2004)”
Section C.2.1, “Changes in Release 4.0.31 (Not released)”
Section 12.2.1, “DELETE Syntax”
Section 13.2.5.4, “FOREIGN KEY Constraints”
Section 7.11.2, “General Thread States”
Section 13.3.2, “MERGE Table Problems”
Section 1.9.4, “MySQL Extensions to Standard SQL”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 12.1.9, “RENAME TABLE Syntax”
Section 12.3.3, “Statements That Cause an Implicit Commit”
Section 2.11.1.1, “Upgrading from MySQL 4.0 to 4.1”
Section 13.2.3.1, “Using Per-Table Tablespaces”
Section 7.10.2, “Using Symbolic Links for Tables on Unix”

REPAIR TABLE

Section 12.1.2, “ALTER TABLE Syntax”
Section C.1.26, “Changes in MySQL 4.1.0 (2003-04-03, Alpha)”
Section C.1.25, “Changes in MySQL 4.1.1 (2003-12-01)”
Section C.1.15, “Changes in MySQL 4.1.11 (2005-04-01)”
Section C.1.10, “Changes in MySQL 4.1.16 (2005-11-29)”
Section C.1.24, “Changes in MySQL 4.1.2 (2004-05-28)”
Section C.1.4, “Changes in MySQL 4.1.22 (2006-11-02)”
Section C.1.3, “Changes in MySQL 4.1.23 (2007-06-12)”
Section C.1.2, “Changes in MySQL 4.1.24 (2008-03-01)”
Section C.1.18, “Changes in MySQL 4.1.8 (2004-12-14)”
Section C.1.17, “Changes in MySQL 4.1.9 (2005-01-11)”
Section C.3.47, “Changes in Release 3.23.14 (09 April 2000)”
Section C.3.45, “Changes in Release 3.23.16 (16 May 2000)”
Section C.3.40, “Changes in Release 3.23.21 (04 July 2000)”
Section C.3.38, “Changes in Release 3.23.23 (01 September 2000)”
Section C.3.36, “Changes in Release 3.23.25 (29 September 2000)”
Section C.3.35, “Changes in Release 3.23.26 (18 October 2000)”
Section C.3.32, “Changes in Release 3.23.29 (16 December 2000)”
Section C.3.29, “Changes in Release 3.23.32 (22 January 2001)”
Section C.3.27, “Changes in Release 3.23.34 (10 March 2001)”
Section C.3.23, “Changes in Release 3.23.37 (17 April 2001)”
Section C.3.22, “Changes in Release 3.23.38 (09 May 2001)”
Section C.3.18, “Changes in Release 3.23.42 (08 September 2001)”
Section C.3.14, “Changes in Release 3.23.46 (29 November 2001)”
Section C.3.8, “Changes in Release 3.23.52 (14 August 2002)”
Section C.2.32, “Changes in Release 4.0.0 (October 2001: Alpha)”
Section C.2.18, “Changes in Release 4.0.14 (18 July 2003)”
Section C.2.13, “Changes in Release 4.0.19 (04 May 2004)”
Section C.2.8, “Changes in Release 4.0.24 (04 March 2005)”
Section C.2.7, “Changes in Release 4.0.25 (05 July 2005)”
Section C.2.5, “Changes in Release 4.0.27 (06 May 2006)”
Section C.2.4, “Changes in Release 4.0.28 (Not released)”
Section C.2.28, “Changes in Release 4.0.4 (29 September 2002)”
Section C.2.27, “Changes in Release 4.0.5 (13 November 2002)”
Section 13.1.4.1, “Corrupted MyISAM Tables”
Section 6.2, “Database Backup Methods”
Section 7.6.4, “External Locking”
Section 11.9.6, “Fine-Tuning MySQL Full-Text Search”
Section 7.11.2, “General Thread States”
Section B.5.4.3, “How MySQL Handles a Full Disk”
Section 6.6.3, “How to Repair MyISAM Tables”
Section 1.8, “How to Report Bugs or Problems”
Section 2.7, “Installing MySQL on NetWare”
Section 12.4.6.3, “KILL Syntax”
Section 12.2.5, “LOAD DATA INFILE Syntax”
Section 13.3.2, “MERGE Table Problems”
Section 13.1.1, “MyISAM Startup Options”
Section 6.6, “MyISAM Table Maintenance and Crash Recovery”
Section 4.6.2.1, “myisamchk General Options”
Section 4.6.2, “myisamchk — MyISAM Table-Maintenance Utility”
Section 1.9.4, “MySQL Extensions to Standard SQL”
Section 4.5.3, “mysqlcheck — A Table Maintenance Program”
Section B.5.8.4, “Open Issues in MySQL”
Section 5.5.1, “Privileges Provided by MySQL”
Section 13.1.4.2, “Problems from Tables Not Being Closed Properly”
Section B.5.7.1, “Problems with ALTER TABLE”
Section 2.11.4, “Rebuilding or Repairing Tables or Indexes”
Section 12.4.2.6, “REPAIR TABLE Syntax”
Section 14.7.5, “Replication and FLUSH”
Section 5.1.3, “Server System Variables”
Section 6.6.5, “Setting Up a MyISAM Table Maintenance Schedule”
Section 7.3.2.4, “Speed of REPAIR TABLE Statements”
Section 13.7, “The ARCHIVE Storage Engine”
Section 13.10, “The ISAM Storage Engine”
Section 5.1.9, “The Shutdown Process”
Section 2.11.1.1, “Upgrading from MySQL 4.0 to 4.1”
Section 7.10.2, “Using Symbolic Links for Tables on Unix”

REPLACE

Section C.1.25, “Changes in MySQL 4.1.1 (2003-12-01)”
Section C.1.10, “Changes in MySQL 4.1.16 (2005-11-29)”
Section C.1.24, “Changes in MySQL 4.1.2 (2004-05-28)”
Section C.1.18, “Changes in MySQL 4.1.8 (2004-12-14)”
Section C.4.14, “Changes in MySQL/InnoDB-4.0.14, July 22, 2003”
Section C.4.7, “Changes in MySQL/InnoDB-4.0.18, February 13, 2004”
Section C.3.61, “Changes in Release 3.23.0 (05 July 1999: Alpha)”
Section C.3.46, “Changes in Release 3.23.15 (08 May 2000)”
Section C.3.32, “Changes in Release 3.23.29 (16 December 2000)”
Section C.3.27, “Changes in Release 3.23.34 (10 March 2001)”
Section C.3.3, “Changes in Release 3.23.57 (06 June 2003)”
Section C.2.19, “Changes in Release 4.0.13 (16 May 2003)”
Section C.2.18, “Changes in Release 4.0.14 (18 July 2003)”
Section C.2.27, “Changes in Release 4.0.5 (13 November 2002)”
Section C.1, “Changes in Release 4.1.x (Lifecycle Support Ended)”
Section 12.1.5.1, “CREATE TABLE ... SELECT Syntax”
Section 7.1.2, “Designing Applications for Portability”
Section 12.2.4.2, “INSERT DELAYED Syntax”
Section 12.2.4, “INSERT Syntax”
Section 13.2.9.6, “Locks Set by Different SQL Statements in InnoDB”
Section 13.3.2, “MERGE Table Problems”
Section 1.9.4, “MySQL Extensions to Standard SQL”
Section B.5.2.9, “MySQL server has gone away”
Section 17.6.6.1, “mysql_affected_rows()”
Section B.5.8.4, “Open Issues in MySQL”
Section 12.2.6, “REPLACE Syntax”
Section 5.1.2, “Server Command Options”
Section 12.2.8, “Subquery Syntax”
Section 13.7, “The ARCHIVE Storage Engine”
Section 1.3.2, “The Main Features of MySQL”

REPLACE ... SELECT

Section B.5.8.4, “Open Issues in MySQL”

RESET

Section 12.4.6.2, “FLUSH Syntax”
Section 1.9.4, “MySQL Extensions to Standard SQL”
Section 12.4.6.5, “RESET Syntax”

RESET MASTER

Section C.3.35, “Changes in Release 3.23.26 (18 October 2000)”
Section 12.4.6.2, “FLUSH Syntax”
Section 17.6.6.53, “mysql_refresh()”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 14.10, “Replication FAQ”
Section 12.5.1.2, “RESET MASTER Syntax”
Section 5.3.4, “The Binary Log”

RESET SLAVE

Section C.1.24, “Changes in MySQL 4.1.2 (2004-05-28)”
Section C.3.35, “Changes in Release 3.23.26 (18 October 2000)”
Section C.2.20, “Changes in Release 4.0.12 (15 March 2003: Production)”
Section C.2.18, “Changes in Release 4.0.14 (18 July 2003)”
Section C.2.17, “Changes in Release 4.0.15 (03 September 2003)”
Section C.2.13, “Changes in Release 4.0.19 (04 May 2004)”
Section C.2.26, “Changes in Release 4.0.6 (14 December 2002: Gamma)”
Section 12.4.6.2, “FLUSH Syntax”
Section 17.6.6.53, “mysql_refresh()”
Section 14.8.3, “Replication Slave Options and Variables”
Section 12.5.1.2, “RESET MASTER Syntax”
Section 12.5.2.5, “RESET SLAVE Syntax”

RESTORE TABLE

Section 12.4.2.2, “BACKUP TABLE Syntax”
Section C.3.36, “Changes in Release 3.23.25 (29 September 2000)”
Section C.3.29, “Changes in Release 3.23.32 (22 January 2001)”
Section 12.4.2.7, “RESTORE TABLE Syntax”
Section 13.10, “The ISAM Storage Engine”
Section 7.10.2, “Using Symbolic Links for Tables on Unix”

REVOKE

Section 5.5.5, “Access Control, Stage 2: Request Verification”
Section C.1.11, “Changes in MySQL 4.1.15 (2005-10-13)”
Section C.2.19, “Changes in Release 4.0.13 (16 May 2003)”
Section C.2.17, “Changes in Release 4.0.15 (03 September 2003)”
Section C.2.29, “Changes in Release 4.0.3 (26 August 2002: Beta)”
Section C.2.28, “Changes in Release 4.0.4 (29 September 2002)”
Section 12.4.1.1, “DROP USER Syntax”
Section 12.4.6.2, “FLUSH Syntax”
Section 5.4.1, “General Security Guidelines”
Section 12.4.1.2, “GRANT Syntax”
Section 7.8.4, “How MySQL Uses Memory”
Section 15.5.9.2, “MySQL Cluster and MySQL Privileges”
Section 1.9.5, “MySQL Differences from Standard SQL”
Section 5.5.2, “Privilege System Grant Tables”
Section 5.5.1, “Privileges Provided by MySQL”
Section 2.10.2.1, “Problems Running mysql_install_db”
Section 14.7.13, “Replication and User Privileges”
Section 12.4.1.3, “REVOKE Syntax”
Section 5.5, “The MySQL Access Privilege System”
Section 5.6.1, “User Names and Passwords”
Section 5.5.6, “When Privilege Changes Take Effect”

REVOKE ALL PRIVILEGES

Section C.3.57, “Changes in Release 3.23.4 (28 September 1999)”

ROLLBACK

Section C.1.13, “Changes in MySQL 4.1.13 (2005-07-15)”
Section C.1.10, “Changes in MySQL 4.1.16 (2005-11-29)”
Section C.1.18, “Changes in MySQL 4.1.8 (2004-12-14)”
Section C.3.32, “Changes in Release 3.23.29 (16 December 2000)”
Section C.2.17, “Changes in Release 4.0.15 (03 September 2003)”
Section C.2.9, “Changes in Release 4.0.23 (18 December 2004)”
Section C.2.27, “Changes in Release 4.0.5 (13 November 2002)”
Section C.2.26, “Changes in Release 4.0.6 (14 December 2002: Gamma)”
Section 13.5.4, “Characteristics of BDB Tables”
Section 13.2.5.1, “How to Use Transactions in InnoDB with Different APIs”
Section 11.13, “Information Functions”
Section 13.2.13, “InnoDB Error Handling”
Section 12.3.5.1, “Interaction of Table Locking and Transactions”
Section 15.1.4.3, “Limits Relating to Transaction Handling in MySQL Cluster”
Section 15.6, “MySQL 4.1 FAQ: MySQL Cluster”
Section 12.3, “MySQL Transactional and Locking Statements”
Section 17.6.6.3, “mysql_change_user()”
Section 14.7.19, “Replication and Transactions”
Section B.5.5.5, “Rollback Failure for Nontransactional Tables”
Section 12.3.4, “SAVEPOINT and ROLLBACK TO SAVEPOINT Syntax”
Section 5.1.5, “Server Status Variables”
Section 5.1.3, “Server System Variables”
Section 12.3.1, “START TRANSACTION, COMMIT, and ROLLBACK Syntax”
Section 12.3.2, “Statements That Cannot Be Rolled Back”
Section 12.3.3, “Statements That Cause an Implicit Commit”
Chapter 13, Storage Engines
Section 13.5, “The BDB (BerkeleyDB) Storage Engine”
Section 5.3.4, “The Binary Log”
Section 13.2.9, “The InnoDB Transaction Model and Locking”
Section 1.9.5.4, “Transactions and Atomic Operations”

ROLLBACK TO SAVEPOINT

Section C.4.14, “Changes in MySQL/InnoDB-4.0.14, July 22, 2003”
Section 12.3.4, “SAVEPOINT and ROLLBACK TO SAVEPOINT Syntax”

S

[index top]

SAVEPOINT

Section C.4.14, “Changes in MySQL/InnoDB-4.0.14, July 22, 2003”
Section 12.3.4, “SAVEPOINT and ROLLBACK TO SAVEPOINT Syntax”

SELECT

Section 12.1.2, “ALTER TABLE Syntax”
Section 11.3.4, “Assignment Operators”
Section 13.2.9.5, “Avoiding the Phantom Problem Using Next-Key Locking”
Section 17.6.4, “C API Data Structures”
Section 17.6.5, “C API Function Overview”
Section 17.6.9, “C API Prepared Statement Function Overview”
Section 17.6.15, “C API Support for Multiple Statement Execution”
Section C.1.25, “Changes in MySQL 4.1.1 (2003-12-01)”
Section C.1.16, “Changes in MySQL 4.1.10 (2005-02-12)”
Section C.1.15, “Changes in MySQL 4.1.11 (2005-04-01)”
Section C.1.14, “Changes in MySQL 4.1.12 (2005-05-13)”
Section C.1.13, “Changes in MySQL 4.1.13 (2005-07-15)”
Section C.1.10, “Changes in MySQL 4.1.16 (2005-11-29)”
Section C.1.9, “Changes in MySQL 4.1.17 (Not released)”
Section C.1.7, “Changes in MySQL 4.1.19 (2006-04-29)”
Section C.1.24, “Changes in MySQL 4.1.2 (2004-05-28)”
Section C.1.5, “Changes in MySQL 4.1.21 (2006-07-19)”
Section C.1.4, “Changes in MySQL 4.1.22 (2006-11-02)”
Section C.1.3, “Changes in MySQL 4.1.23 (2007-06-12)”
Section C.1.2, “Changes in MySQL 4.1.24 (2008-03-01)”
Section C.1.1, “Changes in MySQL 4.1.25 (2008-12-01)”
Section C.1.22, “Changes in MySQL 4.1.4 (2004-08-26, Gamma)”
Section C.1.19, “Changes in MySQL 4.1.7 (2004-10-23, Production)”
Section C.4.12, “Changes in MySQL/InnoDB-3.23.58, September 15, 2003”
Section C.4.14, “Changes in MySQL/InnoDB-4.0.14, July 22, 2003”
Section C.4.13, “Changes in MySQL/InnoDB-4.0.15, September 10, 2003”
Section C.4.7, “Changes in MySQL/InnoDB-4.0.18, February 13, 2004”
Section C.4.4, “Changes in MySQL/InnoDB-4.1.2, May 30, 2004”
Section C.3.49, “Changes in Release 3.23.12 (07 March 2000)”
Section C.3.48, “Changes in Release 3.23.13 (14 March 2000)”
Section C.3.46, “Changes in Release 3.23.15 (08 May 2000)”
Section C.3.38, “Changes in Release 3.23.23 (01 September 2000)”
Section C.3.33, “Changes in Release 3.23.28 (22 November 2000: Gamma)”
Section C.3.24, “Changes in Release 3.23.36 (27 March 2001)”
Section C.3.22, “Changes in Release 3.23.38 (09 May 2001)”
Section C.3.17, “Changes in Release 3.23.43 (04 October 2001)”
Section C.3.12, “Changes in Release 3.23.48 (07 February 2002)”
Section C.3.3, “Changes in Release 3.23.57 (06 June 2003)”
Section C.3.52, “Changes in Release 3.23.9 (29 January 2000)”
Section C.2.31, “Changes in Release 4.0.1 (23 December 2001)”
Section C.2.19, “Changes in Release 4.0.13 (16 May 2003)”
Section C.2.18, “Changes in Release 4.0.14 (18 July 2003)”
Section C.2.17, “Changes in Release 4.0.15 (03 September 2003)”
Section C.2.16, “Changes in Release 4.0.16 (17 October 2003)”
Section C.2.15, “Changes in Release 4.0.17 (14 December 2003)”
Section C.2.14, “Changes in Release 4.0.18 (12 February 2004)”
Section C.2.13, “Changes in Release 4.0.19 (04 May 2004)”
Section C.2.30, “Changes in Release 4.0.2 (01 July 2002)”
Section C.2.10, “Changes in Release 4.0.22 (27 October 2004)”
Section C.2.5, “Changes in Release 4.0.27 (06 May 2006)”
Section C.2.4, “Changes in Release 4.0.28 (Not released)”
Section C.2.28, “Changes in Release 4.0.4 (29 September 2002)”
Section C.2.26, “Changes in Release 4.0.6 (14 December 2002: Gamma)”
Section C.2, “Changes in Release 4.0.x (Lifecycle Support Ended)”
Section 7.4.1, “Column Indexes”
Section 11.3.2, “Comparison Functions and Operators”
Section 7.6.3, “Concurrent Inserts”
Section 15.3.2.11, “Configuring MySQL Cluster Parameters for Local Checkpoints”
Section 9.1.4, “Connection Character Sets and Collations”
Section 13.2.9.2, “Consistent Nonlocking Reads”
Section 12.1.5.1, “CREATE TABLE ... SELECT Syntax”
Section 12.1.5, “CREATE TABLE Syntax”
Section 3.3.1, “Creating and Selecting a Database”
Section 12.2.1, “DELETE Syntax”
Section B.5.5.6, “Deleting Rows from Related Tables”
Section 7.7.3, “Disadvantages of Creating Many Tables in the Same Database”
Section 5.1.4.2, “Dynamic System Variables”
Section 3.2, “Entering Queries”
Section 9.1.7.8, “Examples of the Effect of Collation”
Section 7.2.2, “EXPLAIN Output Format”
Section 12.7.2, “EXPLAIN Syntax”
Section 13.2.7.2, “Forcing InnoDB Recovery”
Section 1.9.5.6, “Foreign Keys”
Chapter 11, Functions and Operators
Section 7.11.2, “General Thread States”
Section 12.4.1.2, “GRANT Syntax”
Section 11.15.1, “GROUP BY (Aggregate) Functions”
Section 12.2.3, “HANDLER Syntax”
Section 7.4.3, “How MySQL Uses Indexes”
Section 7.7.4, “How MySQL Uses Internal Temporary Tables”
Section 7.5.3.1, “How the Query Cache Operates”
Section 13.2.9.9, “How to Cope with Deadlocks”
Section 1.8, “How to Report Bugs or Problems”
Section 13.2.5.1, “How to Use Transactions in InnoDB with Different APIs”
Section 8.2.1, “Identifier Qualifiers”
Section 12.2.7.2, “Index Hint Syntax”
Section 11.13, “Information Functions”
Section 13.2.4, “InnoDB Startup Options and System Variables”
Section 12.2.4.1, “INSERT ... SELECT Syntax”
Section 12.2.4.2, “INSERT DELAYED Syntax”
Section 12.2.4, “INSERT Syntax”
Section 7.6.1, “Internal Locking Methods”
Section 14.1, “Introduction to Replication”
Section B.5.8.2, “Issues in MySQL 4.0 Fixed in a Later Version”
Section 12.2.7.1, “JOIN Syntax”
Section 12.4.6.3, “KILL Syntax”
Section 15.1.4.3, “Limits Relating to Transaction Handling in MySQL Cluster”
Section 12.5.2.2, “LOAD DATA FROM MASTER Syntax”
Section 12.5.2.3, “LOAD TABLE tbl_name FROM MASTER Syntax”
Section 15.2.4, “Loading Sample Data into MySQL Cluster and Performing Queries”
Section 12.3.5, “LOCK TABLES and UNLOCK TABLES Syntax”
Section 13.2.9.6, “Locks Set by Different SQL Statements in InnoDB”
Section 5.4.3, “Making MySQL Secure Against Attackers”
Section 13.3.2, “MERGE Table Problems”
Section 6.6.4, “MyISAM Table Optimization”
Section 1.5, “MySQL 4.0 in a Nutshell”
Section 1.6, “MySQL 4.1 in a Nutshell”
Section 1.9.4, “MySQL Extensions to Standard SQL”
Section 11.15.3, “MySQL Handling of GROUP BY”
Section 4.5.1.1, “mysql Options”
Section 17.6.6.1, “mysql_affected_rows()”
Section 4.6.12, “mysql_explain_log — Use EXPLAIN on Statements in Query Log”
Section 17.6.6.17, “mysql_fetch_field()”
Section 17.6.6.22, “mysql_field_count()”
Section 17.6.6.35, “mysql_insert_id()”
Section 17.6.6.42, “mysql_list_tables()”
Section 17.6.6.45, “mysql_num_fields()”
Section 17.6.10.10, “mysql_stmt_execute()”
Section 17.6.10.11, “mysql_stmt_fetch()”
Section 17.6.10.17, “mysql_stmt_num_rows()”
Section 17.6.10.27, “mysql_stmt_store_result()”
Section 17.6.6.67, “mysql_store_result()”
Section 17.6.6.69, “mysql_use_result()”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 11.9.1, “Natural Language Full-Text Searches”
Section 15.4.15, “ndb_select_all — Print Rows from an NDB Table”
Section B.5.8.4, “Open Issues in MySQL”
Section B.5.6, “Optimizer-Related Issues”
Section 7.2.1, “Optimizing Queries with EXPLAIN”
Section 4.6.2.4, “Other myisamchk Options”
Section 7.3.3, “Other Optimization Tips”
Section 5.5.1, “Privileges Provided by MySQL”
Section B.5.5.2, “Problems Using DATE Columns”
Section 18.3.1, “PROCEDURE ANALYSE”
Section 7.5.3.2, “Query Cache SELECT Options”
Section 7.5.3.4, “Query Cache Status and Maintenance”
Section 14.10, “Replication FAQ”
Section 8.3, “Reserved Words”
Section D.1, “Restrictions on Subqueries”
Section 3.3.4, “Retrieving Information from a Table”
Section 12.2.8.11, “Rewriting Subqueries as Joins for Earlier MySQL Versions”
Section 3.6.7, “Searching on Two Keys”
Section 2.10.3, “Securing the Initial MySQL Accounts”
Section 13.2.9.3, “SELECT ... FOR UPDATE and SELECT ... LOCK IN SHARE MODE Locking Reads”
Section 12.2.7, “SELECT Syntax”
Section 3.3.4.1, “Selecting All Data”
Section 3.3.4.2, “Selecting Particular Rows”
Section 5.1.6, “Server SQL Modes”
Section 5.1.3, “Server System Variables”
Section 12.4.4, “SET Syntax”
Section 12.3.6, “SET TRANSACTION Syntax”
Section 2.12.5.7, “SGI Irix Notes”
Section 12.4.5.2, “SHOW BINLOG EVENTS Syntax”
Section 12.4.5.11, “SHOW ERRORS Syntax”
Section 12.4.5, “SHOW Syntax”
Section 12.4.5.26, “SHOW WARNINGS Syntax”
Section B.5.5.7, “Solving Problems with No Matching Rows”
Section 7.3.2.1, “Speed of INSERT Statements”
Section 7.3.1.1, “Speed of SELECT Statements”
Section 7.3.2.2, “Speed of UPDATE Statements”
Section 12.3.1, “START TRANSACTION, COMMIT, and ROLLBACK Syntax”
Section 8.1.1, “String Literals”
Section 12.2.8.8, “Subqueries in the FROM Clause”
Section 12.2.8.6, “Subqueries with EXISTS or NOT EXISTS”
Section 12.2.8.9, “Subquery Errors”
Section 1.9.5.1, “Subquery Support”
Section 12.2.8, “Subquery Syntax”
Section 7.6.2, “Table Locking Issues”
Section 12.3.5.2, “Table-Locking Restrictions and Conditions”
Section 13.7, “The ARCHIVE Storage Engine”
Section 5.3.4, “The Binary Log”
Section 10.4.4, “The ENUM Type”
Section 1.3.2, “The Main Features of MySQL”
Section 13.3, “The MERGE Storage Engine”
Section 5.5, “The MySQL Access Privilege System”
Section 7.5.3, “The MySQL Query Cache”
Section 12.2.8.1, “The Subquery as Scalar Operand”
Section 1.2, “Typographical and Syntax Conventions”
Section 12.2.7.3, “UNION Syntax”
Section 2.10.2, “Unix Postinstallation Procedures”
Section 12.2.9, “UPDATE Syntax”
Section 8.4, “User-Defined Variables”
Section 16.6.2, “Using a Spatial Index”
Section 18.4.1.5, “Using Server Logs to Find Causes of Errors in mysqld”
Section 5.1.4, “Using System Variables”
Section 4.5.1.6.2, “Using the --safe-updates Option”
Section 7.3.1.2, “WHERE Clause Optimization”
Section B.5.4.4, “Where MySQL Stores Temporary Files”
Section D.3.3, “Windows Platform Limitations”

SELECT *

Section 10.4.3, “The BLOB and TEXT Types”

SELECT ... FOR UPDATE

Section C.1.5, “Changes in MySQL 4.1.21 (2006-07-19)”
Section C.1.4, “Changes in MySQL 4.1.22 (2006-11-02)”
Section 13.2.9.9, “How to Cope with Deadlocks”
Section 13.2.9.1, “InnoDB Lock Modes”
Section 13.2.9.6, “Locks Set by Different SQL Statements in InnoDB”
Section 13.2.9.3, “SELECT ... FOR UPDATE and SELECT ... LOCK IN SHARE MODE Locking Reads”

SELECT ... FROM

Section 13.2.9.6, “Locks Set by Different SQL Statements in InnoDB”

SELECT ... FROM ... FOR UPDATE

Section 13.2.9.6, “Locks Set by Different SQL Statements in InnoDB”

SELECT ... FROM ... LOCK IN SHARE MODE

Section 13.2.9.6, “Locks Set by Different SQL Statements in InnoDB”

SELECT ... IN SHARE MODE

Section C.2.31, “Changes in Release 4.0.1 (23 December 2001)”

SELECT ... INTO DUMPFILE

Section C.1.1, “Changes in MySQL 4.1.25 (2008-12-01)”
Section C.3.55, “Changes in Release 3.23.6 (15 December 1999)”
Section 2.9.1, “Installing MySQL from a Standard Source Distribution”
Section 5.4.3, “Making MySQL Secure Against Attackers”
Section 5.1.3, “Server System Variables”
Section 2.10.2, “Unix Postinstallation Procedures”

SELECT ... INTO OUTFILE

Section 6.1, “Backup and Recovery Types”
Section 5.5.7, “Causes of Access-Denied Errors”
Section C.1.14, “Changes in MySQL 4.1.12 (2005-05-13)”
Section C.1.2, “Changes in MySQL 4.1.24 (2008-03-01)”
Section C.1.19, “Changes in MySQL 4.1.7 (2004-10-23, Production)”
Section 6.4.3, “Dumping Data in Delimited-Text Format with mysqldump”
Section 12.2.5, “LOAD DATA INFILE Syntax”
Section 5.4.3, “Making MySQL Secure Against Attackers”
Section 8.1.6, “NULL Values”
Section 5.5.1, “Privileges Provided by MySQL”
Section 1.9.5.2, “SELECT INTO TABLE”
Section 12.2.7, “SELECT Syntax”
Section 5.1.2, “Server Command Options”
Section 1.2, “Typographical and Syntax Conventions”
Section 2.11.1.1, “Upgrading from MySQL 4.0 to 4.1”
Section D.3.3, “Windows Platform Limitations”

SELECT ... LOCK IN SHARE MODE

Section C.4.48, “Changes in MySQL/InnoDB-3.23.38, May 12, 2001”
Section C.2.31, “Changes in Release 4.0.1 (23 December 2001)”
Section 13.2.9.1, “InnoDB Lock Modes”
Section 13.2.9.6, “Locks Set by Different SQL Statements in InnoDB”
Section 13.2.9.3, “SELECT ... FOR UPDATE and SELECT ... LOCK IN SHARE MODE Locking Reads”
Section 12.3.6, “SET TRANSACTION Syntax”

SELECT DISTINCT

Section C.1.16, “Changes in MySQL 4.1.10 (2005-02-12)”
Section C.1.15, “Changes in MySQL 4.1.11 (2005-04-01)”
Section C.1.11, “Changes in MySQL 4.1.15 (2005-10-13)”
Section C.3.61, “Changes in Release 3.23.0 (05 July 1999: Alpha)”
Section C.3.25, “Changes in Release 3.23.35 (15 March 2001)”
Section C.2.13, “Changes in Release 4.0.19 (04 May 2004)”
Section C.2.5, “Changes in Release 4.0.27 (06 May 2006)”
Section C.2.29, “Changes in Release 4.0.3 (26 August 2002: Beta)”
Section C.2.28, “Changes in Release 4.0.4 (29 September 2002)”
Section 7.11.2, “General Thread States”
Section D.1, “Restrictions on Subqueries”

SET

Section 11.3.4, “Assignment Operators”
Section 14.8.4, “Binary Log Options and Variables”
Section C.1.16, “Changes in MySQL 4.1.10 (2005-02-12)”
Section C.1.15, “Changes in MySQL 4.1.11 (2005-04-01)”
Section C.1.24, “Changes in MySQL 4.1.2 (2004-05-28)”
Section C.1.3, “Changes in MySQL 4.1.23 (2007-06-12)”
Section C.1.20, “Changes in MySQL 4.1.6 (2004-10-10)”
Section C.1.18, “Changes in MySQL 4.1.8 (2004-12-14)”
Section C.3.27, “Changes in Release 3.23.34 (10 March 2001)”
Section C.2.8, “Changes in Release 4.0.24 (04 March 2005)”
Section 5.1.4.2, “Dynamic System Variables”
Section 11.1, “Function and Operator Reference”
Chapter 11, Functions and Operators
Section 11.13, “Information Functions”
Section 1.9.4, “MySQL Extensions to Standard SQL”
Section 4.6.13, “mysql_find_rows — Extract SQL Statements from Files”
Section 4.6.6, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 11.3, “Operators”
Section 7.5.3.3, “Query Cache Configuration”
Section 14.8.2, “Replication Master Options and Variables”
Section 14.8.3, “Replication Slave Options and Variables”
Section D.1, “Restrictions on Subqueries”
Section 5.1.2, “Server Command Options”
Section 5.1.3, “Server System Variables”
Section 12.4.4, “SET Syntax”
Section 12.4.5.25, “SHOW VARIABLES Syntax”
Section 12.2.8, “Subquery Syntax”
Section 10.3.1.1, “TIMESTAMP Properties Prior to MySQL 4.1”
Section 8.4, “User-Defined Variables”
Section 4.2.3.4, “Using Options to Set Program Variables”
Section 5.1.4, “Using System Variables”
Section 4.5.1.6.2, “Using the --safe-updates Option”

SET autocommit

Section 13.2.14.1, “InnoDB Performance Tuning Tips”
Section 12.3, “MySQL Transactional and Locking Statements”
Section 12.3.1, “START TRANSACTION, COMMIT, and ROLLBACK Syntax”

SET COLLATION_SERVER...

Section C.1.20, “Changes in MySQL 4.1.6 (2004-10-10)”

SET GLOBAL

Section C.1.24, “Changes in MySQL 4.1.2 (2004-05-28)”
Section C.2.16, “Changes in Release 4.0.16 (17 October 2003)”
Section C.2.11, “Changes in Release 4.0.21 (06 September 2004)”
Section 5.1.4.2, “Dynamic System Variables”
Section 12.4.1.2, “GRANT Syntax”
Section 7.5.1.2, “Multiple Key Caches”
Section 5.5.1, “Privileges Provided by MySQL”
Section 12.4.4, “SET Syntax”
Section 5.1.4, “Using System Variables”

SET PASSWORD

Section 5.4.2.1, “Administrator Guidelines for Password Security”
Section 5.6.5, “Assigning Account Passwords”
Section 5.5.7, “Causes of Access-Denied Errors”
Section C.1.11, “Changes in MySQL 4.1.15 (2005-10-13)”
Section C.3.29, “Changes in Release 3.23.32 (22 January 2001)”
Section C.3.10, “Changes in Release 3.23.50 (21 April 2002)”
Section C.2.19, “Changes in Release 4.0.13 (16 May 2003)”
Section C.2.17, “Changes in Release 4.0.15 (03 September 2003)”
Section B.5.2.4, “Client does not support authentication protocol”
Section 5.4.2.2, “End-User Guidelines for Password Security”
Section 5.4.2.3, “Password Hashing in MySQL”
Section 14.7.13, “Replication and User Privileges”
Section 2.10.3, “Securing the Initial MySQL Accounts”
Section 12.4.1.4, “SET PASSWORD Syntax”
Section 12.4.4, “SET Syntax”
Section 5.5.3, “Specifying Account Names”
Section 5.5.6, “When Privilege Changes Take Effect”

SET PASSWORD FOR user

Section C.1.25, “Changes in MySQL 4.1.1 (2003-12-01)”

SET SESSION

Section 5.1.4.2, “Dynamic System Variables”
Section 12.4.4, “SET Syntax”
Section 5.1.4, “Using System Variables”

SET sql_mode='mode_value'

Section 1.9.2, “Selecting SQL Modes”

SET TIMESTAMP = value

Section 7.11, “Examining Thread Information”

SET TRANSACTION

Section 12.3.6, “SET TRANSACTION Syntax”
Section 13.2.9, “The InnoDB Transaction Model and Locking”

SET TRANSACTION ISOLATION LEVEL

Section C.3.24, “Changes in Release 3.23.36 (27 March 2001)”
Section 5.1.3, “Server System Variables”
Section 12.4.4, “SET Syntax”
Section 12.3.1, “START TRANSACTION, COMMIT, and ROLLBACK Syntax”

SHOW

Section 17.6.4, “C API Data Structures”
Section 17.6.5, “C API Function Overview”
Section C.1.11, “Changes in MySQL 4.1.15 (2005-10-13)”
Section C.1.24, “Changes in MySQL 4.1.2 (2004-05-28)”
Section C.1.5, “Changes in MySQL 4.1.21 (2006-07-19)”
Section C.2.32, “Changes in Release 4.0.0 (October 2001: Alpha)”
Section 3.3, “Creating and Using a Database”
Section 13.2.5, “Creating and Using InnoDB Tables”
Section 1.9.4, “MySQL Extensions to Standard SQL”
Section 17.6.10.27, “mysql_stmt_store_result()”
Section 17.6.6.67, “mysql_store_result()”
Section 17.6.6.69, “mysql_use_result()”
Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”
Section 14.10, “Replication FAQ”
Section 8.3, “Reserved Words”
Section 12.4.5.5, “SHOW COLUMNS Syntax”
Section 12.4.5.13, “SHOW INDEX Syntax”
Section 12.4.5.17, “SHOW OPEN TABLES Syntax”
Section 9.1.8.3, “SHOW Statements and INFORMATION_SCHEMA”
Section 12.4.5, “SHOW Syntax”
Section 12.4.5.24, “SHOW TABLES Syntax”
Section 12.5.1, “SQL Statements for Controlling Master Servers”
Section 5.3.4, “The Binary Log”
Section 1.3.2, “The Main Features of MySQL”
Section 9.1.10, “UTF-8 for Metadata”

SHOW BINARY LOGS

Section C.1.26, “Changes in MySQL 4.1.0 (2003-04-03, Alpha)”
Section C.1.25, “Changes in MySQL 4.1.1 (2003-12-01)”
Section C.1.13, “Changes in MySQL 4.1.13 (2005-07-15)”
Section C.1.12, “Changes in MySQL 4.1.14 (2005-08-17)”
Section 12.5.1.1, “PURGE BINARY LOGS Syntax”
Section 12.4.5.1, “SHOW BINARY LOGS Syntax”
Section 12.5.1, “SQL Statements for Controlling Master Servers”

SHOW BINLOG EVENTS

Section 12.4.5.2, “SHOW BINLOG EVENTS Syntax”
Section 12.5.1, “SQL Statements for Controlling Master Servers”
Section 12.5.2.7, “START SLAVE Syntax”

SHOW CHARACTER SET

Section 12.1.1, “ALTER DATABASE Syntax”
Section C.1.12, “Changes in MySQL 4.1.14 (2005-08-17)”
Section 9.1.2, “Character Sets and Collations in MySQL”
Section 9.1.12, “Character Sets and Collations That MySQL Supports”
Section 5.1.3, “Server System Variables”
Section 12.4.5.3, “SHOW CHARACTER SET Syntax”
Section 9.1.8.3, “SHOW Statements and INFORMATION_SCHEMA”

SHOW COLLATION

Section 12.1.1, “ALTER DATABASE Syntax”
Section 17.6.4, “C API Data Structures”
Section 9.6, “Character Set Configuration”
Section 9.1.2, “Character Sets and Collations in MySQL”
Section 9.1.3.5, “Character String Literal Character Set and Collation”
Section 9.5.2, “Choosing a Collation ID”
Section 9.1.3.4, “Column Character Set and Collation”
Section 9.1.3.2, “Database Character Set and Collation”
Section 2.9.3, “MySQL Source-Configuration Options”
Section 12.4.5.4, “SHOW COLLATION Syntax”
Section 9.1.8.3, “SHOW Statements and INFORMATION_SCHEMA”
Section 9.1.3.3, “Table Character Set and Collation”

SHOW COLUMNS

Section C.1.3, “Changes in MySQL 4.1.23 (2007-06-12)”
Section C.3.61, “Changes in Release 3.23.0 (05 July 1999: Alpha)”
Section C.3.29, “Changes in Release 3.23.32 (22 January 2001)”
Section 12.7.1, “DESCRIBE Syntax”
Section 12.7.2, “EXPLAIN Syntax”
Section 7.3.1.10, “LIMIT Optimization”
Section 4.6.16, “mysql_tableinfo — Generate Database Metadata”
Section 7.2.1, “Optimizing Queries with EXPLAIN”
Section 12.4.5.5, “SHOW COLUMNS Syntax”
Section 9.1.8.3, “SHOW Statements and INFORMATION_SCHEMA”

SHOW COLUMNS FROM tbl_name

Section 7.2.1, “Optimizing Queries with EXPLAIN”

SHOW CREATE DATABASE

Section C.1.17, “Changes in MySQL 4.1.9 (2005-01-11)”
Section 5.1.3, “Server System Variables”
Section 12.4.5.6, “SHOW CREATE DATABASE Syntax”
Section 9.1.8.3, “SHOW Statements and INFORMATION_SCHEMA”

SHOW CREATE FUNCTION

Section 1.8, “How to Report Bugs or Problems”

SHOW CREATE PROCEDURE

Section 1.8, “How to Report Bugs or Problems”

SHOW CREATE TABLE

Section C.1.16, “Changes in MySQL 4.1.10 (2005-02-12)”
Section C.1.13, “Changes in MySQL 4.1.13 (2005-07-15)”
Section C.1.11, “Changes in MySQL 4.1.15 (2005-10-13)”
Section C.1.5, “Changes in MySQL 4.1.21 (2006-07-19)”
Section C.1.20, “Changes in MySQL 4.1.6 (2004-10-10)”
Section C.1.18, “Changes in MySQL 4.1.8 (2004-12-14)”
Section C.4.16, “Changes in MySQL/InnoDB-4.0.13, May 20, 2003”
Section C.3.41, “Changes in Release 3.23.20 (28 June 2000: Beta)”
Section C.3.27, “Changes in Release 3.23.34 (10 March 2001)”
Section C.3.22, “Changes in Release 3.23.38 (09 May 2001)”
Section C.3.20, “Changes in Release 3.23.40 (18 July 2001)”
Section C.3.12, “Changes in Release 3.23.48 (07 February 2002)”
Section C.3.10, “Changes in Release 3.23.50 (21 April 2002)”
Section C.3.9, “Changes in Release 3.23.51 (31 May 2002)”
Section C.3.2, “Changes in Release 3.23.58 (11 September 2003)”
Section C.2.32, “Changes in Release 4.0.0 (October 2001: Alpha)”
Section C.2.17, “Changes in Release 4.0.15 (03 September 2003)”
Section C.2.14, “Changes in Release 4.0.18 (12 February 2004)”
Section C.2.5, “Changes in Release 4.0.27 (06 May 2006)”
Section 13.5.4, “Characteristics of BDB Tables”
Section 12.1.4, “CREATE INDEX Syntax”
Section 12.1.5, “CREATE TABLE Syntax”
Section 10.1.4, “Data Type Default Values”
Section 12.7.1, “DESCRIBE Syntax”
Section 13.2.5.4, “FOREIGN KEY Constraints”
Section 3.4, “Getting Information About Databases and Tables”
Section 6.6.3, “How to Repair MyISAM Tables”
Section 15.1.4.1, “Noncompliance with SQL Syntax in MySQL Cluster”
Section 2.11.4, “Rebuilding or Repairing Tables or Indexes”
Section 5.1.6, “Server SQL Modes”
Section 5.1.3, “Server System Variables”
Section 12.4.5.5, “SHOW COLUMNS Syntax”
Section 12.4.5.7, “SHOW CREATE TABLE Syntax”
Section 9.1.8.3, “SHOW Statements and INFORMATION_SCHEMA”
Section 12.1.5.2, “Silent Column Specification Changes”
Section 2.11.1.1, “Upgrading from MySQL 4.0 to 4.1”
Section 3.6.6, “Using Foreign Keys”
Section 7.10.2, “Using Symbolic Links for Tables on Unix”

SHOW DATABASES

Section C.2.15, “Changes in Release 4.0.17 (14 December 2003)”
Section C.2.10, “Changes in Release 4.0.22 (27 October 2004)”
Section 12.1.3, “CREATE DATABASE Syntax”
Section 3.3, “Creating and Using a Database”
Section 3.4, “Getting Information About Databases and Tables”
Section 12.4.1.2, “GRANT Syntax”
Section 8.2.2, “Identifier Case Sensitivity”
Section 2.12.1.6, “Linux SPARC Notes”
Section 12.5.2.2, “LOAD DATA FROM MASTER Syntax”
Section 15.5.9.2, “MySQL Cluster and MySQL Privileges”
Section 4.6.16, “mysql_tableinfo — Generate Database Metadata”
Section 5.5.2, “Privilege System Grant Tables”
Section 5.4.4, “Security-Related mysqld Options”
Section 5.1.2, “Server Command Options”
Section 5.1.3, “Server System Variables”
Section 12.4.5.8, “SHOW DATABASES Syntax”

SHOW ENGINE

Section 12.4.5.9, “SHOW ENGINE Syntax”

SHOW ENGINE BDB LOGS

Section 12.4.5.9, “SHOW ENGINE Syntax”
Section 12.4.5.15, “SHOW LOGS Syntax”

SHOW ENGINE INNODB STATUS

Section 13.2.9.9, “How to Cope with Deadlocks”
Section 13.2.14.2.1, “InnoDB Standard Monitor and Lock Monitor Output”
Section 13.2.4, “InnoDB Startup Options and System Variables”
Section 13.2.14.2, “SHOW ENGINE INNODB STATUS and the InnoDB Monitors”
Section 12.4.5.9, “SHOW ENGINE Syntax”
Section 12.4.5.14, “SHOW INNODB STATUS Syntax”
Section B.1, “Sources of Error Information”

SHOW ENGINE NDB STATUS

Section 15.5, “Management of MySQL Cluster”
Section 15.5.8, “Quick Reference: MySQL Cluster SQL Statements”
Section 12.4.5.9, “SHOW ENGINE Syntax”

SHOW ENGINE NDBCLUSTER STATUS

Section 15.5.8, “Quick Reference: MySQL Cluster SQL Statements”
Section 12.4.5.9, “SHOW ENGINE Syntax”

SHOW ENGINES

Section 15.6, “MySQL 4.1 FAQ: MySQL Cluster”
Section 15.5.4, “MySQL Server Usage for MySQL Cluster”
Section B.5.5.5, “Rollback Failure for Nontransactional Tables”
Section 12.4.5.10, “SHOW ENGINES Syntax”
Chapter 13, Storage Engines
Section 13.2, “The InnoDB Storage Engine”
Section 5.2, “The mysqld-max Extended MySQL Server”

SHOW ERRORS

Section C.1.15, “Changes in MySQL 4.1.11 (2005-04-01)”
Section 5.1.3, “Server System Variables”
Section 12.4.5.11, “SHOW ERRORS Syntax”
Section 12.4.5.26, “SHOW WARNINGS Syntax”
Section B.1, “Sources of Error Information”

SHOW FULL COLUMNS

Section 12.1.5, “CREATE TABLE Syntax”
Section 9.1.8.3, “SHOW Statements and INFORMATION_SCHEMA”

SHOW FULL PROCESSLIST

Section 7.11, “Examining Thread Information”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”

SHOW GLOBAL STATUS

Section C.1.3, “Changes in MySQL 4.1.23 (2007-06-12)”
Section 5.1.3, “Server System Variables”

SHOW GRANTS

Section 5.6.2, “Adding User Accounts”
Section C.1.24, “Changes in MySQL 4.1.2 (2004-05-28)”
Section C.3.50, “Changes in Release 3.23.11 (16 February 2000)”
Section C.3.35, “Changes in Release 3.23.26 (18 October 2000)”
Section C.3.12, “Changes in Release 3.23.48 (07 February 2002)”
Section C.2.19, “Changes in Release 4.0.13 (16 May 2003)”
Section C.2.16, “Changes in Release 4.0.16 (17 October 2003)”
Section C.2.28, “Changes in Release 4.0.4 (29 September 2002)”
Section 12.4.1.1, “DROP USER Syntax”
Section 5.4.1, “General Security Guidelines”
Section 12.4.1.2, “GRANT Syntax”
Section 5.5.2, “Privilege System Grant Tables”
Section 12.4.1.3, “REVOKE Syntax”
Section 12.4.5.12, “SHOW GRANTS Syntax”
Section 12.4.5.18, “SHOW PRIVILEGES Syntax”
Section 5.5, “The MySQL Access Privilege System”

SHOW INDEX

Section 12.4.2.1, “ANALYZE TABLE Syntax”
Section C.1.16, “Changes in MySQL 4.1.10 (2005-02-12)”
Section C.3.61, “Changes in Release 3.23.0 (05 July 1999: Alpha)”
Section C.2.32, “Changes in Release 4.0.0 (October 2001: Alpha)”
Section C.2.30, “Changes in Release 4.0.2 (01 July 2002)”
Section 12.7.1, “DESCRIBE Syntax”
Section 7.2.2, “EXPLAIN Output Format”
Section 12.2.7.2, “Index Hint Syntax”
Section 7.4.4, “MyISAM Index Statistics Collection”
Section 4.6.16, “mysql_tableinfo — Generate Database Metadata”
Section 4.6.2.4, “Other myisamchk Options”
Section 13.2.15, “Restrictions on InnoDB Tables”
Section 12.4.5.5, “SHOW COLUMNS Syntax”
Section 12.4.5.13, “SHOW INDEX Syntax”
Section 2.11.1.2, “Upgrading from MySQL 3.23 to 4.0”

SHOW INNODB STATUS

Section C.1.14, “Changes in MySQL 4.1.12 (2005-05-13)”
Section C.1.18, “Changes in MySQL 4.1.8 (2004-12-14)”
Section C.4.16, “Changes in MySQL/InnoDB-4.0.13, May 20, 2003”
Section C.4.14, “Changes in MySQL/InnoDB-4.0.14, July 22, 2003”
Section C.4.6, “Changes in MySQL/InnoDB-4.0.19, May 4, 2004”
Section C.4.5, “Changes in MySQL/InnoDB-4.0.20, May 18, 2004”
Section C.4.1, “Changes in MySQL/InnoDB-4.0.21, September 10, 2004”
Section C.4.4, “Changes in MySQL/InnoDB-4.1.2, May 30, 2004”
Section C.4.2, “Changes in MySQL/InnoDB-4.1.4, August 31, 2004”
Section C.3.7, “Changes in Release 3.23.53 (09 October 2002)”
Section C.2.9, “Changes in Release 4.0.23 (18 December 2004)”
Section 13.2.5.4, “FOREIGN KEY Constraints”
Section 13.2.9.9, “How to Cope with Deadlocks”
Section 13.2.4, “InnoDB Startup Options and System Variables”
Section 13.2.14.2, “SHOW ENGINE INNODB STATUS and the InnoDB Monitors”
Section 12.4.5.9, “SHOW ENGINE Syntax”
Section 12.4.5.14, “SHOW INNODB STATUS Syntax”
Section 13.2.3.1, “Using Per-Table Tablespaces”

SHOW KEYS

Section C.1.14, “Changes in MySQL 4.1.12 (2005-05-13)”
Section C.3.32, “Changes in Release 3.23.29 (16 December 2000)”
Section C.2.19, “Changes in Release 4.0.13 (16 May 2003)”
Section C.2.14, “Changes in Release 4.0.18 (12 February 2004)”

SHOW MASTER LOGS

Section C.1.26, “Changes in MySQL 4.1.0 (2003-04-03, Alpha)”
Section C.1.25, “Changes in MySQL 4.1.1 (2003-12-01)”
Section C.1.4, “Changes in MySQL 4.1.22 (2006-11-02)”
Section C.3.33, “Changes in Release 3.23.28 (22 November 2000: Gamma)”
Section C.2.18, “Changes in Release 4.0.14 (18 July 2003)”
Section 12.4.5.1, “SHOW BINARY LOGS Syntax”

SHOW MASTER STATUS

Section C.3.39, “Changes in Release 3.23.22 (31 July 2000)”
Section C.3.38, “Changes in Release 3.23.23 (01 September 2000)”
Section C.3.33, “Changes in Release 3.23.28 (22 November 2000: Gamma)”
Section C.2.19, “Changes in Release 4.0.13 (16 May 2003)”
Section C.2.29, “Changes in Release 4.0.3 (26 August 2002: Beta)”
Section 14.12, “How to Report Replication Bugs or Problems”
Section 14.4, “How to Set Up Replication”
Section 5.5.1, “Privileges Provided by MySQL”
Section 14.10, “Replication FAQ”
Section 12.5.1, “SQL Statements for Controlling Master Servers”
Section 14.11, “Troubleshooting Replication”
Section 2.11.1.2, “Upgrading from MySQL 3.23 to 4.0”
Section 14.6.1, “Upgrading Replication to 4.0 or 4.1”

SHOW OPEN TABLES

Section C.3.31, “Changes in Release 3.23.30 (04 January 2001)”
Section C.2.32, “Changes in Release 4.0.0 (October 2001: Alpha)”
Section C.2.28, “Changes in Release 4.0.4 (29 September 2002)”
Section 12.4.5.17, “SHOW OPEN TABLES Syntax”
Section 2.11.1.2, “Upgrading from MySQL 3.23 to 4.0”

SHOW PRIVILEGES

Section 12.4.5.18, “SHOW PRIVILEGES Syntax”

SHOW PROCESSLIST

Section C.1.3, “Changes in MySQL 4.1.23 (2007-06-12)”
Section C.1.22, “Changes in MySQL 4.1.4 (2004-08-26, Gamma)”
Section C.1.18, “Changes in MySQL 4.1.8 (2004-12-14)”
Section C.3.39, “Changes in Release 3.23.22 (31 July 2000)”
Section C.3.38, “Changes in Release 3.23.23 (01 September 2000)”
Section C.3.6, “Changes in Release 3.23.54 (05 December 2002)”
Section C.3.5, “Changes in Release 3.23.55 (23 January 2003)”
Section C.3.54, “Changes in Release 3.23.7 (10 December 1999)”
Section C.2.20, “Changes in Release 4.0.12 (15 March 2003: Production)”
Section C.2.19, “Changes in Release 4.0.13 (16 May 2003)”
Section C.2.17, “Changes in Release 4.0.15 (03 September 2003)”
Section C.2.11, “Changes in Release 4.0.21 (06 September 2004)”
Section C.2.27, “Changes in Release 4.0.5 (13 November 2002)”
Section 7.11.2, “General Thread States”
Section 12.4.1.2, “GRANT Syntax”
Section 13.2.13, “InnoDB Error Handling”
Section 12.4.6.3, “KILL Syntax”
Section 5.4.3, “Making MySQL Secure Against Attackers”
Section 15.5.4, “MySQL Server Usage for MySQL Cluster”
Section 17.6.6.41, “mysql_list_processes()”
Section 4.5.2, “mysqladmin — Client for Administering a MySQL Server”
Section 5.5.1, “Privileges Provided by MySQL”
Section 14.10, “Replication FAQ”
Section 14.3, “Replication Implementation Details”
Section 12.4.5.19, “SHOW PROCESSLIST Syntax”
Section 12.4.5.21, “SHOW SLAVE STATUS Syntax”
Section 12.3.1, “START TRANSACTION, COMMIT, and ROLLBACK Syntax”
Section B.5.2.7, “Too many connections”
Section 14.11, “Troubleshooting Replication”

SHOW SLAVE HOSTS

Section 14.8.3, “Replication Slave Options and Variables”
Section 12.5.1, “SQL Statements for Controlling Master Servers”

SHOW SLAVE STATUS

Section C.1.25, “Changes in MySQL 4.1.1 (2003-12-01)”
Section C.1.13, “Changes in MySQL 4.1.13 (2005-07-15)”
Section C.1.12, “Changes in MySQL 4.1.14 (2005-08-17)”
Section C.1.24, “Changes in MySQL 4.1.2 (2004-05-28)”
Section C.3.39, “Changes in Release 3.23.22 (31 July 2000)”
Section C.3.38, “Changes in Release 3.23.23 (01 September 2000)”
Section C.3.33, “Changes in Release 3.23.28 (22 November 2000: Gamma)”
Section C.3.28, “Changes in Release 3.23.33 (09 February 2001)”
Section C.2.20, “Changes in Release 4.0.12 (15 March 2003: Production)”
Section C.2.19, “Changes in Release 4.0.13 (16 May 2003)”
Section C.2.18, “Changes in Release 4.0.14 (18 July 2003)”
Section C.2.17, “Changes in Release 4.0.15 (03 September 2003)”
Section C.2.13, “Changes in Release 4.0.19 (04 May 2004)”
Section C.2.29, “Changes in Release 4.0.3 (26 August 2002: Beta)”
Section 14.12, “How to Report Replication Bugs or Problems”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 5.5.1, “Privileges Provided by MySQL”
Section 12.5.1.1, “PURGE BINARY LOGS Syntax”
Section 14.7.8, “Replication and LOAD Operations”
Section 14.10, “Replication FAQ”
Section 14.3, “Replication Implementation Details”
Section 7.11.5, “Replication Slave I/O Thread States”
Section 14.8.3, “Replication Slave Options and Variables”
Section 12.4.5.21, “SHOW SLAVE STATUS Syntax”
Section 14.7.16, “Slave Errors During Replication”
Section B.1, “Sources of Error Information”
Section 12.5.2, “SQL Statements for Controlling Slave Servers”
Section 12.5.2.7, “START SLAVE Syntax”
Section 14.3.3, “The Slave Status Files”
Section 14.11, “Troubleshooting Replication”
Section 2.11.1.2, “Upgrading from MySQL 3.23 to 4.0”

SHOW STATUS

Section C.3.61, “Changes in Release 3.23.0 (05 July 1999: Alpha)”
Section C.3.33, “Changes in Release 3.23.28 (22 November 2000: Gamma)”
Section C.3.13, “Changes in Release 3.23.47 (27 December 2001)”
Section 15.3.2.6, “Defining SQL and Other API Nodes in a MySQL Cluster”
Section 12.2.4.2, “INSERT DELAYED Syntax”
Section 7.5.3.4, “Query Cache Status and Maintenance”
Section 14.7.12, “Replication and Temporary Tables”
Section 14.3, “Replication Implementation Details”
Section 14.7.17, “Replication Retries and Timeouts”
Section 5.1.5, “Server Status Variables”
Section 5.1.3, “Server System Variables”
Section 12.4.5.22, “SHOW STATUS Syntax”

SHOW TABLE STATUS

Section 13.2.5.3, “AUTO_INCREMENT Handling in InnoDB”
Section C.1.10, “Changes in MySQL 4.1.16 (2005-11-29)”
Section C.1.24, “Changes in MySQL 4.1.2 (2004-05-28)”
Section C.1.19, “Changes in MySQL 4.1.7 (2004-10-23, Production)”
Section C.4.7, “Changes in MySQL/InnoDB-4.0.18, February 13, 2004”
Section C.4.1, “Changes in MySQL/InnoDB-4.0.21, September 10, 2004”
Section C.4.2, “Changes in MySQL/InnoDB-4.1.4, August 31, 2004”
Section C.3.61, “Changes in Release 3.23.0 (05 July 1999: Alpha)”
Section C.3.58, “Changes in Release 3.23.3 (13 September 1999)”
Section C.3.30, “Changes in Release 3.23.31 (17 January 2001: Production)”
Section C.3.12, “Changes in Release 3.23.48 (07 February 2002)”
Section C.3.4, “Changes in Release 3.23.56 (13 March 2003)”
Section C.3.3, “Changes in Release 3.23.57 (06 June 2003)”
Section C.2.21, “Changes in Release 4.0.11 (20 February 2003)”
Section C.2.15, “Changes in Release 4.0.17 (14 December 2003)”
Section 12.1.5, “CREATE TABLE Syntax”
Section 13.2.5, “Creating and Using InnoDB Tables”
Section 12.7.1, “DESCRIBE Syntax”
Section 13.2.12.2, “File Space Management”
Section 13.2.9.6, “Locks Set by Different SQL Statements in InnoDB”
Section 4.6.16, “mysql_tableinfo — Generate Database Metadata”
Section 13.2.15, “Restrictions on InnoDB Tables”
Section 12.4.5.5, “SHOW COLUMNS Syntax”
Section 12.4.5.23, “SHOW TABLE STATUS Syntax”
Section 13.7, “The ARCHIVE Storage Engine”
Section 2.11.1.1, “Upgrading from MySQL 4.0 to 4.1”

SHOW TABLES

Section C.1.4, “Changes in MySQL 4.1.22 (2006-11-02)”
Section C.2.18, “Changes in Release 4.0.14 (18 July 2003)”
Section 3.3.2, “Creating a Table”
Section 8.2.2, “Identifier Case Sensitivity”
Section 4.6.16, “mysql_tableinfo — Generate Database Metadata”
Section 12.4.5.23, “SHOW TABLE STATUS Syntax”
Section 12.4.5.24, “SHOW TABLES Syntax”
Section B.5.2.16, “Table 'tbl_name' doesn't exist”
Section B.5.7.2, “TEMPORARY Table Problems”

SHOW VARIABLES

Section C.1.15, “Changes in MySQL 4.1.11 (2005-04-01)”
Section C.3.46, “Changes in Release 3.23.15 (08 May 2000)”
Section C.3.33, “Changes in Release 3.23.28 (22 November 2000: Gamma)”
Section C.3.58, “Changes in Release 3.23.3 (13 September 1999)”
Section C.3.31, “Changes in Release 3.23.30 (04 January 2001)”
Section C.3.25, “Changes in Release 3.23.35 (15 March 2001)”
Section C.3.16, “Changes in Release 3.23.44 (31 October 2001)”
Section C.3.12, “Changes in Release 3.23.48 (07 February 2002)”
Section C.3.4, “Changes in Release 3.23.56 (13 March 2003)”
Section C.2.30, “Changes in Release 4.0.2 (01 July 2002)”
Section C.2.8, “Changes in Release 4.0.24 (04 March 2005)”
Section C.2.28, “Changes in Release 4.0.4 (29 September 2002)”
Section 5.1.3, “Server System Variables”
Section 12.4.4, “SET Syntax”
Section 12.4.5.25, “SHOW VARIABLES Syntax”
Section 5.1.4, “Using System Variables”

SHOW WARNINGS

Section 12.1.2, “ALTER TABLE Syntax”
Section C.1.25, “Changes in MySQL 4.1.1 (2003-12-01)”
Section C.1.15, “Changes in MySQL 4.1.11 (2005-04-01)”
Section C.1.13, “Changes in MySQL 4.1.13 (2005-07-15)”
Section C.1, “Changes in Release 4.1.x (Lifecycle Support Ended)”
Section 7.2.2, “EXPLAIN Output Format”
Section 12.2.5, “LOAD DATA INFILE Syntax”
Section 1.6, “MySQL 4.1 in a Nutshell”
Section 1.9.6.1, “PRIMARY KEY and UNIQUE Index Constraints”
Section 5.1.3, “Server System Variables”
Section 12.4.5.11, “SHOW ERRORS Syntax”
Section 12.4.5.26, “SHOW WARNINGS Syntax”
Section B.1, “Sources of Error Information”

START SLAVE

Section 12.5.2.1, “CHANGE MASTER TO Syntax”
Section C.1.26, “Changes in MySQL 4.1.0 (2003-04-03, Alpha)”
Section C.1.25, “Changes in MySQL 4.1.1 (2003-12-01)”
Section C.1.24, “Changes in MySQL 4.1.2 (2004-05-28)”
Section C.1.22, “Changes in MySQL 4.1.4 (2004-08-26, Gamma)”
Section C.2.17, “Changes in Release 4.0.15 (03 September 2003)”
Section C.2.15, “Changes in Release 4.0.17 (14 December 2003)”
Section C.2.13, “Changes in Release 4.0.19 (04 May 2004)”
Section C.2.11, “Changes in Release 4.0.21 (06 September 2004)”
Section 14.10, “Replication FAQ”
Section 14.3, “Replication Implementation Details”
Section 14.8.3, “Replication Slave Options and Variables”
Section 12.4.5.21, “SHOW SLAVE STATUS Syntax”
Section 14.7.16, “Slave Errors During Replication”
Section 12.5.2.7, “START SLAVE Syntax”
Section 12.5.2.8, “STOP SLAVE Syntax”
Section 14.11, “Troubleshooting Replication”

START TRANSACTION

Section C.1.18, “Changes in MySQL 4.1.8 (2004-12-14)”
Section C.2.21, “Changes in Release 4.0.11 (20 February 2003)”
Section 13.5.4, “Characteristics of BDB Tables”
Section 13.2.9.9, “How to Cope with Deadlocks”
Section 13.2.5.1, “How to Use Transactions in InnoDB with Different APIs”
Section 13.2.13, “InnoDB Error Handling”
Section 12.3.5.1, “Interaction of Table Locking and Transactions”
Section 12.3.5, “LOCK TABLES and UNLOCK TABLES Syntax”
Section 12.3, “MySQL Transactional and Locking Statements”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 13.2.9.3, “SELECT ... FOR UPDATE and SELECT ... LOCK IN SHARE MODE Locking Reads”
Section 5.1.3, “Server System Variables”
Section 7.3.2.1, “Speed of INSERT Statements”
Section 12.3.1, “START TRANSACTION, COMMIT, and ROLLBACK Syntax”
Section 12.3.3, “Statements That Cause an Implicit Commit”
Section 13.2.9, “The InnoDB Transaction Model and Locking”

STOP SLAVE

Section 12.5.2.1, “CHANGE MASTER TO Syntax”
Section C.1.26, “Changes in MySQL 4.1.0 (2003-04-03, Alpha)”
Section C.1.10, “Changes in MySQL 4.1.16 (2005-11-29)”
Section C.1.22, “Changes in MySQL 4.1.4 (2004-08-26, Gamma)”
Section C.2.20, “Changes in Release 4.0.12 (15 March 2003: Production)”
Section C.2.17, “Changes in Release 4.0.15 (03 September 2003)”
Section C.2.15, “Changes in Release 4.0.17 (14 December 2003)”
Section 14.7.12, “Replication and Temporary Tables”
Section 14.10, “Replication FAQ”
Section 12.5.1.2, “RESET MASTER Syntax”
Section 12.5.2.5, “RESET SLAVE Syntax”
Section 12.5.2.7, “START SLAVE Syntax”
Section 12.5.2.8, “STOP SLAVE Syntax”
Section 14.6.1, “Upgrading Replication to 4.0 or 4.1”

T

[index top]

TRUNCATE TABLE

Section C.1.15, “Changes in MySQL 4.1.11 (2005-04-01)”
Section C.1.13, “Changes in MySQL 4.1.13 (2005-07-15)”
Section C.1.11, “Changes in MySQL 4.1.15 (2005-10-13)”
Section C.1.7, “Changes in MySQL 4.1.19 (2006-04-29)”
Section C.1.5, “Changes in MySQL 4.1.21 (2006-07-19)”
Section C.1.22, “Changes in MySQL 4.1.4 (2004-08-26, Gamma)”
Section C.1.18, “Changes in MySQL 4.1.8 (2004-12-14)”
Section C.3.3, “Changes in Release 3.23.57 (06 June 2003)”
Section C.2.32, “Changes in Release 4.0.0 (October 2001: Alpha)”
Section C.2.20, “Changes in Release 4.0.12 (15 March 2003: Production)”
Section C.2.30, “Changes in Release 4.0.2 (01 July 2002)”
Section C.2.11, “Changes in Release 4.0.21 (06 September 2004)”
Section 13.1.3.3, “Compressed Table Characteristics”
Section 12.2.1, “DELETE Syntax”
Section 7.5.3.1, “How the Query Cache Operates”
Section 6.6.3, “How to Repair MyISAM Tables”
Section 15.1.4.2, “Limits and Differences of MySQL Cluster from Standard MySQL Limits”
Section 15.1.4.3, “Limits Relating to Transaction Handling in MySQL Cluster”
Section 13.3.2, “MERGE Table Problems”
Section 1.5, “MySQL 4.0 in a Nutshell”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 15.4.6, “ndb_delete_all — Delete All Rows from an NDB Table”
Section 5.1.3, “Server System Variables”
Section 12.3.3, “Statements That Cause an Implicit Commit”
Section 13.4, “The MEMORY (HEAP) Storage Engine”
Section 12.1.10, “TRUNCATE TABLE Syntax”
Section 2.11.1.2, “Upgrading from MySQL 3.23 to 4.0”
Section 17.6.13.2, “What Results You Can Get from a Query”

U

[index top]

UNION

Section 17.6.4, “C API Data Structures”
Section C.1.26, “Changes in MySQL 4.1.0 (2003-04-03, Alpha)”
Section C.1.25, “Changes in MySQL 4.1.1 (2003-12-01)”
Section C.1.16, “Changes in MySQL 4.1.10 (2005-02-12)”
Section C.1.15, “Changes in MySQL 4.1.11 (2005-04-01)”
Section C.1.14, “Changes in MySQL 4.1.12 (2005-05-13)”
Section C.1.13, “Changes in MySQL 4.1.13 (2005-07-15)”
Section C.1.12, “Changes in MySQL 4.1.14 (2005-08-17)”
Section C.1.11, “Changes in MySQL 4.1.15 (2005-10-13)”
Section C.1.10, “Changes in MySQL 4.1.16 (2005-11-29)”
Section C.1.7, “Changes in MySQL 4.1.19 (2006-04-29)”
Section C.1.24, “Changes in MySQL 4.1.2 (2004-05-28)”
Section C.1.3, “Changes in MySQL 4.1.23 (2007-06-12)”
Section C.1.2, “Changes in MySQL 4.1.24 (2008-03-01)”
Section C.1.23, “Changes in MySQL 4.1.3 (2004-06-28, Beta)”
Section C.2.32, “Changes in Release 4.0.0 (October 2001: Alpha)”
Section C.2.19, “Changes in Release 4.0.13 (16 May 2003)”
Section C.2.18, “Changes in Release 4.0.14 (18 July 2003)”
Section C.2.17, “Changes in Release 4.0.15 (03 September 2003)”
Section C.2.15, “Changes in Release 4.0.17 (14 December 2003)”
Section C.2.13, “Changes in Release 4.0.19 (04 May 2004)”
Section C.2.30, “Changes in Release 4.0.2 (01 July 2002)”
Section C.2.10, “Changes in Release 4.0.22 (27 October 2004)”
Section C.2.5, “Changes in Release 4.0.27 (06 May 2006)”
Section C.2, “Changes in Release 4.0.x (Lifecycle Support Ended)”
Section 12.1.5, “CREATE TABLE Syntax”
Section 7.2.2, “EXPLAIN Output Format”
Section 7.7.4, “How MySQL Uses Internal Temporary Tables”
Section 11.13, “Information Functions”
Section B.5.8.2, “Issues in MySQL 4.0 Fixed in a Later Version”
Section 13.2.9.6, “Locks Set by Different SQL Statements in InnoDB”
Section 1.5, “MySQL 4.0 in a Nutshell”
Section 10.2.4, “Numeric Type Attributes”
Section 8.3, “Reserved Words”
Section 9.1.8.1, “Result Strings”
Section 3.6.7, “Searching on Two Keys”
Section 12.2.7, “SELECT Syntax”
Section 12.2.8, “Subquery Syntax”
Section 12.2.7.3, “UNION Syntax”

UNION ALL

Section C.1.15, “Changes in MySQL 4.1.11 (2005-04-01)”
Section C.1.24, “Changes in MySQL 4.1.2 (2004-05-28)”
Section 7.7.4, “How MySQL Uses Internal Temporary Tables”
Section 11.13, “Information Functions”
Section B.5.8.2, “Issues in MySQL 4.0 Fixed in a Later Version”
Section 12.2.7.3, “UNION Syntax”

UNION DISTINCT

Section C.1.15, “Changes in MySQL 4.1.11 (2005-04-01)”
Section C.2.15, “Changes in Release 4.0.17 (14 December 2003)”
Section B.5.8.2, “Issues in MySQL 4.0 Fixed in a Later Version”
Section 12.2.7.3, “UNION Syntax”

UNLOCK TABLES

Section C.4.1, “Changes in MySQL/InnoDB-4.0.21, September 10, 2004”
Section 6.2, “Database Backup Methods”
Section 12.4.6.2, “FLUSH Syntax”
Section 13.2.9.9, “How to Cope with Deadlocks”
Section 12.3.5.1, “Interaction of Table Locking and Transactions”
Section 12.3.5, “LOCK TABLES and UNLOCK TABLES Syntax”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 13.2.15, “Restrictions on InnoDB Tables”
Section 7.3.2.1, “Speed of INSERT Statements”
Section 12.3.1, “START TRANSACTION, COMMIT, and ROLLBACK Syntax”
Section 12.3.3, “Statements That Cause an Implicit Commit”
Section 7.8.1, “System Factors and Startup Parameter Tuning”
Section 12.3.5.2, “Table-Locking Restrictions and Conditions”
Section 1.9.5.4, “Transactions and Atomic Operations”

UPDATE

Section 5.5.5, “Access Control, Stage 2: Request Verification”
Section 5.6.2, “Adding User Accounts”
Section 5.6.5, “Assigning Account Passwords”
Section 11.3.4, “Assignment Operators”
Section 14.8.4, “Binary Log Options and Variables”
Section 17.6.5, “C API Function Overview”
Section 17.6.9, “C API Prepared Statement Function Overview”
Section 17.6.15, “C API Support for Multiple Statement Execution”
Section 5.5.7, “Causes of Access-Denied Errors”
Section C.1.16, “Changes in MySQL 4.1.10 (2005-02-12)”
Section C.1.13, “Changes in MySQL 4.1.13 (2005-07-15)”
Section C.1.12, “Changes in MySQL 4.1.14 (2005-08-17)”
Section C.1.11, “Changes in MySQL 4.1.15 (2005-10-13)”
Section C.1.10, “Changes in MySQL 4.1.16 (2005-11-29)”
Section C.1.9, “Changes in MySQL 4.1.17 (Not released)”
Section C.1.8, “Changes in MySQL 4.1.18 (2006-01-27)”
Section C.1.7, “Changes in MySQL 4.1.19 (2006-04-29)”
Section C.1.24, “Changes in MySQL 4.1.2 (2004-05-28)”
Section C.1.4, “Changes in MySQL 4.1.22 (2006-11-02)”
Section C.1.2, “Changes in MySQL 4.1.24 (2008-03-01)”
Section C.1.23, “Changes in MySQL 4.1.3 (2004-06-28, Beta)”
Section C.1.20, “Changes in MySQL 4.1.6 (2004-10-10)”
Section C.4.7, “Changes in MySQL/InnoDB-4.0.18, February 13, 2004”
Section C.3.61, “Changes in Release 3.23.0 (05 July 1999: Alpha)”
Section C.3.46, “Changes in Release 3.23.15 (08 May 2000)”
Section C.3.40, “Changes in Release 3.23.21 (04 July 2000)”
Section C.3.35, “Changes in Release 3.23.26 (18 October 2000)”
Section C.3.33, “Changes in Release 3.23.28 (22 November 2000: Gamma)”
Section C.3.32, “Changes in Release 3.23.29 (16 December 2000)”
Section C.3.58, “Changes in Release 3.23.3 (13 September 1999)”
Section C.3.24, “Changes in Release 3.23.36 (27 March 2001)”
Section C.3.23, “Changes in Release 3.23.37 (17 April 2001)”
Section C.3.20, “Changes in Release 3.23.40 (18 July 2001)”
Section C.3.3, “Changes in Release 3.23.57 (06 June 2003)”
Section C.2.32, “Changes in Release 4.0.0 (October 2001: Alpha)”
Section C.2.20, “Changes in Release 4.0.12 (15 March 2003: Production)”
Section C.2.19, “Changes in Release 4.0.13 (16 May 2003)”
Section C.2.17, “Changes in Release 4.0.15 (03 September 2003)”
Section C.2.15, “Changes in Release 4.0.17 (14 December 2003)”
Section C.2.14, “Changes in Release 4.0.18 (12 February 2004)”
Section C.2.13, “Changes in Release 4.0.19 (04 May 2004)”
Section C.2.30, “Changes in Release 4.0.2 (01 July 2002)”
Section C.2.10, “Changes in Release 4.0.22 (27 October 2004)”
Section C.2.8, “Changes in Release 4.0.24 (04 March 2005)”
Section C.2.7, “Changes in Release 4.0.25 (05 July 2005)”
Section C.2.5, “Changes in Release 4.0.27 (06 May 2006)”
Section C.2.29, “Changes in Release 4.0.3 (26 August 2002: Beta)”
Section C.2.26, “Changes in Release 4.0.6 (14 December 2002: Gamma)”
Section C.1, “Changes in Release 4.1.x (Lifecycle Support Ended)”
Section 12.4.2.3, “CHECK TABLE Syntax”
Section B.5.2.4, “Client does not support authentication protocol”
Section 15.3.2.11, “Configuring MySQL Cluster Parameters for Local Checkpoints”
Section 12.1.5, “CREATE TABLE Syntax”
Section 10.1.2, “Date and Time Type Overview”
Section 13.2.7.2, “Forcing InnoDB Recovery”
Section 13.2.5.4, “FOREIGN KEY Constraints”
Section 11.1, “Function and Operator Reference”
Chapter 11, Functions and Operators
Section 7.11.2, “General Thread States”
Section 12.4.1.2, “GRANT Syntax”
Section 7.5.3.1, “How the Query Cache Operates”
Section 12.2.7.2, “Index Hint Syntax”
Section 11.13, “Information Functions”
Section 13.2.4, “InnoDB Startup Options and System Variables”
Section 12.2.4.3, “INSERT ... ON DUPLICATE KEY UPDATE Syntax”
Section 12.2.4.2, “INSERT DELAYED Syntax”
Section 12.2.4, “INSERT Syntax”
Section 7.6.1, “Internal Locking Methods”
Section 12.2.7.1, “JOIN Syntax”
Section 12.4.6.3, “KILL Syntax”
Section 12.2.5, “LOAD DATA INFILE Syntax”
Section 13.2.9.6, “Locks Set by Different SQL Statements in InnoDB”
Section 11.14, “Miscellaneous Functions”
Section 1.5, “MySQL 4.0 in a Nutshell”
Section 7.1.1, “MySQL Design Limitations and Tradeoffs”
Section 1.9.4, “MySQL Extensions to Standard SQL”
Section 4.5.1.1, “mysql Options”
Section 17.6.6.1, “mysql_affected_rows()”
Section 4.6.12, “mysql_explain_log — Use EXPLAIN on Statements in Query Log”
Section 17.6.6.33, “mysql_info()”
Section 17.6.6.35, “mysql_insert_id()”
Section 17.6.6.42, “mysql_list_tables()”
Section 17.6.6.47, “mysql_options()”
Section 17.6.10.10, “mysql_stmt_execute()”
Section 17.6.10.16, “mysql_stmt_insert_id()”
Section 17.6.10.17, “mysql_stmt_num_rows()”
Section B.5.8.4, “Open Issues in MySQL”
Section 11.3, “Operators”
Section 10.2.5, “Out-of-Range and Overflow Handling”
Section 1.9.6.1, “PRIMARY KEY and UNIQUE Index Constraints”
Section 5.5.2, “Privilege System Grant Tables”
Section 5.5.1, “Privileges Provided by MySQL”
Section B.5.5.2, “Problems Using DATE Columns”
Section 14.7.7, “Replication and LIMIT”
Section 14.8.3, “Replication Slave Options and Variables”
Section B.5.4.1.2, “Resetting the Root Password: Unix Systems”
Section B.5.4.1.1, “Resetting the Root Password: Windows Systems”
Section D.1, “Restrictions on Subqueries”
Section 12.2.8.11, “Rewriting Subqueries as Joins for Earlier MySQL Versions”
Section 2.10.3, “Securing the Initial MySQL Accounts”
Section 13.2.9.3, “SELECT ... FOR UPDATE and SELECT ... LOCK IN SHARE MODE Locking Reads”
Section 3.3.4.1, “Selecting All Data”
Section 5.1.2, “Server Command Options”
Section 5.1.3, “Server System Variables”
Section 12.4.1.4, “SET PASSWORD Syntax”
Section 12.3.6, “SET TRANSACTION Syntax”
Section 12.4.5.26, “SHOW WARNINGS Syntax”
Section 7.3.2.1, “Speed of INSERT Statements”
Section 12.2.8.9, “Subquery Errors”
Section 12.2.8, “Subquery Syntax”
Section 7.6.2, “Table Locking Issues”
Section 12.3.5.2, “Table-Locking Restrictions and Conditions”
Section 9.1.7.6, “The _bin and binary Collations”
Section 13.7, “The ARCHIVE Storage Engine”
Section 5.3.4, “The Binary Log”
Section 1.3.2, “The Main Features of MySQL”
Section 13.3, “The MERGE Storage Engine”
Section 5.5, “The MySQL Access Privilege System”
Section 5.1.9, “The Shutdown Process”
Section 5.3.3, “The Update Log”
Section 10.3.1.1, “TIMESTAMP Properties Prior to MySQL 4.1”
Section 1.9.5.4, “Transactions and Atomic Operations”
Section 1.9.5.3, “UPDATE”
Section 12.2.9, “UPDATE Syntax”
Section 4.5.1.6.2, “Using the --safe-updates Option”
Section 17.6.13.2, “What Results You Can Get from a Query”
Section 5.5.6, “When Privilege Changes Take Effect”
Section 7.3.1.2, “WHERE Clause Optimization”
Section 17.6.13.1, “Why mysql_store_result() Sometimes Returns NULL After mysql_query() Returns Success”

UPDATE ... WHERE ...

Section 13.2.9.6, “Locks Set by Different SQL Statements in InnoDB”

USE

Section 14.8.4, “Binary Log Options and Variables”
Section C.1.24, “Changes in MySQL 4.1.2 (2004-05-28)”
Section C.2.13, “Changes in Release 4.0.19 (04 May 2004)”
Section 6.4.5.2, “Copy a Database from one Server to Another”
Section 3.3.1, “Creating and Selecting a Database”
Section 3.3, “Creating and Using a Database”
Section 6.4.1, “Dumping Data in SQL Format with mysqldump”
Section 14.9.1, “Evaluation of Database-Level Replication and Binary Logging Options”
Section 4.5.1.1, “mysql Options”
Section 4.6.6, “mysqlbinlog — Utility for Processing Binary Log Files”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 6.4.2, “Reloading SQL-Format Backups”
Section 14.8.3, “Replication Slave Options and Variables”
Section 12.7.4, “USE Syntax”

USE db2

Section 4.6.6, “mysqlbinlog — Utility for Processing Binary Log Files”

USE db_name

Section 4.5.1.1, “mysql Options”

USE test

Section 4.6.6, “mysqlbinlog — Utility for Processing Binary Log Files”