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

SQL Reference - Previous

SQL Language Support

Expressions, Functions, Operators

Last modified 1mo ago

Export as PDF

Copy link

Edit on GitHub

On this page

Data types

Constraints

Indexes

Schema