Skip to content

Column

Constants

Constant Visibility Type Value
YES public 1
NO public 0
MIN_UNSIGNED_TINYINT public 0
MAX_UNSIGNED_TINYINT public 255
MIN_SIGNED_TINYINT public -128
MAX_SIGNED_TINYINT public 127
MIN_UNSIGNED_SMALLINT public 0
MAX_UNSIGNED_SMALLINT public 65535
MIN_SIGNED_SMALLINT public -32768
MAX_SIGNED_SMALLINT public 32767
MIN_UNSIGNED_MEDIUMINT public 0
MAX_UNSIGNED_MEDIUMINT public 16777215
MIN_SIGNED_MEDIUMINT public -8388608
MAX_SIGNED_MEDIUMINT public 8388607
MIN_UNSIGNED_INT public 0
MAX_UNSIGNED_INT public 4294967295
MIN_SIGNED_INT public -2147483648
MAX_SIGNED_INT public 2147483647
MIN_UNSIGNED_BIGINT public 0
MAX_UNSIGNED_BIGINT public 1.8446744073709552E+19
MIN_SIGNED_BIGINT public -9.223372036854776E+18
MAX_SIGNED_BIGINT public 9223372036854775807
MIN_SIGNED_FLOAT public -3.402823466E+38
MAX_SIGNED_FLOAT public -1.175494351E-38
MIN_UNSIGNED_FLOAT public 1.175494351E-38
MAX_UNSIGNED_FLOAT public 3.402823466E+38
MIN_SIGNED_DOUBLE public -1.7976931348623157E+308
MAX_SIGNED_DOUBLE public -2.2250738585072014E-308
MIN_UNSIGNED_DOUBLE public 2.2250738585072014E-308
MAX_UNSIGNED_DOUBLE public 1.7976931348623157E+308
MAX_DECIMAL_DIGIT public 65
DATETIME_FORMAT public 'Y-m-d H:i:s'
DATETIME_MIN public '1000-01-01 00:00:00'
DATETIME_MAX public '9999-12-31 23:59:59'
DATE_FORMAT public 'Y-m-d'
DATE_MIN public '1000-01-01'
DATE_MAX public '9999-12-31'
TIMESTAMP_FORMAT public 'Y-m-d H:i:s'
TIMESTAMP_MIN public '1970-01-01 00:00:01'
TIMESTAMP_MAX public '2038-01-19 03:14:07'
YEAR_MIN public 1901
YEAR_MAX public 2155
CHAR_MIN_LENGTH public 0
CHAR_MAX_LENGTH public 255
VARCHAR_MIN_LENGTH public 0
VARCHAR_MAX_LENGTH public 65535
BINARY_MIN_BYTES public 0
BINARY_MAX_BYTES public 255
VARBINARY_MIN_BYTES public 0
VARBINARY_MAX_BYTES public 65535
TINYBLOB_MIN_LENGTH public 0
TINYBLOB_MAX_LENGTH public 255
BLOB_MIN_LENGTH public 0
BLOB_MAX_LENGTH public 65535
MEDIUMBLOB_MIN_LENGTH public 0
MEDIUMBLOB_MAX_LENGTH public 16777215
LONGBLOB_MIN_LENGTH public 0
LONGBLOB_MAX_LENGTH public 4294967295
TINYTEXT_MIN_LENGTH public 0
TINYTEXT_MAX_LENGTH public 255
TEXT_MIN_LENGTH public 0
TEXT_MAX_LENGTH public 65535
MEDIUMTEXT_MIN_LENGTH public 0
MEDIUMTEXT_MAX_LENGTH public 16777215
LONGTEXT_MIN_LENGTH public 0
LONGTEXT_MAX_LENGTH public 4294967295