Numeric Data Types
TINYINT
Tiny integer, -128 to 127 signed
BOOLEAN
Synonym for TINYINT(1)
SMALLINT
Small integer from -32768 to 32767 signed
MEDIUMINT
Medium integer from -8388608 to 8388607 signed
INT
Integer from -2147483648 to 2147483648 signed
INTEGER
Synonym for INT
BIGINT
Large integer
DECIMAL
A packed "exact" fixed-point number
DEC, NUMERIC, FIXED
Synonyms for DECIMAL
FLOAT
Single-precision floating-point number
DOUBLE
Normal-size (double-precision) floating-point number
DOUBLE PRECISION
REAL and DOUBLE PRECISION are are synonyms for DOUBLE
BIT
Bit field type
Floating-point Accuracy
Due to their nature, not all floating-point numbers can be stored with exac...
String Data Types
CHAR
Fixed-length string
VARCHAR
Variable-length string
BINARY
Fixed-length binary byte string
CHAR BYTE
Alias for BINARY
VARBINARY
Variable-length binary byte string
TINYBLOB
Tiny binary large object up to 255 bytes
BLOB
Binary large object up to 65,535 bytes
BLOB and TEXT Data Types
Binary large object data types and the corresponding TEXT types
MEDIUMBLOB
Medium binary large object up to 16,777,215 bytes
LONGBLOB
Long BLOB holding up to 4GB
TINYTEXT
A TEXT column with a maximum length of 255 characters
TEXT
A TEXT column with a maximum length of 65,535 characters
MEDIUMTEXT
A TEXT column with a maximum length of 16,777,215 characters
LONGTEXT
A TEXT column with a maximum length of 4,294,967,295 characters
ENUM
Enumeration, or string object that can have one value chosen from a list of values
SET Data Type
Set, or string object that can have 0 or more values chosen from a list of values
Date and Time Data Types
DATE
The date type YYYY-MM-DD
TIME
Time format HH:MM:SS.ssssss
DATETIME
Date and time combination displayed as YYYY-MM-DD HH:MM:SS
TIMESTAMP
YYYY-MM-DD HH:MM:DD
YEAR Data Type
A four-digit year
Other Data Types Articles
AUTO_INCREMENT
Automatic increment
Autoincrement FAQ
NULL Values
NULL represents an unknown value

ITPub博客

Data Types in MariaDB10

最新文章