Table of Contents
ALTER DATABASE
ALTER TABLE
CREATE DATABASE
CREATE INDEX
CREATE TABLE
DROP DATABASE
DROP INDEX
DROP TABLE
RENAME DATABASE
RENAME TABLE
DELETE
DO
HANDLER
INSERT
LOAD DATA INFILE
REPLACE
SELECT
TRUNCATE
UPDATE
DESCRIBE
USE
START TRANSACTION
COMMIT
ROLLBACK
SAVEPOINT
ROLLBACK TO SAVEPOINT
LOCK TABLES
UNLOCK TABLES
SET TRANSACTION
SET
SHOW
This 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.
EXPLAIN
Statements for writing stored routines are covered in Chapter 19, Stored Procedures and Functions.
Statements for writing triggers are covered in Chapter 20, Triggers.
View-related statements are covered in Chapter 22, Views.
Statements for scheduling events are covered in Chapter 21, Event Scheduler.
