SQL Language Structure

SQL language structure rules.

Title Description
Identifier Names Naming rules for identifiers.
Identifier Case-sensitivity Whether objects are case-sensitive or not is partly determined by the under...
Binary Literals Binary literals can be written in one of the following formats.
Boolean Literals True and false.
Date and Time Literals Literals regarding date and time.
Hexadecimal Literals Hexadecimal literals can be written using any of the following syntaxes
Identifier Qualifiers How to reference an object and its context in an SQL statement.
Identifier to File Name Mapping Some identifiers map to a file name on the filesystem. Databases each have ...
MariaDB Error Codes MariaDB error codes reference list.
Numeric Literals Numeric literals are written as a sequence of digits from 0 to 9
Reserved Words List of reserved words in MariaDB.
SQLSTATE A string which identifies a condition's class and subclass
String Literals Strings are sequences of characters and are enclosed with quotes.
Table Value Constructors Documents adding arbitrary values to the result-set.
User-Defined Variables Variables which exist within a session.
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.

© 2021 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/sql-language-structure/