Difference and length of int, bigint, smallint, and tinyint in MySQL

Bigint

Integer Data from-2 ^ 63 (-9223372036854775808) to 2 ^ 63-1 (9223372036854775807) (All numbers ). The storage size is 8 bytes.

P.s.Bigint has a length. The length in the MySQL table is only used to display the digits.

Int

Integer Data from-2 ^ 31 (-2,147,483,648) to 2 ^ 31-1 (2,147,483,647) (All numbers ). The storage size is 4 bytes.IntThe SQL-92Integer.

Smallint

Integer Data from-2 ^ 15 (-32,768) to 2 ^ 15-1 (32,767. The storage size is 2 bytes.

Tinyint

Integer Data from 0 to 255. The storage size is 1 byte.

Note

Supported by integerBigintData type. However,BigintUsed in some special cases, when the integer value exceedsIntYou can useBigint. In SQL Server,IntThe data type is the main integer data type.

In the data type priority table,BigintLocated inSmallmoneyAndInt.

Only when the parameter expression isBigintThe function returns the data type.Bigint. SQL Server does not automatically convert other integer data types (Tinyint,SmallintAndInt)Bigint.

INT (M) in integer data type, M indicates the maximum display width. In int (m), the value of M has nothing to do with the storage space occupied by INT (m. There is no relationship with the number of digits. INT (3), INT (4), and INT (8) occupy the storage space of 4 btyes on the disk.