Description\n-----------\n\nThere are a number of numeric data types:\n\n BOOLEAN - Synonym for TINYINT(1)\n INT1 - Synonym for TINYINT\n INT2 - Synonym for SMALLINT\n INT3 - Synonym for MEDIUMINT\n INT, INTEGER\n INT4 - Synonym for INT\n INT8 - Synonym for BIGINT\n TINYINT\n SMALLINT\n MEDIUMINT\n BIGINT\n DECIMAL, DEC, NUMERIC, FIXED\n FLOAT\n DOUBLE, DOUBLE PRECISION, REAL\n BIT\n VECTOR\n\nSee the specific articles for detailed information on each.\n\nSIGNED, UNSIGNED and ZEROFILL\n\nMost numeric types can be defined as SIGNED, UNSIGNED or ZEROFILL, for example:\n\n``sql\nTINYINT[(M)] [SIGNED | UNSIGNED | ZEROFILL]\n`\n\nIf SIGNED, or no attribute, is specified, a portion of the numeric type will be reserved for the sign (plus or minus). For example, a TINYINT SIGNED can range from -128 to 127.\n\nIf UNSIGNED is specified, no portion of the numeric type is reserved for the sign, so for integer types range can be larger. For example, a TINYINT UNSIGNED can range from 0 to 255. Floating point and fixed-point types also can be UNSIGNED, but this only prevents negative values from being stored and doesn't alter the range.\n\nIf ZEROFILL is specified, the column will be set to UNSIGNED and the spaces used by default to pad the field are replaced with zeros. ZEROFILL is ignored in expressions or as part of a UNION. ZEROFILL is a non-standard MySQL and MariaDB enhancement.\n\nNote that although the preferred syntax indicates that the attributes are exclusive, more than one attribute can be specified.\n\nOnly the following combinations are supported:\n\n SIGNED\n UNSIGNED\n ZEROFILL\n UNSIGNED ZEROFILL\n ZEROFILL UNSIGNED\n\nThe latter two should be replaced with simply ZEROFILL`, but are still accepted by the parser.\n\nExamples\n--------\n\nCREATE TABLE zf (\n  i1 TINYINT SIGNED,\n  i2 TINYINT UNSIGNED,\n  i3 TINYINT ZEROFILL\n);\n\nINSERT INTO zf VALUES (2,2,2);\n\nSELECT  FROM zf;\n+------+------+------+\n| i1   | i2   | i3   |\n+------+------+------+\n|    2 |    2 |  002 |\n+------+------+------+\n\nURL: https://mariadb.com/docs/server/reference/data-types/numeric-data-types/numeric-data-type-overview