<div id="docs-body">
 <div class="chapter">
  <div class="titlepage">
   <div>
    <div>
     <h1 class="title">
      <a name="sql-statements">
      </a>
      Chapter 15 SQL Statements
     </h1>
    </div>
   </div>
  </div>
  <div class="toc">
   <p>
    <b>
     Table of Contents
    </b>
   </p>
   <dl class="toc">
    <dt>
     <span class="section">
      <a href="sql-data-definition-statements.html">
       15.1 Data Definition Statements
      </a>
     </span>
    </dt>
    <dd>
     <dl>
      <dt>
       <span class="section">
        <a href="atomic-ddl.html">
         15.1.1 Atomic Data Definition Statement Support
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="alter-database.html">
         15.1.2 ALTER DATABASE Statement
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="alter-event.html">
         15.1.3 ALTER EVENT Statement
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="alter-function.html">
         15.1.4 ALTER FUNCTION Statement
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="alter-instance.html">
         15.1.5 ALTER INSTANCE Statement
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="alter-logfile-group.html">
         15.1.6 ALTER LOGFILE GROUP Statement
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="alter-procedure.html">
         15.1.7 ALTER PROCEDURE Statement
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="alter-server.html">
         15.1.8 ALTER SERVER Statement
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="alter-table.html">
         15.1.9 ALTER TABLE Statement
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="alter-tablespace.html">
         15.1.10 ALTER TABLESPACE Statement
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="alter-view.html">
         15.1.11 ALTER VIEW Statement
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="create-database.html">
         15.1.12 CREATE DATABASE Statement
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="create-event.html">
         15.1.13 CREATE EVENT Statement
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="create-function.html">
         15.1.14 CREATE FUNCTION Statement
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="create-index.html">
         15.1.15 CREATE INDEX Statement
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="create-logfile-group.html">
         15.1.16 CREATE LOGFILE GROUP Statement
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="create-procedure.html">
         15.1.17 CREATE PROCEDURE and CREATE FUNCTION Statements
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="create-server.html">
         15.1.18 CREATE SERVER Statement
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="create-spatial-reference-system.html">
         15.1.19 CREATE SPATIAL REFERENCE SYSTEM Statement
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="create-table.html">
         15.1.20 CREATE TABLE Statement
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="create-tablespace.html">
         15.1.21 CREATE TABLESPACE Statement
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="create-trigger.html">
         15.1.22 CREATE TRIGGER Statement
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="create-view.html">
         15.1.23 CREATE VIEW Statement
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="drop-database.html">
         15.1.24 DROP DATABASE Statement
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="drop-event.html">
         15.1.25 DROP EVENT Statement
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="drop-function.html">
         15.1.26 DROP FUNCTION Statement
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="drop-index.html">
         15.1.27 DROP INDEX Statement
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="drop-logfile-group.html">
         15.1.28 DROP LOGFILE GROUP Statement
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="drop-procedure.html">
         15.1.29 DROP PROCEDURE and DROP FUNCTION Statements
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="drop-server.html">
         15.1.30 DROP SERVER Statement
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="drop-spatial-reference-system.html">
         15.1.31 DROP SPATIAL REFERENCE SYSTEM Statement
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="drop-table.html">
         15.1.32 DROP TABLE Statement
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="drop-tablespace.html">
         15.1.33 DROP TABLESPACE Statement
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="drop-trigger.html">
         15.1.34 DROP TRIGGER Statement
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="drop-view.html">
         15.1.35 DROP VIEW Statement
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="rename-table.html">
         15.1.36 RENAME TABLE Statement
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="truncate-table.html">
         15.1.37 TRUNCATE TABLE Statement
        </a>
       </span>
      </dt>
     </dl>
    </dd>
    <dt>
     <span class="section">
      <a href="sql-data-manipulation-statements.html">
       15.2 Data Manipulation Statements
      </a>
     </span>
    </dt>
    <dd>
     <dl>
      <dt>
       <span class="section">
        <a href="call.html">
         15.2.1 CALL Statement
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="delete.html">
         15.2.2 DELETE Statement
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="do.html">
         15.2.3 DO Statement
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="except.html">
         15.2.4 EXCEPT Clause
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="handler.html">
         15.2.5 HANDLER Statement
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="import-table.html">
         15.2.6 IMPORT TABLE Statement
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="insert.html">
         15.2.7 INSERT Statement
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="intersect.html">
         15.2.8 INTERSECT Clause
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="load-data.html">
         15.2.9 LOAD DATA Statement
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="load-xml.html">
         15.2.10 LOAD XML Statement
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="parenthesized-query-expressions.html">
         15.2.11 Parenthesized Query Expressions
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="replace.html">
         15.2.12 REPLACE Statement
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="select.html">
         15.2.13 SELECT Statement
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="set-operations.html">
         15.2.14 Set Operations with UNION, INTERSECT, and EXCEPT
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="subqueries.html">
         15.2.15 Subqueries
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="table.html">
         15.2.16 TABLE Statement
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="update.html">
         15.2.17 UPDATE Statement
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="union.html">
         15.2.18 UNION Clause
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="values.html">
         15.2.19 VALUES Statement
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="with.html">
         15.2.20 WITH (Common Table Expressions)
        </a>
       </span>
      </dt>
     </dl>
    </dd>
    <dt>
     <span class="section">
      <a href="sql-transactional-statements.html">
       15.3 Transactional and Locking Statements
      </a>
     </span>
    </dt>
    <dd>
     <dl>
      <dt>
       <span class="section">
        <a href="commit.html">
         15.3.1 START TRANSACTION, COMMIT, and ROLLBACK Statements
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="cannot-roll-back.html">
         15.3.2 Statements That Cannot Be Rolled Back
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="implicit-commit.html">
         15.3.3 Statements That Cause an Implicit Commit
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="savepoint.html">
         15.3.4 SAVEPOINT, ROLLBACK TO SAVEPOINT, and RELEASE SAVEPOINT Statements
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="lock-instance-for-backup.html">
         15.3.5 LOCK INSTANCE FOR BACKUP and UNLOCK INSTANCE Statements
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="lock-tables.html">
         15.3.6 LOCK TABLES and UNLOCK TABLES Statements
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="set-transaction.html">
         15.3.7 SET TRANSACTION Statement
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="xa.html">
         15.3.8 XA Transactions
        </a>
       </span>
      </dt>
     </dl>
    </dd>
    <dt>
     <span class="section">
      <a href="sql-replication-statements.html">
       15.4 Replication Statements
      </a>
     </span>
    </dt>
    <dd>
     <dl>
      <dt>
       <span class="section">
        <a href="replication-statements-source.html">
         15.4.1 SQL Statements for Controlling Source Servers
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="replication-statements-replica.html">
         15.4.2 SQL Statements for Controlling Replica Servers
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="replication-statements-group.html">
         15.4.3 SQL Statements for Controlling Group Replication
        </a>
       </span>
      </dt>
     </dl>
    </dd>
    <dt>
     <span class="section">
      <a href="sql-prepared-statements.html">
       15.5 Prepared Statements
      </a>
     </span>
    </dt>
    <dd>
     <dl>
      <dt>
       <span class="section">
        <a href="prepare.html">
         15.5.1 PREPARE Statement
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="execute.html">
         15.5.2 EXECUTE Statement
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="deallocate-prepare.html">
         15.5.3 DEALLOCATE PREPARE Statement
        </a>
       </span>
      </dt>
     </dl>
    </dd>
    <dt>
     <span class="section">
      <a href="sql-compound-statements.html">
       15.6 Compound Statement Syntax
      </a>
     </span>
    </dt>
    <dd>
     <dl>
      <dt>
       <span class="section">
        <a href="begin-end.html">
         15.6.1 BEGIN ... END Compound Statement
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="statement-labels.html">
         15.6.2 Statement Labels
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="declare.html">
         15.6.3 DECLARE Statement
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="stored-program-variables.html">
         15.6.4 Variables in Stored Programs
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="flow-control-statements.html">
         15.6.5 Flow Control Statements
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="cursors.html">
         15.6.6 Cursors
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="condition-handling.html">
         15.6.7 Condition Handling
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="condition-handling-restrictions.html">
         15.6.8 Restrictions on Condition Handling
        </a>
       </span>
      </dt>
     </dl>
    </dd>
    <dt>
     <span class="section">
      <a href="sql-server-administration-statements.html">
       15.7 Database Administration Statements
      </a>
     </span>
    </dt>
    <dd>
     <dl>
      <dt>
       <span class="section">
        <a href="account-management-statements.html">
         15.7.1 Account Management Statements
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="resource-group-statements.html">
         15.7.2 Resource Group Management Statements
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="table-maintenance-statements.html">
         15.7.3 Table Maintenance Statements
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="component-statements.html">
         15.7.4 Component, Plugin, and Loadable Function Statements
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="clone.html">
         15.7.5 CLONE Statement
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="set-statement.html">
         15.7.6 SET Statements
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="show.html">
         15.7.7 SHOW Statements
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="other-administrative-statements.html">
         15.7.8 Other Administrative Statements
        </a>
       </span>
      </dt>
     </dl>
    </dd>
    <dt>
     <span class="section">
      <a href="sql-utility-statements.html">
       15.8 Utility Statements
      </a>
     </span>
    </dt>
    <dd>
     <dl>
      <dt>
       <span class="section">
        <a href="describe.html">
         15.8.1 DESCRIBE Statement
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="explain.html">
         15.8.2 EXPLAIN Statement
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="help.html">
         15.8.3 HELP Statement
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="use.html">
         15.8.4 USE Statement
        </a>
       </span>
      </dt>
     </dl>
    </dd>
   </dl>
  </div>
  <p>
   This chapter describes the syntax for the
   <a class="link" href="glossary.html#glos_sql" title="SQL">
    SQL
   </a>
   statements supported by MySQL.
  </p>
 </div>
 <br/>
</div>
