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.

Reference:
http://www.ispirer.com/doc/sqlways38/Output/SQLWays-1-190.html

Posted by 알 수 없는 사용자
,