Skip to Main Content
The world's most popular open source database
Contact MySQL
|
Login
|
Register
MySQL.com
Downloads
Documentation
Developer Zone
Developer Zone
Downloads
MySQL.com
Documentation
MySQL Server
MySQL Enterprise
Workbench
InnoDB Cluster
MySQL NDB Cluster
Connectors
More
MySQL.com
Downloads
Developer Zone
Section Menu:
Documentation Home
MySQL 9.7 Reference Manual
Preface and Legal Notices
General Information
Installing MySQL
Upgrading MySQL
Downgrading MySQL
Tutorial
MySQL Programs
MySQL Server Administration
Security
Backup and Recovery
Optimization
Language Structure
Character Sets, Collations, Unicode
Data Types
Numeric Data Types
Numeric Data Type Syntax
Integer Types (Exact Value) - INTEGER, INT, SMALLINT, TINYINT, MEDIUMINT, BIGINT
Fixed-Point Types (Exact Value) - DECIMAL, NUMERIC
Floating-Point Types (Approximate Value) - FLOAT, DOUBLE
Bit-Value Type - BIT
Numeric Type Attributes
Out-of-Range and Overflow Handling
Date and Time Data Types
Date and Time Data Type Syntax
The DATE, DATETIME, and TIMESTAMP Types
The TIME Type
The YEAR Type
Automatic Initialization and Updating for TIMESTAMP and DATETIME
Fractional Seconds in Time Values
What Calendar Is Used By MySQL?
Conversion Between Date and Time Types
2-Digit Years in Dates
String Data Types
String Data Type Syntax
The CHAR and VARCHAR Types
The BINARY and VARBINARY Types
The BLOB and TEXT Types
The VECTOR Type
The ENUM Type
The SET Type
Spatial Data Types
Spatial Data Types
The OpenGIS Geometry Model
The Geometry Class Hierarchy
Geometry Class
Point Class
Curve Class
LineString Class
Surface Class
Polygon Class
GeometryCollection Class
MultiPoint Class
MultiCurve Class
MultiLineString Class
MultiSurface Class
MultiPolygon Class
Supported Spatial Data Formats
Geometry Well-Formedness and Validity
Spatial Reference System Support
Creating Spatial Columns