Loading

TINYINT, SMALLINT, MEDIUMINT, INT, BIGINT MySQL Data Type

TINYINT, SMALLINT, MEDIUMINT, INT, BIGINT Data Type are used for MySQL integer data value. They differ only from storage value and range value.

Storage point of view TINYINT stores 1 byte, SMALLINT stores 2 bytes, MEDIUMINT stores 3 bytes, INT stores 4 bytes, BIGINT stores 8 bytes.

Minimum signed value point of view TINYINT minimum signed value -128, SMALLINT minimum signed value -32768, MEDIUMINT minimum signed value -8388608, INT minimum signed value -2147483648, BIGINT minimum signed value -9223372036854775808.

Maximum signed value point of view TINYINT maximum signed value 127, SMALLINT maximum signed value 32767, MEDIUMINT maximum signed value 8388607, INT maximum signed value 2147483647, BIGINT maximum signed value 9223372036854775807.

Allow a range of minimum and maximum unsigned values is TINYINT 0 to 255, SMALLINT 0 to 65535, MEDIUMINT 0 to 16777215, INT 0 to 4294967295, BIGINT maximum signed value 0 to 18446744073709551615.

Share with:


Leave a Reply

Connect with:





z35W7z4v9z8w