MySQL has different INT data types with different storage requirements including:
- TINYINT (1 byte) ,
- SMALLINT (2 byte),
- MEDIUMINT (3 byte),
- INT (4 byte) and
- BIGINT (8 byte).
All the INT types can be used as signed or unsigned. You can write UNSIGNED after data type to tell if it is unsigned.
For example below command will create an Employee table which can have Age as unsigned SMALLINT value.
| 1 2 3 | CREATE TABLE `Employee`( `Name` VARCHAR(25) NOT NULL, `Age` SMALLINT UNSIGNED); |