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 ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access