|
|
Ispirer SQLWays Database Migration Software
BIGINT, INT, INTEGER, MEDIUMINT, SMALLINT and TINYINT
BIGINT [UNSIGNED]
Integer data. The signed range is -9223372036854775808 to 9223372036854775807. The unsigned range is 0 to 18446744073709551615. Storage size is 8 bytes.
INT [UNSIGNED]
Integer data. The signed range is -2147483648 to 2147483647. The unsigned range is 0 to 4294967295. Storage size is 4 bytes.
INTEGER [UNSIGNED]
This is a synonym for INT.
MEDIUMINT [UNSIGNED]
Integer data. The signed range is -8388608 to 8388607. The unsigned range is 0 to 16777215. Storage size is 3 bytes.
SMALLINT [UNSIGNED]
Integer data. The signed range is -32768 to 32767. The unsigned range is 0 to 65535. Storage size is 2 bytes.
TINYINT [UNSIGNED]
Integer data. The signed range is -128 to 127. The unsigned range is 0 to 255. Storage size is 1 byte.
|
|