:limit | Numeric Type | Column Size | Signed Max value | Unsigned Max value |
---|---|---|---|---|
1 | TINYINT(4) | 1 byte | 127 | 255 |
2 | SMALLINT(6) | 2 bytes | 32767 | 65535 |
3 | MEDIUMINT(9) | 3 bytes | 8388607 | 16777215 |
4 and others | INT(11) | 4 bytes | 2147483647 | 4294967295 |
5..8 | BIGINT(20) | 8 bytes | 9223372036854775807 | 18446744073709551615 |
Tidak ada komentar:
Posting Komentar