MySQLの整数値の幅
| type | bytes | min | max |
|---|---|---|---|
| TINYINT | 1 | -128 | 127 |
| TINYINT UNSIGNED | 1 | 0 | 255 |
| SMALLINT | 2 | -32,768 | 32,767 |
| SMALLINT UNSIGNED | 2 | 0 | 65,535 |
| MEDIUMINT | 3 | -8,388,608 | 8,388,607 |
| MEDIUMINT UNSIGNED | 3 | 0 | 16,777,215 |
| INT | 4 | -2,147,483,648 | 2,147,483,647 |
| INT UNSIGNED | 4 | 0 | 4,294,967,295 |
| BIGINT | 8 | -9,223,372,036,854,775,808 | 9,223,372,036,854,775,807 |
| BIGINT UNSIGNED | 8 | 0 | 18,446,744,073,709,551,615 |