INTEGER exist as Drizzle's two integer numerical types.
BIGINT is a 64-bit integer, while
INTEGER is a 32-bit integer.
Drizzle does not support
MEDIUMINT. Integer operations have been optimized around 32- and 64-bit integers.
|integer||4 bytes |most||common integer |-214||7483648 to +2147483647|
|bigint||8 bytes |larg||er-range integer |-922||3372036854775808 to 9223372036854775807|
AUTO_INCREMENT is supported for
DOUBLE is the system's native double type.
DOUBLE represents double-precision floating-point values that require eight bytes each for storage.