PHP & MySQL: Novice to Ninja, 5th Edition

Appendix B. MySQL Syntax Reference

This appendix describes the syntax of the most commonly used SQL statements in MySQL, as of version 5.5.22 (current as of this writing).

The following conventions are used in this reference:

• Commands are listed in alphabetical order for easy reference.

• Optional portions of each command are surrounded by square brackets ([]).

• Lists of elements from which one element must be chosen are surrounded by braces ({}), with the elements separated by vertical bars (|).

• An ellipsis (…) means that the preceding element may be repeated.

The query syntax documented in this appendix has been simplified in several places by the omission of the alternative syntax, and of keywords that performed no function, but which were ...