Create a new table. Should I select int or smallint for the field type? When the length is enough, is the smaller the better? Smallint (4) & nbsp; can this happen? ------ Solution ------------------ when int & nbsp; 4-byte smallint & nbsp; 2 bytes are sufficient, it can occupy less disk space ------ solution ------------------ depends on the requirement. Create a new table. Should I select int or smallint for the field type?
When the length is enough, is the smaller the better?
Can smallint (4) be like this?
------ Solution --------------------
Int 4 bytes
Smallint 2 bytes
Insufficient disk space
------ Solution --------------------
Depends on the requirement.
If each type has a range, you need to check whether the range is exceeded.
Int
Integer data (all numbers) from-2 ^ 31 [31 power] (-2,147,483,648) to 2 ^ 31-1 (2,147,483,647 ). The storage size is 4 bytes.
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.
Bigint
Integer data from-2 ^ 63 (-9223372036854775808) to 2 ^ 63-1 (9223372036854775807) (all numbers ). The storage size is 8 bytes.
------ Solution --------------------
For the id, the unsigned int is enough.