Skip navigation links

The world's most popular open source database

Contact MySQL | Login | Register

MySQL.com
Downloads
Documentation
Developer Zone

MySQL Server
MySQL Enterprise
Workbench
Utilities/Fabric
Cluster
Connectors
Topic Guides
Expert Guides
Other Docs
Archives
About

Documentation Library
- Table of Contents
  - MySQL 5.7 Manual
  - MySQL 5.6 Manual
  - MySQL 5.5 Manual
  - MySQL 5.1 Manual
  - MySQL 5.0 Manual
  - MySQL 3.23/4.0/4.1 Manual

Search manual:

MySQL 3.23, 4.0, 4.1 Reference Manual :: 12 SQL Statement Syntax

« 11.15.3 MySQL Handling of GROUP BY

12.1 Data Definition Statements »

Section Navigation [Toggle]

Preface and Legal Notice
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
- 12.1 Data Definition Statements
- 12.2 Data Manipulation Statements
- 12.3 MySQL Transactional and Locking Statements
- 12.4 Database Administration Statements
- 12.5 Replication Statements
- 12.6 SQL Syntax for Prepared Statements
- 12.7 MySQL Utility Statements
13 Storage Engines
14 Replication
15 MySQL Cluster
16 Spatial Extensions
17 Connectors and APIs
18 Extending MySQL
A Licenses for Third-Party Components
B Errors, Error Codes, and Common Problems
C MySQL Release Notes
D Restrictions and Limits
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

Chapter 12 SQL Statement Syntax

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.1.10 TRUNCATE 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 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

This chapter describes the syntax for the SQL statements supported in MySQL versions 4.1 and earlier.

Previous / Next / Up / Table of Contents

User Comments

Top / Previous / Next / Up / Table of Contents

Developer Zone
Developer Articles
Forums
Bugs
Worklog
Planet MySQL

Downloads
MySQL Community Server
MySQL Cluster
MySQL Fabric
MySQL Utilities
MySQL Workbench

Documentation
MySQL Reference Manuals
MySQL Workbench
Expert Guides
Topic Guides
MySQL Cluster

About MySQL
Contact Us
How to Buy
Partners
Job Opportunities
Site Map

Legal
Legal Policies
Your Privacy Rights
Terms of Use
Trademark Policy
Contributor Agreement

© 2015, Oracle Corporation and/or its affiliates