<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"><title>Privileges Index</title><link rel="stylesheet" href="mysql-html.css" type="text/css"><meta name="generator" content="DocBook XSL Stylesheets V1.69.1"><link rel="start" href="index.html" title="MySQL 5.1 Reference Manual"><link rel="up" href="index.html" title="MySQL 5.1 Reference Manual"><link rel="prev" href="dynindex-option.html" title="Option Index"><link rel="next" href="dynindex-sqlmode.html" title="SQL Modes Index"></head><body bgcolor="white" text="black" link="#0000FF" vlink="#840084" alink="#0000FF"><div class="navheader"><table width="100%" summary="Navigation header"><tr><th colspan="3" align="center">Privileges Index</th></tr><tr><td width="20%" align="left"><a accesskey="p" href="dynindex-option.html">Prev</a> </td><th width="60%" align="center"> </th><td width="20%" align="right"> <a accesskey="n" href="dynindex-sqlmode.html">Next</a></td></tr></table><hr></div><div class="index"><div class="titlepage"><div><div><h2 class="title"><a name="dynindex-priv"></a>Privileges Index</h2></div></div></div><div class="indexdiv"><h3 class="title"><code class="literal">ALL</code></h3><dl><dt><a href="server-administration.html#privileges-provided" title="5.4.1. Privileges Provided by MySQL">Section 5.4.1, “Privileges Provided by MySQL”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">ALL PRIVILEGES</code></h3><dl><dt><a href="server-administration.html#privileges-provided" title="5.4.1. Privileges Provided by MySQL">Section 5.4.1, “Privileges Provided by MySQL”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">ALL [PRIVILEGES]</code></h3><dl><dt><a href="sql-syntax.html#grant" title="12.5.1.3. GRANT Syntax">Section 12.5.1.3, “<code class="literal">GRANT</code> Syntax”</a></dt><dt><a href="server-administration.html#privileges-provided" title="5.4.1. Privileges Provided by MySQL">Section 5.4.1, “Privileges Provided by MySQL”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">ALTER</code></h3><dl><dt><a href="sql-syntax.html#alter-database" title="12.1.1. ALTER DATABASE Syntax">Section 12.1.1, “<code class="literal">ALTER DATABASE</code> Syntax”</a></dt><dt><a href="sql-syntax.html#alter-table" title="12.1.7. ALTER TABLE Syntax">Section 12.1.7, “<code class="literal">ALTER TABLE</code> Syntax”</a></dt><dt><a href="sql-syntax.html#grant" title="12.5.1.3. GRANT Syntax">Section 12.5.1.3, “<code class="literal">GRANT</code> Syntax”</a></dt><dt><a href="sql-syntax.html#rename-table" title="12.1.33. RENAME TABLE Syntax">Section 12.1.33, “<code class="literal">RENAME TABLE</code> Syntax”</a></dt><dt><a href="server-administration.html#privileges-provided" title="5.4.1. Privileges Provided by MySQL">Section 5.4.1, “Privileges Provided by MySQL”</a></dt><dt><a href="information-schema.html#table-privileges-table" title="20.7. The INFORMATION_SCHEMA TABLE_PRIVILEGES Table">Section 20.7, “The <code class="literal">INFORMATION_SCHEMA TABLE_PRIVILEGES</code> Table”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">ALTER ROUTINE</code></h3><dl><dt><a href="sql-syntax.html#alter-function" title="12.1.4. ALTER FUNCTION Syntax">Section 12.1.4, “<code class="literal">ALTER FUNCTION</code> Syntax”</a></dt><dt><a href="sql-syntax.html#alter-procedure" title="12.1.5. ALTER PROCEDURE Syntax">Section 12.1.5, “<code class="literal">ALTER PROCEDURE</code> Syntax”</a></dt><dt><a href="sql-syntax.html#create-procedure" title="12.1.15. CREATE PROCEDURE and
CREATE FUNCTION Syntax">Section 12.1.15, “<code class="literal">CREATE PROCEDURE</code> and
<code class="literal">CREATE FUNCTION</code> Syntax”</a></dt><dt><a href="sql-syntax.html#drop-procedure" title="12.1.26. DROP PROCEDURE and
DROP FUNCTION Syntax">Section 12.1.26, “<code class="literal">DROP PROCEDURE</code> and
<code class="literal">DROP FUNCTION</code> Syntax”</a></dt><dt><a href="sql-syntax.html#grant" title="12.5.1.3. GRANT Syntax">Section 12.5.1.3, “<code class="literal">GRANT</code> Syntax”</a></dt><dt><a href="stored-programs-views.html#stored-programs-logging" title="19.6. Binary Logging of Stored Programs">Section 19.6, “Binary Logging of Stored Programs”</a></dt><dt><a href="server-administration.html#privileges-provided" title="5.4.1. Privileges Provided by MySQL">Section 5.4.1, “Privileges Provided by MySQL”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt><dt><a href="stored-programs-views.html#stored-routines-privileges" title="19.2.2. Stored Routines and MySQL Privileges">Section 19.2.2, “Stored Routines and MySQL Privileges”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">CREATE</code></h3><dl><dt><a href="sql-syntax.html#alter-table" title="12.1.7. ALTER TABLE Syntax">Section 12.1.7, “<code class="literal">ALTER TABLE</code> Syntax”</a></dt><dt><a href="sql-syntax.html#create-database" title="12.1.10. CREATE DATABASE Syntax">Section 12.1.10, “<code class="literal">CREATE DATABASE</code> Syntax”</a></dt><dt><a href="sql-syntax.html#create-table" title="12.1.17. CREATE TABLE Syntax">Section 12.1.17, “<code class="literal">CREATE TABLE</code> Syntax”</a></dt><dt><a href="sql-syntax.html#grant" title="12.5.1.3. GRANT Syntax">Section 12.5.1.3, “<code class="literal">GRANT</code> Syntax”</a></dt><dt><a href="sql-syntax.html#rename-table" title="12.1.33. RENAME TABLE Syntax">Section 12.1.33, “<code class="literal">RENAME TABLE</code> Syntax”</a></dt><dt><a href="server-administration.html#privileges-provided" title="5.4.1. Privileges Provided by MySQL">Section 5.4.1, “Privileges Provided by MySQL”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">CREATE ROUTINE</code></h3><dl><dt><a href="sql-syntax.html#create-procedure" title="12.1.15. CREATE PROCEDURE and
CREATE FUNCTION Syntax">Section 12.1.15, “<code class="literal">CREATE PROCEDURE</code> and
<code class="literal">CREATE FUNCTION</code> Syntax”</a></dt><dt><a href="sql-syntax.html#grant" title="12.5.1.3. GRANT Syntax">Section 12.5.1.3, “<code class="literal">GRANT</code> Syntax”</a></dt><dt><a href="stored-programs-views.html#stored-programs-logging" title="19.6. Binary Logging of Stored Programs">Section 19.6, “Binary Logging of Stored Programs”</a></dt><dt><a href="server-administration.html#privileges-provided" title="5.4.1. Privileges Provided by MySQL">Section 5.4.1, “Privileges Provided by MySQL”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt><dt><a href="stored-programs-views.html#stored-routines-privileges" title="19.2.2. Stored Routines and MySQL Privileges">Section 19.2.2, “Stored Routines and MySQL Privileges”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">CREATE TABLESPACE</code></h3><dl><dt><a href="sql-syntax.html#grant" title="12.5.1.3. GRANT Syntax">Section 12.5.1.3, “<code class="literal">GRANT</code> Syntax”</a></dt><dt><a href="server-administration.html#privileges-provided" title="5.4.1. Privileges Provided by MySQL">Section 5.4.1, “Privileges Provided by MySQL”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">CREATE TEMPORARY TABLES</code></h3><dl><dt><a href="sql-syntax.html#create-table" title="12.1.17. CREATE TABLE Syntax">Section 12.1.17, “<code class="literal">CREATE TABLE</code> Syntax”</a></dt><dt><a href="sql-syntax.html#grant" title="12.5.1.3. GRANT Syntax">Section 12.5.1.3, “<code class="literal">GRANT</code> Syntax”</a></dt><dt><a href="server-administration.html#privileges-provided" title="5.4.1. Privileges Provided by MySQL">Section 5.4.1, “Privileges Provided by MySQL”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">CREATE USER</code></h3><dl><dt><a href="sql-syntax.html#create-user" title="12.5.1.1. CREATE USER Syntax">Section 12.5.1.1, “<code class="literal">CREATE USER</code> Syntax”</a></dt><dt><a href="sql-syntax.html#drop-user" title="12.5.1.2. DROP USER Syntax">Section 12.5.1.2, “<code class="literal">DROP USER</code> Syntax”</a></dt><dt><a href="sql-syntax.html#grant" title="12.5.1.3. GRANT Syntax">Section 12.5.1.3, “<code class="literal">GRANT</code> Syntax”</a></dt><dt><a href="sql-syntax.html#rename-user" title="12.5.1.4. RENAME USER Syntax">Section 12.5.1.4, “<code class="literal">RENAME USER</code> Syntax”</a></dt><dt><a href="sql-syntax.html#revoke" title="12.5.1.5. REVOKE Syntax">Section 12.5.1.5, “<code class="literal">REVOKE</code> Syntax”</a></dt><dt><a href="server-administration.html#privileges-provided" title="5.4.1. Privileges Provided by MySQL">Section 5.4.1, “Privileges Provided by MySQL”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">CREATE VIEW</code></h3><dl><dt><a href="sql-syntax.html#alter-view" title="12.1.9. ALTER VIEW Syntax">Section 12.1.9, “<code class="literal">ALTER VIEW</code> Syntax”</a></dt><dt><a href="sql-syntax.html#create-view" title="12.1.20. CREATE VIEW Syntax">Section 12.1.20, “<code class="literal">CREATE VIEW</code> Syntax”</a></dt><dt><a href="sql-syntax.html#grant" title="12.5.1.3. GRANT Syntax">Section 12.5.1.3, “<code class="literal">GRANT</code> Syntax”</a></dt><dt><a href="server-administration.html#privileges-provided" title="5.4.1. Privileges Provided by MySQL">Section 5.4.1, “Privileges Provided by MySQL”</a></dt><dt><a href="restrictions.html#view-restrictions" title="D.4. Restrictions on Views">Section D.4, “Restrictions on Views”</a></dt><dt><a href="information-schema.html#table-privileges-table" title="20.7. The INFORMATION_SCHEMA TABLE_PRIVILEGES Table">Section 20.7, “The <code class="literal">INFORMATION_SCHEMA TABLE_PRIVILEGES</code> Table”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">DELETE</code></h3><dl><dt><a href="sql-syntax.html#create-table" title="12.1.17. CREATE TABLE Syntax">Section 12.1.17, “<code class="literal">CREATE TABLE</code> Syntax”</a></dt><dt><a href="sql-syntax.html#delete" title="12.2.2. DELETE Syntax">Section 12.2.2, “<code class="literal">DELETE</code> Syntax”</a></dt><dt><a href="sql-syntax.html#drop-function-udf" title="12.5.3.2. DROP FUNCTION Syntax">Section 12.5.3.2, “<code class="literal">DROP FUNCTION</code> Syntax”</a></dt><dt><a href="sql-syntax.html#drop-user" title="12.5.1.2. DROP USER Syntax">Section 12.5.1.2, “<code class="literal">DROP USER</code> Syntax”</a></dt><dt><a href="sql-syntax.html#grant" title="12.5.1.3. GRANT Syntax">Section 12.5.1.3, “<code class="literal">GRANT</code> Syntax”</a></dt><dt><a href="sql-syntax.html#lock-tables" title="12.4.5. LOCK TABLES and
UNLOCK
TABLES Syntax">Section 12.4.5, “<code class="literal">LOCK TABLES</code> and
<code class="literal">UNLOCK
TABLES</code> Syntax”</a></dt><dt><a href="sql-syntax.html#replace" title="12.2.7. REPLACE Syntax">Section 12.2.7, “<code class="literal">REPLACE</code> Syntax”</a></dt><dt><a href="sql-syntax.html#truncate" title="12.2.10. TRUNCATE Syntax">Section 12.2.10, “<code class="literal">TRUNCATE</code> Syntax”</a></dt><dt><a href="sql-syntax.html#uninstall-plugin" title="12.5.3.4. UNINSTALL PLUGIN Syntax">Section 12.5.3.4, “<code class="literal">UNINSTALL PLUGIN</code> Syntax”</a></dt><dt><a href="server-administration.html#request-access" title="5.4.5. Access Control, Stage 2: Request Verification">Section 5.4.5, “Access Control, Stage 2: Request Verification”</a></dt><dt><a href="extending-mysql.html#udf-compiling" title="22.3.2.5. Compiling and Installing User-Defined Functions">Section 22.3.2.5, “Compiling and Installing User-Defined Functions”</a></dt><dt><a href="mysql-cluster.html#mysql-cluster-security-mysql-privileges" title="17.5.8.2. MySQL Cluster and MySQL Privileges">Section 17.5.8.2, “MySQL Cluster and MySQL Privileges”</a></dt><dt><a href="server-administration.html#privileges-provided" title="5.4.1. Privileges Provided by MySQL">Section 5.4.1, “Privileges Provided by MySQL”</a></dt><dt><a href="storage-engines.html#merge-storage-engine" title="13.8. The MERGE Storage Engine">Section 13.8, “The <code class="literal">MERGE</code> Storage Engine”</a></dt><dt><a href="extending-mysql.html#udf-security" title="22.3.2.6. User-Defined Function Security Precautions">Section 22.3.2.6, “User-Defined Function Security Precautions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">DROP</code></h3><dl><dt><a href="sql-syntax.html#alter-view" title="12.1.9. ALTER VIEW Syntax">Section 12.1.9, “<code class="literal">ALTER VIEW</code> Syntax”</a></dt><dt><a href="sql-syntax.html#create-view" title="12.1.20. CREATE VIEW Syntax">Section 12.1.20, “<code class="literal">CREATE VIEW</code> Syntax”</a></dt><dt><a href="sql-syntax.html#drop-database" title="12.1.21. DROP DATABASE Syntax">Section 12.1.21, “<code class="literal">DROP DATABASE</code> Syntax”</a></dt><dt><a href="sql-syntax.html#drop-table" title="12.1.28. DROP TABLE Syntax">Section 12.1.28, “<code class="literal">DROP TABLE</code> Syntax”</a></dt><dt><a href="sql-syntax.html#drop-view" title="12.1.31. DROP VIEW Syntax">Section 12.1.31, “<code class="literal">DROP VIEW</code> Syntax”</a></dt><dt><a href="sql-syntax.html#grant" title="12.5.1.3. GRANT Syntax">Section 12.5.1.3, “<code class="literal">GRANT</code> Syntax”</a></dt><dt><a href="sql-syntax.html#rename-table" title="12.1.33. RENAME TABLE Syntax">Section 12.1.33, “<code class="literal">RENAME TABLE</code> Syntax”</a></dt><dt><a href="sql-syntax.html#truncate" title="12.2.10. TRUNCATE Syntax">Section 12.2.10, “<code class="literal">TRUNCATE</code> Syntax”</a></dt><dt><a href="partitioning.html#partitioning-management-range-list" title="18.3.1. Management of RANGE and LIST
Partitions">Section 18.3.1, “Management of <code class="literal">RANGE</code> and <code class="literal">LIST</code>
Partitions”</a></dt><dt><a href="server-administration.html#privileges-provided" title="5.4.1. Privileges Provided by MySQL">Section 5.4.1, “Privileges Provided by MySQL”</a></dt><dt><a href="information-schema.html#table-privileges-table" title="20.7. The INFORMATION_SCHEMA TABLE_PRIVILEGES Table">Section 20.7, “The <code class="literal">INFORMATION_SCHEMA TABLE_PRIVILEGES</code> Table”</a></dt><dt><a href="server-administration.html#privilege-system" title="5.4. The MySQL Access Privilege System">Section 5.4, “The MySQL Access Privilege System”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">EVENT</code></h3><dl><dt><a href="sql-syntax.html#alter-event" title="12.1.2. ALTER EVENT Syntax">Section 12.1.2, “<code class="literal">ALTER EVENT</code> Syntax”</a></dt><dt><a href="sql-syntax.html#create-event" title="12.1.11. CREATE EVENT Syntax">Section 12.1.11, “<code class="literal">CREATE EVENT</code> Syntax”</a></dt><dt><a href="sql-syntax.html#drop-event" title="12.1.22. DROP EVENT Syntax">Section 12.1.22, “<code class="literal">DROP EVENT</code> Syntax”</a></dt><dt><a href="sql-syntax.html#grant" title="12.5.1.3. GRANT Syntax">Section 12.5.1.3, “<code class="literal">GRANT</code> Syntax”</a></dt><dt><a href="server-administration.html#privileges-provided" title="5.4.1. Privileges Provided by MySQL">Section 5.4.1, “Privileges Provided by MySQL”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">EXECUTE</code></h3><dl><dt><a href="sql-syntax.html#create-procedure" title="12.1.15. CREATE PROCEDURE and
CREATE FUNCTION Syntax">Section 12.1.15, “<code class="literal">CREATE PROCEDURE</code> and
<code class="literal">CREATE FUNCTION</code> Syntax”</a></dt><dt><a href="sql-syntax.html#grant" title="12.5.1.3. GRANT Syntax">Section 12.5.1.3, “<code class="literal">GRANT</code> Syntax”</a></dt><dt><a href="server-administration.html#privileges-provided" title="5.4.1. Privileges Provided by MySQL">Section 5.4.1, “Privileges Provided by MySQL”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt><dt><a href="stored-programs-views.html#stored-routines-privileges" title="19.2.2. Stored Routines and MySQL Privileges">Section 19.2.2, “Stored Routines and MySQL Privileges”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">FILE</code></h3><dl><dt><a href="sql-syntax.html#grant" title="12.5.1.3. GRANT Syntax">Section 12.5.1.3, “<code class="literal">GRANT</code> Syntax”</a></dt><dt><a href="sql-syntax.html#load-data" title="12.2.6. LOAD DATA INFILE
Syntax">Section 12.2.6, “<code class="literal">LOAD DATA INFILE</code>
Syntax”</a></dt><dt><a href="sql-syntax.html#select" title="12.2.8. SELECT Syntax">Section 12.2.8, “<code class="literal">SELECT</code> Syntax”</a></dt><dt><a href="server-administration.html#access-denied" title="5.4.7. Causes of Access-Denied Errors">Section 5.4.7, “Causes of Access-Denied Errors”</a></dt><dt><a href="http://dev.mysql.com/doc/refman/5.1/en/mysqldump-description.html" target="_top">Description</a></dt><dt><a href="replication.html#replication-howto" title="16.1.1. How to Set Up Replication">Section 16.1.1, “How to Set Up Replication”</a></dt><dt><a href="server-administration.html#security-against-attack" title="5.3.2. Making MySQL Secure Against Attackers">Section 5.3.2, “Making MySQL Secure Against Attackers”</a></dt><dt><a href="server-administration.html#grant-table-structure" title="5.4.2. Privilege System Grant Tables">Section 5.4.2, “Privilege System Grant Tables”</a></dt><dt><a href="server-administration.html#privileges-provided" title="5.4.1. Privileges Provided by MySQL">Section 5.4.1, “Privileges Provided by MySQL”</a></dt><dt><a href="replication.html#replication-options-slave" title="16.1.3.3. Replication Slave Options and Variables">Section 16.1.3.3, “Replication Slave Options and Variables”</a></dt><dt><a href="functions.html#string-functions" title="11.4. String Functions">Section 11.4, “String Functions”</a></dt><dt><a href="data-types.html#blob" title="10.4.3. The BLOB and
TEXT Types">Section 10.4.3, “The <code class="literal">BLOB</code> and
<code class="literal">TEXT</code> Types”</a></dt><dt><a href="installing.html#upgrading-from-previous-series" title="2.4.1.1. Upgrading from MySQL 5.0 to 5.1">Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">GRANT OPTION</code></h3><dl><dt><a href="sql-syntax.html#grant" title="12.5.1.3. GRANT Syntax">Section 12.5.1.3, “<code class="literal">GRANT</code> Syntax”</a></dt><dt><a href="sql-syntax.html#revoke" title="12.5.1.5. REVOKE Syntax">Section 12.5.1.5, “<code class="literal">REVOKE</code> Syntax”</a></dt><dt><a href="server-administration.html#privileges-provided" title="5.4.1. Privileges Provided by MySQL">Section 5.4.1, “Privileges Provided by MySQL”</a></dt><dt><a href="information-schema.html#column-privileges-table" title="20.8. The INFORMATION_SCHEMA COLUMN_PRIVILEGES Table">Section 20.8, “The <code class="literal">INFORMATION_SCHEMA COLUMN_PRIVILEGES</code> Table”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">INDEX</code></h3><dl><dt><a href="sql-syntax.html#alter-table" title="12.1.7. ALTER TABLE Syntax">Section 12.1.7, “<code class="literal">ALTER TABLE</code> Syntax”</a></dt><dt><a href="sql-syntax.html#grant" title="12.5.1.3. GRANT Syntax">Section 12.5.1.3, “<code class="literal">GRANT</code> Syntax”</a></dt><dt><a href="server-administration.html#privileges-provided" title="5.4.1. Privileges Provided by MySQL">Section 5.4.1, “Privileges Provided by MySQL”</a></dt><dt><a href="information-schema.html#table-privileges-table" title="20.7. The INFORMATION_SCHEMA TABLE_PRIVILEGES Table">Section 20.7, “The <code class="literal">INFORMATION_SCHEMA TABLE_PRIVILEGES</code> Table”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">INSERT</code></h3><dl><dt><a href="sql-syntax.html#alter-table" title="12.1.7. ALTER TABLE Syntax">Section 12.1.7, “<code class="literal">ALTER TABLE</code> Syntax”</a></dt><dt><a href="sql-syntax.html#analyze-table" title="12.5.2.1. ANALYZE TABLE Syntax">Section 12.5.2.1, “<code class="literal">ANALYZE TABLE</code> Syntax”</a></dt><dt><a href="sql-syntax.html#create-function-udf" title="12.5.3.1. CREATE FUNCTION Syntax">Section 12.5.3.1, “<code class="literal">CREATE FUNCTION</code> Syntax”</a></dt><dt><a href="sql-syntax.html#create-user" title="12.5.1.1. CREATE USER Syntax">Section 12.5.1.1, “<code class="literal">CREATE USER</code> Syntax”</a></dt><dt><a href="sql-syntax.html#grant" title="12.5.1.3. GRANT Syntax">Section 12.5.1.3, “<code class="literal">GRANT</code> Syntax”</a></dt><dt><a href="sql-syntax.html#insert" title="12.2.5. INSERT Syntax">Section 12.2.5, “<code class="literal">INSERT</code> Syntax”</a></dt><dt><a href="sql-syntax.html#lock-tables" title="12.4.5. LOCK TABLES and
UNLOCK
TABLES Syntax">Section 12.4.5, “<code class="literal">LOCK TABLES</code> and
<code class="literal">UNLOCK
TABLES</code> Syntax”</a></dt><dt><a href="sql-syntax.html#optimize-table" title="12.5.2.5. OPTIMIZE TABLE Syntax">Section 12.5.2.5, “<code class="literal">OPTIMIZE TABLE</code> Syntax”</a></dt><dt><a href="sql-syntax.html#rename-table" title="12.1.33. RENAME TABLE Syntax">Section 12.1.33, “<code class="literal">RENAME TABLE</code> Syntax”</a></dt><dt><a href="sql-syntax.html#repair-table" title="12.5.2.6. REPAIR TABLE Syntax">Section 12.5.2.6, “<code class="literal">REPAIR TABLE</code> Syntax”</a></dt><dt><a href="sql-syntax.html#replace" title="12.2.7. REPLACE Syntax">Section 12.2.7, “<code class="literal">REPLACE</code> Syntax”</a></dt><dt><a href="server-administration.html#request-access" title="5.4.5. Access Control, Stage 2: Request Verification">Section 5.4.5, “Access Control, Stage 2: Request Verification”</a></dt><dt><a href="server-administration.html#adding-users" title="5.5.2. Adding User Accounts">Section 5.5.2, “Adding User Accounts”</a></dt><dt><a href="extending-mysql.html#udf-compiling" title="22.3.2.5. Compiling and Installing User-Defined Functions">Section 22.3.2.5, “Compiling and Installing User-Defined Functions”</a></dt><dt><a href="storage-engines.html#pluggable-storage" title="13.4.1. Pluggable Storage Engine Architecture">Section 13.4.1, “Pluggable Storage Engine Architecture”</a></dt><dt><a href="server-administration.html#privileges-provided" title="5.4.1. Privileges Provided by MySQL">Section 5.4.1, “Privileges Provided by MySQL”</a></dt><dt><a href="server-administration.html#privileges-options" title="5.3.3. Security-Related mysqld Options">Section 5.3.3, “Security-Related <span><strong class="command">mysqld</strong></span> Options”</a></dt><dt><a href="server-administration.html#server-options" title="5.1.2. Server Command Options">Section 5.1.2, “Server Command Options”</a></dt><dt><a href="information-schema.html#column-privileges-table" title="20.8. The INFORMATION_SCHEMA COLUMN_PRIVILEGES Table">Section 20.8, “The <code class="literal">INFORMATION_SCHEMA COLUMN_PRIVILEGES</code> Table”</a></dt><dt><a href="information-schema.html#table-privileges-table" title="20.7. The INFORMATION_SCHEMA TABLE_PRIVILEGES Table">Section 20.7, “The <code class="literal">INFORMATION_SCHEMA TABLE_PRIVILEGES</code> Table”</a></dt><dt><a href="extending-mysql.html#udf-security" title="22.3.2.6. User-Defined Function Security Precautions">Section 22.3.2.6, “User-Defined Function Security Precautions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">LOCK TABLES</code></h3><dl><dt><a href="sql-syntax.html#grant" title="12.5.1.3. GRANT Syntax">Section 12.5.1.3, “<code class="literal">GRANT</code> Syntax”</a></dt><dt><a href="sql-syntax.html#lock-tables" title="12.4.5. LOCK TABLES and
UNLOCK
TABLES Syntax">Section 12.4.5, “<code class="literal">LOCK TABLES</code> and
<code class="literal">UNLOCK
TABLES</code> Syntax”</a></dt><dt><a href="http://dev.mysql.com/doc/refman/5.1/en/mysqlhotcopy-description.html" target="_top">Description</a></dt><dt><a href="server-administration.html#privileges-provided" title="5.4.1. Privileges Provided by MySQL">Section 5.4.1, “Privileges Provided by MySQL”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">PROCESS</code></h3><dl><dt><a href="sql-syntax.html#grant" title="12.5.1.3. GRANT Syntax">Section 12.5.1.3, “<code class="literal">GRANT</code> Syntax”</a></dt><dt><a href="sql-syntax.html#kill" title="12.5.6.4. KILL Syntax">Section 12.5.6.4, “<code class="literal">KILL</code> Syntax”</a></dt><dt><a href="storage-engines.html#innodb-monitors" title="13.6.13.2. SHOW ENGINE INNODB
STATUS and the InnoDB Monitors">Section 13.6.13.2, “<code class="literal">SHOW ENGINE INNODB
STATUS</code> and the <code class="literal">InnoDB</code> Monitors”</a></dt><dt><a href="sql-syntax.html#show-processlist" title="12.5.5.31. SHOW PROCESSLIST Syntax">Section 12.5.5.31, “<code class="literal">SHOW PROCESSLIST</code> Syntax”</a></dt><dt><a href="server-administration.html#adding-users" title="5.5.2. Adding User Accounts">Section 5.5.2, “Adding User Accounts”</a></dt><dt><a href="optimization.html#thread-information" title="7.5.6. Examining Thread Information">Section 7.5.6, “Examining Thread Information”</a></dt><dt><a href="replication.html#replication-howto" title="16.1.1. How to Set Up Replication">Section 16.1.1, “How to Set Up Replication”</a></dt><dt><a href="server-administration.html#security-against-attack" title="5.3.2. Making MySQL Secure Against Attackers">Section 5.3.2, “Making MySQL Secure Against Attackers”</a></dt><dt><a href="mysql-cluster.html#mysql-cluster-programs-mysqld" title="17.4.1. MySQL Server Usage for MySQL Cluster">Section 17.4.1, “MySQL Server Usage for MySQL Cluster”</a></dt><dt><a href="server-administration.html#privileges-provided" title="5.4.1. Privileges Provided by MySQL">Section 5.4.1, “Privileges Provided by MySQL”</a></dt><dt><a href="information-schema.html#processlist-table" title="20.22. The INFORMATION_SCHEMA PROCESSLIST Table">Section 20.22, “The <code class="literal">INFORMATION_SCHEMA PROCESSLIST</code> Table”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">REFERENCES</code></h3><dl><dt><a href="sql-syntax.html#grant" title="12.5.1.3. GRANT Syntax">Section 12.5.1.3, “<code class="literal">GRANT</code> Syntax”</a></dt><dt><a href="server-administration.html#privileges-provided" title="5.4.1. Privileges Provided by MySQL">Section 5.4.1, “Privileges Provided by MySQL”</a></dt><dt><a href="information-schema.html#column-privileges-table" title="20.8. The INFORMATION_SCHEMA COLUMN_PRIVILEGES Table">Section 20.8, “The <code class="literal">INFORMATION_SCHEMA COLUMN_PRIVILEGES</code> Table”</a></dt><dt><a href="information-schema.html#table-privileges-table" title="20.7. The INFORMATION_SCHEMA TABLE_PRIVILEGES Table">Section 20.7, “The <code class="literal">INFORMATION_SCHEMA TABLE_PRIVILEGES</code> Table”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">RELOAD</code></h3><dl><dt><a href="sql-syntax.html#flush" title="12.5.6.3. FLUSH Syntax">Section 12.5.6.3, “<code class="literal">FLUSH</code> Syntax”</a></dt><dt><a href="sql-syntax.html#grant" title="12.5.1.3. GRANT Syntax">Section 12.5.1.3, “<code class="literal">GRANT</code> Syntax”</a></dt><dt><a href="sql-syntax.html#load-data-from-master" title="12.6.2.2. LOAD DATA FROM MASTER Syntax">Section 12.6.2.2, “<code class="literal">LOAD DATA FROM MASTER</code> Syntax”</a></dt><dt><a href="sql-syntax.html#load-table-from-master" title="12.6.2.3. LOAD TABLE tbl_name FROM
MASTER Syntax">Section 12.6.2.3, “<code class="literal">LOAD TABLE <em class="replaceable"><code>tbl_name</code></em> FROM
MASTER</code> Syntax”</a></dt><dt><a href="sql-syntax.html#reset" title="12.5.6.6. RESET Syntax">Section 12.5.6.6, “<code class="literal">RESET</code> Syntax”</a></dt><dt><a href="connectors-apis.html#mysql-refresh" title="21.9.3.55. mysql_refresh()">Section 21.9.3.55, “<code class="literal">mysql_refresh()</code>”</a></dt><dt><a href="connectors-apis.html#mysql-reload" title="21.9.3.56. mysql_reload()">Section 21.9.3.56, “<code class="literal">mysql_reload()</code>”</a></dt><dt><a href="server-administration.html#request-access" title="5.4.5. Access Control, Stage 2: Request Verification">Section 5.4.5, “Access Control, Stage 2: Request Verification”</a></dt><dt><a href="server-administration.html#adding-users" title="5.5.2. Adding User Accounts">Section 5.5.2, “Adding User Accounts”</a></dt><dt><a href="http://dev.mysql.com/doc/refman/5.1/en/mysqlhotcopy-description.html" target="_top">Description</a></dt><dt><a href="http://dev.mysql.com/doc/refman/5.1/en/mysqldump-description.html" target="_top">Description</a></dt><dt><a href="functions.html#encryption-functions" title="11.11.2. Encryption and Compression Functions">Section 11.11.2, “Encryption and Compression Functions”</a></dt><dt><a href="server-administration.html#grant-table-structure" title="5.4.2. Privilege System Grant Tables">Section 5.4.2, “Privilege System Grant Tables”</a></dt><dt><a href="server-administration.html#privileges-provided" title="5.4.1. Privileges Provided by MySQL">Section 5.4.1, “Privileges Provided by MySQL”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">REPLICATION CLIENT</code></h3><dl><dt><a href="sql-syntax.html#grant" title="12.5.1.3. GRANT Syntax">Section 12.5.1.3, “<code class="literal">GRANT</code> Syntax”</a></dt><dt><a href="sql-syntax.html#show-master-status" title="12.5.5.25. SHOW MASTER STATUS Syntax">Section 12.5.5.25, “<code class="literal">SHOW MASTER STATUS</code> Syntax”</a></dt><dt><a href="sql-syntax.html#show-slave-status" title="12.5.5.36. SHOW SLAVE STATUS Syntax">Section 12.5.5.36, “<code class="literal">SHOW SLAVE STATUS</code> Syntax”</a></dt><dt><a href="server-administration.html#privileges-provided" title="5.4.1. Privileges Provided by MySQL">Section 5.4.1, “Privileges Provided by MySQL”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">REPLICATION SLAVE</code></h3><dl><dt><a href="sql-syntax.html#grant" title="12.5.1.3. GRANT Syntax">Section 12.5.1.3, “<code class="literal">GRANT</code> Syntax”</a></dt><dt><a href="replication.html#replication-howto-repuser" title="16.1.1.1. Creating a User for Replication">Section 16.1.1.1, “Creating a User for Replication”</a></dt><dt><a href="replication.html#replication-howto" title="16.1.1. How to Set Up Replication">Section 16.1.1, “How to Set Up Replication”</a></dt><dt><a href="server-administration.html#privileges-provided" title="5.4.1. Privileges Provided by MySQL">Section 5.4.1, “Privileges Provided by MySQL”</a></dt><dt><a href="replication.html#replication-options-slave" title="16.1.3.3. Replication Slave Options and Variables">Section 16.1.3.3, “Replication Slave Options and Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">SELECT</code></h3><dl><dt><a href="sql-syntax.html#analyze-table" title="12.5.2.1. ANALYZE TABLE Syntax">Section 12.5.2.1, “<code class="literal">ANALYZE TABLE</code> Syntax”</a></dt><dt><a href="sql-syntax.html#checksum-table" title="12.5.2.4. CHECKSUM TABLE Syntax">Section 12.5.2.4, “<code class="literal">CHECKSUM TABLE</code> Syntax”</a></dt><dt><a href="sql-syntax.html#create-procedure" title="12.1.15. CREATE PROCEDURE and
CREATE FUNCTION Syntax">Section 12.1.15, “<code class="literal">CREATE PROCEDURE</code> and
<code class="literal">CREATE FUNCTION</code> Syntax”</a></dt><dt><a href="sql-syntax.html#create-table" title="12.1.17. CREATE TABLE Syntax">Section 12.1.17, “<code class="literal">CREATE TABLE</code> Syntax”</a></dt><dt><a href="sql-syntax.html#create-trigger" title="12.1.19. CREATE TRIGGER Syntax">Section 12.1.19, “<code class="literal">CREATE TRIGGER</code> Syntax”</a></dt><dt><a href="sql-syntax.html#create-view" title="12.1.20. CREATE VIEW Syntax">Section 12.1.20, “<code class="literal">CREATE VIEW</code> Syntax”</a></dt><dt><a href="sql-syntax.html#delete" title="12.2.2. DELETE Syntax">Section 12.2.2, “<code class="literal">DELETE</code> Syntax”</a></dt><dt><a href="sql-syntax.html#grant" title="12.5.1.3. GRANT Syntax">Section 12.5.1.3, “<code class="literal">GRANT</code> Syntax”</a></dt><dt><a href="sql-syntax.html#insert" title="12.2.5. INSERT Syntax">Section 12.2.5, “<code class="literal">INSERT</code> Syntax”</a></dt><dt><a href="sql-syntax.html#load-data-from-master" title="12.6.2.2. LOAD DATA FROM MASTER Syntax">Section 12.6.2.2, “<code class="literal">LOAD DATA FROM MASTER</code> Syntax”</a></dt><dt><a href="sql-syntax.html#load-table-from-master" title="12.6.2.3. LOAD TABLE tbl_name FROM
MASTER Syntax">Section 12.6.2.3, “<code class="literal">LOAD TABLE <em class="replaceable"><code>tbl_name</code></em> FROM
MASTER</code> Syntax”</a></dt><dt><a href="sql-syntax.html#lock-tables" title="12.4.5. LOCK TABLES and
UNLOCK
TABLES Syntax">Section 12.4.5, “<code class="literal">LOCK TABLES</code> and
<code class="literal">UNLOCK
TABLES</code> Syntax”</a></dt><dt><a href="sql-syntax.html#optimize-table" title="12.5.2.5. OPTIMIZE TABLE Syntax">Section 12.5.2.5, “<code class="literal">OPTIMIZE TABLE</code> Syntax”</a></dt><dt><a href="sql-syntax.html#repair-table" title="12.5.2.6. REPAIR TABLE Syntax">Section 12.5.2.6, “<code class="literal">REPAIR TABLE</code> Syntax”</a></dt><dt><a href="sql-syntax.html#show-create-table" title="12.5.5.12. SHOW CREATE TABLE Syntax">Section 12.5.5.12, “<code class="literal">SHOW CREATE TABLE</code> Syntax”</a></dt><dt><a href="sql-syntax.html#show-create-view" title="12.5.5.14. SHOW CREATE VIEW Syntax">Section 12.5.5.14, “<code class="literal">SHOW CREATE VIEW</code> Syntax”</a></dt><dt><a href="sql-syntax.html#show-grants" title="12.5.5.22. SHOW GRANTS Syntax">Section 12.5.5.22, “<code class="literal">SHOW GRANTS</code> Syntax”</a></dt><dt><a href="sql-syntax.html#update" title="12.2.11. UPDATE Syntax">Section 12.2.11, “<code class="literal">UPDATE</code> Syntax”</a></dt><dt><a href="server-administration.html#request-access" title="5.4.5. Access Control, Stage 2: Request Verification">Section 5.4.5, “Access Control, Stage 2: Request Verification”</a></dt><dt><a href="connectors-apis.html#connector-net-programming-connection-options" title="21.2.6. Connector/NET Connection String Options Reference">Section 21.2.6, “Connector/NET Connection String Options Reference”</a></dt><dt><a href="http://dev.mysql.com/doc/refman/5.1/en/mysqlhotcopy-description.html" target="_top">Description</a></dt><dt><a href="http://dev.mysql.com/doc/refman/5.1/en/mysqldump-description.html" target="_top">Description</a></dt><dt><a href="mysql-cluster.html#mysql-cluster-security-mysql-privileges" title="17.5.8.2. MySQL Cluster and MySQL Privileges">Section 17.5.8.2, “MySQL Cluster and MySQL Privileges”</a></dt><dt><a href="server-administration.html#privileges-provided" title="5.4.1. Privileges Provided by MySQL">Section 5.4.1, “Privileges Provided by MySQL”</a></dt><dt><a href="restrictions.html#view-restrictions" title="D.4. Restrictions on Views">Section D.4, “Restrictions on Views”</a></dt><dt><a href="information-schema.html#column-privileges-table" title="20.8. The INFORMATION_SCHEMA COLUMN_PRIVILEGES Table">Section 20.8, “The <code class="literal">INFORMATION_SCHEMA COLUMN_PRIVILEGES</code> Table”</a></dt><dt><a href="information-schema.html#table-privileges-table" title="20.7. The INFORMATION_SCHEMA TABLE_PRIVILEGES Table">Section 20.7, “The <code class="literal">INFORMATION_SCHEMA TABLE_PRIVILEGES</code> Table”</a></dt><dt><a href="storage-engines.html#merge-storage-engine" title="13.8. The MERGE Storage Engine">Section 13.8, “The <code class="literal">MERGE</code> Storage Engine”</a></dt><dt><a href="server-administration.html#privilege-system" title="5.4. The MySQL Access Privilege System">Section 5.4, “The MySQL Access Privilege System”</a></dt><dt><a href="stored-programs-views.html#trigger-syntax" title="19.3.1. Trigger Syntax">Section 19.3.1, “Trigger Syntax”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">SHOW DATABASES</code></h3><dl><dt><a href="sql-syntax.html#grant" title="12.5.1.3. GRANT Syntax">Section 12.5.1.3, “<code class="literal">GRANT</code> Syntax”</a></dt><dt><a href="sql-syntax.html#show-databases" title="12.5.5.15. SHOW DATABASES Syntax">Section 12.5.5.15, “<code class="literal">SHOW DATABASES</code> Syntax”</a></dt><dt><a href="server-administration.html#privileges-provided" title="5.4.1. Privileges Provided by MySQL">Section 5.4.1, “Privileges Provided by MySQL”</a></dt><dt><a href="server-administration.html#privileges-options" title="5.3.3. Security-Related mysqld Options">Section 5.3.3, “Security-Related <span><strong class="command">mysqld</strong></span> Options”</a></dt><dt><a href="server-administration.html#server-options" title="5.1.2. Server Command Options">Section 5.1.2, “Server Command Options”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">SHOW VIEW</code></h3><dl><dt><a href="sql-syntax.html#grant" title="12.5.1.3. GRANT Syntax">Section 12.5.1.3, “<code class="literal">GRANT</code> Syntax”</a></dt><dt><a href="sql-syntax.html#show-create-view" title="12.5.5.14. SHOW CREATE VIEW Syntax">Section 12.5.5.14, “<code class="literal">SHOW CREATE VIEW</code> Syntax”</a></dt><dt><a href="server-administration.html#privileges-provided" title="5.4.1. Privileges Provided by MySQL">Section 5.4.1, “Privileges Provided by MySQL”</a></dt><dt><a href="restrictions.html#view-restrictions" title="D.4. Restrictions on Views">Section D.4, “Restrictions on Views”</a></dt><dt><a href="information-schema.html#views-table" title="20.15. The INFORMATION_SCHEMA VIEWS Table">Section 20.15, “The <code class="literal">INFORMATION_SCHEMA VIEWS</code> Table”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">SHUTDOWN</code></h3><dl><dt><a href="sql-syntax.html#grant" title="12.5.1.3. GRANT Syntax">Section 12.5.1.3, “<code class="literal">GRANT</code> Syntax”</a></dt><dt><a href="connectors-apis.html#mysql-shutdown" title="21.9.3.65. mysql_shutdown()">Section 21.9.3.65, “<code class="literal">mysql_shutdown()</code>”</a></dt><dt><a href="server-administration.html#request-access" title="5.4.5. Access Control, Stage 2: Request Verification">Section 5.4.5, “Access Control, Stage 2: Request Verification”</a></dt><dt><a href="http://dev.mysql.com/doc/refman/5.1/en/mysqld-multi-description.html" target="_top">Description</a></dt><dt><a href="server-administration.html#grant-table-structure" title="5.4.2. Privilege System Grant Tables">Section 5.4.2, “Privilege System Grant Tables”</a></dt><dt><a href="server-administration.html#privileges-provided" title="5.4.1. Privileges Provided by MySQL">Section 5.4.1, “Privileges Provided by MySQL”</a></dt><dt><a href="server-administration.html#server-shutdown" title="5.1.11. The Shutdown Process">Section 5.1.11, “The Shutdown Process”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">SUPER</code></h3><dl><dt><a href="sql-syntax.html#alter-event" title="12.1.2. ALTER EVENT Syntax">Section 12.1.2, “<code class="literal">ALTER EVENT</code> Syntax”</a></dt><dt><a href="sql-syntax.html#alter-function" title="12.1.4. ALTER FUNCTION Syntax">Section 12.1.4, “<code class="literal">ALTER FUNCTION</code> Syntax”</a></dt><dt><a href="sql-syntax.html#alter-server" title="12.1.6. ALTER SERVER Syntax">Section 12.1.6, “<code class="literal">ALTER SERVER</code> Syntax”</a></dt><dt><a href="sql-syntax.html#alter-view" title="12.1.9. ALTER VIEW Syntax">Section 12.1.9, “<code class="literal">ALTER VIEW</code> Syntax”</a></dt><dt><a href="sql-syntax.html#binlog" title="12.5.6.1. BINLOG Syntax">Section 12.5.6.1, “<code class="literal">BINLOG</code> Syntax”</a></dt><dt><a href="sql-syntax.html#create-event" title="12.1.11. CREATE EVENT Syntax">Section 12.1.11, “<code class="literal">CREATE EVENT</code> Syntax”</a></dt><dt><a href="sql-syntax.html#create-procedure" title="12.1.15. CREATE PROCEDURE and
CREATE FUNCTION Syntax">Section 12.1.15, “<code class="literal">CREATE PROCEDURE</code> and
<code class="literal">CREATE FUNCTION</code> Syntax”</a></dt><dt><a href="sql-syntax.html#create-server" title="12.1.16. CREATE SERVER Syntax">Section 12.1.16, “<code class="literal">CREATE SERVER</code> Syntax”</a></dt><dt><a href="sql-syntax.html#create-trigger" title="12.1.19. CREATE TRIGGER Syntax">Section 12.1.19, “<code class="literal">CREATE TRIGGER</code> Syntax”</a></dt><dt><a href="sql-syntax.html#create-view" title="12.1.20. CREATE VIEW Syntax">Section 12.1.20, “<code class="literal">CREATE VIEW</code> Syntax”</a></dt><dt><a href="sql-syntax.html#drop-event" title="12.1.22. DROP EVENT Syntax">Section 12.1.22, “<code class="literal">DROP EVENT</code> Syntax”</a></dt><dt><a href="sql-syntax.html#drop-server" title="12.1.27. DROP SERVER Syntax">Section 12.1.27, “<code class="literal">DROP SERVER</code> Syntax”</a></dt><dt><a href="sql-syntax.html#drop-trigger" title="12.1.30. DROP TRIGGER Syntax">Section 12.1.30, “<code class="literal">DROP TRIGGER</code> Syntax”</a></dt><dt><a href="sql-syntax.html#grant" title="12.5.1.3. GRANT Syntax">Section 12.5.1.3, “<code class="literal">GRANT</code> Syntax”</a></dt><dt><a href="sql-syntax.html#kill" title="12.5.6.4. KILL Syntax">Section 12.5.6.4, “<code class="literal">KILL</code> Syntax”</a></dt><dt><a href="sql-syntax.html#load-data-from-master" title="12.6.2.2. LOAD DATA FROM MASTER Syntax">Section 12.6.2.2, “<code class="literal">LOAD DATA FROM MASTER</code> Syntax”</a></dt><dt><a href="sql-syntax.html#load-table-from-master" title="12.6.2.3. LOAD TABLE tbl_name FROM
MASTER Syntax">Section 12.6.2.3, “<code class="literal">LOAD TABLE <em class="replaceable"><code>tbl_name</code></em> FROM
MASTER</code> Syntax”</a></dt><dt><a href="sql-syntax.html#set-transaction" title="12.4.6. SET TRANSACTION Syntax">Section 12.4.6, “<code class="literal">SET TRANSACTION</code> Syntax”</a></dt><dt><a href="sql-syntax.html#set-sql-log-bin" title="12.6.1.3. SET sql_log_bin Syntax">Section 12.6.1.3, “<code class="literal">SET sql_log_bin</code> Syntax”</a></dt><dt><a href="sql-syntax.html#set-option" title="12.5.4. SET Syntax">Section 12.5.4, “<code class="literal">SET</code> Syntax”</a></dt><dt><a href="sql-syntax.html#show-master-status" title="12.5.5.25. SHOW MASTER STATUS Syntax">Section 12.5.5.25, “<code class="literal">SHOW MASTER STATUS</code> Syntax”</a></dt><dt><a href="sql-syntax.html#show-processlist" title="12.5.5.31. SHOW PROCESSLIST Syntax">Section 12.5.5.31, “<code class="literal">SHOW PROCESSLIST</code> Syntax”</a></dt><dt><a href="sql-syntax.html#show-slave-status" title="12.5.5.36. SHOW SLAVE STATUS Syntax">Section 12.5.5.36, “<code class="literal">SHOW SLAVE STATUS</code> Syntax”</a></dt><dt><a href="sql-syntax.html#show-triggers" title="12.5.5.40. SHOW TRIGGERS Syntax">Section 12.5.5.40, “<code class="literal">SHOW TRIGGERS</code> Syntax”</a></dt><dt><a href="sql-syntax.html#start-slave" title="12.6.2.7. START SLAVE Syntax">Section 12.6.2.7, “<code class="literal">START SLAVE</code> Syntax”</a></dt><dt><a href="sql-syntax.html#stop-slave" title="12.6.2.8. STOP SLAVE Syntax">Section 12.6.2.8, “<code class="literal">STOP SLAVE</code> Syntax”</a></dt><dt><a href="error-handling.html#too-many-connections" title="B.1.2.7. Too many connections">Section B.1.2.7, “<code class="literal">Too many connections</code>”</a></dt><dt><a href="connectors-apis.html#mysql-dump-debug-info" title="21.9.3.12. mysql_dump_debug_info()">Section 21.9.3.12, “<code class="literal">mysql_dump_debug_info()</code>”</a></dt><dt><a href="replication.html#replication-options-binary-log" title="16.1.3.4. Binary Log Options and Variables">Section 16.1.3.4, “Binary Log Options and Variables”</a></dt><dt><a href="stored-programs-views.html#stored-programs-logging" title="19.6. Binary Logging of Stored Programs">Section 19.6, “Binary Logging of Stored Programs”</a></dt><dt><a href="internationalization-localization.html#charset-applications" title="9.1.5. Configuring the Character Set and Collation for Applications">Section 9.1.5, “Configuring the Character Set and Collation for Applications”</a></dt><dt><a href="http://dev.mysql.com/doc/refman/5.1/en/mysqlbinlog-description.html" target="_top">Description</a></dt><dt><a href="functions.html#encryption-functions" title="11.11.2. Encryption and Compression Functions">Section 11.11.2, “Encryption and Compression Functions”</a></dt><dt><a href="functions.html#fulltext-fine-tuning" title="11.8.6. Fine-Tuning MySQL Full-Text Search">Section 11.8.6, “Fine-Tuning MySQL Full-Text Search”</a></dt><dt><a href="replication.html#replication-howto" title="16.1.1. How to Set Up Replication">Section 16.1.1, “How to Set Up Replication”</a></dt><dt><a href="server-administration.html#security-against-attack" title="5.3.2. Making MySQL Secure Against Attackers">Section 5.3.2, “Making MySQL Secure Against Attackers”</a></dt><dt><a href="internationalization-localization.html#locale-support" title="9.8. MySQL Server Locale Support">Section 9.8, “MySQL Server Locale Support”</a></dt><dt><a href="internationalization-localization.html#time-zone-support" title="9.7. MySQL Server Time Zone Support">Section 9.7, “MySQL Server Time Zone Support”</a></dt><dt><a href="server-administration.html#privileges-provided" title="5.4.1. Privileges Provided by MySQL">Section 5.4.1, “Privileges Provided by MySQL”</a></dt><dt><a href="replication.html#replication-options-slave" title="16.1.3.3. Replication Slave Options and Variables">Section 16.1.3.3, “Replication Slave Options and Variables”</a></dt><dt><a href="server-administration.html#server-sql-mode" title="5.1.8. Server SQL Modes">Section 5.1.8, “Server SQL Modes”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt><dt><a href="server-administration.html#server-session-variables" title="5.1.5. Session System Variables">Section 5.1.5, “Session System Variables”</a></dt><dt><a href="server-administration.html#binary-log-setting" title="5.2.4.2. Setting The Binary Log Format">Section 5.2.4.2, “Setting The Binary Log Format”</a></dt><dt><a href="information-schema.html#triggers-table" title="20.16. The INFORMATION_SCHEMA TRIGGERS Table">Section 20.16, “The <code class="literal">INFORMATION_SCHEMA TRIGGERS</code> Table”</a></dt><dt><a href="server-administration.html#binary-log" title="5.2.4. The Binary Log">Section 5.2.4, “The Binary Log”</a></dt><dt><a href="installing.html#upgrading-from-previous-series" title="2.4.1.1. Upgrading from MySQL 5.0 to 5.1">Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”</a></dt><dt><a href="server-administration.html#using-system-variables" title="5.1.6. Using System Variables">Section 5.1.6, “Using System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">TRIGGER</code></h3><dl><dt><a href="sql-syntax.html#create-trigger" title="12.1.19. CREATE TRIGGER Syntax">Section 12.1.19, “<code class="literal">CREATE TRIGGER</code> Syntax”</a></dt><dt><a href="sql-syntax.html#drop-trigger" title="12.1.30. DROP TRIGGER Syntax">Section 12.1.30, “<code class="literal">DROP TRIGGER</code> Syntax”</a></dt><dt><a href="sql-syntax.html#grant" title="12.5.1.3. GRANT Syntax">Section 12.5.1.3, “<code class="literal">GRANT</code> Syntax”</a></dt><dt><a href="sql-syntax.html#show-triggers" title="12.5.5.40. SHOW TRIGGERS Syntax">Section 12.5.5.40, “<code class="literal">SHOW TRIGGERS</code> Syntax”</a></dt><dt><a href="server-administration.html#privileges-provided" title="5.4.1. Privileges Provided by MySQL">Section 5.4.1, “Privileges Provided by MySQL”</a></dt><dt><a href="information-schema.html#triggers-table" title="20.16. The INFORMATION_SCHEMA TRIGGERS Table">Section 20.16, “The <code class="literal">INFORMATION_SCHEMA TRIGGERS</code> Table”</a></dt><dt><a href="installing.html#upgrading-from-previous-series" title="2.4.1.1. Upgrading from MySQL 5.0 to 5.1">Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">UPDATE</code></h3><dl><dt><a href="sql-syntax.html#create-table" title="12.1.17. CREATE TABLE Syntax">Section 12.1.17, “<code class="literal">CREATE TABLE</code> Syntax”</a></dt><dt><a href="sql-syntax.html#create-trigger" title="12.1.19. CREATE TRIGGER Syntax">Section 12.1.19, “<code class="literal">CREATE TRIGGER</code> Syntax”</a></dt><dt><a href="sql-syntax.html#grant" title="12.5.1.3. GRANT Syntax">Section 12.5.1.3, “<code class="literal">GRANT</code> Syntax”</a></dt><dt><a href="sql-syntax.html#insert" title="12.2.5. INSERT Syntax">Section 12.2.5, “<code class="literal">INSERT</code> Syntax”</a></dt><dt><a href="sql-syntax.html#lock-tables" title="12.4.5. LOCK TABLES and
UNLOCK
TABLES Syntax">Section 12.4.5, “<code class="literal">LOCK TABLES</code> and
<code class="literal">UNLOCK
TABLES</code> Syntax”</a></dt><dt><a href="sql-syntax.html#rename-user" title="12.5.1.4. RENAME USER Syntax">Section 12.5.1.4, “<code class="literal">RENAME USER</code> Syntax”</a></dt><dt><a href="sql-syntax.html#revoke" title="12.5.1.5. REVOKE Syntax">Section 12.5.1.5, “<code class="literal">REVOKE</code> Syntax”</a></dt><dt><a href="sql-syntax.html#update" title="12.2.11. UPDATE Syntax">Section 12.2.11, “<code class="literal">UPDATE</code> Syntax”</a></dt><dt><a href="mysql-cluster.html#mysql-cluster-security-mysql-privileges" title="17.5.8.2. MySQL Cluster and MySQL Privileges">Section 17.5.8.2, “MySQL Cluster and MySQL Privileges”</a></dt><dt><a href="server-administration.html#privileges-provided" title="5.4.1. Privileges Provided by MySQL">Section 5.4.1, “Privileges Provided by MySQL”</a></dt><dt><a href="information-schema.html#column-privileges-table" title="20.8. The INFORMATION_SCHEMA COLUMN_PRIVILEGES Table">Section 20.8, “The <code class="literal">INFORMATION_SCHEMA COLUMN_PRIVILEGES</code> Table”</a></dt><dt><a href="information-schema.html#table-privileges-table" title="20.7. The INFORMATION_SCHEMA TABLE_PRIVILEGES Table">Section 20.7, “The <code class="literal">INFORMATION_SCHEMA TABLE_PRIVILEGES</code> Table”</a></dt><dt><a href="storage-engines.html#merge-storage-engine" title="13.8. The MERGE Storage Engine">Section 13.8, “The <code class="literal">MERGE</code> Storage Engine”</a></dt><dt><a href="stored-programs-views.html#trigger-syntax" title="19.3.1. Trigger Syntax">Section 19.3.1, “Trigger Syntax”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">USAGE</code></h3><dl><dt><a href="sql-syntax.html#grant" title="12.5.1.3. GRANT Syntax">Section 12.5.1.3, “<code class="literal">GRANT</code> Syntax”</a></dt><dt><a href="server-administration.html#adding-users" title="5.5.2. Adding User Accounts">Section 5.5.2, “Adding User Accounts”</a></dt><dt><a href="server-administration.html#privileges-provided" title="5.4.1. Privileges Provided by MySQL">Section 5.4.1, “Privileges Provided by MySQL”</a></dt></dl></div></div><div class="navfooter"><hr><table width="100%" summary="Navigation footer"><tr><td width="40%" align="left"><a accesskey="p" href="dynindex-option.html">Prev</a> </td><td width="20%" align="center"> </td><td width="40%" align="right"> <a accesskey="n" href="dynindex-sqlmode.html">Next</a></td></tr><tr><td width="40%" align="left" valign="top">Option Index </td><td width="20%" align="center"><a accesskey="h" href="index.html">Home</a></td><td width="40%" align="right" valign="top"> SQL Modes Index</td></tr></table></div></body></html>
