- Documentation Library
- Table of Contents
- MySQL 6.0 Reference Manual
- MySQL 5.1 Reference Manual
- MySQL 5.0 Reference Manual
- MySQL 3.23/4.0/4.1 Manual
- Table of Contents
MySQL 5.0 Reference Manual :: 12 SQL Statement Syntax
Section Navigation [Toggle]
- Preface
- 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 Using MySQL with memcached
- 16 MySQL Proxy
- 17 MySQL Load Balancer
- 18 Replication
- 19 MySQL Cluster
- 20 Spatial Extensions
- 21 Stored Procedures and Functions
- 22 Triggers
- 23 Views
- 24 INFORMATION_SCHEMA Tables
- 25 Precision Math
- 26 APIs and Libraries
- 27 Connectors
- 28 Extending MySQL
- A MySQL 5.0 Frequently Asked Questions
- B Errors, Error Codes, and Common Problems
- C MySQL Enterprise Release Notes
- D MySQL Community Server Enhancements and Release Notes
- E MySQL Change History
- F Restrictions and Limits
- G Credits
- Index
Table of Contents [+/-]
- 12.1. Data Definition Statements [+/-]
- 12.2. Data Manipulation Statements [+/-]
- 12.3. MySQL Utility Statements [+/-]
- 12.4. MySQL Transactional and Locking Statements [+/-]
- 12.4.1.
START TRANSACTION,COMMIT, andROLLBACKSyntax - 12.4.2. Statements That Cannot Be Rolled Back
- 12.4.3. Statements That Cause an Implicit Commit
- 12.4.4.
SAVEPOINTandROLLBACK TO SAVEPOINTSyntax - 12.4.5.
LOCK TABLESandUNLOCK TABLESSyntax - 12.4.6.
SET TRANSACTIONSyntax - 12.4.7. XA Transactions
- 12.4.1.
- 12.5. Database Administration Statements [+/-]
- 12.6. Replication Statements [+/-]
- 12.7. SQL Syntax for Prepared Statements
This chapter describes the syntax for most of the SQL statements supported by MySQL. Additional statement descriptions can be found in the following chapters:
Statements for writing stored routines are covered in Chapter 21, Stored Procedures and Functions.
Statements for writing triggers are covered in Chapter 22, Triggers.
View-related statements are covered in Chapter 23, Views.
© 1995-2008 MySQL AB. All rights reserved.
User Comments
Add your own comment.