Numeric Data Types
-
Numeric Data Type Overview
Overview and usage of the numeric data types. -
TINYINT
Tiny integer, -128 to 127 signed. -
BOOLEAN
Synonym for TINYINT(1). -
SMALLINT
Small integer from -32768 to 32767 signed. -
MEDIUMINT
Medium integer from -8388608 to 8388607 signed. -
INT
Integer from -2147483648 to 2147483647 signed. -
INTEGER
Synonym for INT -
BIGINT
Large integer. -
DECIMAL
A packed "exact" fixed-point number. -
DEC, NUMERIC, FIXED
Synonyms for DECIMAL -
NUMBER
Synonym for DECIMAL in Oracle mode. -
FLOAT
Single-precision floating-point number -
DOUBLE
Normal-size (double-precision) floating-point number -
DOUBLE PRECISION
REAL and DOUBLE PRECISION are synonyms for DOUBLE. -
BIT
Bit field type. -
VECTOR
Vector data type. -
Floating-point Accuracy
Not all floating-point numbers can be stored with exact precision -
INT1
A synonym for TINYINT. -
INT2
Synonym for SMALLINT. -
INT3
Synonym for MEDIUMINT. -
INT4
Synonym for INT. -
INT8
Synonym for BIGINT. -
BOOL
Overview See TINYINT. EXAMPLES CREATE TABLE bool_example ( example BOOL ... -
DEC
See DECIMAL. EXAMPLES CREATE TABLE dec_example ( example DEC ); SHOW CRE... -
FIXED
Overview See DECIMAL. EXAMPLES CREATE TABLE fixed_example ( example FIXED ); SHOW CREATE -
FLOAT4
Overview See FLOAT. EXAMPLES CREATE TABLE float4_example ( example FLOAT... -
FLOAT8
Overview See DOUBLE. EXAMPLES CREATE TABLE float8_example ( example FLOAT8 ); SHOW CREAT -
MIDDLEINT
Overview See MEDIUMINT. EXAMPLES CREATE TABLE middleint_example ( example MIDDLEINT ); S -
NUMERIC
Overview See DECIMAL. EXAMPLES CREATE TABLE numeric_example ( example NUMERIC ); SHOW CR -
REAL
Overview See DOUBLE. EXAMPLES CREATE TABLE real_example ( example REAL ...
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.
