SQL for MySQL Developers: A Comprehensive Tutorial and Reference

Appendix A. Syntax of SQL

A.1 Introduction

In this appendix, we explain the notation method we have used to define the statements, present the definitions of the SQL statements discussed in this book, and show the list of reserved words.

The definitions in this appendix can differ from those in the previous chapters. The main reason for this is that, in the chapters, we explained the statements and concepts step by step. To avoid too much detail, we sometimes used simple versions of the definitions. This appendix contains the complete definitions.

A.2 The BNF Notation

In this appendix and throughout the book, we have used a formal notation method to describe the syntax of all SQL statements and the common elements. This notation is a derivative ...