O'Reilly logo

PHP & MySQL: Novice to Ninja, 5th Edition by Kevin Yank

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 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 ...

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