Chapter 12. SQL Statement Syntax

Table of Contents

12.1. Data Definition Statements
12.1.1. ALTER DATABASE Syntax
12.1.2. ALTER EVENT Syntax
12.1.3. ALTER FUNCTION Syntax
12.1.4. ALTER PROCEDURE Syntax
12.1.5. ALTER SERVER Syntax
12.1.6. ALTER TABLE Syntax
12.1.7. ALTER VIEW Syntax
12.1.8. CREATE DATABASE Syntax
12.1.9. CREATE EVENT Syntax
12.1.10. The CREATE FUNCTION Statement
12.1.11. CREATE INDEX Syntax
12.1.12. CREATE PROCEDURE and CREATE FUNCTION Syntax
12.1.13. CREATE SERVER Syntax
12.1.14. CREATE TABLE Syntax
12.1.15. CREATE TRIGGER Syntax
12.1.16. CREATE VIEW Syntax
12.1.17. DROP DATABASE Syntax
12.1.18. DROP EVENT Syntax
12.1.19. DROP FUNCTION Syntax
12.1.20. DROP INDEX Syntax
12.1.21. DROP PROCEDURE and DROP FUNCTION Syntax
12.1.22. DROP SERVER Syntax
12.1.23. DROP TABLE Syntax
12.1.24. DROP TRIGGER Syntax
12.1.25. DROP VIEW Syntax
12.1.26. RENAME TABLE Syntax
12.1.27. TRUNCATE TABLE Syntax
12.2. Data Manipulation Statements
12.2.1. CALL Syntax
12.2.2. DELETE Syntax
12.2.3. DO Syntax
12.2.4. HANDLER Syntax
12.2.5. INSERT Syntax
12.2.6. LOAD DATA INFILE Syntax
12.2.7. LOAD XML Syntax
12.2.8. REPLACE Syntax
12.2.9. SELECT Syntax
12.2.10. Subquery Syntax
12.2.11. 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.3.7. XA Transactions
12.4. Database Administration Statements
12.4.1. Account Management Statements
12.4.2. Table Maintenance Statements
12.4.3. Plugin and 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.6.4. Automatic Prepared Statement Repreparation
12.7. MySQL Compound-Statement Syntax
12.7.1. BEGIN ... END Compound Statement Syntax
12.7.2. DECLARE Syntax
12.7.3. Variables in Stored Programs
12.7.4. Conditions and Handlers
12.7.5. Cursors
12.7.6. Flow Control Constructs
12.7.7. RETURN Syntax
12.7.8. SIGNAL and RESIGNAL
12.8. MySQL Utility Statements
12.8.1. DESCRIBE Syntax
12.8.2. EXPLAIN Syntax
12.8.3. HELP Syntax
12.8.4. USE Syntax

This chapter describes the syntax for the SQL statements supported by MySQL.

Copyright © 2010-2017 Platon Technologies, s.r.o.           Home | Man pages | tLDP | Documents | Utilities | About
Design by styleshout