Chapter 11 Language Structure

Table of Contents

11.1 Literal Values

11.1.1 String Literals

11.1.2 Numeric Literals

11.1.3 Date and Time Literals

11.1.4 Hexadecimal Literals

11.1.5 Bit-Value Literals

11.1.6 Boolean Literals

11.1.7 NULL Values

11.2 Schema Object Names

11.2.1 Identifier Length Limits

11.2.2 Identifier Qualifiers

11.2.3 Identifier Case Sensitivity

11.2.4 Mapping of Identifiers to File Names

11.2.5 Function Name Parsing and Resolution

11.3 Keywords and Reserved Words

11.4 User-Defined Variables

11.5 Expressions

11.6 Query Attributes

11.7 Comments

This chapter discusses the rules for writing the following elements of SQL statements when using MySQL:

• Literal values such as strings and numbers

• Identifiers such as database, table, and column names

• Keywords and reserved words

• User-defined and system variables

• Expressions

• Query attributes

• Comments