INT
data type represents whole numbers without decimal points. It is a 32-bit signed integer with a range from -2147483648 to 2147483647.
INT
type.
BIGINT
data type stores large whole numbers that exceed the INT
range. It is a 64-bit signed integer with a range from -9223372036854775808 to 9223372036854775807.
BIGINT
type:
REAL
data type is a 32-bit floating-point number compliant with the IEEE 754 binary32 format.
REAL
column type.
REAL
type only stores 32-bit floating-point numbers. In this example, we input the numbers that exceed the range.
DOUBLE PRECISION
data type is a 64-bit floating-point number compliant with the IEEE 754 binary64 format.
DOUBLE PRECISION
type column.