SQL Language Structure

Explore the SQL language structure in MariaDB Server. This section provides fundamental concepts, syntax rules, and common elements that form the building blocks of SQL queries and commands.

Binary Literals

Binary literal syntax in MariaDB: b'value', B'value', and 0bvalue.

Date and Time Literals

Syntax for DATE, TIME, DATETIME, and TIMESTAMP literals, including SQL- standard and ODBC forms.

Hexadecimal Literals

Hexadecimal literal syntax in MariaDB, such as x'value' and 0xvalue.

Identifier Case Sensitivity

How identifier case sensitivity depends on the object type and the operating system.

Identifier Names

Rules for naming identifiers such as databases, tables, columns, and other objects.

Identifier Qualifiers

Using qualifiers (such as db.table.column) to reference database objects in SQL.

Identifier to File Name Mapping

How MariaDB maps identifiers to file names on disk.

Numeric Literals

Numeric literal syntax for integers and decimals, including signs and exponents.

Reserved Words

The list of reserved words in MariaDB.

Boolean Literals

Boolean literals: TRUE and FALSE as synonyms for 1 and 0.

Schema Qualifiers

Schema qualifiers manage SQL mode dependent behavior for data types and functions.

String Literals

String literal syntax, quoting, and escape sequences.

Table Value Constructors

The VALUES table value constructor, which produces a set of rows.

User-Defined Variables

Session-scoped user-defined variables (@var), and how to set and use them.