tinyint, smallint, int, bigint

Admin

Administrator
Data typeRangeRange expressionStorage
bigint-9,223,372,036,854,775,808 to 9,223,372,036,854,775,807-2^63 to 2^63-18 Bytes
int-2,147,483,648 to 2,147,483,647-2^31 to 2^31-14 Bytes
smallint-32,768 to 32,767-2^15 to 2^15-12 Bytes
tinyint0 to 2552^0-1 to 2^8-11 Byte
 
Top