O'Reilly logo

MySQL® by Paul DuBois

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Appendix 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 (|) separate ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required