DEVELOPER ZONE ::
Login / Register
Table of Contents
ALTER DATABASE
SyntaxALTER TABLE
SyntaxCREATE DATABASE
SyntaxCREATE INDEX
SyntaxCREATE TABLE
SyntaxDROP DATABASE
SyntaxDROP INDEX
SyntaxDROP TABLE
SyntaxRENAME TABLE
SyntaxDELETE
SyntaxDO
SyntaxHANDLER
SyntaxINSERT
SyntaxLOAD DATA INFILE
SyntaxREPLACE
SyntaxSELECT
SyntaxTRUNCATE
SyntaxUPDATE
SyntaxDESCRIBE
SyntaxHELP
SyntaxUSE
SyntaxSTART TRANSACTION
, COMMIT
, and ROLLBACK
SyntaxSAVEPOINT
and ROLLBACK TO SAVEPOINT
SyntaxLOCK TABLES
and UNLOCK TABLES
SyntaxSET TRANSACTION
SyntaxSET
SyntaxSHOW
SyntaxThis chapter describes the syntax for most of the SQL statements supported by MySQL. Additional statement descriptions can be found in the following chapters:
The EXPLAIN
statement is discussed in Chapter 7, Optimization.
Statements for writing stored routines are covered in Chapter 17, Stored Procedures and Functions.
Statements for writing triggers are covered in Chapter 18, Triggers.
View-related statements are covered in Chapter 19, Views.
User Comments
Add your own comment.