Data Types

Comprehensive MariaDB data types reference. Complete guide for numeric, string, date/time, spatial, and JSON types with storage specifications.

Data Type Storage Requirements

Reference for storage space usage. This page lists the disk space consumed by each data type, helping with capacity planning and schema optimization.

AUTO_INCREMENT

Complete AUTO_INCREMENT data type guide for MariaDB. Complete reference for syntax, valid values, storage requirements, and range limits for production use.

AUTO_INCREMENT FAQ

Answers to common questions about AUTO_INCREMENT. Learn about gaps in sequences, resetting values, and behavior in different storage engines.

NULL Values

Understand the concept of NULL. This page explains how NULL represents missing or unknown data and how it interacts with comparison operators and functions.

ROW TYPE OF

Declare row-based variables. This PL/SQL compatibility feature allows declaring variables that match the structure of a table row or cursor.

SERIAL

Alias for BIGINT UNSIGNED NOT NULL AUTO_INCREMENT UNIQUE. This shorthand data type is often used to define primary keys.

TYPE OF

Declare variables based on existing types. This feature allows defining variables or parameters that inherit the data type of a table column or another variable.

Numeric Data Types

Complete numeric types reference: INT/BIGINT ranges, DECIMAL(M,D) precision/scale, FLOAT/DOUBLE storage sizes, and numeric type selection guidelines.

Date and Time Data Types

Store temporal values. This section covers data types for dates, times, and timestamps, including DATE, DATETIME, TIMESTAMP, TIME, and YEAR.

String Data Types

Store text and binary data. This section covers character types like CHAR, VARCHAR, and TEXT, as well as binary types like BLOB and BINARY.

_{This page is licensed: CC BY-SA / Gnu FDL}