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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
