| CARVIEW |
Select Language
HTTP/2 302
server: nginx
date: Tue, 23 Dec 2025 04:05:24 GMT
content-type: text/plain; charset=utf-8
content-length: 0
x-archive-redirect-reason: found capture at 20090202131049
location: https://web.archive.org/web/20090202131049/https://dev.mysql.com/doc/refman/5.0/en/sql-syntax.html
server-timing: captures_list;dur=0.600396, exclusion.robots;dur=0.056138, exclusion.robots.policy;dur=0.046744, esindex;dur=0.010689, cdx.remote;dur=34.389881, LoadShardBlock;dur=180.184437, PetaboxLoader3.datanode;dur=88.766828
x-app-server: wwwb-app225-dc8
x-ts: 302
x-tr: 247
server-timing: TR;dur=0,Tw;dur=0,Tc;dur=0
set-cookie: wb-p-SERVER=wwwb-app225; path=/
x-location: All
x-as: 14061
x-rl: 0
x-na: 0
x-page-cache: MISS
server-timing: MISS
x-nid: DigitalOcean
referrer-policy: no-referrer-when-downgrade
permissions-policy: interest-cohort=()
HTTP/2 200
server: nginx
date: Tue, 23 Dec 2025 04:05:25 GMT
content-type: text/html
x-archive-orig-date: Mon, 02 Feb 2009 13:10:48 GMT
x-archive-orig-server: Apache/2.0.58 (Unix) mod_ssl/2.0.58 OpenSSL/0.9.7f
x-archive-orig-expires: Thu, 19 Nov 1981 08:52:00 GMT
x-archive-orig-cache-control: no-store, no-cache, must-revalidate, post-check=0, pre-check=0
x-archive-orig-pragma: no-cache
x-archive-orig-connection: close
x-archive-guessed-content-type: text/html
x-archive-guessed-charset: utf-8
memento-datetime: Mon, 02 Feb 2009 13:10:49 GMT
link: ; rel="original", ; rel="timemap"; type="application/link-format", ; rel="timegate"
content-security-policy: default-src 'self' 'unsafe-eval' 'unsafe-inline' data: blob: archive.org web.archive.org web-static.archive.org wayback-api.archive.org athena.archive.org analytics.archive.org pragma.archivelab.org wwwb-events.archive.org
x-archive-src: 51_8_20090202093816_crawl101-c/51_8_20090202130751_crawl103.arc.gz
server-timing: captures_list;dur=0.449721, exclusion.robots;dur=0.014943, exclusion.robots.policy;dur=0.006931, esindex;dur=0.008543, cdx.remote;dur=15.359674, LoadShardBlock;dur=138.118853, PetaboxLoader3.datanode;dur=126.011991, load_resource;dur=138.208308, PetaboxLoader3.resolve;dur=59.112618
x-app-server: wwwb-app225-dc8
x-ts: 200
x-tr: 354
server-timing: TR;dur=0,Tw;dur=0,Tc;dur=0
x-location: All
x-as: 14061
x-rl: 0
x-na: 0
x-page-cache: MISS
server-timing: MISS
x-nid: DigitalOcean
referrer-policy: no-referrer-when-downgrade
permissions-policy: interest-cohort=()
content-encoding: gzip
MySQL :: MySQL 5.0 Reference Manual :: 12 SQL Statement Syntax
Skip navigation links
Recommended Servers for MySQLThe world's most popular open source database
- 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 MySQL Enterprise Monitor
- 16 Replication
- 17 MySQL Cluster
- 18 Stored Programs and Views
- 19 INFORMATION_SCHEMA Tables
- 20 Connectors and APIs
- 21 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
- Index
Table of Contents [+/-]
- 12.1. Data Definition Statements [+/-]
- 12.1.1.
ALTER DATABASESyntax - 12.1.2.
ALTER FUNCTIONSyntax - 12.1.3.
ALTER PROCEDURESyntax - 12.1.4.
ALTER TABLESyntax - 12.1.5.
ALTER VIEWSyntax - 12.1.6.
CREATE DATABASESyntax - 12.1.7.
CREATE FUNCTIONSyntax - 12.1.8.
CREATE INDEXSyntax - 12.1.9.
CREATE PROCEDUREandCREATE FUNCTIONSyntax - 12.1.10.
CREATE TABLESyntax - 12.1.11.
CREATE TRIGGERSyntax - 12.1.12.
CREATE VIEWSyntax - 12.1.13.
DROP DATABASESyntax - 12.1.14.
DROP FUNCTIONSyntax - 12.1.15.
DROP INDEXSyntax - 12.1.16.
DROP PROCEDUREandDROP FUNCTIONSyntax - 12.1.17.
DROP TABLESyntax - 12.1.18.
DROP TRIGGERSyntax - 12.1.19.
DROP VIEWSyntax - 12.1.20.
RENAME TABLESyntax
- 12.1.1.
- 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 [+/-]
- 12.8. MySQL Compound-Statement Syntax [+/-]
This chapter describes the syntax for the SQL statements supported by MySQL.
© 1995-2008 MySQL AB, 2008-2009 Sun Microsystems, Inc.
User Comments
Add your own comment.