数据类型
一、INTEGER
INTEGER Exact numeric data type
二、INT
INT Synonym for INTEGER
三、SMALLINT
SMALLINT Exact numeric data type
四、TINYINT
TINYINT Exact numeric data type
五、MEDIUMINT
MEDIUMINT Exact numeric data type
六、BIGINT
BIGINT Exact numeric data type
七、DECIMAL
DECIMAL Exact numeric data type
八、NUMERIC
NUMERIC Synonym for DECIMAL
九、FLOAT
FLOAT Approximate numeric data type
十、DOUBLE
DOUBLE Synonym for DOUBLE PRECISION
十一、DOUBLE PRECISION
DOUBLE PRECISION Approximate numeric data type
十二、REAL
REAL Synonym for DOUBLE PRECISION (unless REAL_AS_FLOAT SQL mode is enabled)
十三、BIT
BIT Stores bit values
十四、DATE
DATE Temporal data type for representing calendar dates
十五、DATETIME
DATETIME Temporal data type for representing date and time
十六、TIMESTAMP
TIMESTAMP Temporal data type for representing date and time with automatic initialization and updating
十七、TIME
TIME Temporal data type for representing time of day
十八、YEAR
YEAR Temporal data type for representing year values
十九、CHAR
CHAR Fixed-length string data type
二十、VARCHAR
VARCHAR Variable-length string data type
二十一、BINARY
BINARY Fixed-length binary data type
二十二、VARBINARY
VARBINARY Variable-length binary data type
二十三、BLOB
BLOB Binary Large Object data type
二十四、TEXT
TEXT Large text data type
二十五、ENUM
ENUM Enumeration data type
二十六、SET
SET Set data type
二十七、GEOMETRY
GEOMETRY Spatial data type for representing geometric values
二十八、POINT
POINT Spatial data type for representing a single location in coordinate space
二十九、LINESTRING
LINESTRING Spatial data type for representing a sequence of points
三十、POLYGON
POLYGON Spatial data type for representing a polygon
三十一、MULTIPOINT
MULTIPOINT Spatial data type for representing multiple points
三十二、MULTILINESTRING
MULTILINESTRING Spatial data type for representing multiple linestrings
三十三、MULTIPOLYGON
MULTIPOLYGON Spatial data type for representing multiple polygons
三十四、GEOMETRYCOLLECTION
GEOMETRYCOLLECTION Spatial data type for representing a collection of geometries
三十五、JSON
JSON Native JSON data type for storing JSON documents