Syntax\n------\n\nSMALLINT[(M)] [SIGNED | UNSIGNED | ZEROFILL]\n\nDescription\n-----------\n\nA small integer. The signed range is -32768 to 32767. The unsigned range is 0 to 65535.\n\nIf a column has been set to ZEROFILL, all values will be prepended by zeros so that the SMALLINT value contains a number of M digits.\n\nNote:\n\nIf the ZEROFILL attribute has been specified, the column will automatically become UNSIGNED.\n\nINT2 is a synonym for SMALLINT.\n\nFor more details on the attributes, see Numeric Data Type Overview.\n\nExamples\n--------\n\nCREATE TABLE smallints (a SMALLINT,b SMALLINT UNSIGNED,c SMALLINT ZEROFILL);\n\nURL: https://mariadb.com/docs/server/reference/data-types/numeric-data-types/smallint