Table of Contents     [+/-]

12.1. Data Definition Statements     [+/-]

12.1.1. ALTER DATABASE Syntax

12.1.2. ALTER TABLE Syntax

12.1.3. CREATE DATABASE Syntax

12.1.4. CREATE INDEX Syntax

12.1.5. CREATE TABLE Syntax

12.1.6. DROP DATABASE Syntax

12.1.7. DROP INDEX Syntax

12.1.8. DROP TABLE Syntax

12.1.9. RENAME TABLE Syntax

12.2. Data Manipulation Statements     [+/-]

12.2.1. DELETE Syntax

12.2.2. DO Syntax

12.2.3. HANDLER Syntax

12.2.4. INSERT Syntax

12.2.5. LOAD DATA INFILE Syntax

12.2.6. REPLACE Syntax

12.2.7. SELECT Syntax

12.2.8. Subquery Syntax

12.2.9. TRUNCATE TABLE Syntax

12.2.10. UPDATE Syntax

12.3. MySQL Transactional and Locking Statements     [+/-]

12.3.1. START TRANSACTION, COMMIT, and ROLLBACK Syntax

12.3.2. Statements That Cannot Be Rolled Back

12.3.3. Statements That Cause an Implicit Commit

12.3.4. SAVEPOINT and ROLLBACK TO SAVEPOINT Syntax

12.3.5. LOCK TABLES and UNLOCK TABLES Syntax

12.3.6. SET TRANSACTION Syntax

12.4. Database Administration Statements     [+/-]

12.4.1. Account Management Statements

12.4.2. Table Maintenance Statements

12.4.3. User-Defined Function Statements

12.4.4. SET Syntax

12.4.5. SHOW Syntax

12.4.6. Other Administrative Statements

12.5. Replication Statements     [+/-]

12.5.1. SQL Statements for Controlling Master Servers

12.5.2. SQL Statements for Controlling Slave Servers

12.6. SQL Syntax for Prepared Statements     [+/-]

12.6.1. PREPARE Syntax

12.6.2. EXECUTE Syntax

12.6.3. DEALLOCATE PREPARE Syntax

12.7. MySQL Utility Statements     [+/-]

12.7.1. DESCRIBE Syntax

12.7.2. EXPLAIN Syntax

12.7.3. HELP Syntax

12.7.4. USE Syntax