W3cubDocs

/MariaDB

Numeric Data Types

Title Description
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
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
Floating-point Accuracy Not all floating-point numbers can be stored with exact precision
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.

© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/data-types-numeric-data-types/