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

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
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