Numeric data types are used to store numeric values. It is very important to make sure range of your data is between lower and upper boundaries of numeric data types.
Type | Storage size | Value range
--- | --- | ---
bigint | 8 bytes | -2<sup>63</sup> to 2<sup>63</sup>-1
int | 4 bytes | -2<sup>31</sup> to 2<sup>31</sup>-1
smallint | 2 bytes | -2<sup>15</sup> to 2<sup>15</sup>-1
tinyint | 1 byte | 0 to 2<sup>8</sup>-1
```
DROP TABLE IF EXISTS data;
CREATE TABLE data (
bi bigint,
i int,
si SMALLINT,
ti TINYINT);
INSERT INTO data (bi, i, si, ti) VALUES (-1, -1, -1, 1);
SELECT * FROM data;
```
Output:
```
bi i si ti
-1 -1 -1 1
```