E. SQL Syntax Reference

This appendix describes the syntax for SQL statements provided by MySQL. It has three parts:

  • SQL statements other than those for compound statements.
  • SQL statements that are used for compound statements, which are written using BEGIN and END and can be used for writing stored programs that are stored on the server side (functions, procedures, triggers, and events).
  • The syntax for writing comments in SQL code. Comments are used to write descriptive text that is ignored by the server, and to hide MySQL-specific keywords that will be executed by MySQL but ignored by other database servers.

Statement syntax descriptions use the following conventions:

  • Square brackets ([]) indicate optional information.
  • Vertical bars (

Get MySQL® now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.