Data Description

Data types

Data type
Supported
Notes
BOOLEAN
Alias for TINYINT
INTEGER
TINYINT
SMALLINT
MEDIUMINT
INT
BIGINT
DECIMAL
Max (precision + scale) is 65
FLOAT
DOUBLE
BIT
DATE
TIME
DATETIME
TIMESTAMP
YEAR
CHAR
VARCHAR
BINARY
VARBINARY
TINYBLOB
BLOB
MEDIUMBLOB
LONGBLOB
TINYTEXT
TEXT
MEDIUMTEXT
LONGTEXT
ENUM
SET
GEOMETRY
POINT
LINESTRING
POLYGON
MULTIPOINT
MULTILINESTRING
MULTIPOLYGON
GEOMETRYCOLLECTION
JSON

Constraints

Component
Supported
Notes and limitations
Not Null
Unique
Unique constraints are supported via creation of indexes with UNIQUE keys.
Primary Key
Check
Foreign Key
Default Value

Indexes

Component
Supported
Notes and limitations
Indexes
🟠
Unsupported on TINYTEXT, TEXT, MEDIUMTEXT, LONGTEXT, TINYBLOB, BLOB, MEDIUMBLOB and LONGBLOB data types
Multi-column indexes
Full-text indexes
Spatial indexes

Schema

Component
Supported
Notes and limitations
ALTER TABLE statements
🟠
Some limitations. See the supported statements doc.
Database renames
Database names are read-only, and configured by the server at startup.
Adding tables
Dropping tables
Table renames
Adding views
Dropping views
View renames
Column renames
Adding columns
Removing columns
Reordering columns
Adding constraints
Removing constraints
Creating indexes
Index renames
Removing indexes
AUTO INCREMENT
Export as PDF
Copy link
Edit on GitHub
On this page
Data types
Constraints
Indexes
Schema