MySQL Crash Course

To help you find the syntax you need when you need it, this appendix lists the syntax for the most frequently used MySQL operations. Each statement starts with a brief description and then displays the appropriate syntax. For added convenience, you'll also find cross-references to the chapters where specific statements are taught.

When reading statement syntax, remember the following:

• The | symbol is used to indicate one of several options, so NULL|NOT NULL means specify either NULL or NOT NULL.

• Keywords or clauses contained within square parentheses [like this] are optional.

• Not all MySQL statements are listed, nor is every clause and option listed.