Statement/Syntax Index
Prev   Next

Statement/Syntax Index

ALTER DATABASE

Section 9.1.3.2, “Database Character Set and Collation”

ALTER EVENT

Section 19.6, “Binary Logging of Stored Programs”
Section 16.3.1.7, “Replication of Invoked Features”
Section D.1, “Restrictions on Stored Routines, Triggers, and Events”
Section 20.20, “The INFORMATION_SCHEMA EVENTS Table”

ALTER FUNCTION

Section 19.6, “Binary Logging of Stored Programs”
Section 19.2.1, “Stored Routine Syntax”

ALTER ONLINE TABLE ... REORGANIZE PARTITION

Section 17.7.8.2, “Adding MySQL Cluster Data Nodes Online: Basic procedure”
Section 17.7.8.3, “Adding MySQL Cluster Data Nodes Online: Detailed Example”
Section 17.7.8.1, “Adding MySQL Cluster Data Nodes Online: General Issues”
Section 17.7.2, “Commands in the MySQL Cluster Management Client”

ALTER ONLINE TABLE tbl REORGANIZE PARTITION

Section 17.7.8.2, “Adding MySQL Cluster Data Nodes Online: Basic procedure”

ALTER PROCEDURE

Section 19.6, “Binary Logging of Stored Programs”
Section 19.2.1, “Stored Routine Syntax”

ALTER TABLE

Section 4.6.3.1, “myisamchk General Options”
Section 13.11.3, “FEDERATED Storage Engine Notes and Tips”
Section 13.5.1, “MyISAM Startup Options”
Section 13.5.3, “MyISAM Table Storage Formats”
Section 18.2.1, “RANGE Partitioning”
Section 21.10.3.35, “mysql_info()”
Section 9.1.3.4, “Column Character Set and Collation”
Section 11.13.4.3, “Creating Spatial Columns”
Section 11.13.6.1, “Creating Spatial Indexes”
Section 3.3.2, “Creating a Table”
Description
Description
Section 11.8.6, “Fine-Tuning MySQL Full-Text Search”
Section 11.8, “Full-Text Search Functions”
Section 6.4.3, “How to Repair Tables”
Section 17.2.5, “Loading Sample Data into MySQL Cluster and Performing Queries”
Section 18.3.3, “Maintenance of Partitions”
Section 18.3.2, “Management of HASH and KEY Partitions”
Section 18.3.1, “Management of RANGE and LIST Partitions”
Section A.10, “MySQL 5.1 FAQ — MySQL Cluster”
Section 17.2.3, “MySQL Cluster Multi-Computer Configuration”
Section 17.4.3, “MySQL Cluster System Variables”
Section 10.2, “Numeric Types”
Section 18.1, “Overview of Partitioning in MySQL”
Section 10.1.3, “Overview of String Types”
Section 18.3, “Partition Management”
Section 18.5.1, “Partitioning Keys, Primary Keys, and Unique Keys”
Section 18.5.2, “Partitioning Limitations Relating to Storage Engines”
Section 16.3.1.1, “Replication and AUTO_INCREMENT”
Section 16.3.1.19, “Replication and Reserved Words”
Section 18.5, “Restrictions and Limitations on Partitioning”
Section D.4, “Restrictions on Views”
Section 12.7, “SQL Syntax for Prepared Statements”
Section 13.3, “Setting the Storage Engine”
Section 9.1.3.3, “Table Character Set and Collation”
Section 13.12, “The ARCHIVE Storage Engine”
Section 20.19, “The INFORMATION_SCHEMA PARTITIONS Table”
Section 13.9, “The MEMORY (HEAP) Storage Engine”
Section 13.5, “The MyISAM Storage Engine”
Section 3.6.9, “Using AUTO_INCREMENT”

ALTER TABLE ... REORGANIZE PARTITION

Section 17.7.8.1, “Adding MySQL Cluster Data Nodes Online: General Issues”

ALTER VIEW

Section D.1, “Restrictions on Stored Routines, Triggers, and Events”
Section D.4, “Restrictions on Views”
Section 19.5.2, “View Processing Algorithms”
Section 19.5.1, “View Syntax”

ALTER [ONLINE] TABLE table_name REORGANIZE PARTITION

Section 17.7.8.3, “Adding MySQL Cluster Data Nodes Online: Detailed Example”

ANALYZE TABLE

Section 4.6.3.1, “myisamchk General Options”
Description
Description
Section 11.8.6, “Fine-Tuning MySQL Full-Text Search”
Section 18.3.3, “Maintenance of Partitions”
Section 16.3.1.9, “Replication and FLUSH”
Section 18.5, “Restrictions and Limitations on Partitioning”
Section 6.4, “Table Maintenance and Crash Recovery”

BEGIN

Section 19.6, “Binary Logging of Stored Programs”
Description
Section 16.3.1.25, “Replication and Transactions”

BEGIN ... END

Section D.1, “Restrictions on Stored Routines, Triggers, and Events”

BEGIN [WORK]

Section D.1, “Restrictions on Stored Routines, Triggers, and Events”

BINLOG

Section 4.6.7.2, “mysqlbinlog Row Event Display”
Description

CACHE INDEX

Section 18.5, “Restrictions and Limitations on Partitioning”

CALL

Section 21.10.3.1, “mysql_affected_rows()”
Section 21.10.3.37, “mysql_insert_id()”
Section 21.10.3.45, “mysql_more_results()”
Section 21.10.3.46, “mysql_next_result()”
Section 21.10.3.52, “mysql_real_connect()”
Section 21.10.3.64, “mysql_set_server_option()”
Section 19.6, “Binary Logging of Stored Programs”
Section 21.10.4, “C API Prepared Statements”
Section 21.10.12, “C API Support for Multiple Statement Execution”
Section 21.10.15, “C API Support for Prepared CALL Statements”
Section D.1, “Restrictions on Stored Routines, Triggers, and Events”
Section 12.7, “SQL Syntax for Prepared Statements”
Chapter 19, Stored Programs and Views
Section 19.2.1, “Stored Routine Syntax”
Section 19.3.1, “Trigger Syntax”

CASE

Section 11.3, “Control Flow Functions”

CHANGE MASTER TO

Section 12.6.2.1, “CHANGE MASTER TO Syntax”
Section 16.1.1.5, “Creating a Data Snapshot Using mysqldump”
Description
Section 17.4.4, “MySQL Cluster Status Variables”
Section 16.3.1.15, “Replication During a Master Shutdown”
Section 16.1.1.8, “Setting Up Replication with Existing Data”
Section 16.1.1.7, “Setting Up Replication with New Master and Slaves”

CHECK TABLE

Section 21.10.3.69, “mysql_store_result()”
Section 21.10.3.71, “mysql_use_result()”
Section 13.5.4.1, “Corrupted MyISAM Tables”
Description
Description
Section 6.4.3, “How to Repair Tables”
Section 1.6, “How to Report Bugs or Problems”
Section 18.3.3, “Maintenance of Partitions”
Section A.6, “MySQL 5.1 FAQ — Views”
Section 13.5.4.2, “Problems from Tables Not Being Closed Properly”
Section 18.5, “Restrictions and Limitations on Partitioning”
Section D.2, “Restrictions on Server-Side Cursors”
Section D.1, “Restrictions on Stored Routines, Triggers, and Events”
Section D.4, “Restrictions on Views”
Section 6.4.6, “Setting Up a Table Maintenance Schedule”
Section 6.4, “Table Maintenance and Crash Recovery”
Section 13.12, “The ARCHIVE Storage Engine”

COMMIT

Section 19.6, “Binary Logging of Stored Programs”
Section 13.1, “Comparing Transaction and Nontransaction Engines”
Description
Section 16.1.1.4, “Obtaining the Master Replication Information”
Section 16.3.1.25, “Replication and Transactions”
Section 12.7, “SQL Syntax for Prepared Statements”
Section 19.3.1, “Trigger Syntax”

CREATE DATABASE

Section 9.1.8.3, “SHOW Statements and INFORMATION_SCHEMA”
Section 21.10.3.8, “mysql_create_db()”
Chapter 6, Backup and Recovery
Section 21.10.2, “C API Function Overview”
Section 9.1.5, “Configuring the Character Set and Collation for Applications”
Section 9.1.3.2, “Database Character Set and Collation”
Description
Section 8.2.2, “Identifier Case Sensitivity”
Section 9.1.3.1, “Server Character Set and Collation”

CREATE EVENT

Section 19.6, “Binary Logging of Stored Programs”
Section 16.3.1.7, “Replication of Invoked Features”
Section D.1, “Restrictions on Stored Routines, Triggers, and Events”
Section 20.20, “The INFORMATION_SCHEMA EVENTS Table”

CREATE FUNCTION

Section 22.3, “Adding New Functions to MySQL”
Section 19.6, “Binary Logging of Stored Programs”
Section 22.3.2.5, “Compiling and Installing User-Defined Functions”
Description
Section 8.2.4, “Function Name Parsing and Resolution”
Section 16.3.1.7, “Replication of Invoked Features”
Section D.1, “Restrictions on Stored Routines, Triggers, and Events”
Section 19.2.1, “Stored Routine Syntax”
Section 22.3.2.1, “UDF Calling Sequences for Simple Functions”
Section 22.3.2.6, “User-Defined Function Security Precautions”

CREATE INDEX

Section 11.13.6.1, “Creating Spatial Indexes”
Section 11.8, “Full-Text Search Functions”
Section 12.7, “SQL Syntax for Prepared Statements”

CREATE OR REPLACE VIEW

Section D.4, “Restrictions on Views”

CREATE PROCEDURE

Section 19.6, “Binary Logging of Stored Programs”
Description
Section 16.3.1.7, “Replication of Invoked Features”
Section D.1, “Restrictions on Stored Routines, Triggers, and Events”
Section 19.2.1, “Stored Routine Syntax”

CREATE SERVER

Section 13.11.3, “FEDERATED Storage Engine Notes and Tips”
Section 13.11.2.2, “Creating a FEDERATED Table Using CREATE SERVER”
Section 13.11.2, “How to Create FEDERATED Tables”

CREATE TABLE

Section 12.3.1, “DESCRIBE Syntax”
Section 18.2.3, “HASH Partitioning”
Section 12.3.3, “HELP Syntax”
Section 18.2.4, “KEY Partitioning”
Section 18.2.2, “LIST Partitioning”
Section 13.5.3, “MyISAM Table Storage Formats”
Section 18.2.1, “RANGE Partitioning”
Section 9.1.8.3, “SHOW Statements and INFORMATION_SCHEMA”
Section 10.3.1.1, “TIMESTAMP Properties”
Chapter 6, Backup and Recovery
Section 21.10.4, “C API Prepared Statements”
Section 9.1.3.4, “Column Character Set and Collation”
Section 11.13.4.3, “Creating Spatial Columns”
Section 11.13.6.1, “Creating Spatial Indexes”
Section 13.11.2.1, “Creating a FEDERATED Table Using CONNECTION”
Section 3.3.2, “Creating a Table”
Section 9.1.3.2, “Database Character Set and Collation”
Description
Section 11.8, “Full-Text Search Functions”
Section 3.4, “Getting Information About Databases and Tables”
Section 18.2.6, “How MySQL Partitioning Handles NULL”
Section 8.2.2, “Identifier Case Sensitivity”
Section 3.3.3, “Loading Data into a Table”
Section 18.3.1, “Management of RANGE and LIST Partitions”
Section A.10, “MySQL 5.1 FAQ — MySQL Cluster”
Section 17.2.3, “MySQL Cluster Multi-Computer Configuration”
Section 18.1, “Overview of Partitioning in MySQL”
Section 10.1.3, “Overview of String Types”
Section 18.3, “Partition Management”
Section 18.2, “Partition Types”
Section 18.5.3, “Partitioning Limitations Relating to Functions”
Section 18.5.2, “Partitioning Limitations Relating to Storage Engines”
Section 16.3.1.1, “Replication and AUTO_INCREMENT”
Section 16.3.1.5, “Replication and DIRECTORY Table Options”
Section 16.3.1.2, “Replication and Character Sets”
Section 16.3.1.3, “Replication of CREATE TABLE ... SELECT Statements”
Section 18.5, “Restrictions and Limitations on Partitioning”
Section 12.7, “SQL Syntax for Prepared Statements”
Section 13.3, “Setting the Storage Engine”
Section 18.2.5, “Subpartitioning”
Section 9.1.3.3, “Table Character Set and Collation”
Section 13.12, “The ARCHIVE Storage Engine”
Section 10.4.4, “The ENUM Type”
Section 20.19, “The INFORMATION_SCHEMA PARTITIONS Table”
Section 13.9, “The MEMORY (HEAP) Storage Engine”
Section 13.5, “The MyISAM Storage Engine”
Section 3.6.9, “Using AUTO_INCREMENT”
Section 3.3.4.9, “Using More Than one Table”

CREATE TABLE ... SELECT

Section 19.6, “Binary Logging of Stored Programs”
Section 16.3.1.3, “Replication of CREATE TABLE ... SELECT Statements”

CREATE TABLE ... SELECT ...

Section 18.3.1, “Management of RANGE and LIST Partitions”

CREATE TEMPORARY TABLE

Description
Section A.10, “MySQL 5.1 FAQ — MySQL Cluster”

CREATE TRIGGER

Section 19.6, “Binary Logging of Stored Programs”
Section A.5, “MySQL 5.1 FAQ — Triggers”
Section 16.3.1.7, “Replication of Invoked Features”
Section D.1, “Restrictions on Stored Routines, Triggers, and Events”
Section 19.3.1, “Trigger Syntax”

CREATE USER

Section 5.5.2, “Adding User Accounts”
Section 5.5.6.1, “Administrator Guidelines for Password Security”
Section 5.5.5, “Assigning Account Passwords”
Section 5.5.6.2, “End-User Guidelines for Password Security”
Section 17.8.2, “MySQL Cluster and MySQL Privileges”
Section 16.3.1.17, “Replication of the System mysql Database”

CREATE VIEW

Section D.4, “Restrictions on Views”
Section 20.15, “The INFORMATION_SCHEMA VIEWS Table”
Section 19.5.3, “Updatable and Insertable Views”
Section 19.5.2, “View Processing Algorithms”
Section 19.5.1, “View Syntax”

DEALLOCATE PREPARE

Section 12.7.3, “DEALLOCATE PREPARE Syntax”
Section 12.7.1, “PREPARE Syntax”
Section D.1, “Restrictions on Stored Routines, Triggers, and Events”
Section 12.7, “SQL Syntax for Prepared Statements”

DELETE

Section 4.5.1.1, “mysql Options”
Section 13.11.3, “FEDERATED Storage Engine Notes and Tips”
Section 18.2.2, “LIST Partitioning”
Section 18.2.1, “RANGE Partitioning”
Section 21.10.3.1, “mysql_affected_rows()”
Section 21.10.3.48, “mysql_num_rows()”
Section 21.10.7.1, “mysql_stmt_affected_rows()”
Section 21.10.7.10, “mysql_stmt_execute()”
Section 21.10.7.13, “mysql_stmt_field_count()”
Section 21.10.7.17, “mysql_stmt_num_rows()”
Section 5.5.2, “Adding User Accounts”
Section 21.10.2, “C API Function Overview”
Section 21.10.6, “C API Prepared Statement Function Overview”
Section 21.10.4, “C API Prepared Statements”
Description
Chapter 11, Functions and Operators
Section 18.3.1, “Management of RANGE and LIST Partitions”
Section 17.8.3, “MySQL Cluster and MySQL Security Procedures”
Section 16.3.1.11, “Replication and LIMIT”
Section 16.3.1.18, “Replication and the Query Optimizer”
Section 16.3.1.16, “Replication with MEMORY Tables”
Section 8.3, “Reserved Words”
Section D.3, “Restrictions on Subqueries”
Section D.4, “Restrictions on Views”
Section 12.7, “SQL Syntax for Prepared Statements”
Section 3.3.4.1, “Selecting All Data”
Section 13.12, “The ARCHIVE Storage Engine”
Section 13.14, “The BLACKHOLE Storage Engine”
Section 20.15, “The INFORMATION_SCHEMA VIEWS Table”
Section 13.9, “The MEMORY (HEAP) Storage Engine”
Section 19.3.1, “Trigger Syntax”
Section 19.5.3, “Updatable and Insertable Views”
Section 19.3, “Using Triggers”
Section 4.5.1.5.2, “Using the --safe-updates Option”
Section 21.10.10.2, “What Results You Can Get from a Query”
Section 21.10.10.1, “Why mysql_store_result() Sometimes Returns NULL After mysql_query() Returns Success”

DESCRIBE

Section 12.3.1, “DESCRIBE Syntax”
Section 12.3.2, “EXPLAIN Syntax”
Section 21.10.7.27, “mysql_stmt_store_result()”
Section 21.10.3.69, “mysql_store_result()”
Section 21.10.3.71, “mysql_use_result()”
Section 21.10.1, “C API Data Types”
Section 21.10.2, “C API Function Overview”
Section 3.3.2, “Creating a Table”
Section 20.28, “Extensions to SHOW Statements”
Section 3.4, “Getting Information About Databases and Tables”
Section 20.19, “The INFORMATION_SCHEMA PARTITIONS Table”
Section 9.1.10, “UTF-8 for Metadata”
Section 3.6.6, “Using Foreign Keys”

DO

Section 19.6, “Binary Logging of Stored Programs”
Section 21.10.4, “C API Prepared Statements”
Section 11.11.4, “Miscellaneous Functions”
Section D.1, “Restrictions on Stored Routines, Triggers, and Events”
Section D.3, “Restrictions on Subqueries”
Section 12.7, “SQL Syntax for Prepared Statements”
Section 20.20, “The INFORMATION_SCHEMA EVENTS Table”

DROP DATABASE

Section 21.10.3.11, “mysql_drop_db()”
Section 21.10.2, “C API Function Overview”
Description

DROP DATABASE IF EXISTS

Section 16.3.1.6, “Replication of DROP ... IF EXISTS Statements”

DROP EVENT

Section 19.6, “Binary Logging of Stored Programs”
Section 16.3.1.7, “Replication of Invoked Features”

DROP FUNCTION

Section 22.3, “Adding New Functions to MySQL”
Section 19.6, “Binary Logging of Stored Programs”
Section 22.3.2.5, “Compiling and Installing User-Defined Functions”
Section 8.2.4, “Function Name Parsing and Resolution”
Section 16.3.1.7, “Replication of Invoked Features”
Section 19.2.1, “Stored Routine Syntax”
Section 22.3.2.6, “User-Defined Function Security Precautions”

DROP FUNCTION IF EXISTS

Section 16.3.1.6, “Replication of DROP ... IF EXISTS Statements”

DROP INDEX

Section 11.13.6.1, “Creating Spatial Indexes”
Section 12.7, “SQL Syntax for Prepared Statements”

DROP PROCEDURE

Section 19.6, “Binary Logging of Stored Programs”
Section 16.3.1.7, “Replication of Invoked Features”
Section 19.2.1, “Stored Routine Syntax”

DROP PROCEDURE IF EXISTS

Section 16.3.1.6, “Replication of DROP ... IF EXISTS Statements”

DROP SCHEMA

Section D.1, “Restrictions on Stored Routines, Triggers, and Events”

DROP TABLE

Section 13.11.3, “FEDERATED Storage Engine Notes and Tips”
Section 12.6.2.7, “START SLAVE Syntax”
Description
Description
Description
Section 22.2.2, “Full-Text Parser Plugins”
Section D.4, “Restrictions on Views”
Section 12.7, “SQL Syntax for Prepared Statements”
Section 13.9, “The MEMORY (HEAP) Storage Engine”

DROP TABLE IF EXISTS

Section 16.3.1.6, “Replication of DROP ... IF EXISTS Statements”

DROP TRIGGER

Section A.5, “MySQL 5.1 FAQ — Triggers”
Section 16.3.1.7, “Replication of Invoked Features”
Section 19.3.1, “Trigger Syntax”

DROP USER

Section 17.8.2, “MySQL Cluster and MySQL Privileges”
Section 5.5.3, “Removing User Accounts”
Section 16.3.1.17, “Replication of the System mysql Database”
Section D.1, “Restrictions on Stored Routines, Triggers, and Events”

DROP VIEW

Section D.4, “Restrictions on Views”
Section 19.5.1, “View Syntax”

DROP VIEW IF EXISTS

Section 16.3.1.6, “Replication of DROP ... IF EXISTS Statements”

EXECUTE

Section 12.7.2, “EXECUTE Syntax”
Section 12.7.1, “PREPARE Syntax”
Section D.1, “Restrictions on Stored Routines, Triggers, and Events”
Section D.4, “Restrictions on Views”
Section 12.7, “SQL Syntax for Prepared Statements”

EXPLAIN

Section 12.3.2, “EXPLAIN Syntax”
Section 21.10.7.27, “mysql_stmt_store_result()”
Section 21.10.3.69, “mysql_store_result()”
Section 21.10.3.71, “mysql_use_result()”
Section 21.10.1, “C API Data Types”
Section 21.10.2, “C API Function Overview”
Section 22.5.1, “Debugging a MySQL Server”
Section 18.3.4, “Obtaining Information About Partitions”
Section D.1, “Restrictions on Stored Routines, Triggers, and Events”
Section 22.5.1.6, “Using Server Logs to Find Causes of Errors in mysqld”
Section 11.13.6.2, “Using a Spatial Index”

EXPLAIN SELECT

Section 1.6, “How to Report Bugs or Problems”
Section 18.3.4, “Obtaining Information About Partitions”

FETCH

Section D.1, “Restrictions on Stored Routines, Triggers, and Events”

FLUSH

Section 6.2.1, “Backup Policy”
Description
Section 16.3.1.9, “Replication and FLUSH”
Section D.1, “Restrictions on Stored Routines, Triggers, and Events”

FLUSH DES_KEY_FILE

Section 11.11.2, “Encryption and Compression Functions”

FLUSH HOSTS

Section 21.10.3.55, “mysql_refresh()”

FLUSH LOGS

Section 21.10.3.55, “mysql_refresh()”
Section 6.2.1, “Backup Policy”
Section 6.2.3, “Backup Strategy Summary”
Section 6.1, “Database Backups”
Section 16.3.1.9, “Replication and FLUSH”
Section 16.4.2.1, “The Slave Relay Log”

FLUSH MASTER

Section 16.3.1.9, “Replication and FLUSH”

FLUSH PRIVILEGES

Section 21.10.3.55, “mysql_refresh()”
Section 21.10.3.56, “mysql_reload()”
Section 5.5.2, “Adding User Accounts”
Description
Section 5.5.4, “Limiting Account Resources”
Section 17.8.3, “MySQL Cluster and MySQL Security Procedures”
Section 16.3.1.9, “Replication and FLUSH”
Section 5.3.3, “Security-Related mysqld Options”
Section 1.2, “Typographical and Syntax Conventions”

FLUSH SLAVE

Section 16.3.1.9, “Replication and FLUSH”

FLUSH TABLES

Section 21.10.3.55, “mysql_refresh()”
Section 12.7.4, “Automatic Prepared Statement Repreparation”
Section 6.1, “Database Backups”
Description
Description
Section 16.1.1.4, “Obtaining the Master Replication Information”
Section 13.5.4.2, “Problems from Tables Not Being Closed Properly”
Section 16.3.1.9, “Replication and FLUSH”

FLUSH TABLES WITH READ LOCK

Section 6.2.1, “Backup Policy”
Section 16.1.1.5, “Creating a Data Snapshot Using mysqldump”
Section 6.1, “Database Backups”
Description
Section 16.1.1.4, “Obtaining the Master Replication Information”
Section 16.3.1.9, “Replication and FLUSH”

FLUSH USER_RESOURCES

Section 5.5.4, “Limiting Account Resources”

GRANT

Section 5.5.2, “Adding User Accounts”
Section 5.5.6.1, “Administrator Guidelines for Password Security”
Section 5.5.5, “Assigning Account Passwords”
Section 16.1.1.1, “Creating a User for Replication”
Section 5.5.6.2, “End-User Guidelines for Password Security”
Section 5.3.1, “General Security Guidelines”
Section 5.5.4, “Limiting Account Resources”
Section 5.3.2, “Making MySQL Secure Against Attackers”
Section 17.8.2, “MySQL Cluster and MySQL Privileges”
Section 5.5.6.3, “Password Hashing in MySQL”
Section 16.3.4, “Replication FAQ”
Section 16.3.1.9, “Replication and FLUSH”
Section 16.3.1.17, “Replication of the System mysql Database”
Section 5.5.7.3, “SSL Command Options”
Section 5.3.3, “Security-Related mysqld Options”
Section 5.5.1, “User Names and Passwords”
Section 5.5.7.2, “Using SSL Connections”
Section 5.5.7, “Using SSL for Secure Connections”

GRANT USAGE

Section 5.5.5, “Assigning Account Passwords”
Section 5.5.4, “Limiting Account Resources”

HANDLER

Section 13.11.3, “FEDERATED Storage Engine Notes and Tips”
Section 21.10.3.3, “mysql_change_user()”
Section 21.10.11, “Controlling Automatic Reconnection Behavior”
Section A.4, “MySQL 5.1 FAQ — Stored Procedures and Functions”

HELP

Section 12.3.3, “HELP Syntax”

IF

Section 11.3, “Control Flow Functions”

INSERT

Section 13.11.3, “FEDERATED Storage Engine Notes and Tips”
Section 18.2.2, “LIST Partitioning”
Section 18.2.1, “RANGE Partitioning”
Section 21.10.3.1, “mysql_affected_rows()”
Section 21.10.3.37, “mysql_insert_id()”
Section 21.10.3.48, “mysql_num_rows()”
Section 21.10.7.1, “mysql_stmt_affected_rows()”
Section 21.10.7.10, “mysql_stmt_execute()”
Section 21.10.7.13, “mysql_stmt_field_count()”
Section 21.10.7.16, “mysql_stmt_insert_id()”
Section 21.10.7.17, “mysql_stmt_num_rows()”
Section 21.10.7.20, “mysql_stmt_prepare()”
Section 21.10.3.69, “mysql_store_result()”
Section 5.5.2, “Adding User Accounts”
Section 5.5.5, “Assigning Account Passwords”
Section 12.7.4, “Automatic Prepared Statement Repreparation”
Section 6.2.1, “Backup Policy”
Chapter 6, Backup and Recovery
Section 19.6, “Binary Logging of Stored Programs”
Section 21.10.2, “C API Function Overview”
Section 21.10.6, “C API Prepared Statement Function Overview”
Section 21.10.4, “C API Prepared Statements”
Section 21.10.12, “C API Support for Multiple Statement Execution”
Section 13.11.2.1, “Creating a FEDERATED Table Using CONNECTION”
Section 10.1.4, “Data Type Default Values”
Description
Section 21.10.10.3, “How to Get the Unique ID for the Last Inserted Row”
Section 11.11.3, “Information Functions”
Section 3.3.3, “Loading Data into a Table”
Section 17.2.5, “Loading Sample Data into MySQL Cluster and Performing Queries”
Section 18.3.1, “Management of RANGE and LIST Partitions”
Section 11.11.4, “Miscellaneous Functions”
Section A.1, “MySQL 5.1 FAQ — General”
Section A.5, “MySQL 5.1 FAQ — Triggers”
Section A.6, “MySQL 5.1 FAQ — Views”
Section 10.2, “Numeric Types”
Section 10.1.2, “Overview of Date and Time Types”
Section 11.13.4.4, “Populating Spatial Columns”
Section 16.3.1.1, “Replication and AUTO_INCREMENT”
Section 16.3.1.10, “Replication and System Functions”
Section 18.5, “Restrictions and Limitations on Partitioning”
Section D.1, “Restrictions on Stored Routines, Triggers, and Events”
Section D.3, “Restrictions on Subqueries”
Section 12.7, “SQL Syntax for Prepared Statements”
Section 13.12, “The ARCHIVE Storage Engine”
Section 13.14, “The BLACKHOLE Storage Engine”
Section 20.15, “The INFORMATION_SCHEMA VIEWS Table”
Section 13.5, “The MyISAM Storage Engine”
Section 9.1.6.4, “The _bin and binary Collations”
Section 19.3.1, “Trigger Syntax”
Section 19.5.3, “Updatable and Insertable Views”
Section 19.3, “Using Triggers”
Section 21.10.10.2, “What Results You Can Get from a Query”
Section 21.10.10.1, “Why mysql_store_result() Sometimes Returns NULL After mysql_query() Returns Success”

INSERT ... ON DUPLICATE KEY UPDATE

Section 13.11.3, “FEDERATED Storage Engine Notes and Tips”
Section 21.10.3.1, “mysql_affected_rows()”
Section 21.10.3.37, “mysql_insert_id()”
Section 11.11.3, “Information Functions”
Section 11.11.4, “Miscellaneous Functions”

INSERT ... SELECT

Section 21.10.3.37, “mysql_insert_id()”
Section 16.3.1.11, “Replication and LIMIT”

INSERT ... VALUES

Section 21.10.3.35, “mysql_info()”

INSERT DELAYED

Description
Section 22.1.1, “MySQL Threads”
Section 18.5, “Restrictions and Limitations on Partitioning”
Section D.1, “Restrictions on Stored Routines, Triggers, and Events”
Section 13.12, “The ARCHIVE Storage Engine”
Section 13.14, “The BLACKHOLE Storage Engine”
Section 13.9, “The MEMORY (HEAP) Storage Engine”
Section 19.5.3, “Updatable and Insertable Views”

INSERT IGNORE

Section 11.11.3, “Information Functions”

INSERT INTO ... SELECT

Section 13.9, “The MEMORY (HEAP) Storage Engine”

INSERT INTO ... SELECT ...

Section 13.11.3, “FEDERATED Storage Engine Notes and Tips”
Section 21.10.3.35, “mysql_info()”
Section 21.10.10.2, “What Results You Can Get from a Query”

INSTALL PLUGIN

Section 22.2.1, “Characteristics of the Plugin Interface”
Section 22.2.3.3, “Creating a Plugin Library”
Section 22.2.3.1, “General Plugin Structures and Functions”
Section 13.4.1, “Pluggable Storage Engine Architecture”

KILL

Section 21.10.3.38, “mysql_kill()”

KILL CONNECTION

Section 12.6.2.8, “STOP SLAVE Syntax”

KILL QUERY

Section 12.6.2.8, “STOP SLAVE Syntax”

LEAVE

Section D.1, “Restrictions on Stored Routines, Triggers, and Events”

LOAD DATA

Section 3.3.3, “Loading Data into a Table”
Section 5.3.2, “Making MySQL Secure Against Attackers”
Section 16.3.1.12, “Replication and LOAD DATA”
Section 18.5, “Restrictions and Limitations on Partitioning”
Section D.1, “Restrictions on Stored Routines, Triggers, and Events”
Section 5.3.4, “Security Issues with LOAD DATA LOCAL”
Section 5.3.3, “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 INFILE

Section 4.5.1.1, “mysql Options”
Section 4.6.7.1, “mysqlbinlog Hex Dump Format”
Section 13.5.1, “MyISAM Startup Options”
Section 8.1.6, “NULL Values”
Chapter 6, Backup and Recovery
Section 6.1, “Database Backups”
Section 9.1.3.2, “Database Character Set and Collation”
Description
Description
Description
Description
Section 10.2, “Numeric Types”
Section 16.3.2, “Replication Compatibility Between MySQL Versions”
Section 16.3.1.12, “Replication and LOAD DATA”
Section D.6, “Restrictions on Character Sets”
Section 13.9, “The MEMORY (HEAP) Storage Engine”

LOAD DATA LOCAL

Section 21.10.3.49, “mysql_options()”
Section 21.10.3.52, “mysql_real_connect()”
Description
Section 5.3.4, “Security Issues with LOAD DATA LOCAL”

LOAD DATA LOCAL INFILE

Section 21.10.3.63, “mysql_set_local_infile_handler()”
Section 21.10.2, “C API Function Overview”
Description
Section 16.3.1.12, “Replication and LOAD DATA”

LOAD INDEX INTO CACHE

Section 18.5, “Restrictions and Limitations on Partitioning”

LOCK TABLES

Section 12.3.3, “HELP Syntax”
Section 6.1, “Database Backups”
Section 11.6, “Date and Time Functions”
Description
Description
Section 13.5.4.2, “Problems from Tables Not Being Closed Properly”
Section D.1, “Restrictions on Stored Routines, Triggers, and Events”
Section 13.14, “The BLACKHOLE Storage Engine”

OPTIMIZE TABLE

Section 4.6.3.1, “myisamchk General Options”
Section 17.7.8.2, “Adding MySQL Cluster Data Nodes Online: Basic procedure”
Section 22.5.1, “Debugging a MySQL Server”
Description
Description
Section 13.5.3.2, “Dynamic Table Characteristics”
Section 11.8.6, “Fine-Tuning MySQL Full-Text Search”
Section 18.3.3, “Maintenance of Partitions”
Section 16.3.1.9, “Replication and FLUSH”
Section 18.5, “Restrictions and Limitations on Partitioning”
Section 6.4.6, “Setting Up a Table Maintenance Schedule”
Section 13.5.3.1, “Static (Fixed-Length) Table Characteristics”
Section 6.4, “Table Maintenance and Crash Recovery”
Section 6.4.4, “Table Optimization”
Section 13.12, “The ARCHIVE Storage Engine”

PREPARE

Section 12.7.3, “DEALLOCATE PREPARE Syntax”
Section 12.7.2, “EXECUTE Syntax”
Section 12.7.1, “PREPARE Syntax”
Section 12.7.4, “Automatic Prepared Statement Repreparation”
Section 8.2.2, “Identifier Case Sensitivity”
Section D.1, “Restrictions on Stored Routines, Triggers, and Events”
Section D.4, “Restrictions on Views”
Section 12.7, “SQL Syntax for Prepared Statements”

PURGE BINARY LOGS

Section 12.6.1.1, “PURGE BINARY LOGS Syntax”
Section 12.6.1.2, “RESET MASTER Syntax”
Section 6.2.1, “Backup Policy”

RENAME TABLE

Description
Section 12.7, “SQL Syntax for Prepared Statements”

REPAIR TABLE

Section 4.6.3.1, “myisamchk General Options”
Section 13.5.1, “MyISAM Startup Options”
Section 13.5.4.1, “Corrupted MyISAM Tables”
Section 6.1, “Database Backups”
Description
Description
Section 11.8.6, “Fine-Tuning MySQL Full-Text Search”
Section 6.4.3, “How to Repair Tables”
Section 1.6, “How to Report Bugs or Problems”
Section 18.3.3, “Maintenance of Partitions”
Section 13.5.4.2, “Problems from Tables Not Being Closed Properly”
Section 16.3.1.9, “Replication and FLUSH”
Section 18.5, “Restrictions and Limitations on Partitioning”
Section 6.4.6, “Setting Up a Table Maintenance Schedule”
Section 6.4, “Table Maintenance and Crash Recovery”
Section 13.12, “The ARCHIVE Storage Engine”

REPEAT

Section 19.1, “Defining Stored Programs”

REPLACE

Section 21.10.3.1, “mysql_affected_rows()”
Section 21.10.4, “C API Prepared Statements”
Section 10.1.4, “Data Type Default Values”
Description
Section 12.7, “SQL Syntax for Prepared Statements”
Section 13.12, “The ARCHIVE Storage Engine”

RESET MASTER

Section 12.6.1.2, “RESET MASTER Syntax”
Section 21.10.3.55, “mysql_refresh()”

RESET SLAVE

Section 12.6.2.1, “CHANGE MASTER TO Syntax”
Section 12.6.1.2, “RESET MASTER Syntax”
Section 12.6.2.5, “RESET SLAVE Syntax”
Section 21.10.3.55, “mysql_refresh()”

RESIGNAL

Section A.4, “MySQL 5.1 FAQ — Stored Procedures and Functions”

RETURN

Section D.1, “Restrictions on Stored Routines, Triggers, and Events”

REVOKE

Section 5.3.1, “General Security Guidelines”
Section 17.8.2, “MySQL Cluster and MySQL Privileges”
Section 16.3.4, “Replication FAQ”
Section 16.3.1.17, “Replication of the System mysql Database”
Section 5.5.1, “User Names and Passwords”

ROLLBACK

Section 21.10.3.3, “mysql_change_user()”
Section 19.6, “Binary Logging of Stored Programs”
Section 13.1, “Comparing Transaction and Nontransaction Engines”
Section 11.11.3, “Information Functions”
Section 16.3.1.25, “Replication and Transactions”
Section 19.3.1, “Trigger Syntax”

SELECT

Section 4.5.1.1, “mysql Options”
Section 12.3.2, “EXPLAIN Syntax”
Section 13.11.3, “FEDERATED Storage Engine Notes and Tips”
Section 11.12.1, “GROUP BY (Aggregate) Functions”
Section 11.12.3, “GROUP BY and HAVING with Hidden Columns”
Chapter 20, INFORMATION_SCHEMA Tables
Section 12.6.2.2, “LOAD DATA FROM MASTER Syntax”
Section 12.6.2.3, “LOAD TABLE tbl_name FROM MASTER Syntax”
Section 22.4.1, “PROCEDURE ANALYSE”
Section 21.10.3.1, “mysql_affected_rows()”
Section 21.10.3.17, “mysql_fetch_field()”
Section 21.10.3.22, “mysql_field_count()”
Section 21.10.3.47, “mysql_num_fields()”
Section 21.10.3.48, “mysql_num_rows()”
Section 21.10.7.1, “mysql_stmt_affected_rows()”
Section 21.10.7.10, “mysql_stmt_execute()”
Section 21.10.7.11, “mysql_stmt_fetch()”
Section 21.10.7.17, “mysql_stmt_num_rows()”
Section 21.10.7.27, “mysql_stmt_store_result()”
Section 21.10.3.69, “mysql_store_result()”
Section 21.10.3.71, “mysql_use_result()”
Section 12.7.4, “Automatic Prepared Statement Repreparation”
Section 19.6, “Binary Logging of Stored Programs”
Section 21.10.1, “C API Data Types”
Section 21.10.2, “C API Function Overview”
Section 21.10.6, “C API Prepared Statement Function Overview”
Section 21.10.4, “C API Prepared Statements”
Section 21.10.12, “C API Support for Multiple Statement Execution”
Section 9.1.4, “Connection Character Sets and Collations”
Section 13.11.2.1, “Creating a FEDERATED Table Using CONNECTION”
Description
Description
Description
Section 3.2, “Entering Queries”
Section 9.1.6.7, “Examples of the Effect of Collation”
Chapter 11, Functions and Operators
Section 18.2.6, “How MySQL Partitioning Handles NULL”
Section 1.6, “How to Report Bugs or Problems”
Section 8.2.1, “Identifier Qualifiers”
Section 11.11.3, “Information Functions”
Section 17.2.5, “Loading Sample Data into MySQL Cluster and Performing Queries”
Section 5.3.2, “Making MySQL Secure Against Attackers”
Section 18.3.1, “Management of RANGE and LIST Partitions”
Section A.11, “MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets”
Section A.4, “MySQL 5.1 FAQ — Stored Procedures and Functions”
Section 11.8.1, “Natural Language Full-Text Searches”
Section 18.3.4, “Obtaining Information About Partitions”
Section 4.6.3.4, “Other myisamchk Options”
Section 17.7.7, “Quick Reference: MySQL Cluster SQL Statements”
Section 13.13.1, “Repairing and Checking CSV Tables”
Section 16.3.4, “Replication FAQ”
Section 16.4, “Replication Implementation”
Section 16.3.1.7, “Replication of Invoked Features”
Section 8.3, “Reserved Words”
Section D.1, “Restrictions on Stored Routines, Triggers, and Events”
Section D.3, “Restrictions on Subqueries”
Section D.4, “Restrictions on Views”
Section 3.3.4, “Retrieving Information from a Table”
Section 12.7, “SQL Syntax for Prepared Statements”
Section 3.6.7, “Searching on Two Keys”
Section 3.3.4.1, “Selecting All Data”
Section 3.3.4.2, “Selecting Particular Rows”
Section 19.2.1, “Stored Routine Syntax”
Section 8.1.1, “Strings”
Section 13.12, “The ARCHIVE Storage Engine”
Section 10.4.4, “The ENUM Type”
Section 20.3, “The INFORMATION_SCHEMA COLUMNS Table”
Section 20.20, “The INFORMATION_SCHEMA EVENTS Table”
Section 20.19, “The INFORMATION_SCHEMA PARTITIONS Table”
Section 20.15, “The INFORMATION_SCHEMA VIEWS Table”
Section 9.2, “The Character Set Used for Data and Sorting”
Section 19.3.1, “Trigger Syntax”
Section 1.2, “Typographical and Syntax Conventions”
Section 9.1.10, “UTF-8 for Metadata”
Section 8.4, “User-Defined Variables”
Section 22.5.1.6, “Using Server Logs to Find Causes of Errors in mysqld”
Section 11.13.6.2, “Using a Spatial Index”
Section 4.5.1.5.2, “Using the --safe-updates Option”
Section 19.5.1, “View Syntax”

SELECT ... INTO OUTFILE

Section 8.1.6, “NULL Values”
Chapter 6, Backup and Recovery
Section 5.3.2, “Making MySQL Secure Against Attackers”
Section 5.3.3, “Security-Related mysqld Options”
Section 1.2, “Typographical and Syntax Conventions”

SELECT DISTINCT

Section D.3, “Restrictions on Subqueries”

SET

Section 19.6, “Binary Logging of Stored Programs”
Section 21.10.4, “C API Prepared Statements”
Section 19.1, “Defining Stored Programs”
Description
Chapter 11, Functions and Operators
Section 11.11.3, “Information Functions”
Section D.3, “Restrictions on Subqueries”
Section 12.7, “SQL Syntax for Prepared Statements”
Section 19.3.1, “Trigger Syntax”
Section 8.4, “User-Defined Variables”
Section 4.2.3.4, “Using Options to Set Program Variables”
Section 4.5.1.5.2, “Using the --safe-updates Option”

SET PASSWORD

Section 5.5.6.1, “Administrator Guidelines for Password Security”
Section 5.5.5, “Assigning Account Passwords”
Section 5.5.6.2, “End-User Guidelines for Password Security”
Section 5.5.6.3, “Password Hashing in MySQL”
Section 16.3.1.17, “Replication of the System mysql Database”

SET [GLOBAL|SESSION] sql_mode='modes'

Section A.3, “MySQL 5.1 FAQ — Server SQL Mode”

SHOW

Chapter 20, INFORMATION_SCHEMA Tables
Section 9.1.8.3, “SHOW Statements and INFORMATION_SCHEMA”
Section 21.10.7.27, “mysql_stmt_store_result()”
Section 21.10.3.69, “mysql_store_result()”
Section 21.10.3.71, “mysql_use_result()”
Section 21.10.1, “C API Data Types”
Section 21.10.2, “C API Function Overview”
Section 21.10.4, “C API Prepared Statements”
Section 3.3, “Creating and Using a Database”
Description
Section 20.28, “Extensions to SHOW Statements”
Section 8.2.3, “Mapping of Identifiers to File Names”
Section A.10, “MySQL 5.1 FAQ — MySQL Cluster”
Section 16.3.4, “Replication FAQ”
Section D.1, “Restrictions on Stored Routines, Triggers, and Events”
Section 12.6.1, “SQL Statements for Controlling Master Servers”
Section 12.7, “SQL Syntax for Prepared Statements”
Section 19.2.3, “Stored Routine Metadata”
Section 20.11, “The INFORMATION_SCHEMA COLLATION_CHARACTER_SET_APPLICABILITY Table”
Section 20.9, “The INFORMATION_SCHEMA CHARACTER_SETS Table”
Section 20.10, “The INFORMATION_SCHEMA COLLATIONS Table”
Section 20.3, “The INFORMATION_SCHEMA COLUMNS Table”
Section 20.8, “The INFORMATION_SCHEMA COLUMN_PRIVILEGES Table”
Section 20.18, “The INFORMATION_SCHEMA ENGINES Table”
Section 20.20, “The INFORMATION_SCHEMA EVENTS Table”
Section 20.21, “The INFORMATION_SCHEMA FILES Table”
Section 20.24, “The INFORMATION_SCHEMA GLOBAL_STATUS and SESSION_STATUS Tables”
Section 20.25, “The INFORMATION_SCHEMA GLOBAL_VARIABLES and SESSION_VARIABLES Tables”
Section 20.13, “The INFORMATION_SCHEMA KEY_COLUMN_USAGE Table”
Section 20.19, “The INFORMATION_SCHEMA PARTITIONS Table”
Section 20.17, “The INFORMATION_SCHEMA PLUGINS Table”
Section 20.22, “The INFORMATION_SCHEMA PROCESSLIST Table”
Section 20.26, “The INFORMATION_SCHEMA PROFILING Table”
Section 20.23, “The INFORMATION_SCHEMA REFERENTIAL_CONSTRAINTS Table”
Section 20.1, “The INFORMATION_SCHEMA SCHEMATA Table”
Section 20.6, “The INFORMATION_SCHEMA SCHEMA_PRIVILEGES Table”
Section 20.4, “The INFORMATION_SCHEMA STATISTICS Table”
Section 20.2, “The INFORMATION_SCHEMA TABLES Table”
Section 20.12, “The INFORMATION_SCHEMA TABLE_CONSTRAINTS Table”
Section 20.7, “The INFORMATION_SCHEMA TABLE_PRIVILEGES Table”
Section 20.16, “The INFORMATION_SCHEMA TRIGGERS Table”
Section 20.5, “The INFORMATION_SCHEMA USER_PRIVILEGES Table”
Section 20.15, “The INFORMATION_SCHEMA VIEWS Table”
Section 9.1.10, “UTF-8 for Metadata”

SHOW BINARY LOGS

Section 12.6.1.1, “PURGE BINARY LOGS Syntax”
Section 12.6.1, “SQL Statements for Controlling Master Servers”

SHOW BINLOG EVENTS

Section 12.6.2.7, “START SLAVE Syntax”
Section D.2, “Restrictions on Server-Side Cursors”
Section 12.6.1, “SQL Statements for Controlling Master Servers”

SHOW CHARACTER SET

Section 9.1.8.3, “SHOW Statements and INFORMATION_SCHEMA”
Section 9.1.12, “Character Sets and Collations That MySQL Supports”
Section 9.1.2, “Character Sets and Collations in MySQL”
Section 20.28, “Extensions to SHOW Statements”

SHOW COLLATION

Section 9.1.8.3, “SHOW Statements and INFORMATION_SCHEMA”
Section 21.10.1, “C API Data Types”
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 9.1.3.3, “Table Character Set and Collation”
Section 20.11, “The INFORMATION_SCHEMA COLLATION_CHARACTER_SET_APPLICABILITY Table”
Section 9.2, “The Character Set Used for Data and Sorting”

SHOW COLUMNS

Section 12.3.1, “DESCRIBE Syntax”
Section 12.3.2, “EXPLAIN Syntax”
Section 9.1.8.3, “SHOW Statements and INFORMATION_SCHEMA”
Section 20.28, “Extensions to SHOW Statements”

SHOW CREATE DATABASE

Section 9.1.8.3, “SHOW Statements and INFORMATION_SCHEMA”

SHOW CREATE FUNCTION

Section 1.6, “How to Report Bugs or Problems”
Section A.4, “MySQL 5.1 FAQ — Stored Procedures and Functions”
Section 19.2.3, “Stored Routine Metadata”

SHOW CREATE PROCEDURE

Section 1.6, “How to Report Bugs or Problems”
Section A.4, “MySQL 5.1 FAQ — Stored Procedures and Functions”
Section 19.2.3, “Stored Routine Metadata”

SHOW CREATE TABLE

Section 12.3.1, “DESCRIBE Syntax”
Section 18.2.4, “KEY Partitioning”
Section 9.1.8.3, “SHOW Statements and INFORMATION_SCHEMA”
Section 10.1.4, “Data Type Default Values”
Section 3.4, “Getting Information About Databases and Tables”
Section 13.11.2, “How to Create FEDERATED Tables”
Section 6.4.3, “How to Repair Tables”
Section 18.3.1, “Management of RANGE and LIST Partitions”
Section 18.3.4, “Obtaining Information About Partitions”
Section 3.6.6, “Using Foreign Keys”

SHOW CREATE VIEW

Section D.4, “Restrictions on Views”
Section 20.15, “The INFORMATION_SCHEMA VIEWS Table”
Section 19.5.4, “View Metadata”

SHOW DATABASES

Chapter 20, INFORMATION_SCHEMA Tables
Section 12.6.2.2, “LOAD DATA FROM MASTER Syntax”
Section 3.3, “Creating and Using a Database”
Section 20.28, “Extensions to SHOW Statements”
Section 3.4, “Getting Information About Databases and Tables”
Section 8.2.2, “Identifier Case Sensitivity”
Section A.11, “MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets”
Section 17.8.2, “MySQL Cluster and MySQL Privileges”
Section 5.3.3, “Security-Related mysqld Options”

SHOW ENGINE NDB STATUS

Section 17.7, “Management of MySQL Cluster”
Section 17.7.7, “Quick Reference: MySQL Cluster SQL Statements”

SHOW ENGINE NDBCLUSTER STATUS

Section 17.4.2, “mysqld Command Options for MySQL Cluster”
Section 17.7.7, “Quick Reference: MySQL Cluster SQL Statements”

SHOW ENGINES

Section A.10, “MySQL 5.1 FAQ — MySQL Cluster”
Section 17.6.1, “MySQL Server Usage for MySQL Cluster”
Section 17.7.7, “Quick Reference: MySQL Cluster SQL Statements”
Chapter 13, Storage Engines
Section 13.12, “The ARCHIVE Storage Engine”
Section 13.14, “The BLACKHOLE Storage Engine”

SHOW EVENTS

Section 16.3.1.7, “Replication of Invoked Features”

SHOW FULL COLUMNS

Section 9.1.8.3, “SHOW Statements and INFORMATION_SCHEMA”
Section 20.8, “The INFORMATION_SCHEMA COLUMN_PRIVILEGES Table”

SHOW FULL PROCESSLIST

Description

SHOW FUNCTION STATUS

Section 19.2.3, “Stored Routine Metadata”

SHOW GLOBAL STATUS

Section 20.24, “The INFORMATION_SCHEMA GLOBAL_STATUS and SESSION_STATUS Tables”

SHOW GLOBAL VARIABLES

Section 20.25, “The INFORMATION_SCHEMA GLOBAL_VARIABLES and SESSION_VARIABLES Tables”

SHOW GRANTS

Section 5.5.2, “Adding User Accounts”
Section 5.3.1, “General Security Guidelines”

SHOW INDEX

Section 12.3.1, “DESCRIBE Syntax”
Section 4.6.3.4, “Other myisamchk Options”
Section 20.4, “The INFORMATION_SCHEMA STATISTICS Table”
Section 20.12, “The INFORMATION_SCHEMA TABLE_CONSTRAINTS Table”

SHOW MASTER STATUS

Section 16.1.1.5, “Creating a Data Snapshot Using mysqldump”
Section 16.3.6, “How to Report Replication Bugs or Problems”
Section 16.1.1.4, “Obtaining the Master Replication Information”
Section 12.6.1, “SQL Statements for Controlling Master Servers”
Section 16.3.5, “Troubleshooting Replication”

SHOW PLUGINS

Section 22.2.1, “Characteristics of the Plugin Interface”
Chapter 18, Partitioning

SHOW PROCEDURE STATUS

Section 19.2.3, “Stored Routine Metadata”

SHOW PROCESSLIST

Section 21.10.3.43, “mysql_list_processes()”
Description
Section 5.3.2, “Making MySQL Secure Against Attackers”
Section 17.6.1, “MySQL Server Usage for MySQL Cluster”
Section 16.3.4, “Replication FAQ”
Section 16.4.1, “Replication Implementation Details”
Section 16.3.5, “Troubleshooting Replication”

SHOW PROFILE

Section 20.26, “The INFORMATION_SCHEMA PROFILING Table”

SHOW PROFILES

Section 20.26, “The INFORMATION_SCHEMA PROFILING Table”

SHOW SESSION STATUS

Section 20.24, “The INFORMATION_SCHEMA GLOBAL_STATUS and SESSION_STATUS Tables”

SHOW SESSION VARIABLES

Section 20.25, “The INFORMATION_SCHEMA GLOBAL_VARIABLES and SESSION_VARIABLES Tables”

SHOW SLAVE HOSTS

Section 12.6.1, “SQL Statements for Controlling Master Servers”

SHOW SLAVE STATUS

Section 12.6.1.1, “PURGE BINARY LOGS Syntax”
Section 12.6.2.7, “START SLAVE Syntax”
Section 16.3.6, “How to Report Replication Bugs or Problems”
Section 16.3.4, “Replication FAQ”
Section 16.4.1, “Replication Implementation Details”
Section 12.6.2, “SQL Statements for Controlling Slave Servers”
Section 16.3.1.20, “Slave Errors during Replication”
Section 16.4.2.2, “The Slave Status Files”
Section 16.3.5, “Troubleshooting Replication”

SHOW STATUS

Section 17.4.2, “mysqld Command Options for MySQL Cluster”
Section 22.2.3.3, “Creating a Plugin Library”
Section 22.2.3.1, “General Plugin Structures and Functions”
Section 17.7.7, “Quick Reference: MySQL Cluster SQL Statements”
Section 16.4.1, “Replication Implementation Details”
Section 16.3.1.23, “Replication Retries and Timeouts”
Section 16.3.1.22, “Replication and Temporary Tables”
Section D.1, “Restrictions on Stored Routines, Triggers, and Events”

SHOW TABLE STATUS

Section 12.3.1, “DESCRIBE Syntax”
Section 18.3.4, “Obtaining Information About Partitions”
Section 13.12, “The ARCHIVE Storage Engine”

SHOW TABLES

Chapter 20, INFORMATION_SCHEMA Tables
Section 3.3.2, “Creating a Table”
Description
Section 20.28, “Extensions to SHOW Statements”
Section 8.2.2, “Identifier Case Sensitivity”
Section 8.2.3, “Mapping of Identifiers to File Names”

SHOW TRIGGERS

Section A.5, “MySQL 5.1 FAQ — Triggers”
Section 20.16, “The INFORMATION_SCHEMA TRIGGERS Table”
Section 19.3.2, “Trigger Metadata”

SHOW VARIABLES

Section 22.2.3.3, “Creating a Plugin Library”
Section A.11, “MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets”
Chapter 18, Partitioning

SHOW WARNINGS

Section 8.2.4, “Function Name Parsing and Resolution”

SIGNAL

Section A.4, “MySQL 5.1 FAQ — Stored Procedures and Functions”

START SLAVE

Section 12.6.2.1, “CHANGE MASTER TO Syntax”
Section 12.6.2.7, “START SLAVE Syntax”
Section 12.6.2.8, “STOP SLAVE Syntax”
Description
Section 16.4.1, “Replication Implementation Details”
Section 16.3.1.20, “Slave Errors during Replication”
Section 16.3.5, “Troubleshooting Replication”

START TRANSACTION

Section D.1, “Restrictions on Stored Routines, Triggers, and Events”
Section 19.3.1, “Trigger Syntax”

STOP SLAVE

Section 12.6.2.1, “CHANGE MASTER TO Syntax”
Section 12.6.1.2, “RESET MASTER Syntax”
Section 12.6.2.5, “RESET SLAVE Syntax”
Section 12.6.2.7, “START SLAVE Syntax”
Section 12.6.2.8, “STOP SLAVE Syntax”
Section 16.1.1.9, “Introducing Additional Slaves to an Existing Replication Environment”

TRUNCATE

Section 13.11.3, “FEDERATED Storage Engine Notes and Tips”
Section 13.5.3.3, “Compressed Table Characteristics”
Description
Section 16.3.1.27, “Replication and TRUNCATE”

TRUNCATE TABLE

Description
Section 18.3.1, “Management of RANGE and LIST Partitions”
Section 13.9, “The MEMORY (HEAP) Storage Engine”
Section 21.10.10.2, “What Results You Can Get from a Query”

UNINSTALL PLUGIN

Section 22.2.1, “Characteristics of the Plugin Interface”
Section 22.2.3.1, “General Plugin Structures and Functions”
Section 13.4.1, “Pluggable Storage Engine Architecture”

UNION

Section 21.10.1, “C API Data Types”
Section 11.11.3, “Information Functions”
Section 10.2, “Numeric Types”
Section D.4, “Restrictions on Views”
Section 9.1.8.1, “Result Strings”
Section 3.6.7, “Searching on Two Keys”
Section 19.5.3, “Updatable and Insertable Views”
Section 19.5.2, “View Processing Algorithms”
Section 19.5.1, “View Syntax”
Section 11.10, “XML Functions”

UNION ALL

Section 11.11.3, “Information Functions”
Section 19.5.3, “Updatable and Insertable Views”
Section 19.5.2, “View Processing Algorithms”

UNLOCK TABLES

Section 6.1, “Database Backups”
Description
Section D.1, “Restrictions on Stored Routines, Triggers, and Events”
Section 13.14, “The BLACKHOLE Storage Engine”

UPDATE

Section 4.5.1.1, “mysql Options”
Section 4.6.7.2, “mysqlbinlog Row Event Display”
Section 13.11.3, “FEDERATED Storage Engine Notes and Tips”
Section 21.10.3.1, “mysql_affected_rows()”
Section 21.10.3.35, “mysql_info()”
Section 21.10.3.37, “mysql_insert_id()”
Section 21.10.3.48, “mysql_num_rows()”
Section 21.10.3.49, “mysql_options()”
Section 21.10.7.1, “mysql_stmt_affected_rows()”
Section 21.10.7.10, “mysql_stmt_execute()”
Section 21.10.7.16, “mysql_stmt_insert_id()”
Section 21.10.7.17, “mysql_stmt_num_rows()”
Section 5.5.2, “Adding User Accounts”
Section 5.5.5, “Assigning Account Passwords”
Section 12.7.4, “Automatic Prepared Statement Repreparation”
Section 21.10.2, “C API Function Overview”
Section 21.10.6, “C API Prepared Statement Function Overview”
Section 21.10.4, “C API Prepared Statements”
Section 21.10.12, “C API Support for Multiple Statement Execution”
Section 13.11.2.1, “Creating a FEDERATED Table Using CONNECTION”
Section 10.1.4, “Data Type Default Values”
Chapter 11, Functions and Operators
Section 11.11.3, “Information Functions”
Section 11.11.4, “Miscellaneous Functions”
Section A.4, “MySQL 5.1 FAQ — Stored Procedures and Functions”
Section 10.2, “Numeric Types”
Section 10.1.2, “Overview of Date and Time Types”
Section 16.3.1.11, “Replication and LIMIT”
Section 16.3.1.18, “Replication and the Query Optimizer”
Section 16.3.1.7, “Replication of Invoked Features”
Section 18.5, “Restrictions and Limitations on Partitioning”
Section D.3, “Restrictions on Subqueries”
Section D.4, “Restrictions on Views”
Section 12.7, “SQL Syntax for Prepared Statements”
Section 3.3.4.1, “Selecting All Data”
Section 13.12, “The ARCHIVE Storage Engine”
Section 13.14, “The BLACKHOLE Storage Engine”
Section 20.15, “The INFORMATION_SCHEMA VIEWS Table”
Section 13.5, “The MyISAM Storage Engine”
Section 9.1.6.4, “The _bin and binary Collations”
Section 19.3.1, “Trigger Syntax”
Section 19.5.3, “Updatable and Insertable Views”
Section 19.3, “Using Triggers”
Section 4.5.1.5.2, “Using the --safe-updates Option”
Section 21.10.10.2, “What Results You Can Get from a Query”
Section 21.10.10.1, “Why mysql_store_result() Sometimes Returns NULL After mysql_query() Returns Success”

USE

Chapter 20, INFORMATION_SCHEMA Tables
Section 12.3.4, “USE Syntax”
Section 3.3.1, “Creating and Selecting a Database”
Section 3.3, “Creating and Using a Database”
Description
Description
Section 19.2.1, “Stored Routine Syntax”

XA END

Section D.5, “Restrictions on XA Transactions”

XA START

Section D.5, “Restrictions on XA Transactions”
Prev   Next
Status Variable Index Home System Variable Index