SQL Language Support
Dolt's goal is to be compliant with the MySQL dialect, with every query and statement that works in MySQL behaving identically in Dolt.
For most syntax and technical questions, you should feel free to refer to the MySQL user manual.
Any deviation from the MySQL manual should be documented on this page, or else indicates a bug. Please file issues with any incompatibilities you discover.
This series of documents shows:
✅ Which SQL language features we support the same as MySQL
🟠 Where we support the feature but deviate from MySQL in some way
❌ Where we lack support for the SQL language feature.
This section is divided into five main categories:
Data Description: SQL features for describing and organizing data
Expressions, Functions, Operators: SQL expressions, functions and operators used in queries
Supported Statements: statements Dolt supports
Information Schema: Dolt support for MySQL information schema
Collations and Character Sets: SQL features for describing and comparing strings
System Variables: SQL features for configuring server behavior
Miscellaneous: miscellaneous SQL features
Last updated