This document is licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 License.
Column names and table names must all start with a letter and may include letters, digits, and the underscore character, _. These names may be case-sensitive if the underlying operating system is case-sensitive.
Numeric values are typed as normal and string values must be contained within single quotes. The escape sequence for a single quote (apostrophe) within a string is to type two single quotes.
The SQL key words are not case-sensitive, but it is traditional to write all key words in upper case.
White space is ignored, so long queries can (and should) be split across several lines.
Every SQL query must end with a semi-colon, ;.
Paul Murrell
This document is licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 License.