Mega Code Archive

 

Categories / MySQL Tutorial / Data Types

 

SMALLINT[(M)] [UNSIGNED] [ZEROFILL]

A small integer. The signed range is -32768 to 32767. The unsigned range is 0 to 65535. mysql> mysql> CREATE TABLE myTable     -> (     ->    ID SMALLINT(4) UNSIGNED ZEROFILL,     ->    Quantity INT UNSIGNED     -> ); Query OK, 0 rows affected (0.05 sec) mysql> mysql> desc myTable; +----------+-------------------------------+------+-----+---------+-------+ | Field    | Type                          | Null | Key | Default | Extra | +----------+-------------------------------+------+-----+---------+-------+ | ID       | smallint(4) unsigned zerofill | YES  |     | NULL    |       | | Quantity | int(10) unsigned              | YES  |     | NULL    |       | +----------+-------------------------------+------+-----+---------+-------+ 2 rows in set (0.02 sec) mysql> mysql> drop table myTable; Query OK, 0 rows affected (0.00 sec)