MySQL 5.1 Reference Manual :: 12 SQL Statement Syntax
Section Navigation [Toggle]
- Preface, Notes, Licenses
- 1 General Information
- 2 Installing and Upgrading MySQL
- 3 Tutorial
- 4 MySQL Programs
- 5 MySQL Server Administration
- 6 Backup and Recovery
- 7 Optimization
- 8 Language Structure
- 9 Internationalization and Localization
- 10 Data Types
- 11 Functions and Operators
- 12 SQL Statement Syntax
- 13 Storage Engines
- 14 High Availability and Scalability
- 15 MySQL Enterprise Monitor
- 16 Replication
- 17 MySQL Cluster NDB 6.X/7.X
- 18 Partitioning
- 19 Stored Programs and Views
- 20 INFORMATION_SCHEMA Tables
- 21 Connectors and APIs
- 22 Extending MySQL
- A MySQL 5.1 Frequently Asked Questions
- B Errors, Error Codes, and Common Problems
- C MySQL Change History
- D Restrictions and Limits
- Index
- Standard Index
- C Function Index
- Command Index
- Function Index
- INFORMATION_SCHEMA Index
- Transaction Isolation Level Index
- JOIN Types Index
- Operator Index
- Option Index
- Privileges Index
- SQL Modes Index
- Status Variable Index
- Statement/Syntax Index
- System Variable Index
Table of Contents [+/-]
- 12.1. Data Definition Statements [+/-]
- 12.1.1.
ALTER DATABASESyntax - 12.1.2.
ALTER EVENTSyntax - 12.1.3.
ALTER LOGFILE GROUPSyntax - 12.1.4.
ALTER FUNCTIONSyntax - 12.1.5.
ALTER PROCEDURESyntax - 12.1.6.
ALTER SERVERSyntax - 12.1.7.
ALTER TABLESyntax - 12.1.8.
ALTER TABLESPACESyntax - 12.1.9.
ALTER VIEWSyntax - 12.1.10.
CREATE DATABASESyntax - 12.1.11.
CREATE EVENTSyntax - 12.1.12.
CREATE FUNCTIONSyntax - 12.1.13.
CREATE INDEXSyntax - 12.1.14.
CREATE LOGFILE GROUPSyntax - 12.1.15.
CREATE PROCEDUREandCREATE FUNCTIONSyntax - 12.1.16.
CREATE SERVERSyntax - 12.1.17.
CREATE TABLESyntax - 12.1.18.
CREATE TABLESPACESyntax - 12.1.19.
CREATE TRIGGERSyntax - 12.1.20.
CREATE VIEWSyntax - 12.1.21.
DROP DATABASESyntax - 12.1.22.
DROP EVENTSyntax - 12.1.23.
DROP FUNCTIONSyntax - 12.1.24.
DROP INDEXSyntax - 12.1.25.
DROP LOGFILE GROUPSyntax - 12.1.26.
DROP PROCEDUREandDROP FUNCTIONSyntax - 12.1.27.
DROP SERVERSyntax - 12.1.28.
DROP TABLESyntax - 12.1.29.
DROP TABLESPACESyntax - 12.1.30.
DROP TRIGGERSyntax - 12.1.31.
DROP VIEWSyntax - 12.1.32.
RENAME DATABASESyntax - 12.1.33.
RENAME TABLESyntax
- 12.1.1.
- 12.2. Data Manipulation Statements [+/-]
- 12.3. MySQL Transactional and Locking Statements [+/-]
- 12.3.1.
START TRANSACTION,COMMIT, andROLLBACKSyntax - 12.3.2. Statements That Cannot Be Rolled Back
- 12.3.3. Statements That Cause an Implicit Commit
- 12.3.4.
SAVEPOINTandROLLBACK TO SAVEPOINTSyntax - 12.3.5.
LOCK TABLESandUNLOCK TABLESSyntax - 12.3.6.
SET TRANSACTIONSyntax - 12.3.7. XA Transactions
- 12.3.1.
- 12.4. Database Administration Statements [+/-]
- 12.5. Replication Statements [+/-]
- 12.6. SQL Syntax for Prepared Statements [+/-]
- 12.7. MySQL Compound-Statement Syntax [+/-]
- 12.8. MySQL Utility Statements [+/-]
This chapter describes the syntax for the SQL statements supported by MySQL.
User Comments
Add your own comment.