The world's most popular open source database
MySQL 5.6 Reference Manual :: 13 SQL Statement Syntax
Section Navigation [Toggle]
- Preface and Legal Notices
- 1 General Information
- 2 Installing and Upgrading MySQL
- 3 Tutorial
- 4 MySQL Programs
- 5 MySQL Server Administration
- 6 Security
- 7 Backup and Recovery
- 8 Optimization
- 9 Language Structure
- 10 Globalization
- 11 Data Types
- 12 Functions and Operators
- 13 SQL Statement Syntax
- 14 The InnoDB Storage Engine
- 15 Alternative Storage Engines
- 16 High Availability and Scalability
- 17 Replication
- 18 MySQL Cluster NDB 7.3 and MySQL Cluster NDB 7.4
- 19 Partitioning
- 20 Stored Programs and Views
- 21 INFORMATION_SCHEMA Tables
- 22 MySQL Performance Schema
- 23 Connectors and APIs
- 24 Extending MySQL
- 25 MySQL Enterprise Edition
- 26 MySQL Workbench
- A MySQL 5.6 Frequently Asked Questions
- B Errors, Error Codes, and Common Problems
- C MySQL Release Notes
- D Restrictions and Limits
- MySQL Glossary
- E Licenses for Third-Party Components
- General Index
- C Function Index
- Command Index
- Function Index
- INFORMATION_SCHEMA Index
- Join Types Index
- Operator Index
- Option Index
- Privileges Index
- SQL Modes Index
- Statement/Syntax Index
- Status Variable Index
- System Variable Index
Table of Contents [+/-]
- 13.1 Data Definition Statements [+/-]
- 13.1.1 ALTER DATABASE Syntax
- 13.1.2 ALTER EVENT Syntax
- 13.1.3 ALTER LOGFILE GROUP Syntax
- 13.1.4 ALTER FUNCTION Syntax
- 13.1.5 ALTER PROCEDURE Syntax
- 13.1.6 ALTER SERVER Syntax
- 13.1.7 ALTER TABLE Syntax
- 13.1.8 ALTER TABLESPACE Syntax
- 13.1.9 ALTER VIEW Syntax
- 13.1.10 CREATE DATABASE Syntax
- 13.1.11 CREATE EVENT Syntax
- 13.1.12 CREATE FUNCTION Syntax
- 13.1.13 CREATE INDEX Syntax
- 13.1.14 CREATE LOGFILE GROUP Syntax
- 13.1.15 CREATE PROCEDURE and CREATE FUNCTION Syntax
- 13.1.16 CREATE SERVER Syntax
- 13.1.17 CREATE TABLE Syntax
- 13.1.18 CREATE TABLESPACE Syntax
- 13.1.19 CREATE TRIGGER Syntax
- 13.1.20 CREATE VIEW Syntax
- 13.1.21 DROP DATABASE Syntax
- 13.1.22 DROP EVENT Syntax
- 13.1.23 DROP FUNCTION Syntax
- 13.1.24 DROP INDEX Syntax
- 13.1.25 DROP LOGFILE GROUP Syntax
- 13.1.26 DROP PROCEDURE and DROP FUNCTION Syntax
- 13.1.27 DROP SERVER Syntax
- 13.1.28 DROP TABLE Syntax
- 13.1.29 DROP TABLESPACE Syntax
- 13.1.30 DROP TRIGGER Syntax
- 13.1.31 DROP VIEW Syntax
- 13.1.32 RENAME TABLE Syntax
- 13.1.33 TRUNCATE TABLE Syntax
- 13.2 Data Manipulation Statements [+/-]
- 13.3 MySQL Transactional and Locking Statements [+/-]
- 13.3.1 START TRANSACTION, COMMIT, and ROLLBACK Syntax
- 13.3.2 Statements That Cannot Be Rolled Back
- 13.3.3 Statements That Cause an Implicit Commit
- 13.3.4 SAVEPOINT, ROLLBACK TO SAVEPOINT, and RELEASE SAVEPOINT Syntax
- 13.3.5 LOCK TABLES and UNLOCK TABLES Syntax
- 13.3.6 SET TRANSACTION Syntax
- 13.3.7 XA Transactions
- 13.4 Replication Statements [+/-]
- 13.5 SQL Syntax for Prepared Statements [+/-]
- 13.6 MySQL Compound-Statement Syntax [+/-]
- 13.7 Database Administration Statements [+/-]
- 13.8 MySQL Utility Statements [+/-]
This chapter describes the syntax for the SQL statements supported by MySQL.
User Comments