Usage of bigint, int, smallint, and tinyint storage in mysql _ MySQL

Usage of bigint, int, smallint, and tinyint storage in mysql bitsCN.com
Use the exact numeric data type of integer data. Bigint integer data from-2 ^ 63 (-9223372036854775808) to 2 ^ 63-1 (9223372036854775807) (all numbers ). The storage size is 8 bytes. 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. The SQL-92 synonym for the int is integer. Smallint integer data from-2 ^ 15 (-32,768) to 2 ^ 15-1 (32,767. The storage size is 2 bytes. Integer data of tinyint from 0 to 255. The storage size is 1 byte. Annotation supports the bigint data type where integer values are supported. However, bigint is used in some special cases. when the integer value exceeds the range supported by the int data type, bigint can be used. In SQL Server, the int data type is the main integer data type. In the data type precedence table, bigint is located between smallmoney and int. The function returns bigint only when the parameter expression is of the bigint data type. SQL Server does not automatically upgrade other integer data types (tinyint, smallint, and int) to bigint. Author: TonyLee0329bitsCN.com