| 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 |
© 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/